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)