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)