Vehicles Schema

Question 1

What is the primary key for the vehicles table?

Answer 1

vehicle_id

Question 2

What is the description of the vehicles table?

Answer 2

Vehicles, including buses and train consists, with descriptive information

Question 3

What is the table type of vehicles?

Answer 3

Supporting

Question 4

What does the vehicle_id field represent?

Answer 4

Identifies the vehicle

Question 5

Is the vehicle_id field required?

Answer 5

Yes

Question 6

What does the vehicle_label field represent?

Answer 6

Human-readable label for the vehicle

Question 7

What does the vehicle_type field represent?

Answer 7

Indicates the type of vehicle

Question 8

What are some examples of vehicle_type values?

Answer 8

Bus, Light rail vehicle, Heavy rail vehicle, Commuter rail locomotive, Commuter rail passenger car, Ferry, Cable car, Gondola, Funicular, Other

Question 9

What does the vehicle_license_plate field represent?

Answer 9

License plate of the vehicle

Question 10

What does the vehicle_manufacturer field represent?

Answer 10

Manufacturer of the vehicle

Question 11

What does the vehicle_model field represent?

Answer 11

Model of the vehicle

Question 12

What does the vehicle_serial_number field represent?

Answer 12

Serial number of the vehicle

Question 13

What does the vehicle_year field represent?

Answer 13

Year the vehicle was manufactured

Question 14

What does the vehicle_length field represent?

Answer 14

Length of the vehicle in meters

Question 15

What is the minimum value for vehicle_length?

Answer 15

0

Question 16

What does the vehicle_width field represent?

Answer 16

Width of the vehicle in meters

Question 17

What is the minimum value for vehicle_width?

Answer 17

0

Question 18

What does the vehicle_height field represent?

Answer 18

Height of the vehicle in meters

Question 19

What is the minimum value for vehicle_height?

Answer 19

0

Question 20

What does the vehicle_weight field represent?

Answer 20

Weight of the vehicle in kilograms

Question 21

What is the minimum value for vehicle_weight?

Answer 21

0

Question 22

What does the vehicle_capacity field represent?

Answer 22

Passenger capacity of the vehicle

Question 23

What is the minimum value for vehicle_capacity?

Answer 23

0

Question 24

What does the vehicle_standing_capacity field represent?

Answer 24

Standing capacity of the vehicle

Question 25

What is the minimum value for vehicle_standing_capacity?

Answer 25

0

Question 26

What does the vehicle_wheelchair_capacity field represent?

Answer 26

Number of wheelchair spaces in the vehicle

Question 27

What is the minimum value for vehicle_wheelchair_capacity?

Answer 27

0

Question 28

What does the vehicle_bike_capacity field represent?

Answer 28

Number of bike spaces in the vehicle

Question 29

What is the minimum value for vehicle_bike_capacity?

Answer 29

0

Question 30

What does the vehicle_door_count field represent?

Answer 30

Number of doors on the vehicle

Question 31

What is the minimum value for vehicle_door_count?

Answer 31

0

Question 32

What does the vehicle_status field represent?

Answer 32

Indicates the status of the vehicle

Question 33

What are some possible values for vehicle_status?

Answer 33

Active, Inactive, Maintenance, Retired

Question 34

What does the vehicle_fuel_type field represent?

Answer 34

Indicates the fuel type of the vehicle

Question 35

What are some examples of vehicle_fuel_type values?

Answer 35

Diesel, Gasoline, Electric, Hybrid, CNG, LNG, Hydrogen, Other

Question 36

What does the vehicle_notes field represent?

Answer 36

Additional notes about the vehicle

Question 37

What foreign references does the vehicles table have?

Answer 37

None