Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ORDERPAGEID int   Default = 0 The ID of the page hosting the order display part. Upon adding or updating tickets, the browser can be redirected to this page.
 ONSALEHORIZON int   Default = 0 Number of days from today defining the end of the span to render events.
 TIMECOUNTTHRESHOLD int   Default = 0 When listing alternative times for an event, list this number of start times and switch to the high-count listing method for more.
 CATEGORYFILTER bit   Default = 0 On the Programs listing, show the category filter control
 MAXIMUMQUANTITY int   Default = 0 Maximum number of tickets (across all price types) that can be purchased for an event.
 TIMEOUTMINUTES int   Default = 0 Timeout value for event tickets.
 LOWAVAILABILITYTHRESHOLD int   Default = 0 Show the low availability label when availability drops below this number. At zero the sold out label shows instead.
 SHOWSOLDOUTEVENTS bit   Default = 0
 EVENTCONTACTEMAILADDRESS UDT_EMAILADDRESS   Default = '' If this setting has a value it will replace the string token MAILTO in the SoldOutMessage string.
 ITEMDEFAULTIMAGEID int   Default = 0 Image library ID of the default image for order display
 ACKTEMPLATE nvarchar(max)   Default = '' Acknowledgement template.
 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.

Foreign Key Field Type Null Notes Description
 CONTENTID int   SiteContent.ID The part instance these settings apply to.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_PROGRAMTICKETPARTCONTENT_DATEADDED DATEADDED    
 IX_PROGRAMTICKETPARTCONTENT_DATECHANGED DATECHANGED      
 PK_PROGRAMTICKETPARTCONTENT ID  
 UC_PROGRAMTICKETPARTCONTENT_CONTENTID CONTENTID    

Trigger Name Description
 TR_PROGRAMTICKETPARTCONTENT_AUDIT_UPDATE
 TR_PROGRAMTICKETPARTCONTENT_AUDIT_DELETE