영화예매 시스템
테이블 (10)
Food (Untitled5)
- Food_id (PK) — 기본 키 — NOT NULL
- Food_name (Field)
- food_price (Field2)
Food_order (Untitled7)
- food_order_id (Key2) — 기본 키 — NOT NULL
- Food_id (PK) — 외래 키 → Food.Food_id — NOT NULL
- order_id (Key) — 외래 키 → Order.order_id — NOT NULL
- count (Field)
Grade (Untitled10)
- grade_id (Key) — 기본 키 — NOT NULL
- grade_step (Field)
- grade_benefit (Field2)
Member (Untitled3)
- member_id (PK) — 기본 키 — NOT NULL
- member_name (.)
- member_phonenumber (Field)
- / (Field2)
Movie (Untitled2)
- movie_id (PK) — 기본 키 — NOT NULL
- movie_name (.)
- movie_genre (Field)
- / (Field2)
Movie_Theater (Untitled6)
- Movie_Theater_id (Key) — 기본 키 — NOT NULL
- movie_id (PK) — 외래 키 → Movie.movie_id — NOT NULL
- theater_id (pk2) — 외래 키 → Theater (상영관).theater_id — NOT NULL
- Field
Order (Untitled9)
- order_id (Key) — 기본 키 — NOT NULL
- member_id (PK2) — 외래 키 → Member.member_id — NOT NULL
Reservation (Untitled4)
- reservation_id (PK) — 기본 키 — NOT NULL
- member_id (FK) — 외래 키 → Member.member_id — NOT NULL
- Ticket_id (Key) — 외래 키 → Ticket.Ticket_id — NOT NULL
- reservation_time (Field)
- reservation_price (Field2)
- reservation_event (Field3)
- count (티켓 수량) (Field4)
Theater (상영관) (Untitled)
- theater_id (pk) — 기본 키 — NOT NULL
- theater_num (Field)
- theater_floor (Field2)
- Field3
Ticket (Untitled8)
- Ticket_id (Key) — 기본 키 — NOT NULL
- theater_id (pk) — 외래 키 → Theater (상영관).theater_id — NOT NULL
- movie_id (PK) — 외래 키 → Movie.movie_id — NOT NULL