asd

Tables (9)

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 — VARCHAR2(80) — Foreign key → BOOK_DETAIL.B_ISBN — NOT NULL
  • COMM_NM — VARCHAR2(100)
  • COMM_PARENT — CHAR(4)

FREE_BOARD

  • BO_NUM — NUMBER — Primary key — NOT NULL
  • BO_TITLE — VARCHAR2(30)
  • BO_CONTENT — CLOB
  • BO_HIT — NUMBER
  • BO_REG_DATE — DATE
  • BO_MOD_DATE — DATE
  • BO_DEL_YN — CHAR(1 BYTE)
  • BO_MEM_ID — VARCHAR2(30) — Foreign key → MEMBERS.MEM_ID — NOT NULL
  • BO_CATEAGORY — VARCHAR2(80) — Foreign key → COMM_NM.COMM_CD — NOT NULL
  • BO_LIKE — NUMBER

LOAN_TABLE

  • L_LOAN_DATE — DATE
  • L_RETURN_DATE — DATE
  • L_AVAIL_YN — VARCHAR2(80)
  • L_MEM_ID — VARCHAR2(30) — Foreign key → MEMBERS.MEM_ID — NOT NULL
  • LIB_CODE — NUMBER — Foreign key → Library.LIB_CODE — NOT NULL
  • L_ISBN — NUMBER

Library

  • LIB_CODE — NUMBER — Primary key — NOT NULL
  • LIB_NAME — VARCHAR(100) — NOT NULL
  • LIB_ADD — VARCHAR(100)
  • LIB_TEL — VARCHAR(80)
  • LIB_LAT — NUMBER
  • LIB_LON — NUMBER
  • LIB_URL — VARCHAR(500)
  • LIB_TIME — VARCHAR(500)

MEMBERS

  • MEM_ID — VARCHAR2(30) — Primary key — NOT NULL
  • MEM_NAME — VARCHAR2(60)
  • MEM_PASS — CLOB
  • MEM_SALT — CLOB
  • 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 BYTE)
  • MEM_HP — VARCHAR2(80)
  • MEM_HP_YN — CHAR(1 BYTE)
  • MEM_RANK — VARCHAR2(80)
  • MEM_DEL_YN — CHAR(1 BYTE)
  • MEM_PREF — VARCHAR2(80) — Foreign key → COMM_NM.COMM_CD — NOT NULL

PWKEY

  • MEM_ID — VARCHAR2(30) — Foreign key → MEMBERS.MEM_ID — NOT NULL
  • MEM_PRIVATEK — CLOB

QnA_BOARD

  • QB_NUM — NUMBER — Primary key — NOT NULL
  • QB_TITLE — VARCHAR2(80)
  • QB_WRITER — VARCHAR2(40)
  • QB_CONTENT — CLOB
  • QB_HIT — NUMBER
  • QB__REG_DATE — DATE
  • QB_MOD_DATE — DATE
  • QB_DEL_YN — CHAR(1 BYTE)
  • QB_MEM_ID — VARCHAR2(30) — Foreign key → MEMBERS.MEM_ID — NOT NULL

REPLY

  • RE_PARENT_NO — NUMBER
  • RE_PARENT — NUMBER
  • RE_WRITER — VARCHAR2(30)
  • RE_CONTENT — VARCHAR2(4000)
  • RE_REG_DATE — DATE
  • RE_MOD_DATE — DATE
  • RE_MEM_ID — VARCHAR2(30) — Foreign key → MEMBERS.MEM_ID — NOT NULL
  • RE_NUM — NUMBER — NOT NULL