options
Description
Ledger-wide key-value configuration. Stores directives imported from .goluca files (e.g. operating-currency, require-accounts) and runtime settings.
Table Definition
CREATE TABLE options (
id TEXT PRIMARY KEY,
key TEXT NOT NULL UNIQUE,
value TEXT NOT NULL DEFAULT '',
created_at TEXT DEFAULT (datetime('now'))
)
Columns
| Name |
Type |
Default |
Nullable |
Children |
Parents |
Comment |
| created_at |
TEXT |
datetime('now') |
true |
|
|
Timestamp when the option was created |
| id |
TEXT |
|
true |
|
|
UUID primary key |
| key |
TEXT |
|
false |
|
|
Option name (unique), e.g. operating-currency |
| value |
TEXT |
'' |
false |
|
|
Option value |
Constraints
| Name |
Type |
Definition |
| id |
PRIMARY KEY |
PRIMARY KEY (id) |
| sqlite_autoindex_options_1 |
PRIMARY KEY |
PRIMARY KEY (id) |
| sqlite_autoindex_options_2 |
UNIQUE |
UNIQUE (key) |
Indexes
| Name |
Definition |
| sqlite_autoindex_options_1 |
PRIMARY KEY (id) |
| sqlite_autoindex_options_2 |
UNIQUE (key) |
Relations
erDiagram
"options" {
TEXT created_at "Timestamp when the option was created"
TEXT id PK "UUID primary key"
TEXT key "Option name (unique), e.g. operating-currency"
TEXT value "Option value"
}
Generated by tbls