ERD 과제
테이블 (7)
Attach
- AttachId (attach_id) — BIGINT — 기본 키 — NOT NULL
- PostId (post_id) — BIGINT — 외래 키 → Posts.PostId — NOT NULL
- attachurl (attach_url) — VARCHAR(200) — NOT NULL
- attachsize (attach_size) — INT — NOT NULL
- attachtime (attach_time) — DATETIME — NOT NULL
CommentLike
- CommentId (comment_id) — BIGINT — 외래 키 → Comments.CommentId — NOT NULL
- UserId (user_id) — BIGINT — 외래 키 → Users.UserId — NOT NULL
Comments
- CommentId (comment_id) — BIGINT — 기본 키 — NOT NULL
- PostId (post_id) — BIGINT — 외래 키 → Posts.PostId — NOT NULL
- UserId (user_id) — BIGINT — 외래 키 → Users.UserId — NOT NULL
- content — VARCHAR(500) — NOT NULL
- createtime (create_time) — DATETIME — NOT NULL
- updatetime (update_time) — DATETIME — NOT NULL
- likecount (like_count) — INTEGER — NOT NULL
Posts
- PostId (post_id) — BIGINT — 기본 키 — NOT NULL
- UserId (user_id) — BIGINT — 외래 키 → Users.UserId — NOT NULL
- content — TEXT — NOT NULL
- likecount (like_count) — INTEGER — NOT NULL
- viewcount (view_count) — INTEGER — NOT NULL
- createtime (create_time) — DATETIME — NOT NULL
- updatetime (update_time) — DATETIME — NOT NULL
PostsLike (PostLike)
- PostId (post_id) — BIGINT — 외래 키 → Posts.PostId — NOT NULL
- UserId (user_id) — BIGINT — 외래 키 → Users.UserId — NOT NULL
Reports
- ReportId (Report_id) — BIGINT — 기본 키 — NOT NULL
- PostId (post_id) — BIGINT — 외래 키 → Posts.PostId — NOT NULL
- UserId (reporter_id) — BIGINT — 외래 키 → Users.UserId — NOT NULL
- reporttype (report_type) — VARCHAR(50) — NOT NULL
- reportcontent (report_content) — TEXT
Users
- UserId (user_id) — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- profileimageurl (profile_image_url) — VARCHAR(200)