free-board
테이블 (5)
Untitled (comment_likes_mapping)
- Key (member_id) — int — 외래 키 → 회원.Key — NOT NULL
- Key (comment_id) — Int — 외래 키 → 댓글.Key — NOT NULL
- Field (created_date) — DateTime
Untitled (post_likes_mapping)
- Key (post_id) — Int — 외래 키 → 게시글.Key — NOT NULL
- Key (member_id) — int — 외래 키 → 회원.Key — NOT NULL
- Field (created_date) — DateTime
게시글 (post)
- Key (post_id) — Int — 기본 키 — NOT NULL
- Key (member_id) — int — 외래 키 → 회원.Key — NOT NULL — post_id, member_id 인덱스 설정
- Field (type) — Varchar — FREE, FOOD, TRAVEL, SPORT
- Field (title) — Varchar
- Field (content) — Varchar
- Field (views) — Int
- Field (likes) — Int
- Field (hidden_yn) — TinyInt
- Field (created_date) — DateTime
- Field (modified_date) — DateTime
댓글 (comment)
- Key (comment_id) — Int — 기본 키 — NOT NULL
- Key (post_id) — Int — 외래 키 → 게시글.Key — NOT NULL — (comment_id, post_id) 인덱스
- Key (member_id) — int — 외래 키 → 회원.Key — NOT NULL — (comment_id, member_id) 인덱스
- Field (parent_comment_id) — Int
- Field (content) — Varchar
- Field (likes) — Int
- Field (hidden_yn) — TinyInt
- Field (created_date) — DateTime
- Field (modified_date) — DateTime
회원 (member)
- Key (member_id) — int — 기본 키 — NOT NULL
- Field (user_id) — Varchar — UNIQUE
- Field (password) — Varchar
- (nick_name) — Varchar — UNIQUE
- Field (created_date) — DateTime
- Field (modified_date) — DateTime