STS_SubtrackTable table
The STS_SubtrackTable table contains the subtrack definitions.
When you run the STS_SubtrackCreate function, a row is added to the STS_SubtrackTable table.
The following table lists the columns in the STS_SubtrackTable table.
| Column name | Data type | Description |
|---|---|---|
| subtrack_id | SERIAL | The unique ID of the subtrack table. |
| subtrack_name | VARCHAR(128) | The name of the subtrack table. The primary key. |
| base_table_name | VARCHAR(128) | The name of the time series table. |
| ts_column_name | VARCHAR(128) | The name of the time series column in the time series table. |
| flags | INTEGER | Specifies whether a Scheduler task indexes new data:
|
| parameters | BSON | A BSON document that contains parameters to build the subtrack. See STS_SetDefaultParameters function. |
| ts_data_first_timestamp | DATETIME YEAR TO SECOND | The first time stamp in the time series to index with the Scheduler task. |
| ts_data_lag_to_current | INTERVAL DAY TO SECOND | The time interval before the current time to avoid indexing with the Scheduler task. |
| task_nschsessions | INTEGER | The number of Scheduler sessions to start to update the index in parallel. |
| task_frequency | INTERVAL DAY TO SECOND | How frequently to index new data with the Scheduler task. |
| task_start_time | DATETIME HOUR TO SECOND | The first time to start the Schedule task. |
| task_data_interval_to_process | INTERVAL DAY TO SECOND | The time interval in the time series to process each time that the Scheduler task is run. |