BookShopDB

Tables (10)

bs_author

  • authorid — NUMBER — Primary key — NOT NULL
  • authorname — VARCHAR2(50 BYTE)
  • nationid — VARCHAR2(2 BYTE) — Foreign key → bs_nation.nationid
  • authorintro — LONG
  • regdate — DATE
  • updatedate — DATE

bs_bcate

  • catecode — VARCHAR2(30 BYTE) — Primary key — NOT NULL
  • tier — NUMBER(1) — NOT NULL
  • catename — VARCHAR2(30 BYTE) — NOT NULL
  • cateparent — VARCHAR2(30 BYTE) — Foreign key → bs_bcate.catecode

bs_book

  • bookid — NUMBER — Primary key — NOT NULL
  • bookname — VARCHAR2(50 BYTE) — NOT NULL
  • authorid — NUMBER — Foreign key → bs_author.authorid
  • publeyear — DATE — NOT NULL
  • publisher — VARCHAR2(70 BYTE) — NOT NULL
  • catecode — VARCHAR2(30 BYTE) — Foreign key → bs_bcate.catecode
  • bookprice — NUMBER — NOT NULL
  • bookstock — NUMBER — NOT NULL
  • bookdiscount — NUMBER(2, 2)
  • bookintro — CLOB
  • bookcontents — CLOB
  • regdate — DATE
  • updatedate — DATE
  • ratingavg — NUMBER(2, 1)

bs_cart

  • cartid — NUMBER — Primary key — NOT NULL
  • memberid — VARCHAR2(50 BYTE) — Foreign key → bs_member.memberid
  • bookid — NUMBER — Foreign key → bs_book.bookid
  • bookcount — NUMBER

bs_image

  • uuid — VARCHAR2(100 BYTE) — Primary key — NOT NULL
  • bookid — NUMBER(*, 0) — Foreign key → bs_book.bookid
  • filename — VARCHAR2(100 BYTE) — NOT NULL
  • uploadpath — VARCHAR2(200 BYTE) — NOT NULL

bs_member

  • memberid — VARCHAR2(50 BYTE) — Primary key — NOT NULL
  • memberpw — VARCHAR2(100 BYTE) — NOT NULL
  • membername — VARCHAR2(30 BYTE) — NOT NULL
  • membermail — VARCHAR2(100 BYTE) — NOT NULL
  • memberaddr1 — VARCHAR2(100 BYTE) — NOT NULL
  • memberaddr2 — VARCHAR2(100 BYTE) — NOT NULL
  • memberaddr3 — VARCHAR2(100 BYTE) — NOT NULL
  • adminck — NUMBER — NOT NULL
  • regdate — DATE — NOT NULL
  • money — NUMBER — NOT NULL
  • point — NUMBER — NOT NULL

bs_nation

  • nationid — VARCHAR2(2 BYTE) — Primary key — NOT NULL
  • nationname — VARCHAR2(50 BYTE) — NOT NULL

bs_order

  • orderid — VARCHAR2(50 BYTE) — Primary key — NOT NULL
  • customer — VARCHAR2(50 BYTE) — NOT NULL
  • memberid — VARCHAR2(50 BYTE) — Foreign key → bs_member.memberid
  • memberaddr1 — VARCHAR2(100 BYTE) — NOT NULL
  • memberaddr2 — VARCHAR2(100 BYTE) — NOT NULL
  • memberaddr3 — VARCHAR2(100 BYTE) — NOT NULL
  • orderstate — VARCHAR2(30 BYTE) — NOT NULL
  • deliverycost — NUMBER — NOT NULL
  • usepoint — NUMBER — NOT NULL
  • orderdate — DATE

bs_orderitem

  • orderitemid — NUMBER — Primary key — NOT NULL
  • orderid — VARCHAR2(50 BYTE) — Foreign key → bs_order.orderid
  • bookid — NUMBER — Foreign key → bs_book.bookid — NOT NULL
  • bookcount — NUMBER — NOT NULL
  • bookprice — NUMBER — NOT NULL
  • bookdiscount — NUMBER — NOT NULL
  • savepoint — NUMBER — NOT NULL

bs_reply

  • replyid — NUMBER — Primary key — NOT NULL
  • bookid — NUMBER — Foreign key → bs_book.bookid — NOT NULL
  • memberid — VARCHAR2(50 BYTE) — Foreign key → bs_member.memberid — NOT NULL
  • regdate — DATE
  • content — VARCHAR2(3500 BYTE)
  • rating — NUMBER(2, 1) — NOT NULL