SMARTFIELDVALUEGROUP (4.0)

Contains data describing smart field value groups.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

SMARTFIELDID

uniqueidentifier

false

FK to SMARTFIELD

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.
Fields
Field Field Type Null Notes Description

MONEYVALUERANGE

money

false

0

INTEGERVALUERANGE

int

false

0

GROUPNAME

nvarchar(100)

false

''

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

DATEVALUERANGE

int

false

0

Value range for date smart field in the units specified on the smart field.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_SMARTFIELDVALUEGROUP_DATEADDED

DATEADDED

False

False

True

IX_SMARTFIELDVALUEGROUP_DATECHANGED

DATECHANGED

False

False

False

IX_SMARTFIELDVALUEGROUP_SMARTFIELDID

SMARTFIELDID

False

False

False

PK_SMARTFIELDVALUEGROUP

ID

True

True

False
Triggers
Trigger Name Description

TR_SMARTFIELDVALUEGROUP_SYNCSMARTFIELDVIEW

TR_SMARTFIELDVALUEGROUP_AUDIT_UPDATE

TR_SMARTFIELDVALUEGROUP_AUDIT_DELETE

TR_SMARTFIELDVALUEGROUP_AUDIT_ETLDELETEDID

Referenced by
Referenced by Field

SMARTFIELDVALUEGROUPIDSETREGISTER

SMARTFIELDVALUEGROUPID