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