db
Tables (15)
Actor (actor)
- ActorID (id) — int — Primary key — NOT NULL
- ActorName (name) — varchar(100)
- Gender (gender) — varchar(10)
- Age (age) — int
Cinema (cinema)
- CinemaID (id) — int — Primary key — NOT NULL
- CinemaName (name) — varchar(100)
- CinemaLocation (location) — varchar(225)
- Time (time) — varchar(225)
Cinema_Room (Untitled)
- CinemaID (id) — int — Foreign key → Cinema.CinemaID — NOT NULL
- SeatID (id2) — int — Foreign key → Room.SeatID — NOT NULL
Director
- DirectorID (id) — int — Primary key — NOT NULL
- DirectorName (name) — varchar(100)
- Gender (gender) — varchar(10)
- Age (age) — int
Favorite (favorite)
- MovieID (id2) — int — Foreign key → Movie.MovieID
- UserID (id3) — int — Foreign key → User.UserID — NOT NULL
Genre (genre)
- GenreName (name) — varchar(25) — Primary key — NOT NULL
Language (language)
- LanguageName (id) — varchar(25) — Primary key — NOT NULL
Movie (movie)
- MovieID (id) — int — Primary key
- MovieName (name) — varchar(100)
- MoviePoster (poster) — varchar(225)
- ReleaseYear (year) — int
- Summary (summary) — varchar(225)
- Rating (rating) — int
- LanguageName (id2) — varchar(25) — Foreign key → Language.LanguageName — NOT NULL
Room (seat)
- SeatID (id) — int — Primary key — NOT NULL
Tickets (ticket)
- TicketID (id) — int — Primary key — NOT NULL
- Price (price) — int
- Date (date) — varchar(100)
- UserID (id2) — int — Foreign key → User.UserID — NOT NULL
- CinemaID (id3) — int — Foreign key → Cinema_Room.CinemaID — NOT NULL
- SeatID (id22) — int — Foreign key → Cinema_Room.SeatID — NOT NULL
User (users)
- UserID (id) — int — Primary key — NOT NULL
- User Name (name) — varchar(20)
- User Password (password) — varchar(20)
director-movie connect (director_movie_connect)
- MovieID (id2) — int — Foreign key → Movie.MovieID
- DirectorID (id) — int — Foreign key → Director.DirectorID — NOT NULL
movie-actor connect (movie_actor_connect)
- ActorID (id) — int — Foreign key → Actor.ActorID — NOT NULL
- MovieID (id2) — int — Foreign key → Movie.MovieID
movie-cinema connect (movie_cinema_connect)
- MovieID (id) — int — Foreign key → Movie.MovieID
- CinemaID (id2) — int — Foreign key → Cinema.CinemaID — NOT NULL
movie-genre connect (movie_genere_connect)
- GenreName (name) — varchar(25) — Foreign key → Genre.GenreName — NOT NULL
- MovieID (id2) — int — Foreign key → Movie.MovieID