Bookstore
Tables (8)
Author (Untitled2)
- aCode (Key) — char(20) — Primary key — NOT NULL
- aName (Field) — char(20)
- aBio (Field2) — char(40)
- aEdu (Field3) — char(20)
- aBestbook (Field4) — char(40)
Book (Untitled)
- ISBN (Key) — char(20) — Primary key — NOT NULL
- biCode (Key4) — char(20) — Foreign key → Book_Intro.biCode — NOT NULL
- bVersion (Field5) — char(20)
- aCode (Key2) — char(20) — Foreign key → Author.aCode — NOT NULL
- oCode (Key3) — char(20) — Foreign key → Order.oCode — NOT NULL
- bName (Field) — char(20)
- bPrice (Field2) — int(7)
Book_Intro (Untitled7)
- biCode (Key) — char(20) — Primary key — NOT NULL
- biChapter (Field) — char(20)
- biReview (Field2) — char(40)
- biCoverImage (Field3) — char(20)
- biDetails (Field4) — char(20)
Book_Type (Untitled8)
- btCode (Key) — char(20) — Primary key — NOT NULL
- ISBN (Key2) — char(20) — Foreign key → Book.ISBN — NOT NULL
- biCode (Key4) — char(20) — Foreign key → Book.biCode — NOT NULL
Order (Untitled3)
- oCode (Key) — char(20) — Primary key — NOT NULL
- oDate (Field) — date
- oBookAmount (Field2) — int(5)
- oPrice (Field3) — int(10)
- oPaidorNot (Field4) — char(20)
Publisher (Untitled4)
- pCode (Key) — char(20) — Primary key — NOT NULL
- pName (Field) — char(20)
- pPhone (Field2) — char(20)
- pFax (Field3) — char(20)
- pEmail (Field4) — char(20)
- pAddr (Field5) — char(40)
- oCode (Key2) — char(20) — Foreign key → Order.oCode — NOT NULL
Purchase (Untitled5)
- pcCode (Key) — char(20) — Primary key — NOT NULL
- pcStock (Field) — int(5)
- uCode (Key2) — char(20) — Foreign key → User.uCode — NOT NULL
- ISBN (Key3) — char(20) — Foreign key → Book.ISBN — NOT NULL
- biCode (Key4) — char(20) — Foreign key → Book.biCode — NOT NULL
- pcDate (Field2) — date
User (Untitled6)
- uCode (Key) — char(20) — Primary key — NOT NULL
- uAge (Field) — int(3)
- uJob (Field2) — char(20)
- uName (Field3) — char(20)
- uInterest (Field4) — char(20)
- uPhone (Field5) — char(20)
- uAddr (Field6) — char(40)