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)