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