Database Structure and Search Implementation for Business and Nakes Codes

In this meeting, the participants discuss a data inquiry API and the challenge of generating codes and descriptions. The main question is how to set up the database to retrieve multiple codes for businesses. The suggestion is to use a table that links the codes table with the businesses table to handle the many-to-many relationship. The participants also discuss the possibility of including the codes table in the search index, and it is recommended to have separate endpoints for different searches in different tables. The meeting ends with a discussion about immediate tasks, including troubleshooting a timestamp formatting issue.


(Source: Office Hours 5/3 )

State Change Members Can View The Video Here
chris-montgomery-smgTvepind4-unsplash.jpg

View This Video Now

Join State Change Risk-Free