diff options
| author | Terry Truong <terry06890@gmail.com> | 2022-05-05 12:48:25 +1000 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2022-05-05 12:48:25 +1000 |
| commit | 975638afe73b3aec4617987800fc6871e6134469 (patch) | |
| tree | be04af183b4e90657e9e71b72ed8d5d561569c10 | |
| parent | 6ff26ab72ec507698f43e86fd59188a3a3fbee54 (diff) | |
Add db table info to data/README.mdcore-db
| -rw-r--r-- | backend/data/README.md | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/backend/data/README.md b/backend/data/README.md index 8791fb4..15adb96 100644 --- a/backend/data/README.md +++ b/backend/data/README.md @@ -23,6 +23,15 @@ File Generation Process 2 Run genEnwikiData.py, which adds a 'descs' table to data.db, using data in enwiki/enwikiData.db, and the 'nodes' table. +data.db tables +============== +nodes: name TEXT PRIMARY KEY, children TEXT, parent TEXT, tips INT, p\_support INT +names: name TEXT, alt\_name TEXT, pref\_alt INT, PRIMARY KEY(name, alt\_name) +eol\_ids: id INT PRIMARY KEY, name TEXT +spellfix\_alt\_names +images: eol\_id INT PRIMARY KEY, source\_url TEXT, license TEXT, copyright\_owner TEXT +descs: name TEXT PRIMARY KEY, desc TEXT, redirected INT + spellfix.so =========== |
