RESOURCE

Stores information for resources.

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
NAME nvarchar(100) Default = '' The name to identify the resource.
DESCRIPTION nvarchar(255) Default = '' The description of the resource.
QUANTITY int Default = 0 The quantity of the resource.
ISACTIVE bit Default = 1 Indicates if the resource is currently active.
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.
TYPECODE tinyint Default = 0 Indicates the type of resource.
TYPE nvarchar(14) (Computed) yes CASE [TYPECODE] WHEN 0 THEN N'Non-consumable' WHEN 1 THEN N'Consumable' END Provides a translation for the 'TYPECODE' field.
ISPERTICKETITEM bit Default = 0 Indicates whether the item is used on a per ticket basis.
PERTICKETQUANTITY int Default = 0 The number of items used per each ticket sold, only valid when this is a per ticket item.
PERTICKETDIVISOR int Default = 1 The number of tickets PERTICKETQUANTITY should be divided by to get the actual per ticket quantity.
FORMATTEDPERTICKETQUANTITY nvarchar(25) (Computed) yes dbo.UFN_RESOURCE_FORMATPERTICKETQUANTITY(PERTICKETQUANTITY, PERTICKETDIVISOR) Formats the per ticket quantity with the divisor

Foreign Keys

Foreign Key Field Type Null Notes Description
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
RESOURCECATEGORYCODEID uniqueidentifier RESOURCECATEGORYCODE.ID Indicates the resource category used for classifying the resource.

Indexes

Index Name Fields Unique Primary Clustered
IX_RESOURCE_DATEADDED DATEADDED yes
IX_RESOURCE_DATECHANGED DATECHANGED
PK_RESOURCE ID yes yes
UC_RESOURCE_NAME NAME yes

Triggers

Trigger Name Description
TR_RESOURCE_AUDIT_UPDATE
TR_RESOURCE_AUDIT_DELETE

Referenced by

Referenced by Field
EVENTRESOURCE RESOURCEID
GROUPTYPEREQUIREDRESOURCE RESOURCEID
ITINERARYITEMRESOURCE RESOURCEID
ITINERARYRESOURCE RESOURCEID
PROGRAMRESOURCE RESOURCEID
RATESCALEAPPLICATION RESOURCEID
RATESCALERESOURCE RESOURCEID
RESERVATIONRATESCALEAPPLICATION RESOURCEID
RESERVATIONRATESCALERESOURCE RESOURCEID
RESOURCEPRICING ID
RESOURCETAX RESOURCEID
REVENUESPLITORDER RESOURCEID
TRACKITEMRESOURCE RESOURCEID
TRACKRESOURCE RESOURCEID