Book

Tables (7)

Author (Untitled6)

  • authorID — Primary key — NOT NULL
  • authorName
  • phone

Book (Untitled)

  • bookID — Integer — Primary key — NOT NULL
  • authorID — Foreign key → Author.authorID — NOT NULL
  • publisherID — Foreign key → Publisher.publisherID — NOT NULL
  • Genres
  • coverPage
  • Title
  • Price
  • Description
  • details
  • publicationDate
  • summary
  • sample
  • ebookCode

Consumer (Untitled3)

  • consumerID — Primary key — NOT NULL
  • consumerName
  • address
  • phone
  • deviceCode

Order (Untitled4)

  • orderID — Primary key — NOT NULL
  • orderDate
  • totalPrice

Publisher (Untitled5)

  • publisherID — Primary key — NOT NULL
  • publisherName
  • location

ReadingData (Untitled7)

  • bookTitle
  • openTime
  • closeTime (Field3)
  • pageRead (Field4)
  • percentageOfContent (Field5)
  • Field6
  • Field7

Review (Untitled2)