탑건

테이블 (29)

AIRCRAFT

  • aircraft_id — NUMBER — 기본 키 — NOT NULL
  • reg_no — VARCHAR2(20) — NOT NULL
  • model_name — VARCHAR2(50) — NOT NULL
  • total_seats — NUMBER(4) — NOT NULL
  • aircraft_status_id — NUMBER — 외래 키 → AIRCRAFT_STATUS.aircraft_status_id — NOT NULL
  • is_active — CHAR(1) — NOT NULL

AIRCRAFT_STATUS

  • aircraft_status_id — NUMBER — 기본 키 — NOT NULL
  • status_name — VARCHAR2(50) — NOT NULL
  • is_active — CHAR(1) — NOT NULL

AIRPORT

  • airport_id — NUMBER — 기본 키 — NOT NULL
  • iata_code — CHAR(3) — NOT NULL
  • airport_name — VARCHAR2(100) — NOT NULL
  • country — VARCHAR2(50) — NOT NULL
  • timezone — VARCHAR2(40) — NOT NULL
  • region_id — NUMBER — 외래 키 → REGION.region_id — NOT NULL
  • flight_type — VARCHAR2(3) — NOT NULL
  • is_active — CHAR(1) — NOT NULL

BOOKING

  • booking_id — NUMBER — 기본 키 — NOT NULL
  • booking_no — VARCHAR2(20) — NOT NULL
  • member_id — NUMBER — 외래 키 → MEMBER.member_id — NOT NULL
  • trip_type — VARCHAR2(10) — NOT NULL
  • outbound_flight_id — NUMBER — 외래 키 → FLIGHT.flight_id — NOT NULL
  • inbound_flight_id — NUMBER — 외래 키 → FLIGHT.flight_id
  • status — VARCHAR2(10) — NOT NULL
  • total_amount — NUMBER(12) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • cancelled_at — TIMESTAMP

BOOKING_PASSENGER

  • booking_passenger_id — NUMBER — 기본 키 — NOT NULL
  • booking_id — NUMBER — 외래 키 → BOOKING.booking_id — NOT NULL
  • saved_passenger_id — NUMBER — 외래 키 → SAVED_PASSENGER.saved_passenger_id
  • name — VARCHAR2(50) — NOT NULL
  • birth_date — DATE — NOT NULL
  • phone — VARCHAR2(20)
  • gender — CHAR(1)
  • passport_no — VARCHAR2(20)
  • passport_expiry — DATE

CHAT_INQUIRY

  • inquiry_id — NUMBER — 기본 키 — NOT NULL
  • member_id — NUMBER — 외래 키 → MEMBER.member_id — NOT NULL
  • staff_id — NUMBER — 외래 키 → MEMBER.member_id
  • status — VARCHAR2(15) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • resolved_at — TIMESTAMP

CHAT_MESSAGE

  • message_id — NUMBER — 기본 키 — NOT NULL
  • inquiry_id — NUMBER — 외래 키 → CHAT_INQUIRY.inquiry_id — NOT NULL
  • sender_id — NUMBER — 외래 키 → MEMBER.member_id — NOT NULL
  • sender_type — VARCHAR2(10) — NOT NULL
  • content — VARCHAR2(2000) — NOT NULL
  • sent_at — TIMESTAMP — NOT NULL

EVENT

  • event_id — NUMBER — 기본 키 — NOT NULL
  • title — VARCHAR2(200) — NOT NULL
  • content — CLOB — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • image_url — VARCHAR2(500)
  • is_visible — CHAR(1) — NOT NULL
  • is_ended — CHAR(1) — NOT NULL
  • created_by — NUMBER — 외래 키 → MEMBER.member_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

