AUCTIONITEM

Items sold in auctions.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
NAME	nvarchar(100)		Default = ''	Name of the item
DESCRIPTION	nvarchar(255)		Default = ''	Description of the item
VALUE	money		Default = 0	Value of the item
MINIMUMBID	money		Default = 0	Minimum bid for the item
EXPIRATIONDATE	datetime	yes
TYPECODE	tinyint		Default = 0	Type (item or package) of the auction item.
TYPE	nvarchar(7) (Computed)	yes	CASE [TYPECODE] WHEN 0 THEN N'Item' WHEN 1 THEN N'Package' END	Provides a translation for the 'TYPECODE' field.
DATEADDED	datetime		Default = getdate()	Indicates the date this record was added.
DATECHANGED	datetime		Default = getdate()	Indicates the date this record was last changed.
TS	timestamp			Timestamp.
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.
CUSTOMIDENTIFIER	nvarchar(100)		Default = ''	User-definable custom identifier.
SEQUENCEID	int			Identity column used to increment the default lookupid.
LOOKUPID	nvarchar(100) (Computed)	yes	(CASE LEN(CUSTOMIDENTIFIER) WHEN 0 THEN 'ITEM-' + CAST(SEQUENCEID AS nvarchar(20)) ELSE CUSTOMIDENTIFIER END)	Unique identifier that supports user defined values as well as system generated values.
TRANSACTIONVALUE	money		Default = 0	VALUE of the item in transaction currency.
ORGANIZATIONVALUE	money		Default = 0	VALUE of the item in organization currency.
ORGANIZATIONMINIMUMBID	money		Default = 0	MINIMUMBID of the item in organization currency.
TRANSACTIONMINIMUMBID	money		Default = 0	MINIMUMBID of the item in transaction currency.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
AUCTIONITEMCATEGORYID	uniqueidentifier	yes	AUCTIONITEMCATEGORY.ID	FK to AUCTIONITEMCATEGORY
AUCTIONITEMSUBCATEGORYID	uniqueidentifier	yes	AUCTIONITEMSUBCATEGORY.ID	FK to AUCTIONITEMSUBCATEGORY
EVENTAUCTIONID	uniqueidentifier	yes	EVENTAUCTION.ID	Auction
PACKAGEID	uniqueidentifier	yes	AUCTIONITEM.ID	Package
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
COPIEDFROMID	uniqueidentifier	yes	AUCTIONITEM.ID	FK to AUCTIONITEM
REVENUEAUCTIONDONATIONID	uniqueidentifier	yes	REVENUEAUCTIONDONATION.ID	Revenue record
BASECURRENCYID	uniqueidentifier	yes	CURRENCY.ID	The base currency associated with this auction item.
BASEEXCHANGERATEID	uniqueidentifier	yes	CURRENCYEXCHANGERATE.ID	The exchange rate used to calculate the base amounts.
BASETOORGANIZATIONEXCHANGERATEID	uniqueidentifier	yes	CURRENCYEXCHANGERATE.ID	The rate used to convert the minimum bid field. The minimum bid field will only be in base currency.
ORIGINTOORGANIZATIONEXCHANGERATEID	uniqueidentifier	yes	CURRENCYEXCHANGERATE.ID	The rate used to convert the value field.
TRANSACTIONCURRENCYID	uniqueidentifier	yes	CURRENCY.ID	The transaction currency associated with this auction item.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_AUCTIONITEM_AUCTIONITEMCATEGORYID	AUCTIONITEMCATEGORYID
IX_AUCTIONITEM_AUCTIONITEMSUBCATEGORYID	AUCTIONITEMSUBCATEGORYID
IX_AUCTIONITEM_BASECURRENCYID	BASECURRENCYID
IX_AUCTIONITEM_BASEEXCHANGERATEID	BASEEXCHANGERATEID
IX_AUCTIONITEM_BASETOORGANIZATIONEXCHANGERATEID	BASETOORGANIZATIONEXCHANGERATEID
IX_AUCTIONITEM_DATEADDED	DATEADDED			yes
IX_AUCTIONITEM_DATECHANGED	DATECHANGED
IX_AUCTIONITEM_EVENTAUCTIONID	EVENTAUCTIONID
IX_AUCTIONITEM_ORIGINTOORGANIZATIONEXCHANGERATEID	ORIGINTOORGANIZATIONEXCHANGERATEID
IX_AUCTIONITEM_PACKAGEID	PACKAGEID
IX_AUCTIONITEM_REVENUEAUCTIONDONATIONID	REVENUEAUCTIONDONATIONID
IX_AUCTIONITEM_TRANSACTIONCURRENCYID	TRANSACTIONCURRENCYID
PK_AUCTIONITEM	ID	yes	yes
UC_AUCTIONITEM_LOOKUPID	LOOKUPID	yes

Triggers

Trigger Name	Description
TR_AUCTIONITEM_AUDIT_UPDATE
TR_AUCTIONITEM_AUDIT_DELETE
TR_AUCTIONITEM_INSERTUPDATE_CURRENCY

Referenced by

Referenced by	Field
AUCTIONITEMPURCHASE	AUCTIONITEMID
AUCTIONITEMRESERVATION	AUCTIONITEMID
AUCTIONITEMREVENUEPURCHASE	AUCTIONITEMID
BATCHAMPROIMPORTITEM	AUCTIONITEM_LINKID
BATCHAMPROIMPORTPACKAGE	PACKAGE_LINKID