Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Is my database setup the right way? This way I can't make decent imports since I have five tables

Topic Labels: Base design
226 2
cancel
Showing results for 
Search instead for 
Did you mean: 
FlorisM
4 - Data Explorer
4 - Data Explorer

I am developing software for car appraisers and have structured my database with five tables:

  1. Enduser (Appraiser) - Unique identifier: Email of the appraiser
  2. Clients of the Enduser Unique identifier: Email of the client (One appraiser can have multiple clients)
  3. Vehicles of the Client Unique identifier: Vehicle registration number of the client (One client can own multiple vehicles)
  4. Appraisals of the Vehicle Unique identifier: Report number of the appraisal of the client (Each vehicle can have multiple appraisals)
  5. Payments for the Appraisals Unique identifier: Payment number of the report number (Each appraisal can involve multiple payments)

Is this structure appropriate? One potential drawback is that when importing data into related tables, I can only link one table at a time. Ideally, when I add an appraisal along with the vehicle's registration number, the system should automatically identify the associated client (based on the vehicle registration number) and the corresponding enduser (since the client is linked to the enduser).

 

2 Replies 2

Hello,

Your structure looks fine to me and it should react as expected when adding an appraisal as long as the registration number allready exists in the "vehicle" table.

You may want to add some lookup fields in your table to bring down the information client and enduser. To do that, you need first to add 2 lookup fields in table vehicle to bring down cleint_id and enduser_id from table client and then repeat the operation in table appraisal.

If you add a record in table Appraisal for a registration number that does not exist in table Vehicle, it will create the record in table vehicle with the appropriate primary key, but link with table client will not be done.

Regards,

Pascal

FlorisM
4 - Data Explorer
4 - Data Explorer

Hi Pascal, is there any way I can help me with this? I am willing to a fee.