Database: Sets Table

Description

Holds a list of sets in the collection. Sets can hold coins, bills (banknotes), or other sets.

Fields

• ID - BigInt(20) (UNSIGNED) (PRIMARY KEY)
• Name - VarChar(100) (DEFAULT NULL)
• Yr - Int(11) (DEFAULT NULL)
• CurValue - Decimal(15,2) (UNSIGNED) (DEFAULT NULL)
• ObvImgExt - VarChar(10) (DEFAULT NULL)
• RevImgExt - VarChar(10) (DEFAULT NULL)
• Note - VarChar(1024) (DEFAULT NULL)
• ContainerID - BigInt(20) (UNSIGNED) (DEFAULT NULL)
• ParentID - BigInt(20) (UNSIGNED) (DEFAULT NULL)
• PurchaseDate - Date (DEFUALT NULL)
• PurchasePrice - Decimal(20,2) (DEFAULT NULL)
• PurchasedFrom - varchar(100) (DEFAULT NULL)
• Sold - boolean (DEFUALT FALSE) (DEFAULT FALSE)
• SellPrice - Decimal(20,2) (DEFAULT NULL)
• SoldTo - varchar(100) (DEFAULT NULL)
• SoldDate - Date (DEFAULT NULL)

Field Descriptions

• ID - Unique identifier for this set
• Name - Name of the set
• Yr - Year of the set. Only set if ever item is from the same year. Can be null.
• CurValue - Current market value of the set. Null if unknown.
• ObvImgExt - File extension of the file containing an image of the front of the set.
• RevImgExt - File extension of the file containing an image of the back of the set.
• Note - A custom note about this set(e.g. Inherited from father.)
• ContainerID - Unique identifier of the container that holds this set. Null if not in a container.
  • REFERENCES: Containers.ID
• ParentID - Unique ID of the set that holds this set. Null if this set is not inside of another set.
  • REFERENCES: Sets.ID
• PurchaseDate - Date that you purchased this item. Null if unknown or not purchased.
• PurchasePrice - Price paid when purchased. Null if unknown or not purchased.
• PurchasedFrom - Who the item was purchased from. Null if unknown or not purchased.
• Sold - True if this item has been sold, otherwise false.
• SellPrice - Amount received when sol. Null if unknown or not sold.
• SoldTo - Who the item was sold to. Null if unknown or not sold.
• SoldDate - Date that you sold this item. Null if unknown or not sold.

Related Tables

Coins - Coins that can be in this set.

Bills - Bills (banknotes) that can be in this set.

Containers - Containers that can hold this set.