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