DB_5week
Tables (6)
Customer
- customer_id — INT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100)
- phone — VARCHAR(15)
Flight
- flight_id — INT
- origin — VARCHAR(100) — NOT NULL
- destination — VARCHAR(100) — NOT NULL
- status — VARCHAR(20)
Reservation
- reservation_id — INT
- customer_id — INT
- flight_id — INT
- reservation_date — DATE
Routing
- route_id — INT
- flight_id — INT
- stops — VARCHAR(255)
- duration — INT
Schedule
- schedule_id — INT
- flight_id — INT
- departure_time — DATETIME
- arrival_time — DATETIME
Seat_Assignment
- seat_id — INT
- reservation_id — INT
- seat_number — VARCHAR(10)