Devices Schema Flashcards
(30 cards)
What is the primary key for the devices table?
device_id
What is the description of the devices table?
Measurement devices, such as AVL, APC, and AFC devices, associated with vehicles or stops or stations
What is the table type of devices?
Supporting
What does the device_id field represent?
Identifies the device
Is the device_id field required?
Yes
What does the device_type field represent?
Indicates the type of device
Is the device_type field required?
Yes
What are some possible values for device_type?
AVL, APC, AFC, Other
What does the device_subtype field represent?
Indicates the subtype of device
What are some examples of device_subtype values?
GPS, Cellular, Infrared, Pressure, Optical, Magnetic, Smartcard, Mobile, Other
What does the device_name field represent?
Human-readable name for the device
What does the device_model field represent?
Model of the device
What does the device_manufacturer field represent?
Manufacturer of the device
What does the device_serial_number field represent?
Serial number of the device
What does the device_firmware_version field represent?
Firmware version of the device
What does the device_software_version field represent?
Software version of the device
What does the device_installation_date field represent?
Date the device was installed
What does the device_retirement_date field represent?
Date the device was retired
What does the device_status field represent?
Indicates the status of the device
What are some possible values for device_status?
Active, Inactive, Maintenance, Retired
What does the vehicle_id field represent?
Identifies the vehicle the device is installed on
What does the stop_id field represent?
Identifies the stop the device is installed at
What does the device_location field represent?
Indicates the location of the device on the vehicle or at the stop
What are some examples of device_location values?
Front door, Rear door, Middle door, Front of vehicle, Rear of vehicle, Middle of vehicle, Ceiling, Floor, Wall, Other
