aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTerry Truong <terry06890@gmail.com>2022-05-05 12:48:25 +1000
committerTerry Truong <terry06890@gmail.com>2022-05-05 12:48:25 +1000
commit975638afe73b3aec4617987800fc6871e6134469 (patch)
treebe04af183b4e90657e9e71b72ed8d5d561569c10
parent6ff26ab72ec507698f43e86fd59188a3a3fbee54 (diff)
Add db table info to data/README.mdcore-db
-rw-r--r--backend/data/README.md9
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
===========