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)