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