data_points

Description

Time-series parameter values. Stores named data points with value and knowledge timestamps for bitemporal queries (e.g. interest rate changes, exchange rates).

Table Definition

CREATE TABLE data_points (
    id TEXT PRIMARY KEY,
    value_time TEXT NOT NULL,
    knowledge_time TEXT DEFAULT (datetime('now')),
    param_name TEXT NOT NULL,
    param_type TEXT NOT NULL DEFAULT 'string',
    param_value TEXT NOT NULL DEFAULT '',
    created_at TEXT DEFAULT (datetime('now'))
)

Columns

Name	Type	Default	Nullable	Comment
created_at	TEXT	datetime('now')	true	Timestamp when the data point was created
id	TEXT		true	UUID primary key
knowledge_time	TEXT	datetime('now')	true	When the system learned about this value
param_name	TEXT		false	Parameter name (e.g. base-rate)
param_type	TEXT	'string'	false	Value type: string, number, or bool
param_value	TEXT	''	false	The parameter value as a string
value_time	TEXT		false	When this value became effective

Constraints

Name	Type	Definition
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_data_points_1	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
idx_data_points_name_time	CREATE INDEX idx_data_points_name_time ON data_points(param_name, value_time)
sqlite_autoindex_data_points_1	PRIMARY KEY (id)

Relations

erDiagram


"data_points" {
  TEXT created_at "Timestamp when the data point was created"
  TEXT id PK "UUID primary key"
  TEXT knowledge_time "When the system learned about this value"
  TEXT param_name "Parameter name (e.g. base-rate)"
  TEXT param_type "Value type: string, number, or bool"
  TEXT param_value "The parameter value as a string"
  TEXT value_time "When this value became effective"
}

Generated by tbls