아무 말 대잔치 ERD
테이블 (3)
Comments
- Comment ID (id) — INT(11) — 기본 키 — NOT NULL
- Post ID (post_id) — INT(11) — 외래 키 → Posts.Post ID — NOT NULL
- User ID (user_id) — INT(11) — 외래 키 → Users.User ID — NOT NULL
- Content (content) — TEXT
- Create At (created_at) — DATETIME
- Updated At (updated_at) — DATETIME
Posts
- Post ID (id) — INT(11) — 기본 키 — NOT NULL
- User ID (user_id) — INT(11) — 외래 키 → Users.User ID — NOT NULL
- Title (title) — VARCHAR(26)
- Content (content) — LONGTEXT
- Image (image) — VARCHAR(255) — NOT NULL
- Created At (created_at) — DATATIME
- View Count (view_count) — INT(11)
- Like Count (like_count) — INT(11)
- Comment Count (comment_count) — INT(11)
Users (Untitled)
- User ID (id) — INT(11) — 기본 키 — NOT NULL
- Profile Picuture (profile_picture) — VARCHAR(255)
- Email (email) — VARCHAR(255)
- Password (password) — VARCHAR(255)
- Nickname (nickname) — VARCHAR(255)
- Create At (created_at) — DATETIME
- Updated At (updated_at) — DATETIME