Cinema
Tables (7)
Movie (영화)
- id (Key) — bidint — Primary key — NOT NULL
- Movie_Name (Field) — varchar(255)
- Running_Time (Field2) — int
Movie_Time (상영 시간)
- id (Key) — bigint — Primary key — NOT NULL
- Movie_id (영화) — bidint — Foreign key → Movie.id — NOT NULL
- Theater_id (상영관) — bigint — Foreign key → Theater.id — NOT NULL
- Field
- Field2
Payment (결제)
- id (Key) — bigint — Primary key — NOT NULL
- Ticket_id (티켓) — bigint — Foreign key → Ticket.id — NOT NULL
- User_id (사용자) — bigint — Foreign key → User.id — NOT NULL
- Field
- Field2
Seat (좌석)
- id (Key) — bigint — Primary key — NOT NULL
- id (Key2) — bigint — Foreign key → Theater.id — NOT NULL
- Field
- Field2
Theater (상영관)
- id (Key) — bigint — Primary key — NOT NULL
- Theater_number (Field) — int
- Seat_count (Field2) — int
Ticket (표)
- id (Key) — bigint — Primary key — NOT NULL
- Movie_time_id (상영시간) — bigint — Foreign key → Movie_Time.id — NOT NULL
- Seat_id (좌석) — bigint — Foreign key → Seat.id — NOT NULL
- Field
- Field2
- Field3
User (사용자)
- id (Key) — bigint — Primary key — NOT NULL
- Field
- Field2