first
Tables (3)
Comment (comment)
- Comment Id (comment_id) — INT(11) — Primary key — NOT NULL
- Post Id (post_id) — INT(11) — Foreign key → Post.Post Id — NOT NULL
- User Id (user_id) — INT(11) — Foreign key → Post.User Id — NOT NULL
- User Id (user_id2) — INT(11) — Foreign key → Users.User Id — NOT NULL
- Content (content) — VARCHAR(255)
- Create At (createdAt) — CHAR(8)
- Modified At (modifiedAt) — CHAR(8)
Post (post)
- Post Id (post_id) — INT(11) — Primary key — NOT NULL
- User Id (user_id) — INT(11) — Foreign key → Users.User Id — NOT NULL
- Title (title) — VARCHAR(255)
- Content (content) — VARCHAR(255)
- Create At (createdAt) — CHAR(8)
- Modified At (modifiedAt) — CHAR(8)
Users (users)
- User Id (user_id) — INT(11) — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- Password (password) — VARCHAR(255)