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