I am developing software for car appraisers in Softr and have structured my database with five tables:
- Enduser (Appraiser) - Unique identifier: Email of the appraiser
- Clients of the Enduser - Unique identifier: Email of the client (One appraiser can have multiple clients)
- Vehicles of the Client - Unique identifier: Vehicle registration number of the client (One client can own multiple vehicles)
- Appraisals of the Vehicle - Unique identifier: Report number of the appraisal of the client (Each vehicle can have multiple appraisals)
- 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 numer) and the corresponding enduser (since the client is linked to the enduser).