finalPJT

Tables (4)

Comment (Untitled3)

  • Key — Primary key — NOT NULL
  • user (Key2) — integer — Foreign key → Review.Key — NOT NULL
  • movie (Key22) — text — Foreign key → Review.user — NOT NULL
  • review (Key3) — text — Foreign key → Review.movie_title — NOT NULL
  • content (Field) — text
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime

Movie (Untitled4)

  • Key — integer — Primary key — NOT NULL
  • title (Field) — text
  • overview (Field2) — text
  • release_date (Field3) — date
  • poster_path (Field4) — text
  • Field5

Review (Untitled2)

  • Key — Primary key — NOT NULL
  • user (Key2) — text — Foreign key → User.id — NOT NULL
  • movie_title (Key3) — text — Foreign key → Movie.Key — NOT NULL
  • title (Field) — text
  • content (Field2) — text
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime
  • rank (Field5) — integer

User (Untitled)

  • id (Key) — integer — Primary key — NOT NULL
  • email (Field2) — text
  • password (Field3) — text
  • is_staff (Field4) — bool
  • is_superuser (Field5) — bool