Movie_ticketing
Tables (12)
Actor (Untitled4)
- actor_id (PK) — int — Primary key — NOT NULL
- actor_name (Field) — varchar
- Field2
Actor_Movie (Untitled12)
- actor_movie_id (Key) — int — Primary key — NOT NULL
- actor_id (PK) — int — Foreign key → Actor.actor_id — NOT NULL
- movie_id (PK2) — int — Foreign key → Movie.movie_id — NOT NULL
Cinema (Untitled7)
- cinema_id (Key) — int — Primary key — NOT NULL
- cinema_name (Field2) — varchar
- Field
Director (Untitled9)
- director_id (PK) — int — Primary key — NOT NULL
- director_name (Field) — varchar
- Field2
Director_Movie (Untitled10)
- director_movie_id (PK) — int — Primary key — NOT NULL
- movie_id (FK) — int — Foreign key → Movie.movie_id — NOT NULL
- director_id (PK2) — int — Foreign key → Director.director_id — NOT NULL
- Field
Genre (Untitled5)
- genre_id (PK) — Primary key — NOT NULL
- gere_name (Field) — varchar
- Field2
Genre_Movie (Untitled6)
- genre_movie_id (PK) — int — Primary key — NOT NULL
- genre_id (FK) — int — Foreign key → Genre.genre_id — NOT NULL
- movie_id (FK2) — int — Foreign key → Movie.movie_id — NOT NULL
Member (Untitled2)
- member_id (PK) — int — Primary key — NOT NULL
- member_name (Field) — varchar
- Field2
Movie (Untitled)
- movie_id (PK) — int — Primary key — NOT NULL
- movie_title (Field) — varchar
- runningtime (Field4) — time
- Field2
Reservation (Untitled11)
- reservation_id (Key) — int — Primary key — NOT NULL
- member_id (PK) — int — Foreign key → Member.member_id — NOT NULL
- Field
Theater (Untitled13)
- theater_id (PK) — int — Primary key — NOT NULL
- cinema_id (Key) — int — Foreign key → Cinema.cinema_id — NOT NULL
- movie_id (PK2) — int — Foreign key → Movie.movie_id — NOT NULL
- location (Field) — String
- seat (Field2) — int
- Field3
Ticket (Untitled3)
- ticket_id (Key) — int — Primary key — NOT NULL
- reservation_id (Key3) — int — Foreign key → Reservation.reservation_id — NOT NULL
- theater_id (PK) — int — Foreign key → Theater.theater_id — NOT NULL
- cinema_id (Key2) — int — Foreign key → Theater.cinema_id — NOT NULL
- movie_id (PK2) — int — Foreign key → Theater.movie_id — NOT NULL
- reservation_available (Field) — boolean
- price (Field3)