QUERYVIEWRELATIONSHIP
The QUERYVIEWRELATIONSHIP table stores the relationship for each of the views used by query.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| PATHALIAS |
nvarchar(128) |
|
Default = '' |
Alias name for the linked view; allows two views to be linked on different columns |
| ROOTCOLUMN |
nvarchar(128) |
|
Default = '' |
Column in the query view that is used to link to the related query view |
| RELATEDCOLUMN |
nvarchar(128) |
|
Default = '' |
Column in the related query view that is used to link to the primary object |
| SEQUENCE |
int |
|
Default = 0 |
Used to define a sequential order in query |
| JOINTYPE |
tinyint |
|
Default = 0 |
0 - left outer join, 1 - inner join, 2 - outer apply, 3 - cross apply |
| JOINPARAMETERS |
nvarchar(255) |
|
Default = '0' |
A list of parameters that can be supplied to the table function that is being joined to |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed |
| TS |
timestamp |
|
|
Timestamp |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp |
| CARDINALITYTYPE |
tinyint |
|
Default = 0 |
|
| DISPLAYALIAS |
nvarchar(100) |
|
Default = '' |
|
| DISPLAYALIASRESOURCEKEY |
nvarchar(100) |
|
Default = '' |
|
| RESOURCEFILEASSEMBLYNAME |
nvarchar(max) |
|
|
|
| RESOURCEFILECLASSNAME |
nvarchar(max) |
|
|
|
| OBSOLETE |
bit |
|
Default = 0 |
|
| USEFOREXPORTDEFINITIONSONLY |
bit |
|
Default = 0 |
|
| SUBGROUP |
nvarchar(255) |
|
Default = '' |
|
| SUBGROUPRESOURCEKEY |
nvarchar(100) |
|
Default = '' |
|
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| ROOTQUERYVIEWID |
uniqueidentifier |
|
QUERYVIEWCATALOG.ID
|
Query view ID |
| RELATEDQUERYVIEWID |
uniqueidentifier |
|
QUERYVIEWCATALOG.ID
|
Related query view ID |
| ADDEDBYQUERYVIEWID |
uniqueidentifier |
|
QUERYVIEWCATALOG.ID
|
Query view ID from which the relationship record was created |
| ADDEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT |
| CHANGEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_QUERYVIEWRELATIONSHIP_ADDEDBYQUERYVIEWID |
ADDEDBYQUERYVIEWID |
|
|
|
| IX_QUERYVIEWRELATIONSHIP_DATEADDED |
DATEADDED |
|
|
yes |
| IX_QUERYVIEWRELATIONSHIP_DATECHANGED |
DATECHANGED |
|
|
|
| IX_QUERYVIEWRELATIONSHIP_RELATEDQUERYVIEWID |
RELATEDQUERYVIEWID |
|
|
|
| IX_QUERYVIEWRELATIONSHIP_ROOTQUERYVIEWID |
ROOTQUERYVIEWID |
|
|
|
| PK_QUERYVIEWRELATIONSHIP |
ID |
yes |
yes |
|
| UIX_QUERYVIEWRELATIONSHIP_ROOTQUERYVIEWID_PATHALIAS |
ROOTQUERYVIEWID, PATHALIAS |
yes |
|
|
Triggers
Referenced by