moview

Django project for movie-reviewing community

Tables (5)

Comment (articles_comment)

  • id — integer — Primary key — NOT NULL
  • review_id — integer — Foreign key → Review.id — NOT NULL
  • user_id — integer — Foreign key → User.id — NOT NULL
  • content — text

Follower (accounts_user_followers)

  • id — integer — Primary key — NOT NULL
  • from_user_id — integer — Foreign key → User.id — NOT NULL
  • to_user_id — integer — Foreign key → User.id — NOT NULL

Movie

  • id — integer — Primary key — NOT NULL
  • title — varchar(30)
  • url — varchar(100)

Review

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → User.id — NOT NULL
  • movie_id — integer — Foreign key → Movie.id — NOT NULL
  • title — varchar(100)
  • content — text
  • created_at — datetime
  • updated_at — datetime

User (accounts_user)

  • id — integer — Primary key — NOT NULL
  • password — varchar(128) — NOT NULL
  • last_login — datetime
  • is_superuser — bool
  • username — varchar(150)
  • first_name — varchar(30)
  • last_name — varchar(150)
  • email — varchar(254)
  • is_staff — bool
  • is_active — bool
  • date_joined — datetime