항공DB_개인
테이블 (11)
AIRCRAFT
- aircraft_code — VARCHAR2(10) — 기본 키 — NOT NULL
- model_name — VARCHAR2(50) — NOT NULL
- total_seats — NUMBER(4) — NOT NULL
- max_range — NUMBER(6) — NOT NULL
AIRLINE
- airline_code — VARCHAR2(10) — 기본 키 — NOT NULL
- airline_name — VARCHAR2(50) — NOT NULL
AIRPORT
- airport_code — VARCHAR2(10) — 기본 키 — NOT NULL
- airport_name — VARCHAR2(50) — NOT NULL
- region — VARCHAR2(30) — NOT NULL
- country — VARCHAR2(10) — NOT NULL
BAGGAGE
- baggage_id — VARCHAR2(15) — 기본 키 — NOT NULL
- ticket_id — VARCHAR2(10) — 외래 키 → TICKET.ticket_id — NOT NULL
- weight — NUMBER(5,2) — NOT NULL
- status — VARCHAR2(20) — NOT NULL
BOOKING
- booking_id — VARCHAR2(10) — 기본 키 — NOT NULL
- cno — VARCHAR2(10) — 외래 키 → CUSTOMER.cno — NOT NULL
- total_price — NUMBER(10) — NOT NULL
- book_date — DATE — NOT NULL
- status — VARCHAR2(20) — NOT NULL
CREW
- emp_no — VARCHAR2(10) — 기본 키 — NOT NULL
- emp_name — VARCHAR2(20) — NOT NULL
- job_role — VARCHAR2(20) — NOT NULL
- available_aircraft — VARCHAR2(10) — NOT NULL
CREW_ASSIGNMENT
- assignment_id — VARCHAR2(10) — 기본 키 — NOT NULL
- schedule_id — VARCHAR2(20) — 외래 키 → FLIGHT_SCHEDULE.schedule_id — NOT NULL
- emp_no — VARCHAR2(10) — 외래 키 → CREW.emp_no — NOT NULL
- flight_role — VARCHAR2(20) — NOT NULL
CUSTOMER
- cno — VARCHAR2(10) — 기본 키 — NOT NULL
- name — VARCHAR2(20) — NOT NULL
- phone — VARCHAR2(20) — NOT NULL
- birth — DATE — NOT NULL
- mileage — NUMBER(10)
- grade — VARCHAR2(10)
FLIGHT_SCHEDULE
- schedule_id — VARCHAR2(20) — 기본 키 — NOT NULL
- flight_name — VARCHAR2(20) — NOT NULL
- departure_airport — VARCHAR2(10) — 외래 키 → AIRPORT.airport_code — NOT NULL
- arrival_airport — VARCHAR2(10) — 외래 키 → AIRPORT.airport_code — NOT NULL
- aircraft_code — VARCHAR2(10) — 외래 키 → AIRCRAFT.aircraft_code — NOT NULL
- departure_time — DATE — NOT NULL
- arrival_time — DATE — NOT NULL
- base_price — NUMBER(10) — NOT NULL
- status — VARCHAR2(20) — NOT NULL
MAINTENANCE_LOG
- log_id — VARCHAR2(10) — 기본 키 — NOT NULL
- aircraft_code — VARCHAR2(10) — 외래 키 → AIRCRAFT.aircraft_code — NOT NULL
- maintenance_date — DATE — NOT NULL
- description — VARCHAR2(100) — NOT NULL
- pass_status — VARCHAR2(10) — NOT NULL
TICKET
- ticket_id — VARCHAR2(10) — 기본 키 — NOT NULL
- booking_id — VARCHAR2(10) — 외래 키 → BOOKING.booking_id — NOT NULL
- schedule_id — VARCHAR2(20) — 외래 키 → FLIGHT_SCHEDULE.schedule_id — NOT NULL
- seat_no — VARCHAR2(5) — NOT NULL
- passenger_name — VARCHAR2(20) — NOT NULL
- baggage_opt — VARCHAR2(2) — NOT NULL