dbo.ExtendedAttribute
Extended properties
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_ExtendedAttribute | varchar(38) | no | Extended property | PKUID |
Ident_ExtendedAttribute | nvarchar(128) | yes | Extended property name | |
Description | nvarchar(1024) | yes | Description | |
CustomProperty01 | nvarchar(128) | yes | Spare field no. 01 | |
CustomProperty02 | nvarchar(128) | yes | Spare field no. 02 | |
CustomProperty03 | nvarchar(128) | yes | Spare field no. 03 | |
CustomProperty04 | nvarchar(128) | yes | Spare field no. 04 | |
CustomProperty05 | nvarchar(128) | yes | Spare field no. 05 | |
CustomProperty06 | nvarchar(128) | yes | Spare field no. 06 | |
CustomProperty07 | nvarchar(128) | yes | Spare field no. 07 | |
CustomProperty08 | nvarchar(128) | yes | Spare field no. 08 | |
CustomProperty09 | nvarchar(128) | yes | Spare field no. 09 | |
CustomProperty10 | nvarchar(128) | yes | Spare field no. 10 | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
UID_ExtendedAttributeGroup | varchar(38) | yes | Property group | FKUID |
LowerLimit | nvarchar(128) | yes | Lower limit | |
UpperLimit | nvarchar(128) | yes | Upper limit | |
XObjectKey | varchar(138) | no | Object key | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1362 | ObjectHasExtendedAttribute.UID_ExtendedAttribute | ExtendedAttribute.UID_ExtendedAttribute |
| QER_RFRL1369 | ExtendedAttribute.UID_ExtendedAttributeGroup | ExtendedAttributeGroup.UID_ExtendedAttributeGroup |
| QER_RFRL1371 | ExtendedAttributeInGroup.UID_ExtendedAttribute | ExtendedAttribute.UID_ExtendedAttribute |
Triggers
GEN_T2998905391D0119C29D6B9957 SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.QER_ZBaseTreeHasObjectExtAtt | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasObjectExtAtt | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · UID_ExtendedAttribute · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · Ident_ExtendedAttribute · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · Description · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty01 · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty02 · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty03 · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty04 · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty05 · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty06 · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty07 · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty08 · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty09 · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty10 · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XDateInserted · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XDateUpdated · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XUserInserted · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XUserUpdated · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XTouched · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · UID_ExtendedAttributeGroup · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · LowerLimit · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · UpperLimit · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| dbo.ADS_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XMarkedForDeletion · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · UID_ExtendedAttribute · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · Ident_ExtendedAttribute · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · Description · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty01 · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty02 · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty03 · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty04 · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty05 · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty06 · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty07 · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty08 · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty09 · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · CustomProperty10 · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XDateInserted · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XDateUpdated · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XUserInserted · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XUserUpdated · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XTouched · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · UID_ExtendedAttributeGroup · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · LowerLimit · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · UpperLimit · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XMarkedForDeletion · OBJECT_OR_COLUMN |
| dbo.TSB_VAccountGroupExtendedAtt | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_VPersonAndGroupsExtended | SQL expression dependency | OBJECT_OR_COLUMN |
| ObjectHasExtendedAttribute | foreign key references table | QER_RFRL1362: ObjectHasExtendedAttribute.UID_ExtendedAttribute -> ExtendedAttribute.UID_ExtendedAttribute |
| ExtendedAttributeGroup | referenced by foreign key from table | QER_RFRL1369: ExtendedAttribute.UID_ExtendedAttributeGroup -> ExtendedAttributeGroup.UID_ExtendedAttributeGroup |
| ExtendedAttributeInGroup | foreign key references table | QER_RFRL1371: ExtendedAttributeInGroup.UID_ExtendedAttribute -> ExtendedAttribute.UID_ExtendedAttribute |
| dbo.QER_ZBaseTreeHasObjectExtAtt | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZPersonHasObjectExtAtt | source text reference | has TRY/CATCH error handling |