CONFIGURATIONEXPORTINSTANCE

Stores parameter settings for a specific step in the configuration export business process.

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
CONFIGURATIONEXPORTDATAFORMITEM xml yes Stores the saved parameters for the configuration export process.
SEQUENCE int Default = 0
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
CONFIGURATIONDATACATALOGID uniqueidentifier CONFIGURATIONDATACATALOG.ID Join field for the configuration data definition.
CONFIGURATIONEXPORTPROCESSID uniqueidentifier CONFIGURATIONEXPORTPROCESS.ID FK to CONFIGURATIONEXPORTPROCESS
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.

Indexes

Index Name Fields Unique Primary Clustered
IX_CONFIGURATIONEXPORTINSTANCE_CONFIGURATIONDATACATALOGID CONFIGURATIONDATACATALOGID
IX_CONFIGURATIONEXPORTINSTANCE_CONFIGURATIONEXPORTPROCESSID CONFIGURATIONEXPORTPROCESSID
IX_CONFIGURATIONEXPORTINSTANCE_DATEADDED DATEADDED yes
IX_CONFIGURATIONEXPORTINSTANCE_DATECHANGED DATECHANGED
PK_CONFIGURATIONEXPORTINSTANCE ID yes yes

Triggers

Trigger Name Description
TR_CONFIGURATIONEXPORTINSTANCE_AUDIT_UPDATE
TR_CONFIGURATIONEXPORTINSTANCE_AUDIT_DELETE