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)