1 contributor
Table: schema_meta
Stores schema/runtime metadata as key-value rows.
Columns
| Column | Type | Null | Default | Notes |
|---|---|---|---|---|
key |
TEXT |
no | none | Metadata key. |
value |
TEXT |
no | none | Metadata value. |
updated_at |
TEXT |
no | none | ISO UTC timestamp written by the application. |
Keys And Indexes
- Primary key:
key - SQLite creates the internal primary-key index.
Known Keys
| Key | Meaning |
|---|---|
schema_version |
Current relational schema version. Current value: 2. |
registry_updated_at |
Last registry update timestamp used for API/export metadata. |
Relationships
None.
Definition
CREATE TABLE IF NOT EXISTS schema_meta (
key TEXT PRIMARY KEY,
value TEXT NOT NULL,
updated_at TEXT NOT NULL
);