Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 DATEENTERED datetime   The date the attachment was entered.
 TITLE nvarchar(50)   Default = '' The title of the attachment.
 FILENAME nvarchar(255)   Default = '' The original file name for the attachment.
 FILE varbinary   The actual file for the attachment.
 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
 AUTHORID uniqueidentifier CONSTITUENT.LOCALID The author of the attachment.
 DESIGNATIONLEVELATTACHTYPECODEID uniqueidentifier   DESIGNATIONLEVELATTACHTYPECODE.ID Indicates the user-defined type of this attachment.
 DESIGNATIONLEVELID uniqueidentifier   DESIGNATIONLEVEL.ID The designation level record to which this attachment belongs.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_DESIGNATIONLEVELATTACHMENT_AUTHORID AUTHORID      
 IX_DESIGNATIONLEVELATTACHMENT_DATEADDED DATEADDED    
 IX_DESIGNATIONLEVELATTACHMENT_DATECHANGED DATECHANGED      
 IX_DESIGNATIONLEVELATTACHMENT_DESIGNATIONLEVELID DESIGNATIONLEVELID      
 PK_DESIGNATIONLEVELATTACHMENT ID  

Trigger Name Description
 TR_DESIGNATIONLEVELATTACHMENT_AUDIT_UPDATE
 TR_DESIGNATIONLEVELATTACHMENT_AUDIT_DELETE

Entity-Relationship diagram of this table