게시판 물리적 모델링
테이블 (3)
Member
- Key (id) — INT — 기본 키 — NOT NULL
- Field (account_name) — VARCHAR(50) — NOT NULL
- Field (password) — VARCHAR(200) — NOT NULL
- Field (birth) — DATETIME
- Field (gender) — VARCHAR(1)
- Field (regdate) — DATETIME — NOT NULL
Untitled (Article)
- Key (id) — INT — 기본 키 — NOT NULL
- Key (member_id) — INT — 외래 키 → Member.Key — NOT NULL
- Field (title) — INT — NOT NULL
- Field (text) — CARCHAR(400) — NOT NULL
- Field (read_count) — INT — NOT NULL
- Field (regdate) — DATETIME — NOT NULL
Untitled (Like)
- Key (id) — INT — 기본 키 — NOT NULL
- Key (member_id) — INT — 외래 키 → Member.Key — NOT NULL
- Key (article_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Field (regdate) — DATETIME — NOT NULL