Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ALLOWMONDAY bit   Default = 1 Indicates if the combination is available on Mondays.
 ALLOWTUESDAY bit   Default = 1 Indicates if the combination is available on Tuesdays.
 ALLOWWEDNESDAY bit   Default = 1 Indicates if the combination is available on Wednesdays.
 ALLOWTHURSDAY bit   Default = 1 Indicates if the combination is available on Thursdays.
 ALLOWFRIDAY bit   Default = 1 Indicates if the combination is available on Fridays.
 ALLOWSATURDAY bit   Default = 1 Indicates if the combination is available on Saturdays.
 ALLOWSUNDAY bit   Default = 1 Indicates if the combination is available on Sundays.
 ALLOWCOMBINATIONDATEFROM datetime Indicates the beginning date the combination is valid.
 ALLOWCOMBINATIONDATETO datetime Indicates the end date the combination is valid.
 ALLOWCOMBINATIONTIMEFROM UDT_HOURMINUTE   Default = '' Indicates the beginning time of day the combination is valid.
 ALLOWCOMBINATIONTIMETO UDT_HOURMINUTE   Default = '' Indicates the end time of day the combination is valid.
 SEQUENCE int   Default = 0 The sequence for availability records.
 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
 COMBINATIONID uniqueidentifier   COMBINATION.ID The ID of the Combination the Combination Availability belongs to.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_COMBINATIONAVAILABILITY_DATEADDED DATEADDED    
 IX_COMBINATIONAVAILABILITY_DATECHANGED DATECHANGED      
 PK_COMBINATIONAVAILABILITY ID  

Trigger Name Description
 TR_COMBINATIONAVAILABILITY_AUDIT_UPDATE
 TR_COMBINATIONAVAILABILITY_AUDIT_DELETE

Referenced by Field
 COMBINATIONAVAILABILITYCONSTITUENCY COMBINATIONAVAILABILITYID
 COMBINATIONAVAILABILITYMEMBER COMBINATIONAVAILABILITYID
 COMBINATIONAVAILABILITYSALESMETHOD COMBINATIONAVAILABILITYID

Entity-Relationship diagram of this table