ㅇ

Tables (23)

ATCAdvisory

  • advisory_id — INT
  • flight_id — INT
  • type — VARCHAR(50)
  • description — VARCHAR(255)
  • start_time — TIMESTAMP
  • end_time — TIMESTAMP

Airlines

  • airline_id — INT
  • name — VARCHAR(100)
  • iata_code — CHAR(2)
  • icao_code — CHAR(3)
  • country — VARCHAR(50)

Airports

  • airport_id — INT
  • name — VARCHAR(100)
  • iata_code — CHAR(3)
  • icao_code — CHAR(4)
  • city — VARCHAR(50)
  • country — VARCHAR(50)

Bookings

  • booking_id — INT
  • customer_id — INT
  • flight_id — INT
  • seat_id — INT
  • booking_date — TIMESTAMP

Corporate_Customers

  • corporate_id — INT
  • company_name — VARCHAR(100)
  • representative_name — VARCHAR(100)
  • contact_number — VARCHAR(20)
  • email — VARCHAR(100)
  • join_date — DATE
  • agreement_id — INT

Corporate_Discounts

  • agreement_id — INT
  • airline_id — INT
  • corporate_id — INT
  • discount_rate — DECIMAL(5, 2)
  • start_date — DATE
  • end_date — DATE

Corporate_Employees

  • employee_id — INT
  • corporate_id — INT
  • customer_id — INT
  • position — VARCHAR(50)

Crew

  • crew_id — INT
  • first_name — VARCHAR(50)
  • last_name — VARCHAR(50)
  • birth_date — DATE
  • gender — ENUM('M', 'F', 'O')
  • position — ENUM('Pilot', 'Co-Pilot', 'Flight Attendant', 'Other')

Crew_Assignments

  • assignment_id — INT
  • flight_id — INT
  • crew_id — INT

Crew_Flight_Plans

  • flight_plan_id — INT
  • crew_id — INT
  • assignment_id — INT
  • departure_time — TIMESTAMP
  • arrival_time — TIMESTAMP
  • flight_duration — INT

Customer_Identification

  • identification_id — INT
  • customer_id — INT
  • id_type — ENUM('주민등록증', '여권')
  • id_number — VARCHAR(50)
  • expiration_date — DATE

Customer_Miles

  • customer_miles_id — INT
  • customer_id — INT
  • program_id — INT
  • miles — INT

Customers

  • customer_id — INT
  • first_name — VARCHAR(50)
  • last_name — VARCHAR(50)
  • email — VARCHAR(100)
  • contact_number — VARCHAR(20)
  • birth_date — DATE
  • nationality — VARCHAR(50)
  • gender — ENUM('M', 'F', 'O')

Departures_Arrivals

  • departure_arrival_id — INT
  • flight_id — INT
  • route_id — INT
  • departure_time — TIMESTAMP
  • arrival_time — TIMESTAMP
  • miles — INT

Flight_Routes

  • route_id — INT
  • departure_airport_id — INT
  • arrival_airport_id — INT
  • distance — INT

Flight_Schedules

  • schedule_id — INT
  • flight_id — INT
  • available_date — DATE
  • season_code — ENUM('Winter', 'Spring', 'Summer', 'Autumn')

Flights

  • flight_id — INT
  • airline_id — INT
  • departure_airport_id — INT
  • arrival_airport_id — INT
  • departure_time — TIMESTAMP
  • arrival_time — TIMESTAMP

Individual_Customers

  • customer_id — INT
  • membership_type — ENUM('정회원', '간편회원')
  • join_date — DATE

Loyalty_Programs

  • program_id — INT
  • airline_id — INT
  • name — VARCHAR(100)

Products

  • product_id — INT
  • name — VARCHAR(100)
  • description — VARCHAR(255)
  • price — DECIMAL(10, 2)
  • airline_id — INT

Reservations

  • reservation_id — INT
  • customer_id — INT
  • flight_id — INT
  • departure_arrival_id — INT
  • booking_date — TIMESTAMP
  • status — ENUM('Confirmed', 'Cancelled', 'Pending')
  • class — ENUM('Economy', 'Premium Economy', 'Business', 'First Class')

Seat_Reservations

  • seat_reservation_id — INT
  • reservation_id — INT
  • seat_id — INT

Seats

  • seat_id — INT
  • flight_id — INT
  • seat_number — VARCHAR(10)
  • seat_class — ENUM('Economy', 'Premium Economy', 'Business', 'First Class')
  • is_available — BOOLEAN
  • price — DECIMAL(10, 2)