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