Page History
The information related to the status of the query is stored in the QT_QUERY_INSTANCE table.
QT_QUERY_INSTANCE |
|
|
|
Key | Column Name | Column Definition | Nullable? |
PK | QUERY_INSTANCE_ID | Unique id for the query | NO |
FK | QUERY_MASTER_ID | Many to one reference to the query master table | NO |
| USER_ID | The user's login id | NO |
| GROUP_ID | The project id | NO |
| BATCH_MODE | The name of the queue in which the query is running or last ran | YES |
| START_DATE | The date the query was started (run) | YES |
| END_DATE | The date the query finished running | YES |
| DELETE_FLAG | A flag that denotes whether or not the query was deleted. (Y / N) | NO |
FK | STATUS_TYPE_ID | Reference to the QT_STATUS_TYPE table | NO |
| Message | To store the query error message, warning, etc. | YES |