book

Tables (3)

ADMIN

  • CONDENUMBER (codenumber) — VARCHAR2(30) — Primary key — NOT NULL
  • NAME (name) — VARCHAR2(30)
  • PASSWORD (password) — VARCHAR2(20)

BOOK

  • BOOKID (bookid) — NUMBER(20) — Primary key — NOT NULL
  • BOOKNAME (bookname) — VHARCHAR2(30)
  • GENRE (장르) — VARCHAR2(20)
  • WRITER (작가) — VARCHAR2(30)
  • PRICE (가격) — NUMBER(8)
  • BOOKDATE (구매일자) — DATE
  • BOOKTYPE (책타입) — VARCHAR2(40)

USERS

  • 사용자번호 (usernumber) — NUMBER — Primary key — NOT NULL
  • ID — VARCHAR2(20)
  • PASSWORD — VARCHAR2(20)
  • NAME — VARCHAR2(30)
  • RRN (주민번호) — VARCHAR2(20)
  • EMAIL (Email) — VARCHAR2(30)
  • PHONE (Phone) — VARCHAR2(20)
  • ADDRESS (Address) — VARCHAR2(200)
  • USERNUMBER (usernumber2) — NUMBER — Foreign key → USERS.사용자번호 — NOT NULL