DB물리

테이블 (3)

BOARD

  • BOARD_NO — NUMBER — 기본 키 — NOT NULL
  • BOARD_TITLE — VARCHAR2(100) — NOT NULL
  • BOARD_CONTENT — VARCHAR2(200) — NOT NULL
  • USERID — VARCHAR2(20) — NOT NULL
  • BOARD_CDATE — TIMESTAMP — NOT NULL
  • REPLY_COUNT — NUMBER — NOT NULL

MEMBER

  • USERID — VARCHAR2(20) — 기본 키 — NOT NULL
  • PASSWORD — VARCHAR2(20) — NOT NULL
  • USERNAME — VARCHAR2(20) — NOT NULL
  • NICKNAME — VARCHAR2(20) — NOT NULL
  • GENDER — VARCHAR2(20) — NOT NULL
  • AGE — NUMBER — NOT NULL
  • SKIN_TYPE — VARCHAR2(50) — NOT NULL
  • SKIN_TROUBLE — VARCHAR2(50) — NOT NULL
  • EMAIL — VARCHAR2(20) — NOT NULL
  • PHONE — VARCHAR2(20) — NOT NULL
  • ADDRESS — VARCHAR2(50) — NOT NULL
  • MDATE — DATE — NOT NULL

REPLY

  • REPLY_NO — NUMBER — 기본 키 — NOT NULL
  • REPLY_BNO — NUMBER — NOT NULL
  • REPLY_TITLE — VARCHAR2(100) — NOT NULL
  • REPLY_CONTENT — VARCHAR2(200) — NOT NULL
  • REPLY_ADMINID — VARCHAR2(20) — NOT NULL
  • REPLY_CDATE — TIMESTAMP — NOT NULL