아무 말 대잔치 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