10 likes | 171 Views
Student. Banner ID (PK) First Last Party Size Last Board Vehicle ID (FK 1). Shuttle. Vehicle ID (PK) Last Odom Reading Capacity Driver ID (FK 1). Request. Driver. Student (PK, FK 1) Request ID (PK) Timestamp Status. Driver ID (PK) First Last. Route. Stop.
E N D
Student Banner ID (PK) First Last Party Size Last Board Vehicle ID(FK 1) Shuttle Vehicle ID (PK) Last Odom Reading Capacity Driver ID(FK 1) Request Driver Student (PK, FK 1) Request ID (PK) Timestamp Status Driver ID (PK) First Last Route Stop Route Number (PK) Description Length Stop Name (PK) Location Description Checkpoint Loop Route Number (PK, FK 1) Stop Name (PK, FK 2) Vehicle ID (PK, FK 1) Route Number (PK, FK 2)