Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| CompanyID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| CreatedBy | Unknown | 0 | null |
|
|
Created by - Reference to the user who created this query |
||
| IsPublic | Unknown | 0 | null |
|
|
Public flag - Whether this query is available to all users |
||
| Query | nvarchar | 1073741823 | √ | null |
|
|
Text field - Query text information for CustomQueries records |
|
| QueryDescription | Unknown | 0 | null |
|
|
Query description - Explanation of what the query retrieves |
||
| QueryID | Unknown | 0 | null |
|
|
Primary key - CustomQueries unique identifier for each custom query |
||
| QueryName | Unknown | 0 | null |
|
|
Query name - Descriptive name of the custom query |
||
| QuerySQL | Unknown | 0 | null |
|
|
Query SQL - SQL statement for the custom query |
||
| Type | nvarchar | 100 | √ | null |
|
|
Type classification - Category or classification type for CustomQueries records |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CustomQueries | Primary key | Asc | ID |