test

Tables (8)

BOOK_DETAIL

  • B_ISBN — VARCHAR2(80) — Primary key — NOT NULL
  • B_NAME — VARCHAR2(100)
  • B_PUB_DATE — DATE
  • B_AUTHORS — VARCHAR2(80)
  • B_PUBLISHER — VARCHAR2(80)
  • B_CLASS_NO — NUMBER
  • B_PUBLICATION_YEAR — VARCHAR2(80)
  • B_IMAGE_URL — VARCHAR2(80)
  • B_LOAN_CNT — NUMBER

COMM_NM

  • COMM_CD — CHAR(4 BYTE) — Primary key — NOT NULL
  • COMM_NM — VARCHAR2(100)
  • COMM_PARENT — CHAR(4)

FREE_BOARD

  • BO_NUM — NUMBER — Primary key — NOT NULL
  • BO_TITLE — VARCHAR2(30)
  • BO_CATEGORY — VARCHAR2(10)
  • BO_PASS — VARCHAR2(80)
  • BO_CONTENT — CLOB
  • BO_HIT — NUMBER
  • BO_REG_DATE — DATE
  • BO_MOD_DATE — DATE
  • BO_DEL_YN — CHAR(1 BYTE)

LOAN_TABLE

  • L_ISBN — VARCHAR2(80) — Primary key — NOT NULL
  • MEM_ID — VARCHAR2(80)
  • L_LIB_CODE — VARCHAR2(80)
  • L_LOAN_DATE — DATE
  • L_RETURN_DATE — DATE
  • L_AVAIL_YN — VARCHAR2(80)

PWKEY

  • MEM_ID — VARCHAR2(30) — Primary key — NOT NULL
  • MEM_PRIVATEK — CLOB

QnA_BOARD

  • QB_NUM — NUMBER — Primary key — NOT NULL
  • QB_TITLE — VARCHAR2(80)
  • QB_WRITER — VARCHAR2(40)
  • QB_PASS — VARCHAR2(80)
  • QB_CONTENT — CLOB
  • QB_HIT — NUMBER
  • QB__REG_DATE — DATE
  • QB_MOD_DATE — DATE
  • QB_DEL_YN — CHAR(1 BYTE)

REPLY

  • RE_NUM — NUMBER — Primary key — NOT NULL
  • RE_CATEGORY — VARCHAR2(30)
  • RE_PARENT_NO — NUMBER
  • RE_WRITER — VARCHAR2(30)
  • RE_CONTENT — VARCHAR2(4000)
  • RE_REG_DATE — DATE
  • RE_MOD_DATE — DATE

members

  • MEM_ID — VARCHAR2(30) — NOT NULL
  • MEM_NAME — VARCHAR2(60)
  • MEM_PASS — VARCHAR2(60)
  • MEM_SALT — VARCHAR2(80)
  • MEM_ADD1 — VARCHAR2(80)
  • MEM_ADD2 — VARCHAR2(80)
  • MEM_BIR — VARCHAR2(80)
  • MEM_ZIP — VARCHAR2(80)
  • MEM_MAIL — VARCHAR2(80)
  • MEM_MAIL_YN — CHAR(1)
  • MEM_HP — VARCHAR2(80)
  • MEM_HP_YN — CHAR(1)
  • MEM_RANK — VARCHAR2(80)
  • MEM_PREF — VARCHAR2(80)
  • MEM_DEL_YN — CHAR(1)