The part
table shows hierarchical information about the car parts. It contains these columns:
id
– the unique ID of the part.
name
– the name of the part.
price
– the price of the part.
registered_date
– the registered date of the part.
model_id
– the Ford model (universal parts for all models have NULL
in this column).
parent_id
– the ID of the parent part, if any (main parts have NULL
in this column because they don't belong to any parent part). For example, the car body is a parent part built of an engine and other parts, and an engine is a parent part built of cylinders, pistons, and other parts.
Explore the contents of the table part
by selecting all data from it.