spotlight_stat_names contains data about the columns belonging to collections. There is one row in this column for each column/table/data source combination.
| Column | Description |
|---|---|
|
statistic_name_id |
Generated ID. |
|
statistic_class_id |
The statistic_class (collection) this column belongs to. |
|
datasource_id |
The data source of the collection that this column belongs to. |
|
statistic_name |
The name of the column. |
|
datatype_guide |
This column provides a broad guide to the type of data that can be expected in facts for this named statistic. Values can be “string”, “numeric” or “date”. |
|
derived |
Whether this is a derived column or not. |
| using_wide_string | Whether the value for this data source is stored in the wide_string column in the spotlight_perdata table or not. If not it is stored in the raw_value column. |
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy
