DBS
Tables (4)
Flight (비행편)
- flight_no (Key) — char — Primary key — NOT NULL
- departure_country (Field) — char
- departure_time (Field2) — char
- arrival_country (Field3) — char
- arrival_time (Field4) — char
- price (Field5) — char
Member (회원)
- id (id2) — char — Primary key — NOT NULL
- pwd — char
- name — char
- phone — char
- email (Field) — char
- nationality (Field2) — char
PreorderedMeal (사전기내식)
- name (Key) — char — Primary key — NOT NULL
- departure_airport (Field) — char
- image (Field2) — char
- explanation (Field3) — char
- category (Field4) — char
- price (Field5) — char
Reservation (예약)
- reservation_no (Key3) — char — Primary key — NOT NULL
- member_id (id2) — char — Foreign key → Member.id — NOT NULL
- flight_no (Key) — char — Foreign key → Flight.flight_no — NOT NULL
- meal_name (Key2) — char — Foreign key → PreorderedMeal.name — NOT NULL
- class (Field) — char
- seat (Field2) — char