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