Newer
■
■
■
■
■
■
■
■
■
■
Older
37 lines
|
0.844kb
| 1 |
# Table: `schema_meta` |
|
| 2 | ||
| 3 |
Stores schema/runtime metadata as key-value rows. |
|
| 4 | ||
| 5 |
## Columns |
|
| 6 | ||
| 7 |
| Column | Type | Null | Default | Notes | |
|
| 8 |
|--------|------|------|---------|-------| |
|
| 9 |
| `key` | `TEXT` | no | none | Metadata key. | |
|
| 10 |
| `value` | `TEXT` | no | none | Metadata value. | |
|
| 11 |
| `updated_at` | `TEXT` | no | none | ISO UTC timestamp written by the application. | |
|
| 12 | ||
| 13 |
## Keys And Indexes |
|
| 14 | ||
| 15 |
- Primary key: `key` |
|
| 16 |
- SQLite creates the internal primary-key index. |
|
| 17 | ||
| 18 |
## Known Keys |
|
| 19 | ||
| 20 |
| Key | Meaning | |
|
| 21 |
|-----|---------| |
|
| 22 |
| `schema_version` | Current relational schema version. Current value: `2`. | |
|
| 23 |
| `registry_updated_at` | Last registry update timestamp used for API/export metadata. | |
|
| 24 | ||
| 25 |
## Relationships |
|
| 26 | ||
| 27 |
None. |
|
| 28 | ||
| 29 |
## Definition |
|
| 30 | ||
| 31 |
```sql |
|
| 32 |
CREATE TABLE IF NOT EXISTS schema_meta ( |
|
| 33 |
key TEXT PRIMARY KEY, |
|
| 34 |
value TEXT NOT NULL, |
|
| 35 |
updated_at TEXT NOT NULL |
|
| 36 |
); |
|
| 37 |
``` |