Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 STARTDATE UDT_MONTHDAY   Default = '0000'
 ENDDATE UDT_MONTHDAY   Default = '0000'
 DAYOFWEEKCODE tinyint   Default = 0 Day of week when volunteer available.
 DAYOFWEEK nvarchar(9) (Computed) CASE [DAYOFWEEKCODE] WHEN 0 THEN N'Every day' WHEN 1 THEN N'Sunday' WHEN 2 THEN N'Monday' WHEN 3 THEN N'Tuesday' WHEN 4 THEN N'Wednesday' WHEN 5 THEN N'Thursday' WHEN 6 THEN N'Friday' WHEN 7 THEN N'Saturday' WHEN 8 THEN N'Weekends' WHEN 9 THEN N'Weekdays' END Provides a translation for the 'DAYOFWEEKCODE' field.
 STARTTIME UDT_HOURMINUTE   Default = '' Earliest time volunteer is available
 ENDTIME UDT_HOURMINUTE   Default = '' Lastest time volunteer is available
 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.
 FULLSTARTDATE date
 FULLENDDATE date

Foreign Key Field Type Null Notes Description
 VOLUNTEERID uniqueidentifier   CONSTITUENT.LOCALID FK to CONSTITUENT
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_VOLUNTEERAVAILABILITY_DATEADDED DATEADDED    
 IX_VOLUNTEERAVAILABILITY_DATECHANGED DATECHANGED      
 IX_VOLUNTEERAVAILABILITY_VOLUNTEERID VOLUNTEERID      
 PK_VOLUNTEERAVAILABILITY ID  

Trigger Name Description
 TR_VOLUNTEERAVAILABILITY_AUDIT_UPDATE
 TR_VOLUNTEERAVAILABILITY_AUDIT_DELETE

Entity-Relationship diagram of this table