asasd
Tables (5)
ZPBOOK_26
- BOOK_ID — CHAR(5)
- TITLE — CHAR(30) — NOT NULL
- AUTHOR — CHAR(20) — NOT NULL
- TOTAL_QTY — INT — NOT NULL
- AVAILABLE_QTY — INT — NOT NULL
- PUBLISHER — CHAR(20) — NOT NULL
- PUBLISH_YEAR — CHAR(4) — NOT NULL
- CATEGORY — CHAR(20) — NOT NULL
- LOCATION — CHAR(20) — NOT NULL
ZPBOOK_LOAN_26
- LOAN_ID — CHAR(10)
- STUDENT_ID — CHAR(5) — NOT NULL
- BOOK_ID — CHAR(5) — NOT NULL
- LOAN_DATE — DATE — NOT NULL
- RETURN_DATE — DATE
- DUE_DATE — DATE — NOT NULL
- MEMO — CHAR(100)
ZPLIB_USER_26
- ID — CHAR(20)
- PASSWORD — CHAR(20) — NOT NULL
- NAME — CHAR(20) — NOT NULL
- PHONE — CHAR(20) — NOT NULL
- LAST_LOGIN_D — DATE
- LAST_LOGIN_T — TIME
- PW_HINT_Q — CHAR(30)
- PW_HINT_A — CHAR(50)
ZPLOAN_LOG_26
- LOG_ID — CHAR(10)
- BOOK_ID — CHAR(5) — NOT NULL
- STUDENT_ID — CHAR(5) — NOT NULL
- LOAN_ID — CHAR(10) — NOT NULL
- ACTION — CHAR(6) — NOT NULL
- LOG_DATE — DATE — NOT NULL
- DUE_DATE — DATE
- RETURN_DATE — DATE
- MEMO — CHAR(100)
ZPSTUDENT_26
- STUDENT_ID — CHAR(5)
- NAME — CHAR(20) — NOT NULL
- DEPT — CHAR(20) — NOT NULL
- EMAIL — CHAR(30) — NOT NULL
- PHONE — CHAR(20) — NOT NULL
- BIRTH_DATE — DATE — NOT NULL
- GRADE — CHAR(1) — NOT NULL
- STATUS — CHAR(1) — NOT NULL