whatchapedia

Tables (3)

Comment

  • comment_id — INT — Primary key — NOT NULL
  • review_id — INT — Foreign key → Review.review_id — NOT NULL
  • (content) — VACHAR(256) — NOT NULL

Movie

  • (id) — INT — Primary key — NOT NULL
  • (title) — VACHAR(64) — NOT NULL
  • (director) — VACHAR(64) — NOT NULL

Review

  • review_id — INT — Primary key — NOT NULL
  • movie_id — INT — Foreign key → Movie.id — NOT NULL
  • (title) — VACHAR(64) — NOT NULL
  • (content) — VACHAR(256) — NOT NULL