library

Tables (7)

ACCOUNT

  • ACCNUM — NUMBER(20) — Primary key — NOT NULL
  • ID — VARCHAR2(50) — NOT NULL
  • PD_NAME — VARCHAR2(50) — NOT NULL
  • AC_NAME — VARCHAR2(50)
  • BALANCE — NUMBER(20)
  • AC_OP_DATE — DATE
  • AC_PASS — NUMBER(20)
  • BANK_CODE — NUMBER(20)

BOARD

  • POST_NUM — NUMBER(20) — Primary key — NOT NULL
  • ID — VARCHAR2(50) — NOT NULL
  • TITLE — VARCHAR2(50)
  • CONTENT — VARCHAR2(10000)
  • POST_DATE — DATE
  • POST_TYPE — VARCHAR2(20)

COMMENT

  • COMMENT_NUM — NUMBER(20) — Primary key — NOT NULL
  • ID — VARCHAR2(50) — NOT NULL
  • POST_NUM — NUMBER(20) — NOT NULL
  • COM_DATE — DATE
  • CONTENT — VARCHAR2(1000)

MONEY_HISTORY

  • ACCNUM — NUMBER(20) — NOT NULL
  • NAME — VARCHAR2(50)
  • TARGET_NAME — VARCHAR2(50)
  • MONEY — NUMBER(20)
  • TRANSFER_DATE — DATE
  • BANK_CODE — NUMBER(20)

PRODUCT

  • PD_NAME — VARCHAR2(50) — Primary key — NOT NULL
  • PD_DATE — DATE
  • ID — VARCHAR2(50) — Foreign key → USER.ID — NOT NULL

REPLY

  • REPLY_NUM — NUMBER(20) — Primary key — NOT NULL
  • ID — VARCHAR2(50) — NOT NULL
  • COMMENT_NUM — NUMBER(20) — NOT NULL
  • REPLY_DATE — DATE
  • REPLY_CONTENT — VARCHAR2(1000)

USER

  • ID — VARCHAR2(50) — Primary key — NOT NULL
  • PASS — VARCHAR2(50)
  • NAME — VARCHAR2(50)
  • USERCODE — NUMBER(20)
  • EMAIL — VARCHAR2(50)
  • PHONE — NUMBER(20)
  • POSTCODE — NUMBER(20)
  • ADRESS — VARCHAR2(50)
  • USERDATE — DATE
  • ADMIN — VARCHAR2(50)