0506test1
Tables (4)
Comments
- comment_id — INT
- post_id — INT — Foreign key → Posts.post_id — NOT NULL
- user_id — VARCHAR(20) — Foreign key → Users.user_id
- content — TEXT — NOT NULL
- created_at — DATETIME
Post_Likes
- like_id — INT
- post_id — INT — Foreign key → Posts.post_id — NOT NULL
- user_id — VARCHAR(20) — Foreign key → Users.user_id — NOT NULL
- created_at — DATETIME
Posts
- post_id — INT
- user_id — VARCHAR(20) — Foreign key → Users.user_id
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT
- created_at — DATETIME
- updated_at — DATETIME
Users
- user_id — VARCHAR(20)
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- created_at — DATETIME