pjt

Tables (7)

Article (Untitled2)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • title (Field) — CharField
  • content (Field2) — TextField
  • created_at (Field3) — DateTimeField
  • updated_at (Field4) — DateTimeField
  • author (Key2) — ForeignKey — Foreign key → User.id — NOT NULL
  • board (Key4) — ForeignKey — Foreign key → Board.id — NOT NULL
  • hits (Field5) — IntegerField

Board (Untitled6)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • name (Field) — CharFIeld
  • url_name (Field2) — CharField
  • auth_required (Field3) — BooleanField
  • name_short (Field4) — CharField

Comment (Untitled3)

  • id — IntegerField — Primary key — NOT NULL
  • content — TextField
  • created_at — DateTimeField
  • updated_at — DateTiemField
  • author — ForeignKey — Foreign key → User.id — NOT NULL
  • article — ForeignKey — Foreign key → Article.id — NOT NULL
  • liked_users (Key) — ManyToManyField — Foreign key → User.id — NOT NULL

Genre (Untitled5)

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

Movie (Untitled4)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • title (Field) — CharField
  • popularity (Field11) — FloatField
  • original_title (Field9) — CharField
  • release_date (Field10) — DateField
  • poster_path (Field2) — CharField
  • backdrop_path (Field3) — CharField
  • original_language (Field4) — CharField
  • overview (Field5) — TextField
  • vote_count (Field6) — IntegerField
  • vote_average (Field7) — FloatField
  • adult (Field8) — BooleanField
  • genre (Key2) — ManyToManyField — Foreign key → Genre.id — NOT NULL
  • liked_users (Key3) — ManyToManyField — Foreign key → User.id — NOT NULL
  • api_id (Field12) — IntegerField
  • trailer (Field13) — CharField

Review (Untitled7)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • content (Field2) — TextField
  • create_at (Field3) — DateTimeField
  • updated_at (Field4) — DateTimeField
  • rank (Field5) — IntegerField
  • movie (Key2) — ForeignKey — Foreign key → Movie.id — NOT NULL
  • author (Key3) — ForeignKey — Foreign key → User.id — NOT NULL
  • liked_users (Key4) — ManyToManyField — Foreign key → User.id — NOT NULL

User (Untitled)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • username (Field) — CharField
  • password (Field2) — CharField
  • liked_articles (Key2) — ManyToManyField — Foreign key → Article.id — NOT NULL
  • liked_movies (Key3) — ManyToManyField — Foreign key → Movie.id — NOT NULL
  • liked_comments (Key4) — ManyToManyField — Foreign key → Comment.id — NOT NULL
  • liked_under60 (Field3) — IntegerField
  • liked_1960 (Field4) — IntegerField
  • liked_1970 (Field5) — IntegerField
  • liked_1980 (Field6) — IntegerField
  • liked_1990 (Field7) — IntegerField
  • liked_2000 (Field8) — IntegerField
  • liked_2010 (Field9) — IntegerField
  • liked_2020 (Field10) — IntegerField
  • liked_adventure (Field11) — IntegerField
  • liked_fantasy (Field12) — IntegerField
  • liked_animation (Field13) — IntegerField
  • liked_drama (Field14) — IntegerField
  • liked_horror (Field15) — IntegerField
  • liked_action (Field16) — IntegerField
  • liked_comedy (Field17) — IntegerField
  • liked_history (Field18) — IntegerField
  • liked_western (Field19) — IntegerField
  • liked_thriller (Field20) — IntegerField
  • liked_crime (Field21) — IntegerField
  • liked_documentary (Field22) — IntegerField
  • liked_sciencefiction (Field23) — IntegerField
  • liked_mystery (Field24) — IntegerField
  • liked_music (Field25) — IntegerField
  • liked_romance (Field26) — IntegerField
  • liked_family (Field27) — IntegerField
  • liked_war (Field28) — IntegerField
  • liked_tvmovie (Field29) — IntegerField
  • liked_recents (Field30) — CharField
  • liked_reviews (Key5) — ManyToManyField — Foreign key → Review.id — NOT NULL