movie
Tables (20)
Actor (movies_actor)
- PK (actor_pk) — id — Primary key — NOT NULL
- Name (name) — varchar(50)
- ProfilePath (profile_path) — varchar(200)
Actor_Movie (movies_actor_movies)
- PK (pk) — id — Primary key — NOT NULL
- PK (actor_pk) — id — Foreign key → Actor.PK — NOT NULL
- PK (movie_pk) — id — Foreign key → Movie.Movie Pk — NOT NULL
Article (community_article)
- Article Pk (article_pk) — id — Primary key — NOT NULL
- Title (title) — varchar(100)
- Content (content) — text
- MovieTitle (movie_title) — varchar(200)
- CreateAt (create_at) — datetime
- UpdateAt (update_at) — datetime
- User Id (user_id) — integer(FK) — Foreign key → User.User Pk — NOT NULL
Article_LikeUsers (community_article_like_users)
- PK (pk) — id — Primary key — NOT NULL
- User Id (user_id) — id — Foreign key → User.User Pk — NOT NULL
- Article Id (article_id) — id — Foreign key → Article.Article Pk — NOT NULL
Certification (movies_certification)
- Certification Pk (certification_pk) — id — Primary key — NOT NULL
- Name (name) — varchar(50)
Certification_Movie (movies_certification_movies)
- PK (pk) — id — Primary key — NOT NULL
- PK (certification_pk) — id — Foreign key → Certification.Certification Pk — NOT NULL
- PK (movie_pk) — id — Foreign key → Movie.Movie Pk — NOT NULL
Comment (community_comment)
- Comment Pk (comment_pk) — id — Primary key — NOT NULL
- Content (content) — text
- CreateAt (create_at) — datetime
- UpdateAt (update_at) — datetime
- Article Id (article_id) — integer(FK) — Foreign key → Article.Article Pk — NOT NULL
- User Id (user_id) — integer(FK) — Foreign key → User.User Pk — NOT NULL
Director (movies_director)
- Director Pk (director_pk) — id — Primary key — NOT NULL
- Name (name) — varchar(50)
Director_Movie (movies_director_movies)
- PK (pk) — id — Primary key — NOT NULL
- PK (director_pk) — id — Foreign key → Director.Director Pk — NOT NULL
- PK (movie_pk) — id — Foreign key → Movie.Movie Pk — NOT NULL
Genre (movies_genre)
- Genre Pk (genre_pk) — id — Primary key — NOT NULL
- Name (name) — varchar(50)
Genre_Movie (movies_genre_movies)
- PK (pk) — id — Primary key — NOT NULL
- PK (genre_pk) — id — Foreign key → Genre.Genre Pk — NOT NULL
- PK (movie_pk) — id — Foreign key → Movie.Movie Pk — NOT NULL
Keyword (movies_keyword)
- Keyword Pk (keyword_pk) — id — Primary key — NOT NULL
- Name (name) — varchar(50)
Keyword_Movie (movies_keyword_movies)
- PK (pk) — id — Primary key — NOT NULL
- PK (movie_pk) — id — Foreign key → Movie.Movie Pk — NOT NULL
- PK (keyword_pk) — id — Foreign key → Keyword.Keyword Pk — NOT NULL
Movie (movies_movie)
- Movie Pk (movie_pk) — id — Primary key — NOT NULL
- Title (title) — varchar(100)
- OriginalTitle (original_title) — varchar(100)
- Overview (overview) — text
- PosterPath (poster_path) — varchar(200)
- ReleaseDate (release_date) — datetime
- Runtime (runtime) — integer
- Video (video) — varchar(100)
- VoteAverage (vote_average) — float
- VoteCount (vote_count) — integer
Movie_UsersMyMovie (movies_movie_users_mymovie)
- PK (pk) — id — Primary key — NOT NULL
- User Id (user_id) — id — Foreign key → User.User Pk — NOT NULL
- Movie Id (movie_id) — id — Foreign key → Movie.Movie Pk — NOT NULL
Movie_UsersWish (movies_movie_users_wish)
- PK (pk) — id — Primary key — NOT NULL
- User Id (user_id) — id — Foreign key → User.User Pk — NOT NULL
- Movie Id (movie_id) — id — Foreign key → Movie.Movie Pk — NOT NULL
OTT (movies_ott)
- Ott Pk (ott_pk) — id — Primary key — NOT NULL
- Name (name) — varchar(50)
Ott_Movie (movies_ott_movies)
- PK (pk) — id — Primary key — NOT NULL
- PK (ott_pk) — id — Foreign key → OTT.Ott Pk — NOT NULL
- PK (movie_pk) — id — Foreign key → Movie.Movie Pk — NOT NULL
Review (movies_review)
- Review Pk (review_pk) — id — Primary key — NOT NULL
- Content (content) — varchar(100)
- Rank (rank) — integer
- CreateAt (create_at) — datetime
- UpdateAt (update_at) — datetime
- User Id (user_id) — integer(FK) — Foreign key → User.User Pk — NOT NULL
- Movie Id (movie_id) — integer(FK) — Foreign key → Movie.Movie Pk — NOT NULL
User (accounts_user)
- User Pk (user_pk) — integer — Primary key — NOT NULL
- Username (username) — varchar(150)
- Password (password) — varchar(128)
- Email (email) — varchar(254)
- IsSuperuser (is_superuser) — bool
- IsStaff (is_staff) — bool
- IsActive (is_active) — bool
- LastName (last_name) — varchar(150)
- FirstName (first_name) — varchar(150)
- DateJoined (date_joined) — datetime
- LastLogin (last_login) — datetime