1 contributor
Table: documents
Legacy document-store table kept only for migration from the first SQLite implementation.
The application no longer uses this table as source of truth after relational tables are seeded.
Columns
| Column | Type | Null | Default | Notes |
|---|---|---|---|---|
name |
TEXT |
no | none | Legacy document name. Known values: hosts_yaml, work_orders_yaml. |
content |
TEXT |
no | none | Legacy YAML payload. |
updated_at |
TEXT |
no | none | Legacy document update timestamp. |
Keys And Indexes
- Primary key:
name - SQLite creates the internal primary-key index.
Relationships
None. Migration code reads this table and imports the YAML into relational tables when hosts or work_orders are empty.
Definition
CREATE TABLE IF NOT EXISTS documents (
name TEXT PRIMARY KEY,
content TEXT NOT NULL,
updated_at TEXT NOT NULL
);