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