Articles

Tables (4)

Article (article)

  • Article Id (article_id) — Not Null — Primary key — NOT NULL
  • User Id (user_id) — Not Null — Foreign key → User.User Id — NOT NULL
  • Article Title (article_title) — CHAR(200)
  • Article Content (article_content) — TEXT
  • Article Created At (article_created_at) — DATETIME
  • Article Updated At (article_updated_at) — DATETIME
  • Article Movie Title (article_movie_title) — CHAR(200)

Comment (comment)

  • Comment Id (comment_id) — Not Null — Primary key — NOT NULL
  • User Id (user_id) — Not Null — Foreign key → User.User Id — NOT NULL
  • Article Id (article_id) — Not Null — Foreign key → Article.Article Id — NOT NULL
  • User Id (user_id2) — Not Null — Foreign key → Article.User Id — NOT NULL
  • Comment Content (comment_content) — TEXT
  • Comment Created At (comment_created_at) — DATETIME
  • Comment Updated At (comment_updated_at) — DATETIME

Untitled

  • Key — Primary key — NOT NULL
  • Field

User (user)

  • User Id (user_id) — Not Null — Primary key — NOT NULL
  • User Survey Genre Id (user_survey_genre_id) — INT(11)