ㄷㅇㅌㅂㅇㅅㄴ

Tables (4)

airplane

  • airplane_id — VARCHAR(50) — Primary key — NOT NULL
  • departure_date — DATE — NOT NULL
  • departure_time — TIME — NOT NULL

credit_card

  • card_number — VARCHAR(50) — Primary key — NOT NULL
  • expiry_date — VARCHAR(10) — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → member.user_id

member

  • user_id — VARCHAR(50) — Primary key — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • name — VARCHAR(50) — NOT NULL

seat

  • seat_id — VARCHAR(20) — Primary key — NOT NULL
  • airplane_id — VARCHAR(50) — Foreign key → airplane.airplane_id — NOT NULL
  • grade — VARCHAR(20) — NOT NULL
  • reserved_user_id — VARCHAR(50) — Foreign key → member.user_id