Good day. There is a need to store data on different types of cars - trucks, cars, special ones. Each type of car has its own set of characteristics. I had the idea to combine common properties into one table, and put specific ones into a separate table. And the question arose - how to connect a common table and a table of specific properties. Please advise how it is more logical to implement such a scheme and link the tables, provided that new types of cars can be added.
Общий список авто auto_list +-------+-------+-------------+ |auto_id| doors | price | +-------+-------+-------------+ | 1 | 4 | 10000 | | 2 | 3 | 20000 | | 3 | 2 | 10000 | +-------+-------+-------------+ Характеристики грузовых авто cargo_details +-------+-------+-------------+ |auto_id| cargo | wheels | +-------+-------+-------------+ | 2 | 4 | 6 | +-------+-------+-------------+ Характеристики легковых авто passenger_details +-------+-------+-------------+ |auto_id|passgrs| fuel | +-------+-------+-------------+ | 1 | 4 | 92 | | 3 | 6 | 95 | +-------+-------+-------------+ 