20번문제

테이블 (3)

BOARD (Untitled2)

  • BOARD_ID (Key) — 기본 키 — NOT NULL
  • BOARD_TITLE (Field)
  • BOARD_WRITER (Key2) — 외래 키 → Member.ID — NOT NULL
  • BOARD_CONTENT\ (Field2)
  • BOARD_COUNT (Field3)
  • BOARD_CREATE_DATE (Field4)
  • BOARD_MODIFY_DATE (Field5)

Member (Untitled)

  • ID (Key) — 기본 키 — NOT NULL
  • PWD (Field)
  • NAME (Field2)
  • NICKNAME (Field3)
  • EMAIL (Field4)
  • GENDER (Field5)
  • AGE (Field6)
  • PHONE (Field7)
  • ADDRESS (Field8)
  • ENROLL_DATE (Field9)
  • UPDATE_DATE (Field10)

Untitled3

  • REPLY_ID (Key) — 기본 키 — NOT NULL
  • REPLY_CONTENT (Field)
  • REF_BOARD_ID (Key3) — 외래 키 → BOARD.BOARD_ID — NOT NULL
  • REPLY_WRITER (Key4) — 외래 키 → Member.ID — NOT NULL
  • REPLY_CREATE_DATE (Field2)
  • REPLY_MODIFY_DATE (Field3)