Test
테이블 (3)
게시판 (board)
- Key (id) — uint — 기본 키 — NOT NULL
- Key (user_id) — uint — 외래 키 → 회원.Key — NOT NULL
- Field (title) — vchar(256) — NOT NULL
- Field (body) — text(65535) — NOT NULL
- Field2 (create_at) — tiemstamp — NOT NULL
댓글 (comment)
- Key (id) — uint — 기본 키 — NOT NULL
- Key (board_id) — uint — 외래 키 → 게시판.Key — NOT NULL
- Key (user_id) — uint — 외래 키 → 회원.Key — NOT NULL
- Field (comment) — text(65535) — NOT NULL
- Field2 (create_at) — timestamp — NOT NULL
회원 (user)
- Key (id) — uint — 기본 키 — NOT NULL
- Field (user_name) — vchar(64) — NOT NULL — login_id
- Field (password) — char(64) — NOT NULL — SHA256
- Field2 (nickname) — vchar(64) — NOT NULL
- Field3 (profile_image) — vchar(128) — user/profile/2233.jpg
- Field (role) — tiny int — NOT NULL — 0:admin, 1:normal
- Field (create_at) — timestamp — NOT NULL