Database: BooksPages Table

Description

Holds a list of pages in books.

Fields

• ID - BigInt(20) (UNSIGNED) (PRIMARY KEY)
• BookID - BigInt(20) (UNSIGNED) (NOT NULL)
• PageNum - Int(10) (UNSIGNED) (NOT NULL)

Field Descriptions

• ID - Unique identifier for this page
• BookID - Unique ID of the book that this page is in
  • REFERENCES: Books.ID
• PageNum - What page number it is in the book (e.g. 1 for the first page of a book)

Related Tables

Books - Books that this page can be in.

PageSlots - Slots that can be in this book.