Schema 201906032300
atom
| Column | Type | Qualifiers |
|---|---|---|
| id | INTEGER | |
| name | TEXT | |
| PRIMARY KEY ++ | id | |
| UNIQUE | name |
content
| Column | Type | Qualifiers |
|---|---|---|
| id | INTEGER | |
| uuid | TEXT | |
| ctime | INTEGER | |
| size | INTEGER | |
| data | BLOB | nullable |
| PRIMARY KEY ++ | id | |
| UNIQUE | uuid | |
| CHECK | length(uuid) = 64 AND id > 0 | |
| content_2 | INDEX | ctime |
content_dex
| Column | Type | Qualifiers |
|---|---|---|
| id | INTEGER | |
| slot | INTEGER | |
| thing | INTEGER | --> content (id) |
| PRIMARY KEY ++ | id | |
| UNIQUE | slot | |
| UNIQUE | thing |
path
| Column | Type | Qualifiers |
|---|---|---|
| id | INTEGER | |
| content | INTEGER | --> content (id) |
| path | TEXT | |
| PRIMARY KEY ++ | id | |
| UNIQUE | path | |
| path_3 | INDEX | content |
schema
| Column | Type | Qualifiers |
|---|---|---|
| key | TEXT | |
| version | INTEGER | |
| PRIMARY KEY | key |
search
| Column | Type | Qualifiers |
|---|---|---|
| id | INTEGER | |
| name | TEXT | nullable |
| spec | TEXT | nullable |
| left | INTEGER | --> search (id) nullable |
| right | INTEGER | --> search (id) nullable |
| size | INTEGER | nullable |
| PRIMARY KEY ++ | id | |
| UNIQUE | spec, left, right |
search_dex
| Column | Type | Qualifiers |
|---|---|---|
| id | INTEGER | |
| slot | INTEGER | |
| thing | INTEGER | --> search (id) |
| PRIMARY KEY ++ | id | |
| UNIQUE | slot | |
| UNIQUE | thing |
search_result
| Column | Type | Qualifiers |
|---|---|---|
| id | INTEGER | --> search (id) |
| content | INTEGER | --> content (id) |
| PRIMARY KEY | id, content |
tag
| Column | Type | Qualifiers |
|---|---|---|
| id | INTEGER | |
| name | INTEGER | --> atom (id) |
| PRIMARY KEY ++ | id | |
| UNIQUE | name |
tag_content
| Column | Type | Qualifiers |
|---|---|---|
| id | INTEGER | |
| content | INTEGER | --> content (id) -- |
| tag | INTEGER | --> tag (id) -- |
| PRIMARY KEY ++ | id | |
| UNIQUE | content, tag |
tag_value
| Column | Type | Qualifiers |
|---|---|---|
| id | INTEGER | --> tag_content (id) |
| serial | INTEGER | -- Index of value in tag/content |
| value | INTEGER | --> atom (id) |
| PRIMARY KEY | id, serial |