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