Movie

Tables (17)

Comment (Untitled9)

  • pk (Key2) — Primary key — NOT NULL
  • review (Key) — ForeignKey — Foreign key → Review.pk — NOT NULL
  • created_at (Field) — DateTime
  • is_bad (Field2) — Boolean
  • user (Key3) — Foreignkey — Foreign key → User.pk — NOT NULL

Gender_age_counter (Untitled5)

  • pk (Key) — Primary key — NOT NULL
  • gender (Field) — Char
  • ages (Field2) — Char
  • counter (Field3) — PositiveInteger
  • movie (Key2) — ForeignKey — Foreign key → Movie.pk — NOT NULL

Genre (Untitled2)

  • pk (Key) — Primary key — NOT NULL
  • kname (Field) — Char
  • ename (Field2) — Char

Genre_counter (Untitled4)

  • pk (Key) — Primary key — NOT NULL
  • counter (Field) — PositiveInteger
  • genre (Key2) — ForeignKey — Foreign key → Genre.pk — NOT NULL
  • user (Key3) — ForeignKey — Foreign key → User.pk — NOT NULL

Movie (Untitled)

  • pk (Key) — Primary key — NOT NULL
  • ktitle (Field) — Char
  • etitle (Field2) — Char
  • original_title (Field3) — Char
  • release_date (Field4) — Date
  • popularity (Field5) — Float
  • vote_count (Field6) — Integer
  • vote_average (Field7) — Float
  • adult (Field8) — Boolean
  • koverview (Field9) — Text
  • eoverview (Field10) — Text
  • original_language (Field11) — Char
  • poster_path (Field12) — Char
  • backdrop_path (Field13) — Char
  • genres (Field14) — ManyToMany
  • liked_users (Field15) — ManyToMany
  • tags (Field16) — TaggableManager

Movie_Genre (Untitled3)

  • pk (Key) — Foreign key → Movie.pk — NOT NULL
  • pk (Key2) — Foreign key → Genre.pk — NOT NULL

Movie_User (Untitled16)

  • pk (Key) — Foreign key → Movie.pk — NOT NULL
  • pk (Key2) — Foreign key → User.pk — NOT NULL

Recomment (Untitled10)

  • pk (Key) — Primary key — NOT NULL
  • content (Field) — Char
  • created_at (Field2) — DateTime
  • is_bad (Field3) — Boolean
  • comment (Key2) — ForeignKey — Foreign key → Comment.pk — NOT NULL

Report (Untitled12)

  • pk (Key) — Primary key — NOT NULL
  • sort (Field) — Char
  • r_id (Field2) — Integer
  • reporter (Field3) — ForeignKey
  • simple_reason (Field4) — Char
  • detail_reason (Field5) — Text
  • isresolved (Field6) — Boolean
  • reported_at (Field7) — DateTime

Review (Untitled8)

  • pk (Key) — Primary key — NOT NULL
  • title (Field) — Char
  • content (Field2) — Text
  • rating (Field3) — Integer
  • hits (Field4) — Integer
  • created_at (Field5) — DateTime
  • updated_at (Field6) — DateTime
  • tags (Field7) — TaggableManager
  • is_bad (Field8) — Boolean
  • movie (Key2) — ForeignKey — Foreign key → Movie.pk — NOT NULL
  • user (Key3) — ForeignKey — Foreign key → User.pk — NOT NULL

ShortReview (Untitled11)

  • pk (Key) — Primary key — NOT NULL
  • content (Field) — Text
  • rating (Field2) — Integer
  • liked_users (Field4) — ManyToMany
  • tags (Field5) — TaggableManager
  • is_bad (Field6) — Boolean
  • created_at (Field7) — DateTime
  • updated_at (Field8) — DateTime
  • movie (Key2) — ForeignKey — Foreign key → Movie.pk — NOT NULL
  • user (Key3) — ForeignKey — Foreign key → User.pk — NOT NULL

Trending (Untitled6)

  • pk (Key) — Primary key — NOT NULL
  • trendingdate (Field) — Date
  • movies (Field2) — ManyToMany

Trending_Movie (Untitled7)

  • pk (Key) — Foreign key → Movie.pk — NOT NULL
  • pk (Key2) — Foreign key → Trending.pk — NOT NULL

User (Untitled13)

  • pk (Key) — Primary key — NOT NULL
  • email (Field) — Email
  • username (Field2) — Char
  • nickname (Field3) — Char
  • date_of_birth (Field4) — Date
  • is_active (Field5) — Boolean
  • is_admin (Field6) — Boolean
  • gender (Field7) — Char
  • objects (Field9) — UserManager
  • followers (Field8) — ManyToMany

User_Followers (Untitled17)

  • pk (Key) — Foreign key → User.pk — NOT NULL

User_Report (Untitled14)

  • pk (Key) — Foreign key → User.pk — NOT NULL
  • pk (Key2) — Foreign key → Report.pk — NOT NULL

User_ShortReview (Untitled15)

  • pk (Key) — Foreign key → User.pk — NOT NULL
  • pk (Key2) — Foreign key → ShortReview.pk — NOT NULL