jsp 도서관
테이블 (3)
books
- bookno — NUMBER(10, 0) — 기본 키
- title — VARCHAR2(255) — NOT NULL
- author — VARCHAR2(255) — NOT NULL
- publisher — VARCHAR2(255)
- publicationyear — NUMBER(4, 0)
- isbn — VARCHAR2(13)
- category — VARCHAR2(255)
- totaln — NUMBER(10, 0)
- availablen — NUMBER(10, 0)
borrows
- borrowno — NUMBER(10, 0) — 기본 키
- userno (userno3) — NUMBER(10, 0) — 외래 키 → users.userno
- bookno (bookno2) — NUMBER(10, 0) — 외래 키 → books.bookno
- borrowdate — DATE — NOT NULL
- duedate — DATE — NOT NULL
- returndate — DATE
users
- userno — NUMBER(10, 0) — 기본 키
- userid — VARCHAR2(255) — NOT NULL
- password — VARCHAR2(255) — NOT NULL
- name — VARCHAR2(255) — NOT NULL
- phone — VARCHAR2(20) — NOT NULL
- borrown — NUMBER(2, 0)
- joindate — DATE
- ROLE — VARCHAR2(5)