LIBRARY
Tables (8)
BOOK
- UNQ — NUMBER — Primary key — NOT NULL
- ID — VARCHAR(50)
- THUMBNAIL — VARCHAR(500)
- TITLE — VARCHAR(100)
- AUTHORS — VARCHAR(100)
- PUBLISHER — VARCHAR(100)
- ISBN — VARCHAR(100)
- CONTENTS — CLOB
- HITS — NUMBER
- DATETIME — TIMESTAMP
- RDATE — TIMESTAMP
LibArchives
- SIT_NUMBER — NUMBER
- SESSION_ID — VARCHAR(30)
- SDATE — TIMESTAMP
- EDATE — TIMESTAMP
LibBookHistory
- UNQ — NUMBER — Primary key — NOT NULL
- ID — VARCHAR(50)
- THUMBNAIL — VARCHAR(500)
- TITLE — VARCHAR(100)
- AUTHORS — VARCHAR(100)
- DATETIME — TIMESTAMP
- ISBN — VARCHAR(100)
- CODE — NUMBER
- RDATE — TIMESTAMP
- EDATE — TIMESTAMP
LibCalendar
- UNQ — NUMBER — Primary key — NOT NULL
- YEAR — NUMBER
- MONTH — NUMBER
- DAY — NUMBER
- TITLE — VARCHAR(500)
- CONTENT — VARCHAR(4000)
- FILE1 — VARCHAR(1000)
LibEventBoard
- UNQ — NUMBER — Primary key — NOT NULL
- TITLE — VARCHAR(500)
- NAME — VARCHAR(20)
- CONTENT — VARCHAR(4000)
- HITS — NUMBER
- FILE1 — VARCHAR(1000)
- FILE2 — VARCHAR(1000)
- RDATE — TIMESTAMP
LibMemberInfo
- USERID — VARCHAR(50)
- USERPASS — VARCHAR(50)
- NAME — VARCHAR(50)
- BIRTH — DATE
- PHONE — VARCHAR(20)
- EMAIL — VARCHAR(50)
- ADDR1 — VARCHAR(100)
- ADDR2 — VARCHAR(100)
- MAILCHK — CHAR(1)
- SMSCHK — CHAR(1)
- RDATE — TIMESTAMP
- UDATE — TIMESTAMP
- STATE — CHAR(1)
LibNoticeBoard
- UNQ — NUMBER — Primary key — NOT NULL
- TITLE — VARCHAR(500)
- NAME — VARCHAR(20)
- CONTENT — VARCHAR(4000)
- HITS — NUMBER
- EMPS — CHAR(1)
- FILE1 — VARCHAR(1000)
- FILE2 — VARCHAR(1000)
- RDATE — TIMESTAMP
LibReserve
- SIT_NUMBER — NUMBER
- SESSION_ID — VARCHAR(30)
- SIT_STATUS — CHAR(1)