Operators Schema Flashcards
(15 cards)
What is the primary key for the operators table?
operator_id
What is the description of the operators table?
Personnel who operate vehicles
What is the table type of operators?
Supporting
What does the operator_id field represent?
Identifies the operator
Is the operator_id field required?
Yes
What does the operator_name field represent?
Name of the operator
What does the operator_employee_id field represent?
Employee ID of the operator
What does the operator_type field represent?
Indicates the type of operator
What are some examples of operator_type values?
Bus driver, Train operator, Ferry captain, Cable car operator, Other
What does the operator_status field represent?
Indicates the status of the operator
What are some possible values for operator_status?
Active, Inactive, On leave, Retired
What does the operator_hire_date field represent?
Date the operator was hired
What does the operator_termination_date field represent?
Date the operator was terminated
What does the operator_notes field represent?
Additional notes about the operator
What foreign references does the operators table have?
None
