dbo.QBMRelation
Table relations
TableType TUsage CONFIGURATIONRows 1456SizeMB 1.528
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QBMRelation | varchar(38) | no | Table relation | PKUID |
RelationID | nvarchar(128) | no | Relation ID | |
ParentRestriction | nchar(4) | no | Parent relation constraint | limited |
ParentExecuteBy | nchar(2) | yes | Parent relation test instance | limited |
ParentAllowUpdate | bit(1) | yes | Configurable parent relation | |
ChildRestriction | nchar(4) | no | Child relation constraint | limited |
ChildExecuteBy | nchar(2) | yes | Child relation test instance | limited |
ChildAllowUpdate | bit(1) | yes | Configurable child relation | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
IsMNRelation | bit(1) | yes | Many-to-many relation | |
XTouched | nchar(2) | yes | Processing status | |
isSPML | bit(1) | yes | Export for SPML schema | |
IsConnectedInTransport | int(4) | yes | Only transport as group | bitmask |
Caption | nvarchar(512) | yes | Display name | |
generateParent | nvarchar(6) | yes | Generated restriction test for parent relation | |
generateChild | nvarchar(6) | yes | Generated restriction test for child relations | |
UID_ChildColumn | varchar(38) | no | Connected column | FKUID |
UID_ParentColumn | varchar(38) | no | Parent column | FKUID |
UID_QBMRelationBase | varchar(38) | yes | Relation (Base) | FKUID |
UID_QBMRelationMN | varchar(38) | yes | Relation (many-to-many) | FKUID |
XObjectKey | varchar(138) | no | Object key | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsForUpdateXDateSubItem | bit(1) | yes | Update dependencies modification date | |
IsForAddElementAffected | bit(1) | yes | Parent object in job queue | |
UISlimCreationTemplate | nvarchar(-1) | yes | Slim creation template | |
UIGetFilterScript | nvarchar(-1) | yes | Selection script |
Relations
| FK | From | To |
|---|---|---|
| No FK rows in snapshot. | ||
Triggers
GEN_T1B78853CA21187E12B988A24E SQL_TRIGGER
GEN_T2A57429F308CA07A04D784479 SQL_TRIGGER
GEN_T3A0C1A0EFC8862F96A1C8E8B4 SQL_TRIGGER
GEN_T4661FE9741BD352F16C111F58 SQL_TRIGGER
GEN_T5BC79B72B981D1230589D4AC3 SQL_TRIGGER
GEN_T69451921BB8C994499868FB08 SQL_TRIGGER
QBM_TDAssembly_QBMRelation SQL_TRIGGER
QBM_TDQBMRelation SQL_TRIGGER
QBM_TIAssembly_QBMRelation SQL_TRIGGER
QBM_TIQBMRelation SQL_TRIGGER
QBM_TUAssembly_QBMRelation SQL_TRIGGER
QBM_TUQBMRelation 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.QBM_FCVObjectKeyMNToParentKey | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FSQXDateSubItemUpdate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PCheckSameCase_38 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDatabasePrepareCheck2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PQBMRelationCheck | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PQBMRelationExpand_One | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PQBMRelationUserChangeCorr | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PRelationshipDefineManual | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PRITriggerCreate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropColumn | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropColumnFK | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPreProptableFK | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZRITriggerPrepare | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZXMarkedForDeletionPush | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1221F649A2079EA2C2D2121D3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1B78853CA21187E12B988A24E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T20F72DD10227C3738AA03624D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2A57429F308CA07A04D784479 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T30FD7D35FC495D5D5685F4017 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3A0C1A0EFC8862F96A1C8E8B4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5BC79B72B981D1230589D4AC3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUAssembly_QBMRelation | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUQBMRelation | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_VForeignKeyRepairable | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_VQBMRelation | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_VQBMRelationALL | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FCVObjectKeyMNToParentKey | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FSQXDateSubItemUpdate | source text reference | inserts DBQueue tasks, uses session context values |
| dbo.QBM_PCheckSameCase_38 | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PColumnCustomRemove | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PDatabasePrepareCheck2 | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PQBMRelationCheck | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PQBMRelationExpand_One | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PQBMRelationUserChangeCorr | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PRelationshipDefineManual | source text reference | SQL_STORED_PROCEDURE |
| dbo.QBM_PRITriggerCreate | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PTableDrop | source text reference | has TRY/CATCH error handling |
| dbo.QBM_ZPrePropColumn | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZPrePropColumnFK | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZPreProptableFK | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZRITriggerPrepare | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZXMarkedForDeletionPush | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TUAssembly_QBMRelation | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TUQBMRelation | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |