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