10 likes | 136 Vues
Student. Driver. Banner ID (PK) First Last Party Size Last Board. Driver ID (PK) First Last. Schedule. Schedule No (PK) Vehicle ID (PK, FK) Driver ID (PK, FK). Shuttle. Vehicle ID (PK) Last Odom Reading Capacity. Request.
E N D
Student Driver Banner ID (PK) First Last Party Size Last Board Driver ID (PK) First Last Schedule Schedule No (PK) Vehicle ID (PK, FK) Driver ID (PK, FK) Shuttle Vehicle ID (PK) Last Odom Reading Capacity Request Student (PK, FK 1) Vehicle ID (PK, FK)Stop Name (PK, FK)TimestampStatus Size of Party Route Stop Route Number (PK) Description Length Stop Name (PK) Location Description Checkpoint Route Number (PK, FK 1) Stop Name (PK, FK 2) Loop Vehicle ID (PK, FK 1) Route Number (PK, FK 2)