Hello everyone,
in my App, I am using three tables.
Table name | Key |
Cases | case_id |
Rentals | rental_id |
Vehicles | vehicle_id |
Table structure with columns
Cases
Column name | case_id | rental_id | vehicle_id |
Description | Reference to Rentals | Reference to Rentals |
Rentals
Column name | rental_id | vehicle_id |
Description | Reference to Rentals Can be multiple vehicles for each rental_id |
Vehicles
Column name | vehicle_id |
Description |
Note:
Each rental_id can have multiple lines with different vehicle_id and each vehicle_id can be used in multiple rental_id.
Questions
I want to keep the columns type Ref if possible.
Thanks for your help in advance!
User | Count |
---|---|
19 | |
10 | |
7 | |
5 | |
5 |