Database: Coins Table

Description

Holds a list of coins in the collection.

Fields

• ID - BigInt(20) (UNSIGNED) (NOT NULL)
• CountryName - VarChar(100) (NOT NULL)
• CurrencyAbbr - VarChar(10) (NOT NULL)
• Type - VarChar(100) (DEFAULT NULL)
• Yr - Int(11) (NOT NULL)
• Denomination - Decimal(20,3) (UNSIGNED) (NOT NULL)
• CurValue - Decimal(20,2) (UNSIGNED) (DEFAULT NULL)
• MintMark - VarChar(3) (DEFAULT NULL)
• Graded - Boolean (DEFAULT FALSE)
• Grade - VarChar(10) (DEFAULT NULL)
• Error - Boolean (DEFAULT FALSE)
• ErrorType - VarChar(100) (DEFAULT NULL)
• SetID - BigInt(20) (UNSIGNED) (DEFAULT NULL) CHECK (SetID is null or SlotID is null),
• SlotID - BigInt(20) (UNSIGNED) (DEFAULT NULL)
• ObvImgExt - VarChar(10) (DEFAULT NULL)
• RevImgExt - VarChar(10) (DEFAULT NULL)
• Note - VarChar(1024) (DEFAULT NULL)
• ContainerID - 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 coin.
• CountryName - Name of the country the coin is from (empty string if it's a token or medal.)
• CurrencyAbbr - Abbreviation of the currency of the coin (empty string if it's a token or medal.)
• Type - Type of coin (e.g. "Lincoln Cent")
• Yr - Year of the coin.
• Denomination - Face value of the coin.
• CurValue - Current market value of the coin. Null if unknown.
• MintMark - Mint mark on the coin. Null if there is no mint mark.
• Graded - True if the coin has been professionally graded. Otherwise false.
• Grade - Grade of the coin. (e.g. MS-65) This grade is best guess unless Graded is true.
• Error - True if the coin has an error. Otherwise false.
• ErrorType - Description of the error, if there is one. Null if there is no error.
• SetID - Unique identifier of the set the coin is in. Null if the coin is not in a set.
  • REFERENCES: Sets.ID
  • NOTE: Either SetID or SlotID must be null, as a coin cannot be in both a set and a book.
• SlotID - Unique identifier of the page slot that the coin is in. Null if the coin is not in a book.
  • REFERENCES: PageSlots.ID
  • NOTE: Either SetID or SlotID must be null, as a coin cannot be in both a set and a book.
• ObvImgExt - File extension of the file containing an image of the front of the coin.
• RevImgExt - File extension of the file containing an image of the back of the coin.
• Note - A custom note about this coin (e.g. Coin inherited from father.)
• ContainerID - Unique identifier of the container that holds this coin. Null if not in a container.
  • REFERENCES: Containers.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 coin is from.

Currencies - The currency of this coin.

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

PageSlots - The slot that this coin is in, which is inside of a book (if any).

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