dbo.DPRSchemaPropertyReference
Defines a reference between two or more schema properties. The table is handled by the SynchronizationEditor. Do not make any changes here.
TableType TUsage USERDATARows 1037SizeMB 1.872
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRSchemaPropertyReference | varchar(38) | no | Schema property reference | PKUID |
XObjectKey | varchar(138) | no | Object key | |
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 | |
Description | nvarchar(2048) | yes | Description | |
DisplayName | nvarchar(512) | yes | Display name | |
IsReferentialIntegrityEnabled | bit(1) | yes | Referential integrity enabled | |
IsScopeReference | bit(1) | yes | Scope reference | |
Name | nvarchar(512) | no | Name | |
ReferenceType | nvarchar(32) | yes | Reference type | |
UID_QBMClrType | varchar(38) | no | CLR type | FKUID |
SerializationBag | nvarchar(-1) | yes | Serialization bag | |
NameFormat | nvarchar(64) | yes | Name format | |
UID_DPRSchema | varchar(38) | no | Schema | FKUID |
IsLocked | bit(1) | yes | Locked | |
UID_TargetDetectorQBMClrType | varchar(38) | yes | Target detector CLR type | FKUID |
MetaData | nvarchar(2048) | yes | Meta data | |
TargetsUniqueByFilter | nvarchar(-1) | yes | Targets are unique by filter |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2440 | DPRSchemaPropertyReference.UID_QBMClrType | QBMClrType.UID_QBMClrType |
| DPR_RFRL2441 | DPRSchemaPropertyReference.UID_TargetDetectorQBMClrType | QBMClrType.UID_QBMClrType |
Triggers
GEN_T10EBDEF0B467A1F63CF854AC1 SQL_TRIGGER
GEN_T2BCBC844AF9B3DA43810E2361 SQL_TRIGGER
GEN_T3BDC7DA04CFEE606A51F2FFBA SQL_TRIGGER
GEN_T43274D2057FFC0686CB8F541F SQL_TRIGGER
GEN_T55B75F19CA5187F64DEC704FF SQL_TRIGGER
GEN_T641E7B954EB980449BF4E02C0 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.DPR_TDDPRSchemaProperty | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13371B79AFC07E3D85A0E6931 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T19EDD4239A514F26651086E32 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2ABAE3443DC53DD3EC1BBAC13 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2D652E5ECBBE245D62FD15BAF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3D466D5C4953840BA3CFC4FBA | SQL expression dependency | OBJECT_OR_COLUMN |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2440: DPRSchemaPropertyReference.UID_QBMClrType -> QBMClrType.UID_QBMClrType |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2441: DPRSchemaPropertyReference.UID_TargetDetectorQBMClrType -> QBMClrType.UID_QBMClrType |
| dbo.DPR_TDDPRSchemaProperty | source text reference | has TRY/CATCH error handling |