-
Notifications
You must be signed in to change notification settings - Fork 0
Database: PageSlots Table
Fifteen 15 Studios edited this page Jan 7, 2023
·
3 revisions
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
-
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)
-
ID- Unique identifier for this slot. -
PageID- Unique identifier for the page which this slot is in.- REFERENCES:
PageSlots.ID
- REFERENCES:
-
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
Coins - A list of coins that can be in this slot.
BookPages - Pages that have slots.