FAQ

  • faq_id — NUMBER — 기본 키 — NOT NULL
  • category — VARCHAR2(30) — NOT NULL
  • question — VARCHAR2(300) — NOT NULL
  • answer — CLOB — NOT NULL
  • is_visible — CHAR(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

FARE

  • fare_id — NUMBER — 기본 키 — NOT NULL
  • route_id — NUMBER — 외래 키 → ROUTE.route_id — NOT NULL
  • seat_class_id — NUMBER — 외래 키 → SEAT_CLASS.seat_class_id — NOT NULL
  • season_id — NUMBER — 외래 키 → SEASON.season_id — NOT NULL
  • price — NUMBER(10) — NOT NULL
  • is_active — CHAR(1) — NOT NULL

FAVORITE_ROUTE

  • favorite_id — NUMBER — 기본 키 — NOT NULL
  • member_id — NUMBER — 외래 키 → MEMBER.member_id — NOT NULL
  • favorite_type — VARCHAR2(10) — NOT NULL
  • departure_airport_id — NUMBER — 외래 키 → AIRPORT.airport_id
  • arrival_airport_id — NUMBER — 외래 키 → AIRPORT.airport_id
  • flight_id — NUMBER — 외래 키 → FLIGHT.flight_id
  • created_at — TIMESTAMP — NOT NULL

FLIGHT

  • flight_id — NUMBER — 기본 키 — NOT NULL
  • flight_no — VARCHAR2(10) — NOT NULL
  • route_id — NUMBER — 외래 키 → ROUTE.route_id — NOT NULL
  • aircraft_id — NUMBER — 외래 키 → AIRCRAFT.aircraft_id — NOT NULL
  • departure_gate_id — NUMBER — 외래 키 → GATE.gate_id
  • arrival_gate_id — NUMBER — 외래 키 → GATE.gate_id
  • departure_time — TIMESTAMP — NOT NULL
  • arrival_time — TIMESTAMP — NOT NULL
  • flight_status — VARCHAR2(15) — NOT NULL
  • delay_minutes — NUMBER(5)
  • is_deleted — CHAR(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

FLIGHT_FARE

  • flight_fare_id — NUMBER — 기본 키 — NOT NULL
  • flight_id — NUMBER — 외래 키 → FLIGHT.flight_id — NOT NULL
  • seat_class_id — NUMBER — 외래 키 → SEAT_CLASS.seat_class_id — NOT NULL
  • price — NUMBER(10) — NOT NULL

FLIGHT_NOTICE

  • flight_notice_id — NUMBER — 기본 키 — NOT NULL
  • flight_id — NUMBER — 외래 키 → FLIGHT.flight_id — NOT NULL
  • notice_type — VARCHAR2(10) — NOT NULL
  • reason — VARCHAR2(500) — NOT NULL
  • delay_minutes — NUMBER(5)
  • created_by — NUMBER — 외래 키 → MEMBER.member_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

GATE

  • gate_id — NUMBER — 기본 키 — NOT NULL
  • airport_id — NUMBER — 외래 키 → AIRPORT.airport_id — NOT NULL
  • gate_code — VARCHAR2(10) — NOT NULL
  • gate_area_id — NUMBER — 외래 키 → GATE_AREA.gate_area_id — NOT NULL
  • flight_type — VARCHAR2(3) — NOT NULL
  • is_active — CHAR(1) — NOT NULL

GATE_AREA

  • gate_area_id — NUMBER — 기본 키 — NOT NULL
  • area_name — VARCHAR2(50) — NOT NULL
  • is_active — CHAR(1) — NOT NULL

MEMBER

  • member_id — NUMBER — 기본 키 — NOT NULL
  • login_id — VARCHAR2(50) — NOT NULL
  • password — VARCHAR2(255) — NOT NULL
  • name — VARCHAR2(50) — NOT NULL
  • email — VARCHAR2(100)
  • phone — VARCHAR2(20)
  • role — VARCHAR2(10) — NOT NULL
  • status — VARCHAR2(10) — NOT NULL
  • suspend_reason — VARCHAR2(200)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

NOTICE

  • notice_id — NUMBER — 기본 키 — NOT NULL
  • title — VARCHAR2(200) — NOT NULL
  • content — CLOB — NOT NULL
  • is_public — CHAR(1) — NOT NULL
  • created_by — NUMBER — 외래 키 → MEMBER.member_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

NOTIFICATION

  • notification_id — NUMBER — 기본 키 — NOT NULL
  • member_id — NUMBER — 외래 키 → MEMBER.member_id — NOT NULL
  • type — VARCHAR2(30) — NOT NULL
  • content — VARCHAR2(500) — NOT NULL
  • ref_type — VARCHAR2(20)
  • ref_url — VARCHAR2(100)
  • is_read — CHAR(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

PAYMENT

  • payment_id — NUMBER — 기본 키 — NOT NULL
  • booking_id — NUMBER — 외래 키 → BOOKING.booking_id — NOT NULL
  • method — VARCHAR2(20) — NOT NULL
  • amount — NUMBER(12) — NOT NULL
  • status — VARCHAR2(16) — NOT NULL
  • imp_uid — VARCHAR2(50)
  • merchant_uid — VARCHAR2(50)
  • paid_at — TIMESTAMP
  • refund_amount — NUMBER(12)
  • refunded_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

REFUND

  • refund_id — NUMBER — 기본 키 — NOT NULL
  • payment_id — NUMBER — 외래 키 → PAYMENT.payment_id — NOT NULL
  • ticket_id — NUMBER — 외래 키 → TICKET.ticket_id — NOT NULL
  • amount — NUMBER(10) — NOT NULL
  • reason — VARCHAR2(200)
  • refunded_at — TIMESTAMP — NOT NULL

REGION

  • region_id — NUMBER — 기본 키 — NOT NULL
  • region_name — VARCHAR2(50) — NOT NULL
  • is_active — CHAR(1) — NOT NULL

ROUTE

  • route_id — NUMBER — 기본 키 — NOT NULL
  • departure_airport_id — NUMBER — 외래 키 → AIRPORT.airport_id — NOT NULL
  • arrival_airport_id — NUMBER — 외래 키 → AIRPORT.airport_id — NOT NULL
  • flight_type — VARCHAR2(3) — NOT NULL
  • route_type_id — NUMBER — 외래 키 → ROUTE_TYPE.route_type_id — NOT NULL
  • is_active — CHAR(1) — NOT NULL

ROUTE_TYPE

  • route_type_id — NUMBER — 기본 키 — NOT NULL
  • type_name — VARCHAR2(50) — NOT NULL
  • is_active — CHAR(1) — NOT NULL

SAVED_PASSENGER

  • saved_passenger_id — NUMBER — 기본 키 — NOT NULL
  • member_id — NUMBER — 외래 키 → MEMBER.member_id — NOT NULL
  • name — VARCHAR2(50) — NOT NULL
  • birth_date — DATE — NOT NULL
  • phone — VARCHAR2(20)
  • gender — CHAR(1)
  • passport_no — VARCHAR2(20)
  • passport_expiry — DATE
  • created_at — TIMESTAMP — NOT NULL

SEASON

  • season_id — NUMBER — 기본 키 — NOT NULL
  • season_name — VARCHAR2(50) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • is_active — CHAR(1) — NOT NULL

SEAT

  • seat_id — NUMBER — 기본 키 — NOT NULL
  • aircraft_id — NUMBER — 외래 키 → AIRCRAFT.aircraft_id — NOT NULL
  • seat_no — VARCHAR2(5) — NOT NULL
  • seat_class_id — NUMBER — 외래 키 → SEAT_CLASS.seat_class_id — NOT NULL
  • is_active — CHAR(1) — NOT NULL

SEAT_CLASS

  • seat_class_id — NUMBER — 기본 키 — NOT NULL
  • class_name — VARCHAR2(50) — NOT NULL
  • ROWS — NUMBER(2) — NOT NULL
  • COLUMNS — NUMBER(2) — NOT NULL
  • sort_order — NUMBER(3) — NOT NULL
  • is_active — CHAR(1) — NOT NULL

TICKET

  • ticket_id — NUMBER — 기본 키 — NOT NULL
  • booking_id — NUMBER — 외래 키 → BOOKING.booking_id — NOT NULL
  • booking_passenger_id — NUMBER — 외래 키 → BOOKING_PASSENGER.booking_passenger_id — NOT NULL
  • flight_id — NUMBER — 외래 키 → FLIGHT.flight_id — NOT NULL
  • seat_id — NUMBER — 외래 키 → SEAT.seat_id — NOT NULL
  • leg_type — VARCHAR2(10) — NOT NULL
  • fare_amount — NUMBER(10) — NOT NULL
  • hold_status — VARCHAR2(10) — NOT NULL
  • held_at — TIMESTAMP — NOT NULL
  • expired_at — TIMESTAMP
  • checkin_status — VARCHAR2(15) — NOT NULL
  • checked_in_at — TIMESTAMP
  • checked_in_by — NUMBER — 외래 키 → MEMBER.member_id
  • boarded_at — TIMESTAMP
  • boarded_by — NUMBER — 외래 키 → MEMBER.member_id