t
Tables (6)
Customer (Untitled4)
- cust_id (Key) — Primary key — NOT NULL
- phone (Field)
- name (Field2)
Movie (Untitled3)
- movie_id (Key) — INT — Primary key — NOT NULL
- movie_name (Field) — VARCHAR(20)
- start_date (Field2) — DATETIME
- finish_date (Field3) — DATETIME
- Field4
Screen (Untitled2)
- screen_id (Key) — INT — Primary key — NOT NULL
- seat_count (Field) — INT
- screen_name (Field2) — VARCHAR(3)
Seat (좌석)
- seat_id (Key) — INT — Primary key — NOT NULL
- screen_id (Key2) — INT — Foreign key → Screen.screen_id — NOT NULL
- status (Field) — VARCHAR(20)
- seat_num (Field2) — VARCHAR(4)
- price (Field3)
Ticket (Untitled5)
- ticket_id (Key) — INT — Primary key — NOT NULL
- id (Key3) — INT — Foreign key → screenPeriod.id — NOT NULL
- seat_id (Key5) — INT — Foreign key → Seat.seat_id — NOT NULL
- cust_id (Key4) — Foreign key → Customer.cust_id — NOT NULL
- movie_id (Key2) — INT — Foreign key → screenPeriod.movie_id — NOT NULL
- phone (Field) — VARCHAR(20)
- price (Field3) — VARCHAR(20)
screenPeriod (Untitled)
- id (Key) — INT — Primary key — NOT NULL
- screen_id (Key4) — INT — Foreign key → Screen.screen_id — NOT NULL
- movie_id (Key2) — INT — Foreign key → Movie.movie_id — NOT NULL
- start_time (Field) — datetime
- finish_time (Field2) — datetime
- Field3