KTB3_Week6_ERD(yun.jeon)

Tables (4)

Comment

  • PK (comment_id) — INT — Primary key — NOT NULL
  • 작성자 (nickname) — VARCHAR(11) — NOT NULL
  • 내용 (content) — TEXT — NOT NULL
  • 작성 시각 (created_at) — DATETIME — NOT NULL
  • 삭제 여부 (is_deleted) — BOOLEAN — NOT NULL
  • FK (member_id) — INT — Foreign key → Member.PK — NOT NULL
  • FK (post_id) — INT — Foreign key → Post.PK — NOT NULL

Like

  • PK (like_id) — INT — Primary key — NOT NULL
  • FK (member_id) — INT — Foreign key → Member.PK — NOT NULL
  • FK (post_id) — INT — Foreign key → Post.PK — NOT NULL

Member

  • PK (member_id) — INT — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR — NOT NULL
  • 비밀번호 (password) — VARCHAR — NOT NULL
  • 닉네임 (nickname) — VARCHAR(11) — NOT NULL
  • 프로필 이미지 (profile_image) — VARCHAR — NOT NULL
  • 탈퇴 여부 (is_deleted) — BOOLEAN — NOT NULL

Post

  • PK (post_id) — INT — Primary key — NOT NULL
  • 제목 (title) — VARCHAR(27) — NOT NULL
  • 작성자 (nickname) — VARCHAR(11) — NOT NULL
  • 내용 (content) — LONGTEXT — NOT NULL
  • 첨부사진 (post_image) — VARCHAR
  • 좋아요 수 (likes) — INT — NOT NULL
  • 댓글 수 (comments) — INT — NOT NULL
  • 조회수 (views) — INT — NOT NULL
  • 작성 시각 (created_at) — DATETIME — NOT NULL
  • 삭제 여부 (is_deleted) — BOOLEAN — NOT NULL
  • FK (member_id) — INT — Foreign key → Member.PK — NOT NULL