BookStore
Tables (6)
Category (Untitled)
- Key (cateCode) — int — Primary key — NOT NULL
- Field2 (tier) — int
- (cateName) — NUMBER(4)
- Field (cateParent) — NUMBER(4)
book
- Key (book_num) — int — Primary key — NOT NULL
- Field (subject) — VARCHAR2(30)
- Field2 (author) — VARCHAR2(30)
- Field3 (publish_date) — date
- Field4 (publisher) — VARCHAR2(30)
- Field5 (price) — int
- Field (intro) — clob
- Field (stock) — int
- Field (img) — VARCHAR2(30)
- Key (category_num) — int — Foreign key → Category.Key — NOT NULL
book_purchase (Untitled3)
- Key (purchase_num) — int — Primary key — NOT NULL
- 아이디 (id) — VARCHAR2(30) — Foreign key → user.아이디 — NOT NULL
- Field (date)
- Key (book_num) — int — Foreign key → book.Key — NOT NULL
review (Untitled4)
- Key (review_num) — int — Primary key — NOT NULL
- 아이디 (id) — VARCHAR2(30) — Foreign key → user.아이디 — NOT NULL
- Field (subject) — VARCHAR2(50)
- Field (content) — CLOB
- Field (ip) — VARCHAR2(50)
- Field (regdate) — date
- Field (readhit) — NUMBER(4)
- Field (ref) — NUMBER(4)
- Field (step) — NUMBER(4)
- Field (depth) — NUMBER(4)
- Key (purchase_num) — int — Foreign key → book_purchase.Key — NOT NULL
shopping cart (Shopping cart)
- Key (shop_no) — int — Primary key — NOT NULL
- 아이디 (id) — VARCHAR2(30) — Foreign key → user.아이디 — NOT NULL
- Key (book_num) — int — Foreign key → book.Key — NOT NULL
user (User)
- 아이디 (id) — VARCHAR2(30) — Primary key — NOT NULL
- 이름 (name) — VARCHAR2(30)
- 비밀번호 (pwd) — VARCHAR2(30)
- 별명 (nickname) — VARCHAR2(30)
- 성별 (gender) — CHAR(1)
- 주민번호1 (jumin1) — int(8)
- 주민번호2 (jumin2) — int(7)
- 휴대번호 (tel) — int(8)
- 우편번호 (postcode) — number
- 주소1 (addess1) — VARCHAR2(30)
- 주소2 (address2) — VARCHAR2(30)
- 주소3 (address3)
- 이메일 (email) — VARCHAR2(30)
- Field (shop_point) — int
- Field (money) — int