Scribd
Upload
21 views2 pages

Bus and Route Management Database Schema

The document outlines the structure of four database tables: BusDetails, RouteFare, UserAccount, and Feedback, each with their respective primary and foreign keys. It details the columns, data types, and descriptions for each table, including unique identifiers, operational statuses, user information, and feedback mechanisms. This schema supports a transportation management system by linking buses to routes and user accounts while allowing for feedback collection.

Uploaded by

gs admin
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
21 views2 pages

Bus and Route Management Database Schema

The document outlines the structure of four database tables: BusDetails, RouteFare, UserAccount, and Feedback, each with their respective primary and foreign keys. It details the columns, data types, and descriptions for each table, including unique identifiers, operational statuses, user information, and feedback mechanisms. This schema supports a transportation management system by linking buses to routes and user accounts while allowing for feedback collection.

Uploaded by

gs admin
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Table Name : BusDetails

Primary Key : BusID


Foreign Key : RouteID
Column Name Datatype Description
BusID int (PK) Unique identifier for each bus
RouteID int (FK) Identifier linking to the Route and Fare Table
BusNumber varchar Registration or bus number
Capacity int Seating capacity of the bus
Status varchar Operational status of the bus (e.g., Active, Maintenance)
QRCode varchar Unique QR code for accessing bus details

Table Name : RouteFare


Primary Key : RouteID
Column Name Datatype Description
RouteID int (PK) Unique identifier for each route
StartPoint varchar Name or code of the starting point of the route
EndPoint varchar Name or code of the end point of the route
IntermediateStops text List of intermediate stops
RoutePath text Description or encoded format of the route path
BaseFare decimal Base fare for the route
FarePerKm decimal Fare charged per kilometer

Table Name : UserAccount


Primary Key : UserID
Column Name Datatype Description
UserID int (PK) Unique identifier for each user
Username varchar Username for account login
Password varchar Hashed password for account security
Email varchar User’s email address
PhoneNumber varchar User’s phone number
RegisteredDate datetime Date and time of account creation
LastLogin datetime Date and time of last login
PreferredRoutes text List of frequently used routes by the user

Table Name : Feedback


Primary Key : FeedbackID
Foreign Key : UserID, RouteID
Column Name Datatype Description
FeedbackID int (PK) Unique identifier for each feedback entry
UserID int (FK) Identifier linking to the User Account Table
RouteID int (FK, nullable) Identifier linking to a specific route, if applicable
FeedbackType varchar Type of feedback (e.g., Complaint, Suggestion, Query)
Description text Detailed description of the feedback
SubmittedDate datetime Date and time when the feedback was submitted
Status varchar Current status of the feedback (e.g., Open, Closed, In Review)

You might also like