MegaBox
Tables (8)
actor
- id — INT
- name — VARCHAR(50) — NOT NULL
- birth — DATE
- grade — BOOLEAN
- nationality — VARCHAR(50)
customer
- id — INT
- name — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- birth — DATE
- point — INT
movie
- id — INT
- name — VARCHAR(100) — NOT NULL
- content — TEXT
- release_date — DATE
- audience_rating — VARCHAR(10)
- running_time — INT
- actor_id — INT — Foreign key → actor.id
reservation
- id — INT
- customer_id — INT — Foreign key → customer.id
- running_time_id — INT — Foreign key → running_time_table.id
- seat_id — INT — Foreign key → seat.id
- payment_amount — INT
- payment_status — BOOLEAN
running_time_table
- id — INT
- movie_id — INT — Foreign key → movie.id
- theater_id — INT — Foreign key → theater.id
- screening_time_id — INT — Foreign key → time_slot.id
seat
- id — INT
- seat_name — VARCHAR(10) — NOT NULL
- status — BOOLEAN
- theater_id — INT — Foreign key → theater.id
theater
- id — INT
- theater_name — VARCHAR(50) — NOT NULL
- branch_name — VARCHAR(50)
- total_seat_number — INT
time_slot
- id — INT
- running_time — VARCHAR(10)