Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 ISDAILYADMISSION bit   Default = 1 Determines whether or not the program is a daily admission program.
 SCHEDULEOPTIONTYPECODE tinyint   Default = 0 Determines the scheduling options if the program is a scheduled program.
 SCHEDULEOPTIONTYPE nvarchar(38) (Computed) CASE [SCHEDULEOPTIONTYPECODE] WHEN 0 THEN N'None' WHEN 1 THEN N'One button for each time' WHEN 2 THEN N'One button for the next available time' WHEN 3 THEN N'Manually select event time' END Provides a translation for the 'SCHEDULEOPTIONTYPECODE' field.
 SHOWALLDATES bit   Default = 1 Determines whether the next available times are shown for all dates or only current date.

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   DAILYSALEITEM.ID Primary Key.
 PROGRAMID uniqueidentifier   PROGRAM.ID The ID of the program.
 PRICETYPECODEID uniqueidentifier   PRICETYPECODE.ID The ID of the price type code.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_DAILYSALEITEMPROGRAM_DATEADDED DATEADDED    
 IX_DAILYSALEITEMPROGRAM_DATECHANGED DATECHANGED      
 PK_DAILYSALEITEMPROGRAM ID  

Trigger Name Description
 TR_DAILYSALEITEMPROGRAM_AUDIT_UPDATE
 TR_DAILYSALEITEMPROGRAM_AUDIT_DELETE

Entity-Relationship diagram of this table