Legacy database schema

Discover how Remède used to store data in his database.

Tables

The database is divided in three tables :

Name Description
dictionary all Remède documents
rimes an indexations of words to make a rimes dictionary
wordlist an index of all the words to make search faster

Dictionary table

This table contains rows with the following fields:

Field Description Type
word The word string
document The word’s document, as JSON-string string

Rimes table

This table contains rows with the following fields:

Field Description Type Example
word The word string manger
phon The word’s phoneme string m#Ze
orgi The word’s nature string VER\|manger
freq The word’s frequency in french language float 37905
min_nsyl The word’s maximum syllables^1 integer 2
max_nsyl The word’s minimum syllables^1 integer 2
word_end The word’s last syllables string er
phon_end The word’s last phoneme string e
elidable Can the word be precede by an “élide”^1 boolean false
feminine Is the last phoneme “féminine” boolean false

See Rimes

Wordlist table

This table contains rows with the following fields:

Field Description Type Example
word The word string à vue d'œil
indexed The word but case, accent and special chars insensitive string a vue d oeil