-
admin_login (id, admin_name, password)
-
locations (id, destination, latitude, longitude, hotel, hotline)
-
users (U_ID, username, email, phone, password)
-
bookings (id, from, to, date, return_date, class, passengers, email, phone, trip, cost, confirm, printTime)
-
feedback (id, submission_time, category, subject, name, email, phone, country, message, ticket_number, journey_date, ticket_file)
-
driver info (DID, name, email, phone, role)
-
flight assign (id, pilot, copilot, hostess, co_hostess, co_hostess_secondary, date)
-
hotel assign (id, did, role, checkin_date, checkout_date, room_no, hotel)
-
driver (DID, name, email, phone, password)
Download ERD VISIO file.
Download Database backup file. 02-Nov-2023