ㅇ
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)