항공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