Database: PageSlots Table

Description

Holds a list of slots that are in page, which are in books. Slots hold coins, and can have up to 3 lines of text associated to the slot.

NOTE: This is still in development and may change

Fields

• ID - BigInt(20) (UNSIGNED) (PRIMARY KEY)
• PageID - BigInt(20) (UNSIGNED) (NOT NULL)
• RowNum - Int(10) (UNSIGNED) (NOT NULL)
• ColNum - Int(10) (UNSIGNED) (NOT NULL)
• Denomination - Decimal(20,3) (UNSIGNED) (DEFAULT NULL)
• Label - VarChar(50) (DEFAULT NULL)
• Label2 - VarChar(50) (DEFAULT NULL)
• Label3 - VarChar(50) (DEFAULT NULL)

Field Descriptions

• ID - Unique identifier for this slot.
• PageID - Unique identifier for the page which this slot is in.
  • REFERENCES: PageSlots.ID
• RowNum - Which row the slot is in on the page.
• ColNum - Which column the slot is in on the page.
• Denomination - The face value of that coin that fits in this slot.
• Label - The text to display directly under the slot
• Label2 - A second line of text to display under the slot
• Label3 - A third line of text to display under the slot

Related Tables

Coins - A list of coins that can be in this slot.

BookPages - Pages that have slots.