luv

Tables (6)

Article (Untitled2)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → User.Key — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • created_at (Field3) — Date
  • updated_at (Field4) — Date

Comment (Untitled3)

  • Key — Int — Primary key — NOT NULL
  • Article (FK1) — Int — Foreign key → Article.Key — NOT NULL
  • User (FK2) — Int — Foreign key → User.Key — NOT NULL
  • created_at (Field) — Date
  • updated_at (Field2) — Date
  • content (Field3) — String

Genre (Untitled4)

  • Key — Int — Primary key — NOT NULL
  • name (Field) — String

Movie (Untitled5)

  • Key — Primary key — NOT NULL
  • genre (FK) — Int — Foreign key → Genre.Key — NOT NULL
  • like_users (FK2) — Int — Foreign key → User.Key — NOT NULL
  • title (Field) — String
  • original_title (Field2) — String
  • release_date (Field3) — Date
  • popularity (Field4) — Float
  • vote_count (Field5) — Int
  • vote_average (Field6) — Float
  • overview (Field7) — String
  • poster_path (Field8) — String
  • backdrop_path (Field9) — String
  • where (Field10) — String

Review (Untitled6)

  • Key — Primary key — NOT NULL
  • user (FK) — Int — Foreign key → User.Key — NOT NULL
  • movie (FK2) — Int — Foreign key → Movie.like_users — NOT NULL
  • content (Field) — String
  • score (Field2) — String

User (Untitled)

  • Key — Int — Primary key — NOT NULL
  • username (Field) — String
  • password (Field2) — String