Console-log-ver.2

Tables (6)

Comment (Untitled4)

  • 댓글ID (id) — PK — Primary key — NOT NULL
  • 댓글작성자ID (member_id) — FK — Foreign key → Member.유저ID — NOT NULL
  • 게시글ID (post_id) — FK — Foreign key → Post.게시글ID — NOT NULL
  • 게시글내용 (content) — not null
  • 생성날짜 (created_at) — not null
  • 수정날짜 (updated_at) — not null
  • 삭제날짜 (is_deleted) — null

Likes (Untitled6)

  • 좋아요ID (id) — PK — Primary key — NOT NULL
  • 게시글ID (post_id) — FK — Foreign key → Post.게시글ID — NOT NULL
  • 유저ID (member_id) — FK — Foreign key → Member.유저ID — NOT NULL

Member (Untitled2)

  • 유저ID (id) — PK — Primary key — NOT NULL
  • 아이디 (login_id) — UK
  • 비밀번호 (password) — not null
  • 닉네임 (nickname) — not null
  • 프로필 이미지 (profile_url) — null
  • 권한 (type) — not null
  • 생성날짜 (created_at) — not null
  • 수정날짜 (updated_at) — not null
  • 삭제날짜 (is_deleted) — null

Post (Untitled3)

  • 게시글ID (id) — PK — Primary key — NOT NULL
  • 유저ID (member_id) — FK — Foreign key → Member.유저ID — NOT NULL
  • 제목 (title) — not null
  • 내용 (content) — not null
  • 조회수 (view_count) — not null
  • 좋아요수 (like_count) — not null
  • 댓글개수 (comment_count) — not null
  • 생성날짜 (created_at) — not null
  • 수정날짜 (updated_at) — not null
  • 삭제날짜 (is_deleted) — null

Reply (Untitled)

  • 대댓글ID (id) — Primary key — NOT NULL
  • 댓글ID (comment_id) — PK — Foreign key → Comment.댓글ID — NOT NULL
  • 유저ID (member_id) — PK — Foreign key → Member.유저ID — NOT NULL
  • 게시글내용 (content)

Tag (Untitled5)

  • 태그ID (id) — PK — Primary key — NOT NULL
  • 게시글ID (post_id) — FK — Foreign key → Post.게시글ID — NOT NULL
  • 태그이름 (name) — not null