탑건
테이블 (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