ureaca-cinemasys
Tables (6)
customer
- custid — INT
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- email — VARCHAR(100)
- age — INT — NOT NULL
movie
- movieid — INT
- title — VARCHAR(100) — NOT NULL
- genre — VARCHAR(50)
- director — VARCHAR(50)
- rating — VARCHAR(20)
reservation
- reservid — INT
- custid — INT — Foreign key → customer.custid — NOT NULL
- screenid — INT — Foreign key → screening.screenid — NOT NULL
- seatno — VARCHAR(10) — NOT NULL
- reservdate — DATE — NOT NULL
screening
- screenid — INT
- movieid — INT — Foreign key → movie.movieid — NOT NULL
- theaterid — INT — Foreign key → theater.theaterid — NOT NULL
- showtime — DATETIME — NOT NULL
- price — INT — NOT NULL
theater
- theaterid — INT
- name — VARCHAR(50) — NOT NULL
- total_seats — INT — NOT NULL