From 975638afe73b3aec4617987800fc6871e6134469 Mon Sep 17 00:00:00 2001 From: Terry Truong Date: Thu, 5 May 2022 12:48:25 +1000 Subject: Add db table info to data/README.md --- backend/data/README.md | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'backend/data') 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 =========== -- cgit v1.2.3