DATAFORMADDINCATALOG

The DATAFORMADDINCATALOG table stores custom addins for data form instances.

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
NAME nvarchar(60) Default = '' A friendly-name for the data form addin
DESCRIPTION nvarchar(1000) Default = '' A description for the data form addin
ASSEMBLYNAME nvarchar(128) Default = '' The name of the CLR assembly containing the addin
CLASSNAME nvarchar(128) Default = '' The name of the class within the assembly that implements the addin
ENABLED bit Default = 1 Indicates whether or not the addin is enabled
SEQUENCE int Default = 0 Provides a sequence when loading multiple addins for a data form
DATAFORMADDINSPECXML xml Contains the spec used to create the data form addin
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) yes CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Keys

Foreign Key Field Type Null Notes Description
DATAFORMINSTANCEID uniqueidentifier DATAFORMINSTANCECATALOG.ID FK to DATAFORMINSTANCECATALOG
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.

Indexes

Index Name Fields Unique Primary Clustered
IX_DATAFORMADDINCATALOG_DATEADDED DATEADDED yes
IX_DATAFORMADDINCATALOG_DATECHANGED DATECHANGED
PK_DATAFORMADDINCATALOG ID yes yes
UC_DATAFORMADDINCATALOG_NAME NAME yes
UIX_DATAFORMADDINCATALOG_DATAFORMINSTANCEID_ASSEMBLYNAME_CLASSNAME DATAFORMINSTANCEID, ASSEMBLYNAME, CLASSNAME yes

Triggers

Trigger Name Description
TR_DATAFORMADDINCATALOG_AUDIT_UPDATE
TR_DATAFORMADDINCATALOG_AUDIT_DELETE