Console-log-demo

Tables (6)

Base Data (Untitled)

  • 생성날짜 (created_at) — not null
  • 수정날짜 (updated_at) — not null
  • 삭제날짜 (deleted_at) — not null

Comment (Untitled4)

  • 댓글ID (comment_id) — PK — Primary key — NOT NULL
  • 댓글작성자ID (commenter_id) — FK — Foreign key → User.유저ID — NOT NULL
  • 게시글ID (write_id) — FK — Foreign key → Write.게시글ID — NOT NULL
  • 부모댓글ID (parent_comment_id) — FK — Foreign key → Comment.댓글ID — NOT NULL
  • 게시글내용 (comment_content) — not null
  • 댓글레벨 (comment_level) — not null

Like (Untitled6)

  • 좋아요ID (like_id) — PK — Primary key — NOT NULL
  • 게시글ID (write_id) — FK — Foreign key → Write.게시글ID — NOT NULL
  • 유저ID (user_id) — FK — Foreign key → User.유저ID — NOT NULL

Tag (Untitled5)

  • 태그ID (tag_id) — PK — Primary key — NOT NULL
  • 게시글ID (write_id) — PK — Foreign key → Write.게시글ID — NOT NULL
  • 태그이름 (tag_name) — not null

User (Untitled2)

  • 유저ID (user_id) — PK — Primary key — NOT NULL
  • 아이디 (login_id) — UK
  • 비밀번호 (password) — not null
  • 닉네임 (nickname) — not null
  • 프로필 이미지 (profile_url) — not null
  • 권한 (user_auth) — not null

Write (Untitled3)

  • 게시글ID (write_id) — PK — Primary key — NOT NULL
  • 유저ID (writer_id) — FK — Foreign key → User.유저ID — NOT NULL
  • 제목 (title) — not null
  • 내용 (write_content) — not null
  • 조회수 (view_count) — not null
  • 좋아요수 (likes_count) — not null