BOARD
테이블 (3)
BOARD
- BOARD_NO — NUMBER — 기본 키 — NOT NULL
- CATEGORY — NVARCHAR2(10) — NOT NULL
- BOARD_NAME — NVARCHAR2(20) — NOT NULL
POST
- POST_NO — NUMBER — 기본 키 — NOT NULL
- POST_NAME — NVARCHAR2(100) — NOT NULL
- POST_CONTENT — NVARCHAR2(4000) — NOT NULL
- POST_DATE — DATE — NOT NULL
- BOARD_NO — NUMBER — 외래 키 → BOARD.BOARD_NO — NOT NULL
- MEMBER_NO — NUMBER — 외래 키 → 회원.MEMBER_NO — NOT NULL
회원 (MEMBER)
- MEMBER_NO — NUMBER — 기본 키 — NOT NULL
- MEMBER_ID — VARCHAR2(10) — NOT NULL
- MEMBER_PWD — VARCHAR2(20) — NOT NULL
- EMAIL — VARCHAR2(20) — NOT NULL