indicator_definitions
indicator_definitions exists only when the Job uses at least one Indicator Instance. It is the self-describing mapping between the frozen Job configuration and the generated columns in indicator output tables.
Columns
| Column | Type | Meaning or values |
|---|---|---|
indicator_instance_id |
TEXT |
Dataset-local identity such as sma_0001 |
indicator_id |
TEXT |
Stable technical Registry indicator ID |
instance_ordinal |
INTEGER |
1-based canonical instance order |
output_id |
TEXT |
Stable technical Registry output ID |
output_ordinal |
INTEGER |
1-based output order from the reviewed definition |
input_series_json |
TEXT |
Deterministic JSON array of required input series |
recalculation_scope |
TEXT |
bounded_forward_range, recursive_to_tail, or cumulative_to_tail |
recalculation_forward_bars |
INTEGER NULL |
Forward range for bounded_forward_range; otherwise NULL |
table_name |
TEXT |
Persisted output table containing this output |
column_name |
TEXT |
Stable generated output column name |
display_name |
TEXT |
Human-readable frozen output label |
params_json |
TEXT |
Deterministic JSON object containing every resolved parameter |
source |
TEXT |
Calculation source/engine attribution |
warmup_bars |
INTEGER |
Warmup needed by the frozen Indicator Instance |
The primary key is (indicator_instance_id, output_id), and (table_name, column_name) is unique.
Stable generated identities
Instances are canonicalized by technical indicator_id, then assigned a contiguous instance_ordinal. Generated columns use:
i{four-digit instance ordinal}_{indicator_id}__{output_id}Examples include i0001_sma__sma and i0042_bbands__upperband. Do not rebuild names from display labels.
JSON-backed values
input_series_json and params_json are compact deterministic JSON text. Parameter values include defaults resolved for the frozen Job configuration. Enum parameters persist the stable Registry option ID rather than a localized label or engine integer.
Query definitions with explicit order:
SELECT *
FROM indicator_definitions
ORDER BY instance_ordinal, output_ordinal;