Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SECTIONCOUNT int   Default = 0 Designates the number of sections in the event seating layout.
 SUBSECTIONCOUNT int   Default = 0 Designates the number of sub-sections per section in the event seating layout.
 SEATCOUNT int   Default = 0 Designates the number of seats per sub-section in the event seating layout.
 SUBSECTIONTYPECODE tinyint   Default = 0 Designates the type of sub-section for the event seating layout. Possible values are Table or Row.
 SUBSECTIONTYPE nvarchar(27) (Computed) CASE [SUBSECTIONTYPECODE] WHEN 0 THEN N'Sections, Tables, and Seats' WHEN 1 THEN N'Sections, Rows, and Seats' WHEN 2 THEN N'Sections and Seats' END Provides a translation for the 'SUBSECTIONTYPECODE' field.
 SUBSECTIONSUSECONTINUOUSNUMBERING bit   Default = 0 Designates that the auto-generated number for the subsection should be continuous from section to section.
 SEATSUSECONTINUOUSNUMBERING bit   Default = 0 Designates that the auto-generated number for the seat should be continuous from sub-section to sub-section.
 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
 ID uniqueidentifier   EVENT.ID Primary Key.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_EVENTSEATING_DATEADDED DATEADDED    
 IX_EVENTSEATING_DATECHANGED DATECHANGED      
 PK_EVENTSEATING ID  

Trigger Name Description
 TR_EVENTSEATING_AUDIT_UPDATE
 TR_EVENTSEATING_AUDIT_DELETE

Referenced by Field
 EVENTSEATINGSECTION EVENTSEATINGID

Entity-Relationship diagram of this table