TRACKRESOURCE

Lists the resources used by a track.

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
QUANTITYNEEDED int Default = 0 The quantity of the resource needed for this track.
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.

Foreign Keys

Foreign Key Field Type Null Notes Description
TRACKID uniqueidentifier TRACK.ID The track that the resource is used for.
RESOURCEID uniqueidentifier RESOURCE.ID The resource associated with the track.
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.

Indexes

Index Name Fields Unique Primary Clustered
IX_TRACKRESOURCE_DATEADDED DATEADDED yes
IX_TRACKRESOURCE_DATECHANGED DATECHANGED
PK_TRACKRESOURCE ID yes yes
UIX_TRACKRESOURCE_TRACKID_RESOURCEID TRACKID, RESOURCEID yes

Triggers

Trigger Name Description
TR_TRACKRESOURCE_AUDIT_UPDATE
TR_TRACKRESOURCE_AUDIT_DELETE