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)