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