dbo.QERReuse
Multi-request resources
TableType TUsage USERDATARows 6SizeMB 0.048
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QERReuse | varchar(38) | no | Multi-request resource | PKUID |
UID_AccProduct | varchar(38) | yes | Service item | FKUID |
Ident_QERReuse | nvarchar(128) | yes | Multi-request 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 | |
IsAutoAssignToPerson | bit(1) | yes | Automatic assignment to identities | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsNoInheriteToSecurityIncident | bit(1) | yes | No inheritance on security risk | |
UID_QERReusePredecessor | varchar(38) | yes | Resource predecessor | FKUID |
UID_QERResourceType | varchar(38) | yes | Resource type | FKUID |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL2521 | PersonHasQERReuse.UID_QERReuse | QERReuse.UID_QERReuse |
| QER_RFRL2526 | QERReuse.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL2564 | QERReuse.UID_QERResourceType | QERResourceType.UID_QERResourceType |
Triggers
ATT_TUQERReuse SQL_TRIGGER
GEN_T12F3AA995F5ED2F9822AEAE0A SQL_TRIGGER
GEN_T2B941281A314117A6F2ABE08C SQL_TRIGGER
GEN_T321C8DAB4400191BE98C5786C SQL_TRIGGER
GEN_T508DF7ED88458A800972CB535 SQL_TRIGGER
QER_TUQERReuse 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_FTEA1216AC32F7DDFD2F28A5A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA1F4A4D596754E8C86BFEA9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA46F00D80E21C1022CB5C08 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA532B9A3E14A9D7429B5D48 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEACA40EFDEFD73519CB8686E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEADE880E3AF4EE9AA85A729C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAEF8461936F1EDDAA2786EE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAF375C8DA6762C3F41D8CD0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAF7C9B410A1B1C80C52DC2D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEFFAA41A2AB92F8FB75E91BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO0EAA3325F4B764158A37C9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO28A2459499E91085A71994 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO367CE1B2CFF414B5FB884A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO4E5921D551EC885BEFB26E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO4F410D16844712C63A98BA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO7C273B59BCD5A19218AD6E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD74410BBDA5C1BE51102F6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEODE642CEE7EF80F321AEF2B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOEC43185C598C8AD42BBAC7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY06423E1553D20332D88F9A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY3119E9B9D28BDAB8DBBB2F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY362F968B4687C8212EF4EF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY41843567E57D1397868D56 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY4855C755CA9487EA21B72A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY603E46E7D17851CEECD074 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYB8BBCF8E8E26BBED8671F5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYFAEF8CACEA5085E028D489 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYFF99B6B069C342288C6BA9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERReuse | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasQERReuse | 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_FTQERReusePredecessor | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTQERReusePredecessor | SQL expression dependency | dbo · UID_QERReuse · OBJECT_OR_COLUMN |
| dbo.QER_FTQERReusePredecessor | SQL expression dependency | dbo · UID_QERReusePredecessor · OBJECT_OR_COLUMN |
| dbo.GEN_T12F3AA995F5ED2F9822AEAE0A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1F4558730390BCF38050100FF | 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_T23007F178ED2AD3FE16EFDC33 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2B941281A314117A6F2ABE08C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T321C8DAB4400191BE98C5786C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T508DF7ED88458A800972CB535 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T52DB0D70DB7469FBEFFF7A17F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIBaseTreeHasQERReuse | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIPersonHasQERReuse | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERReuse | 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 |
| PersonHasQERReuse | foreign key references table | QER_RFRL2521: PersonHasQERReuse.UID_QERReuse -> QERReuse.UID_QERReuse |
| AccProduct | referenced by foreign key from table | QER_RFRL2526: QERReuse.UID_AccProduct -> AccProduct.UID_AccProduct |
| QERResourceType | referenced by foreign key from table | QER_RFRL2564: QERReuse.UID_QERResourceType -> QERResourceType.UID_QERResourceType |
| dbo.QER_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZOrgHasQERReuse | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZPersonHasQERReuse | source text reference | has TRY/CATCH error handling |
| dbo.QER_FTQERReusePredecessor | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_TIBaseTreeHasQERReuse | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIPersonHasQERReuse | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUQERReuse | 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-itshophelperasync.cs | decompiled C# reference | classes ITShopHelperAsync, _003C_003Ec__DisplayClass14_0, _003C_003Ec__DisplayClass2_0, _003C_003Ec__DisplayClass4_0; methods _003C_CheckIsGroupAccount_003Eb__0, _003CHandlePersonHasAccountDef_003Eb__0, _003CGetValidAccountDef_003Eb__0, MoveNext, SetStateMachine, CreateAccountITShopOrder; references AccProduct, BasetreeAssign, BaseTreeHasObject, Delegation, DialogTable, ITShopOrg; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| 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 |