semiproject
테이블 (3)
게시판 (Board)
- Key (board_id) — int — 기본 키 — NOT NULL
- Key (member_id) — varchar(100) — 외래 키 → 회원.Key — NOT NULL
- Field (board_title) — VARCHAR(200) — NOT NULL
- Field (board_author) — VARCHAR(50) — NOT NULL
- Field (board_publisher) — VARCHAR(100)
- Field (board_content) — TEXT — NOT NULL
- Field (board_views) — INT
- Field (board_regdate) — DATETIME
댓글 (Comment)
- Key (comment_id) — INT — 기본 키 — NOT NULL
- Key (board_id) — int — 외래 키 → 게시판.Key — NOT NULL
- Key (member_id) — varchar(100) — 외래 키 → 게시판.Key — NOT NULL
- Field (comment_content) — TEXT — NOT NULL
- Field (comment_regdate) — DATETIME
회원 (Member)
- Key (member_id) — INT — 기본 키 — NOT NULL
- Field (member_pw) — varchar(100) — NOT NULL
- Field (member_name) — varchar(100) — NOT NULL
- Field (member_email) — varchar(100) — NOT NULL
- Field (member_tel) — varchar(100)
- Field (member_regdate) — DATETIME
- Field (member_loginId) — VARCHAR(20) — NOT NULL