dbo.QEREntitlementSource
Definition of sources can be the origin of an entitlement assignment.
TableType TUsage CONFIGURATIONRows 259SizeMB 1.056
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QEREntitlementSource | varchar(38) | no | Entitlement source | PKUID |
UID_DialogTable | varchar(38) | yes | Table | FKUID |
SQLQuery | nvarchar(-1) | yes | Query | |
Ident_QEREntitlementSource | nvarchar(128) | yes | Source | |
XDateInserted | datetime(8) | yes | Created on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL2567 | QEREntitlementSource.UID_DialogTable | DialogTable.UID_DialogTable |
Triggers
GEN_T2D33DEC4215A5F9FBA7C838D8 SQL_TRIGGER
GEN_T367935E69C35E8CA612EC701F SQL_TRIGGER
QER_TDQEREntitlementSource SQL_TRIGGER
QER_TIQEREntitlementSource SQL_TRIGGER
QER_TUQEREntitlementSource 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.QER_PQEREntitlementSourceDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZEntitlementSourceMakeProc | SQL expression dependency | OBJECT_OR_COLUMN |
| DialogTable | referenced by foreign key from table | QER_RFRL2567: QEREntitlementSource.UID_DialogTable -> DialogTable.UID_DialogTable |
| dbo.QER_PQEREntitlementSourceDef | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZEntitlementSourceMakeProc | source text reference | has TRY/CATCH error handling |