dbo.PersonHasQERResource
Resource assignments
TableType TUsage USERDATARows 0SizeMB 0.032
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_Person | varchar(38) | no | Identity | PKFKUID |
UID_QERResource | varchar(38) | no | Resource | PKFKUID |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
RiskIndexCalculated | float(8) | yes | Risk index (calculated) | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
XOrigin | int(4) | yes | Origin | bitmask |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XIsInEffect | bit(1) | yes | Assignment in effect |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL2519 | PersonHasQERResource.UID_QERResource | QERResource.UID_QERResource |
Triggers
GEN_T16E27F78E72A7755A31C4204E SQL_TRIGGER
GEN_T245DC8757AF873A2FA6F44088 SQL_TRIGGER
GEN_T5665D8E7E130F13C8F0E23EF7 SQL_TRIGGER
GEN_T6D878AF06F26CC1991BFBBE67 SQL_TRIGGER
QER_TIPersonHasQERResource SQL_TRIGGER
QER_TUPersonHasQERResource 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_FTEA3506D39B51979D4C46E482 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA76EA96C7866686065CF072 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEFFAA41A2AB92F8FB75E91BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO2DFFC3597F23CBA73DEBA2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOF378BB872D5FCEAED0E90F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY57C35E74C42BCE83936653 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYE3300D332EFDFCD61A0A1F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P9B87544E1325D45A63B7E4C95 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PB997831590DAEE270ABD98498 | 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_FTE429BF64AFEA12BCCFC1AC2C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T377F10C7782E804450A883790 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5665D8E7E130F13C8F0E23EF7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUPersonHasQERResource | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERResource | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVPersonHasElement | SQL expression dependency | OBJECT_OR_COLUMN |
| QERResource | referenced by foreign key from table | QER_RFRL2519: PersonHasQERResource.UID_QERResource -> QERResource.UID_QERResource |
| dbo.QER_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZPersonHasQERResource | source text reference | has TRY/CATCH error handling |
| dbo.QER_TUPersonHasQERResource | 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 |