admin

테이블 (6)

Flight (Untitled)

  • flight_id (Key) — 기본 키 — NOT NULL
  • flight_name (Field)
  • departure_airport (Field2)
  • arrival_airport (Field3)
  • fee (Field4)
  • departure_time (Field5)
  • arrivalTime (Field6)

Member (Untitled2)

  • member_id (Key) — 기본 키 — NOT NULL
  • member_name (Field)
  • member_email (Field2)
  • member_password (Field3)
  • passport_number (Field4)

Reservation (Untitled3)

  • reservation_id (Key) — 기본 키 — NOT NULL
  • price (Field)
  • reservation_date (Field2)
  • member_id (Key2) — 외래 키 → Member.member_id — NOT NULL
  • flight_id (Key3) — 외래 키 → Flight.flight_id — NOT NULL

게시글 (Post)

  • Key (id) — 기본 키 — NOT NULL
  • Field (title)
  • Field (content)
  • Key (member_id) — 외래 키 → 사용자.Key — NOT NULL

댓글 (Comment)

  • Key (id) — 기본 키 — NOT NULL
  • Field (content)
  • Key (member_id) — 외래 키 → 사용자.Key — NOT NULL
  • Key (post_id) — 외래 키 → 게시글.Key — NOT NULL

사용자 (Member)

  • Key (id) — 기본 키 — NOT NULL
  • Field (email)
  • Field (password)