test
Tables (11)
Actors
- actor_id — INT
- actor_name — VARCHAR(255) — NOT NULL
Bookings
- booking_id — INT
- member_id — INT — NOT NULL
- screening_id — INT — NOT NULL
- seat_id — INT — NOT NULL
- booking_date — DATE — NOT NULL
- payment_method — VARCHAR(255) — NOT NULL
Castings
- casting_id — INT
- movie_id — INT — NOT NULL
- actor_id — INT — NOT NULL
- casting_date — DATE — NOT NULL
Members
- member_id — INT
- username — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(15) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- residence_area — VARCHAR(255) — NOT NULL
- membership_level — INT
- rewards — DECIMAL(10, 2)
MovieActors
- movie_id — INT — Primary key — NOT NULL
- actor_id — INT — Primary key — NOT NULL
Movies
- movie_id — INT
- title — VARCHAR(255) — NOT NULL
- genre — VARCHAR(255) — NOT NULL
- director — VARCHAR(255) — NOT NULL
- release_date — DATE — NOT NULL
- production_company — VARCHAR(255) — NOT NULL
Screenings
- screening_id — INT
- movie_id — INT — NOT NULL
- theater_id — INT — NOT NULL
- screening_date — DATE — NOT NULL
- theater_name — VARCHAR(255) — NOT NULL
- screening_time — TIME — NOT NULL
Seats
- seat_id — INT
- seat_number — INT — NOT NULL
- row_number — INT — NOT NULL
- column_number — INT — NOT NULL
- seat_name — VARCHAR(255) — NOT NULL
- theater_id — INT — NOT NULL
Theaters
- theater_id — INT
- theater_name — VARCHAR(255) — NOT NULL
- location — VARCHAR(255) — NOT NULL
- screens — INT — NOT NULL