Book Store Database Design
จาก Wiki2
เนื้อหา |
Book
- bookid
- bookname
- bookauthor
- bookpublisher
- bookisbn
- booklanguage
- thai
- notthai
- bookcover
- hard
- soft
- booknumberpage
- bookcategory
- bookoutline
- booksummary
- bookimage
- bookstock
- bookallocate
- bookcost
- bookprice
- bookdiscountprice
- bookshipping
- bookstatus
- active
- disable
- booknew
- bookpromote
- bookbestselling
User
- userid
- username
- usersurename
- userlogin
- userpassword
- useraddress
- userbalance Money in account
- usertype
- buyer
- admin
- userstatus
- active
- block
- userstart date & time
- userlast date & time
- userchange date & time
- userpurchase money total buy since start
Order
- orderid
- bookid
- userid
- ordercartdate
- orderdate
- ordershipdate
- ordercanceldate
- orderqty
- orderamount
- ordertype
- cart
- order
- favorite
- orderstatus
- cart
- cartcancel
- new
- processing
- shipped
- buyercancel
- admincancel
category
- catid
- catname
subcat
- subcatid
- subcatname
- http://www.chulabook.com/book_browse.asp
