final-pjt

Tables (5)

Accounts (user)

  • ID (id) — int — Primary key — NOT NULL
  • USERNAME (username) — str
  • PASSWORD (password) — str

Article (article)

  • ID (id) — int — Primary key — NOT NULL
  • ID (id2) — int — Foreign key → Accounts.ID — NOT NULL
  • TITLE (title) — str
  • CONTENT (content) — str
  • CREATED_AT (created_at) — datetime
  • UPDATED_AT (updated_at) — datetime

Comment (comment)

  • ID (id) — int — Primary key — NOT NULL
  • ID (id2) — int — Foreign key → Accounts.ID — NOT NULL
  • ID (id3) — int — Foreign key → Article.ID — NOT NULL
  • CONTENT (content) — str
  • CREATED_AT (created_at) — datetime
  • UPDATED_AT (updated_at) — datetime

Movie (movies)

  • ID (id) — int — Primary key — NOT NULL
  • TITLE (title) — str
  • ORIGINAL_TITLE (original_title) — str
  • IMAGE (image) — str
  • BACKDROP_PATH (backdrop_path) — str
  • OVERVIEW (overview) — str
  • RELEASE (release) — str
  • RATING (rating) — float
  • GENRES (genres) — str
  • CREATED_AT (created_at) — datetime
  • UPDATED_AT (updated_at) — datetime

Review (movie_review)

  • ID (id) — int — Primary key — NOT NULL
  • ID (id2) — int — Foreign key → Accounts.ID — NOT NULL
  • ID (id3) — int — Foreign key → Movie.ID — NOT NULL
  • CONTENT (content) — str
  • RATINGS (ratings) — uint
  • CREATED_AT (created_at) — datetime
  • UPDATED_AT (updated_at) — datetime