CornFlix

Tables (9)

accounts_user (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • username (Field) — varchar(150)
  • password (Field2) — varchar(128)
  • email (Field3) — varchar(255)
  • is_superuser (Field4) — bool
  • is_staff (Field5) — bool
  • is_active (Field6) — bool
  • last_name (Field7) — varchar(150)
  • first_name (Field8) — varchar(150)
  • date_joined (Field9) — datetime
  • last_login (Field10) — datetime

accounts_user_followings (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • from_user_id (Key3) — int — Foreign key → accounts_user.id — NOT NULL
  • to_user_id (Key2) — int — Foreign key → accounts_user.id — NOT NULL

acounts_like_movie (Untitled7)

  • user_id (Key) — int — Foreign key → accounts_user.id — NOT NULL
  • movie_id (Key2) — int — Foreign key → movies_movie.id — NOT NULL

community_comment (Untitled8)

  • id (Key2) — Primary key — NOT NULL
  • user_id (Key) — int — Foreign key → accounts_user.id — NOT NULL
  • post_id (Key3) — int — Foreign key → community_post.id — NOT NULL
  • content (Field) — text
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime

community_post (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → accounts_user.id — NOT NULL
  • title (Field) — varchar(100)
  • content (Field2) — text
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime

community_review (CopyOfUntitled6)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → accounts_user.id — NOT NULL
  • movie_id (Key3) — int — Foreign key → movies_movie.id — NOT NULL
  • title (Field) — varchar(100)
  • content (Field2) — text
  • rank (Field3) — int
  • created_at (Field4) — datetime
  • updated_at (Field5) — datetime

genre (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(50)

movies_movie (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • title — varchar(100)
  • overview — text
  • popularity (Field) — real
  • poster_path (Field2) — varchar(200)
  • release_date (Field3) — date

movies_movie_genres (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • movie_id (Key4) — int — Foreign key → movies_movie.id — NOT NULL
  • genre_id (Key2) — int — Foreign key → genre.id — NOT NULL