데베설 팀플
테이블 (11)
AIRLINE (Untitled10)
- AIRLINE_ID (Key) — 기본 키 — NOT NULL
- airline_code (Field)
- airline_name (Field2)
- airline_country (Field3)
- created_at (Field4)
- updated_at (Field5)
AIRPORT (Untitled6)
- AIRPORT_ID (Key) — 기본 키 — NOT NULL
- airport_name (Field)
- country (Field2)
- state (Field3)
- city (Field4)
- created_at (Field5)
- updated_at (Field6)
BAGGAGE (Untitled8)
- BAGGAGE_ID (Key) — 기본 키 — NOT NULL
- PASSENGERS_ID (Key22) — 외래 키 → BOOKING.PASSENGERS_ID — NOT NULL
- weight_in_kg (Field)
- created_at (Field2)
- updated_at (Field3)
BAGGAGE_CHECK (Untitled3)
- BAGGAGE_CHECK_ID (Key) — 기본 키 — NOT NULL
- BOOKING_ID (Key3) — 외래 키 → BOOKING.BOOKING_ID — NOT NULL
- PASSENGERS_ID (Key22) — 외래 키 → NO_FLY_LIST.PASSENGERS_ID — NOT NULL
- check_result (Field)
- created_at (Field2)
- updated_at (Field3)
BOARDING_PASS (Untitled11)
- BOARDING_PASS_ID (Key) — 기본 키 — NOT NULL
- BOOKING_ID (Key2) — 외래 키 → BOOKING.BOOKING_ID — NOT NULL
- PASSENGERS_ID (Key22) — 외래 키 → BOOKING.PASSENGERS_ID — NOT NULL
- qr_code (Field)
- created_at (Field2)
- updated_at (Field3)
BOOKING (Untitled7)
- BOOKING_ID (Key) — 기본 키 — NOT NULL
- PASSENGERS_ID (Key2) — 외래 키 → PASSENGERS.PASSENGERS_ID — NOT NULL
- flight_id (Field)
- status (Field2)
- booking_platform (Field3)
- created_at (Field4)
- updated_at (Field5)
FLIGHTS (Untitled5)
- FLIGHTS_ID (Key) — 기본 키 — NOT NULL
- AIRLINE_ID (Key2) — 외래 키 → AIRLINE.AIRLINE_ID — NOT NULL
- AIRPORT_ID (Key3) — 외래 키 → AIRPORT.AIRPORT_ID — NOT NULL
- departing_gate (Field)
- arriving_gate (Field2)
- created_at (Field3)
- updated_at (Field4)
FLIGHTS_MANIFEST (Untitled9)
- FLIGHTS_MANIFEST_ID (Key) — 기본 키 — NOT NULL
- BOOKING_ID (Key2) — 외래 키 → BOOKING.BOOKING_ID — NOT NULL
- FLIGHTS_ID (Key3) — 외래 키 → FLIGHTS.FLIGHTS_ID — NOT NULL
- created_at (Field)
- updated_at (Field2)
NO_FLY_LIST (Untitled4)
- NO_FLY_LIST_ID (Key) — 기본 키 — NOT NULL
- PASSENGERS_ID (Key2) — 외래 키 → PASSENGERS.PASSENGERS_ID — NOT NULL
- active_from (Field)
- active_to (Field2)
- no_fly_reason (Field3)
- created_at (Field4)
- updated_at (Field5)
PASSENGERS (Untitled)
- PASSENGERS_ID (Key) — 기본 키 — NOT NULL
- first_name (Field)
- last_name (Field2)
- date_of_birth (Field3)
- country_of_citizenship (Field4)
- country_of_residence (Field5)
- passport_number (Field6)
- created_at (Field7)
- updated_at (Field8)
SECORITY_CHECK (Untitled2)
- SECORITY_CHECK_ID (Key) — 기본 키 — NOT NULL
- PASSENGERS_ID (Key2) — 외래 키 → PASSENGERS.PASSENGERS_ID — NOT NULL
- check_result (Field)
- comments (Field2)
- created_at (Field3)
- updated_at (Field4)