project
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)
MEMBERS
- MEM_ID — VARCHAR2(30) — Primary key — 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 BYTE)
- MEM_HP — VARCHAR2(80)
- MEM_HP_YN — CHAR(1 BYTE)
- MEM_RANK — VARCHAR2(80)
- MEM_PREF — VARCHAR2(80)
- MEM_DEL_YN — CHAR(1 BYTE)
PWKEY
- MEM_UD (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