Database: Bills Table

Description

Holds a list of banknotes in the collection.

Fields

• ID - BitInt(20) (UNSIGNED) (NOT NULL)
• CountryName - VarChar(100) (NOT NULL)
• CurrencyAbbr - VarChar(10) (NOT NULL)
• Type - VarChar(100) (DEFAULT NULL)
• Yr - Int(11) (NOT NULL)
• SeriesLetter - VarChar(3) (DEFAULT NULL)
• Serial - VarChar(20) )DEFAULT NULL)
• Denomination - decimal(20,3) (UNSIGNED) (NOT NULL)
• CurValue - decimal(15,2) (UNSIGNED) (DEFAULT NULL)
• Graded - Boolean (DEFAULT FALSE)
• Grade - VarChar(10) (DEFAULT NULL)
• Error - Boolean (DEFAULT FALSE)
• ErrorType - VarChar(100) DEFAULT NULL)
• Replacement - Boolean (DEFAULT FALSE)
• Signatures - VarChar(255) (DEFAULT NULL)
• ObvImgExt - VarChar(10) (DEFAULT NULL)
• RevImgExt - VarChar(10) (DEFAULT NULL)
• Note - VarChar(1024) (DEFAULT NULL)
• ContainerID - BitInt(20) (UNSIGNED) (DEFAULT NULL)
• SetID - BitInt(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 banknote.
• CountryName - Name of the country the banknote is from.
• CurrencyAbbr - Abbreviation of the currency of the banknote.
• Type - Type of banknote. (e.g. Washington)
• Yr - Year of the banknote.
• SeriesLetter - Letter after the year on the banknote. Null if none.
• Serial - Serial number of the banknote.
• Denomination - Face value of the banknote. (e.g. 1)
• CurValue - Current market value of the banknote.
• Graded - True if professionally graded. Otherwise false.
• Grade - Grade of the banknote. This grade is best guess unless Graded is true.
• Error - True if the banknote has an error. Otherwise false.
• ErrorType - Description of the error, if there is one. Null if there is no error.
• Replacement - True if this is a replacement bill, otherwise false. (e.g. US star notes.)
• Signatures - Signatures present on the bill. Recommended comma separated.
• ObvImgExt - File extension of the file containing an image of the front of the banknote.
• RevImgExt - File extension of the file containing an image of the back of the banknote.
• Note - A custom note about this banknote (e.g. Coin inherited from father.)
• ContainerID - Unique identifier of the container that holds this banknote. Null if not in a container.
  • REFERENCES: Containers.ID
• SetID - Unique identifier of the set the banknote is in. Null if the banknote is not in a 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

Countries - The country which this banknote is from.

Currencies - The currency of this banknote.

Sets - The set that this banknote is a part of (if any).

Containers - The container which holds this coin (if any).