dbo.QERReuseUS
Multi requestable/unsubscribable resources
TableType TUsage USERDATARows 1SizeMB 0.048
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QERReuseUS | varchar(38) | no | Multi requestable/unsubscribable resource | PKUID |
UID_AccProduct | varchar(38) | yes | Service item | FKUID |
Ident_QERReuseUS | nvarchar(128) | yes | Multi requestable/unsubscribable resource | |
Description | nvarchar(-1) | 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 | |
IsForITShop | bit(1) | yes | IT Shop | |
IsITShopOnly | bit(1) | yes | Only use in IT Shop | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
RiskIndex | float(8) | yes | Risk index | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsAutoAssignToPerson | bit(1) | yes | Automatic assignment to identities | |
IsNoInheriteToSecurityIncident | bit(1) | yes | No inheritance on security risk | |
UID_QERReuseUSPredecessor | varchar(38) | yes | Resource predecessor | FKUID |
UID_QERResourceType | varchar(38) | yes | Resource type | FKUID |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL2522 | PersonHasQERReuseUS.UID_QERReuseUS | QERReuseUS.UID_QERReuseUS |
| QER_RFRL2527 | QERReuseUS.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL2565 | QERReuseUS.UID_QERResourceType | QERResourceType.UID_QERResourceType |
Triggers
ATT_TUQERReuseUS SQL_TRIGGER
GEN_T1FA37B83CFFDCFAA7FA476507 SQL_TRIGGER
GEN_T2B6C30B48F6538C1D5A1608B1 SQL_TRIGGER
GEN_T364B9E81165D21BC1EE74FFEF SQL_TRIGGER
GEN_T516F8D02D8A947E6C1982FBEA SQL_TRIGGER
QER_TUQERReuseUS 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.GEN_FTEA052C57FFC38328DEBA32A9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA1216AC32F7DDFD2F28A5A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA18204A66ECAA552D7FF404 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA5422151F788E3664457CFE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA79B4104C58AE0D64794CC5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEADE4559DC2647E1BE849894 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAE3032C0FADEE6588E30677 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAF648DFCDF3FE983A928268 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAFC326AB61853A5350E3D2C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEFFAA41A2AB92F8FB75E91BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO29472A7EC8BF68D730175A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO561124721D666224302112 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO600EF8000C21B93AD22340 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO706B2DAD7C59B720D3AB83 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOA707EB18AFD3AEB659DC74 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOB6B06C1E337B666C531D2A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD74410BBDA5C1BE51102F6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEODC415EB845AEA9700D4736 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOFCDDA80E733A80CFE09BC5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY06423E1553D20332D88F9A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY0D204A0FA588A619EB3F7B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY32246AB0D1EBEA0EF689F3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY46244768898D6B348324B5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY8D93A3D46765A5490FA4FC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYD1C52DE6CB749CD02A401C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYF710376B9619AA2464A2B2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYF7783E5B8726C9CAE353D8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYF9571F25A9F1882987B829 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERReuseUS | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasQERReuseUS | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT4EA9514908EF8B11861005B5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE429BF64AFEA12BCCFC1AC2C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTQERReuseUSPredecessor | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTQERReuseUSPredecessor | SQL expression dependency | dbo · UID_QERReuseUS · OBJECT_OR_COLUMN |
| dbo.QER_FTQERReuseUSPredecessor | SQL expression dependency | dbo · UID_QERReuseUSPredecessor · OBJECT_OR_COLUMN |
| dbo.GEN_T14EAE5D111D4A1716BAE3A9E9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1FA37B83CFFDCFAA7FA476507 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1FFF140BA494B3D88D2C4663E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T21F6500A327433F3515292487 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T220C9857650EAFA0779CA48BE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2B6C30B48F6538C1D5A1608B1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T364B9E81165D21BC1EE74FFEF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T516F8D02D8A947E6C1982FBEA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5D70DB5E2EA3F30AC666E6805 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIBaseTreeHasQERReuseUS | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIPersonHasQERReuseUS | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERReuseUS | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERAccProductUsage | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVBaseTreeHasElement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVPersonHasElement | SQL expression dependency | OBJECT_OR_COLUMN |
| PersonHasQERReuseUS | foreign key references table | QER_RFRL2522: PersonHasQERReuseUS.UID_QERReuseUS -> QERReuseUS.UID_QERReuseUS |
| AccProduct | referenced by foreign key from table | QER_RFRL2527: QERReuseUS.UID_AccProduct -> AccProduct.UID_AccProduct |
| QERResourceType | referenced by foreign key from table | QER_RFRL2565: QERReuseUS.UID_QERResourceType -> QERResourceType.UID_QERResourceType |
| dbo.QER_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZOrgHasQERReuseUS | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZPersonHasQERReuseUS | source text reference | has TRY/CATCH error handling |
| dbo.QER_FTQERReuseUSPredecessor | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_TIBaseTreeHasQERReuseUS | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIPersonHasQERReuseUS | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUQERReuseUS | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-qer-customizer-qer-customizer-person.cs | decompiled C# reference | classes Person, MP, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass11_1; methods _003C_LoadShoppingCartPattern_003Eb__0, _003C_LoadShoppingCartPattern_003Eb__1, _003C_LoadShoppingCartPattern_003Eb__3, _003C_LoadShoppingCartPattern_003Eb__2, _003C_UpdateShoppingCartPattern_003Eb__0, _003C_UpdateShoppingCartPattern_003Eb__1; references AccProduct, AERole, Delegation, DialogColumn, DialogGroup, DialogParameter; markers reads entity values, writes entity values, saves entities, references DB/Dialog objects, IT Shop related markers, Job/process related markers |