Train Cars Schema Flashcards
(32 cards)
What is the primary key for the train_cars table?
train_car_id
What is the description of the train_cars table?
Assets that comprise vehicles, such as train cars, with descriptive information
What is the table type of train_cars?
Supporting
What does the train_car_id field represent?
Identifies the train car
Is the train_car_id field required?
Yes
What does the train_car_label field represent?
Human-readable label for the train car
What does the train_car_type field represent?
Indicates the type of train car
What are some examples of train_car_type values?
Locomotive, Passenger car, Baggage car, Dining car, Sleeper car, Control car, Other
What does the train_car_manufacturer field represent?
Manufacturer of the train car
What does the train_car_model field represent?
Model of the train car
What does the train_car_serial_number field represent?
Serial number of the train car
What does the train_car_year field represent?
Year the train car was manufactured
What does the train_car_length field represent?
Length of the train car in meters
What is the minimum value for train_car_length?
0
What does the train_car_width field represent?
Width of the train car in meters
What is the minimum value for train_car_width?
0
What does the train_car_height field represent?
Height of the train car in meters
What is the minimum value for train_car_height?
0
What does the train_car_weight field represent?
Weight of the train car in kilograms
What is the minimum value for train_car_weight?
0
What does the train_car_capacity field represent?
Passenger capacity of the train car
What is the minimum value for train_car_capacity?
0
What does the train_car_wheelchair_capacity field represent?
Number of wheelchair spaces in the train car
What is the minimum value for train_car_wheelchair_capacity?
0
