_게시판
테이블 (7)
article
- article_id — Binary(16) — 기본 키 — NOT NULL
- member_id — Binary(16) — 외래 키 → member.member_id — NOT NULL — pk
- title — varchar(500) — NOT NULL
- content — text — NOT NULL
- views — bigInt — NOT NULL
- owner — Binary(16) — NOT NULL
- created_at — smalldatetime — NOT NULL
- updated_at — smalldatetime — NOT NULL
- category — varChar(255) — 외래 키 → category.category — NOT NULL
category
- category — varChar(255) — 기본 키 — NOT NULL
comment
- comment_id — Binary(16) — 기본 키 — NOT NULL
- article_id — NOT NULL
- parent (parnet) — BInary(16) — 대댓글의 주소
- parent_depth — int — 대댓글 위치
- comment — vharchar(1000) — NOT NULL
- Field
- member_id — Binary(16) — 외래 키 → member.member_id — NOT NULL — pk
- article_id (article_id2) — Binary(16) — 외래 키 → article.article_id — NOT NULL
like
- article_id (article_id2) — Binary(16) — 외래 키 → article.article_id — NOT NULL
- member_id — Binary(16) — 외래 키 → article.member_id — NOT NULL — pk
- created_at — smalldatetime
member
- member_id — Binary(16) — 기본 키 — NOT NULL — pk
- email — varchar(255) — NOT NULL
- password — varchar(500) — NOT NULL
- nickname — varchar(255) — NOT NULL
- created_at (createa_at) — smalldatetime — NOT NULL
- updated_at — smalldatetime — NOT NULL
role
- role — varchar(255) — 기본 키 — NOT NULL
user_role
- member_id (member_id2) — Binary(16) — 외래 키 → member.member_id — NOT NULL — pk
- role (role2) — varchar(255) — 외래 키 → role.role — NOT NULL