dbo.QERResource
Resources
TableType TUsage USERDATARows 3SizeMB 0.048
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QERResource | varchar(38) | no | Resource | PKUID |
UID_AccProduct | varchar(38) | yes | Service item | FKUID |
Ident_QERResource | nvarchar(128) | yes | 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_QERResourcePredecessor | varchar(38) | yes | Required resource | FKUID |
UID_QERResourceType | varchar(38) | yes | Resource type | FKUID |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL2519 | PersonHasQERResource.UID_QERResource | QERResource.UID_QERResource |
| QER_RFRL2524 | QERResource.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL2562 | QERResource.UID_QERResourceType | QERResourceType.UID_QERResourceType |
Triggers
ATT_TUQERResource SQL_TRIGGER
GEN_T1265232B0F7164F141442200A SQL_TRIGGER
GEN_T242359FFEF64177D04F971D24 SQL_TRIGGER
GEN_T34D8CBAC0DC6C9D423647D56D SQL_TRIGGER
GEN_T58676072FA5C8C396989859EB SQL_TRIGGER
QER_TUQERResource 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_FT0044E9DC660D8FECCA25B039 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA1216AC32F7DDFD2F28A5A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA3506D39B51979D4C46E482 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA370D1058470A9CD26BDA5D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA47E4D1BAE6544A9A61145D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA4B00D2AD20943F16077A89 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA76EA96C7866686065CF072 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEABD70E8CEFB7F495A4BF5E8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEACEAEF6307F54578E77C1CB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAEFA354DB5BB55501D2E20F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAF8A64AD7505FEFD6CA66F0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEFFAA41A2AB92F8FB75E91BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO25BCD2079C53589A9285E1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO2C7526BB07DB9C7586664C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO2DFFC3597F23CBA73DEBA2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO77A9FDA5C1EA828F236BDD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO876EEF41AC6D6820E6BF7A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOB5C679685E9F8BFB80D9AF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOCA638CE8E06208A9F58B78 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD74410BBDA5C1BE51102F6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOF378BB872D5FCEAED0E90F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOF8181E29775D04AE6D5526 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY06423E1553D20332D88F9A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY0F8CCEAC5542AB58BC6783 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY57C35E74C42BCE83936653 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY57D0C486EFB83A7F90C10D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY5F7DBF32525FD5E76002A3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY63EBFB5F389C2C71565877 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY81C940D082F32291EFCE78 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYD1337EF6C6FC4CB197D0D2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYE3300D332EFDFCD61A0A1F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYECAD876E5948B1A0FEF889 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P47FE782293862D2C716B80BCC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PB1830A69EEF88FC94BC348C4B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PB997831590DAEE270ABD98498 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERResource | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasQERResource | 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_FTQERResourcePredecessor | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTQERResourcePredecessor | SQL expression dependency | dbo · UID_QERResource · OBJECT_OR_COLUMN |
| dbo.QER_FTQERResourcePredecessor | SQL expression dependency | dbo · UID_QERResourcePredecessor · OBJECT_OR_COLUMN |
| dbo.GEN_T1169D092956FF62263B6ABDE7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1265232B0F7164F141442200A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1EA7BE24A3331D721708CF413 | 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_T231FF55E94FA474F7C783DADD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T242359FFEF64177D04F971D24 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2CF44B1B0CFB801EB44A91ECE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T34D8CBAC0DC6C9D423647D56D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5665D8E7E130F13C8F0E23EF7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T58676072FA5C8C396989859EB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T59FE35DFCA264AA5378162873 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIBaseTreeHasQERResource | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIPersonHasQERResource | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERResource | 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 |
| dbo.QERVReportAllData | SQL expression dependency | OBJECT_OR_COLUMN |
| PersonHasQERResource | foreign key references table | QER_RFRL2519: PersonHasQERResource.UID_QERResource -> QERResource.UID_QERResource |
| AccProduct | referenced by foreign key from table | QER_RFRL2524: QERResource.UID_AccProduct -> AccProduct.UID_AccProduct |
| QERResourceType | referenced by foreign key from table | QER_RFRL2562: QERResource.UID_QERResourceType -> QERResourceType.UID_QERResourceType |
| dbo.QER_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZOrgHasQERResource | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZPersonHasQERResource | source text reference | has TRY/CATCH error handling |
| dbo.QER_FTQERResourcePredecessor | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_TIBaseTreeHasQERResource | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIPersonHasQERResource | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUQERResource | 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-personhasqerresource.cs | decompiled C# reference | classes PersonHasQERResource; methods MoveNext, SetStateMachine, CreateITShopOrder; references Person, PersonHasQERResource, QERResource; markers references DB/Dialog objects, IT Shop related markers |