re_VANILLA

Tables (14)

Comment (Untitled4)

  • pk (Key) — integeer — Primary key — NOT NULL
  • content (Field) — varchar
  • user (Key2) — integer — Foreign key → User.pk — NOT NULL
  • review (Key3) — integer — Foreign key → Review.pk — NOT NULL
  • created_at (Field2) — date
  • is_bad (Field3) — boolea

Following (Untitled11)

  • pk (Key2) — integer — Primary key — NOT NULL
  • following (Key) — integer — Foreign key → User.pk — NOT NULL
  • follower (Key3) — integer — Foreign key → User.pk — NOT NULL

Genre (Untitled7)

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

Genre Counter (Untitled8)

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

Liked_review (Untitled6)

  • pk (Key3) — integer — Primary key — NOT NULL
  • liked_review (Key2) — integer — Foreign key → Review.pk — NOT NULL
  • liked_user (Key) — integer — Foreign key → User.pk — NOT NULL

Movie (Untitled9)

  • pk (Key) — integer — Primary key — NOT NULL
  • genre (Key2) — integer — Foreign key → Genre.pk — NOT NULL
  • ktitle (Field) — varchar
  • etitle (Field2) — varchar
  • koverview (Field3) — varchar
  • eoverview (Field4) — varchar
  • release_date (Field5) — date
  • popularity (Field6) — float
  • vote_count (Field7) — integer
  • vote_average (Field8) — float
  • poster_path (Field9) — varchar
  • backdrop_path (Field10) — varchar
  • original_title (Field11) — varchar
  • adult (Field12) — boolean

Recomment (Untitled5)

  • pk (Key) — integer — Primary key — NOT NULL
  • content (Field) — varchar
  • comment (Key2) — integeer — Foreign key → Comment.pk — NOT NULL
  • user (Key3) — integer — Foreign key → User.pk — NOT NULL
  • created_at (Field2) — date
  • is_bad (Field3) — boolean

Report (Untitled12)

  • pk (Key) — integer — Primary key — NOT NULL
  • sort (Field) — varchar
  • r_id (Field2) — integer
  • reported_at (Field3) — date
  • isresolved (Field4) — boolean
  • user (Key2) — integer — Foreign key → User.pk — NOT NULL

Review (Untitled2)

  • pk (Key) — integer — Primary key — NOT NULL
  • title (Field) — varchar
  • content (Field2) — varchar
  • rating (Field3) — integer
  • user (Key2) — integer — Foreign key → User.pk — NOT NULL
  • Field4
  • movie (Key3) — integer — Foreign key → Movie.pk — NOT NULL
  • genre (Key22) — integer — Foreign key → Movie.genre — NOT NULL
  • created_at (Field5) — date
  • updated_at (Field6) — date
  • is_bad (Field7) — boolean

ShortReview (Untitled3)

  • pk (Key) — integer — Primary key — NOT NULL
  • content (Field) — varchar
  • rating (Field2) — integer
  • user (Key2) — integer — Foreign key → User.pk — NOT NULL
  • movie (Key3) — integer — Foreign key → Movie.pk — NOT NULL
  • genre (Key22) — integer — Foreign key → Movie.genre — NOT NULL
  • created_at (Field3) — date
  • is_bad (Field4) — boolean

User (Untitled)

  • pk (Key) — integer — Primary key — NOT NULL
  • username (Field) — varchar
  • nickname (Field2) — varchar
  • password (Field3) — varchar
  • gender (Field4) — varchar
  • date_of_birth (Field5) — date
  • email (Field6) — email

gender age counter (Untitled10)

  • pk (Key) — integer — Primary key — NOT NULL
  • counter (Field) — integer
  • gender (Field2) — varchar
  • ages (Field3) — varchar
  • movie (Key2) — integer — Foreign key → Movie.pk — NOT NULL
  • genre (Key22) — integer — Foreign key → Movie.genre — NOT NULL

liked_movies (Untitled13)

  • pk (Key) — integer — Primary key — NOT NULL
  • liked_user (Key2) — integer — Foreign key → User.pk — NOT NULL
  • liked_movie (Key3) — integer — Foreign key → Movie.pk — NOT NULL
  • genre (Key22) — integer — Foreign key → Movie.genre — NOT NULL

liked_shortreview (Untitled14)

  • pk (Key) — integer — Primary key — NOT NULL
  • liked_user (Key2) — integer — Foreign key → User.pk — NOT NULL
  • liked_sr (Key3) — integer — Foreign key → ShortReview.pk — NOT NULL