게시판 야호
테이블 (3)
Article (Untitled2)
- id (Key) — INT — 기본 키 — NOT NULL
- memder_id (Key2) — INT — 외래 키 → Member.id — NOT NULL
- title (Field) — VARCHAR(400) — NOT NULL
- text (Field2) — VARCHAR(4000) — NOT NULL
- read_count (Field3) — INT — NOT NULL
- regdate (Field4) — DATETIME — NOT NULL
Like (Untitled3)
- id (Key) — INT — 기본 키 — NOT NULL
- member_id (Key2) — INT — 외래 키 → Member.id — NOT NULL
- article_id (Key3) — INT — 외래 키 → Article.id — NOT NULL
- regdate (Field) — DATETIME — NOT NULL
Member (Untitled)
- id (Key) — INT — 기본 키 — NOT NULL
- account_name (Field) — VARCHAR(50) — NOT NULL
- password (Field2) — VARCHAR(200) — NOT NULL
- birth (Field3) — DATETIME
- gender (Field4) — VARCHAR(1)
- regdate (Field5) — DATETIME — NOT NULL