User Tools

Site Tools


tech

This is an old revision of the document!


Tech Specs

Tech Notes


Nymology proudly runs on Python3, Django2 and PostgreSQL.

Many thanks to the authors of these tools:

Database Tables and Fields
The Nymology database Nymbase contains the following tables and fields. All fields are text strings except foreign keys, count fields (integer) and z (float).

Common Tables share a set of Common Fields and only list their extra fields. Special Tables only have the fields listed.

Common Tables




COMMON FIELDS:
name = entry word/concept
by = user (foreign key)
src = original source
url = info link
area = field of study
z = generality (0.0-1.0)

TERMS

Quad Poly
length Q count P count
width substitution count element count
depth max depth

Phrase:
qode = single-Q template
subs = NEROS-string
width = substitution count
realm = domains

Fable:
qode = multi-Q template
length = quadranym count
width = substitution count
subs = NEROS-string
realm = domains

Quadranym:
pos = part-of-speech
realm = domains
e = expansion
r = reduction
o = objective
s = subjective
epos = expansion POS
rpos = reduction POS
opos = objective POS
spos = subjective POS

Polynym:
mode = part/step/type
depth = nym count
nness = average depth-ness score
p1 - p12 = nyms

Story:
phrases = names (CSV)
quadranyms = names (CSV)
length = pair count
realm = domains

Tale:
fable = fable (foreign key)
quadranyms = names (CSV)
length = quadranym count

Polymap:
pa = polynym A (foreign key)
pb = polynym B (foreign key)
r1 - r12 = element-to-element relationship

Vectornym:
length = polynym count
width = element count
depth = max polynym width
realm = domains
v1 - v9 = polynyms 1-9 (foreign keys)

Polyset
polynyms = foreign keys (many-to-many)
length = polynym count
depth = max polynym depth
width = element count

Quadraset
quadranyms = foreign keys (many-to-many)
length = quadranym count

Special Tables

Fortune:
body = original text
qode = enqoded text
q1 = Q matches 1 sub
q2 = Q matches 2+ subs
subs = NEROS-string
depth = substitution count

Winner:
by = user (foreign key)
app = game played
round = rounds played
score = high score

Nness
score = N-ness score
polynym = foreign key
user = foreign key


tech.1578875003.txt.gz · Last modified: 2020/01/13 00:23 by 71.174.33.216