Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| row_id | serial | 10 | √ | nextval('config_row_id_seq'::regclass) |
|
|
Synthetic unique key. Always lookup using |
||||
| id1 | varchar | 2147483647 | null |
|
|
The primary ID of the config. |
|||||
| id2 | varchar | 2147483647 | null |
|
|
The secondary ID of the config. Must be defined, use "" if not required. |
|||||
| id3 | varchar | 2147483647 | null |
|
|
The tertiary ID of the config. Must be defined, use "" if not required. |
|||||
| value | jsonb | 2147483647 | √ | null |
|
|
The configuration value in JSON format. |
||||
| value_schema | uuid | 2147483647 | √ | null |
|
|
The Schema the Config Value conforms to. The |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| config_pkey | Primary key | Asc | row_id |
| config_idx | Must be unique | Asc/Asc/Asc | id1 + id2 + id3 |
Relationships
Close relationships within degrees of separation
