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