❔ SQL: Shared data. One or two table
Hey, im currently creating a database and I need to store the information about vehicles.
The vehicles can be bought or rented. Obviously depending on the type of financing, one will need some fields while the other would need other fields.
That being said, most information are the same no matter the financing type such as the model, the year etc.
My question is: Should I create two table to store the information to avoid having row with empty data in my table or should i not care and just do one table?
PS: For bought vehicles we are talking about 10 fields more or less and rented one about 20 fields
The vehicles can be bought or rented. Obviously depending on the type of financing, one will need some fields while the other would need other fields.
That being said, most information are the same no matter the financing type such as the model, the year etc.
My question is: Should I create two table to store the information to avoid having row with empty data in my table or should i not care and just do one table?
PS: For bought vehicles we are talking about 10 fields more or less and rented one about 20 fields
