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