fin_pjt_django
Tables (11)
accounts_user (Untitled)
- id (Key) — integer — Primary key — NOT NULL
- username (Field2) — varchar(150) — NOT NULL
- password (Field) — varchar(128) — NOT NULL
- nickname (Field3) — varchar(20) — NOT NULL
accounts_user_followers (Untitled2)
- id (Key) — integer — Primary key — NOT NULL
- from_user_id (Key3) — integer — Foreign key → accounts_user.id — NOT NULL
- to_user_id (Key4) — integer — Foreign key → accounts_user.id — NOT NULL
community_comment (Untitled7)
- id (Key) — integer — Primary key — NOT NULL
- content (Field) — text — NOT NULL
- created_at (Field2) — datetime — NOT NULL
- review_id (Key2) — integer — Foreign key → community_review.id — NOT NULL
- user_id (Key3) — integer — Foreign key → accounts_user.id — NOT NULL
community_review (Untitled6)
- id (Key) — integer — Primary key — NOT NULL
- title (Field) — varchar(100) — NOT NULL
- content (Field2) — text — NOT NULL
- created_at (Field3) — datetime — NOT NULL
- updated_at (Field4) — datetime — NOT NULL
- user_id (Key2) — integer — Foreign key → accounts_user.id — NOT NULL
- movie_id (Key3) — integer — Foreign key → movies_movie.movie_id — NOT NULL
community_review_like_users (Untitled9)
- id (Key) — integer — Primary key — NOT NULL
- review_id (Key2) — integer — Foreign key → community_review.id — NOT NULL
- user_id (Key3) — integer — Foreign key → accounts_user.id — NOT NULL
movies_country (Untitled5)
- id (Key) — varchar(3) — Primary key — NOT NULL
- name (Field) — varchar(20) — NOT NULL
movies_genre (Untitled4)
- id (Key) — integer — Primary key — NOT NULL
- name (Field) — varchar(15) — NOT NULL
movies_movie (Untitled3)
- movie_id (Key) — integer — Primary key — NOT NULL
- title (Field) — varchar(50) — NOT NULL
- overview (Field2) — text
- director (Field3) — varchar(50)
- runtime (Field4) — integer
- release_date (Field5) — date
- backdrop_path (Field6) — varchar(50)
- poster_path (Field7) — varchar(50)
- adult (Field8) — bool
- production_companies (Field9) — varchar(60)
movies_movie_countries (Untitled10)
- id (Key) — integer — Primary key — NOT NULL
- movie_id (Key2) — integer — Foreign key → movies_movie.movie_id — NOT NULL
- country_id (Key3) — varchar(3) — Foreign key → movies_country.id — NOT NULL
movies_movie_genres (Untitled11)
- id (Key) — integer — Primary key — NOT NULL
- movie_id (Key2) — integer — Foreign key → movies_movie.movie_id — NOT NULL
- genre_id (Key3) — integer — Foreign key → movies_genre.id — NOT NULL
movies_movie_like_users (Untitled12)
- id (Key) — integer — Primary key — NOT NULL
- user_id (Key2) — integer — Foreign key → accounts_user.id — NOT NULL
- movie_id (Key3) — integer — Foreign key → movies_movie.movie_id — NOT NULL