User Tools

Site Tools


tech

Tech Specs

Tech Notes


Nymology runs on Python, Django and PostgreSQL. The complete open source code base behind the site can be found on GitHub

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 contain Common Fields in addition to those listed.
Special Tables contain only listed fields.

Common Tables




COMMON FIELDS:
name = entry topic
user = entry author (foreign key)
src = original source
wiki = wikipedia link
area = field of study

TERMS

Quad Poly
length Q count P count
width substitution count dimension 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
p1 - p12 = nyms

Story:
length = pair count
realm = domains

Storyline:
story = group (foreign key)
rank = order
phrase = template (foreign key)
quadranym = topic (foreign key)

Tale:
fable = fable (foreign key)
length = quadranym count

Taleline:
tale = group (foreign key)
rank = order
quadranym = topic (foreign key)

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

Vectornym:
length = polynym count
width = dimension 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 = dimension count

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

Special Tables

Fortune:
body = original text
qode = enqoded text
q1 = enqoding quadranyms (foreign keys)
q2 = enqoding 2+ quadranyms (foreign keys)
subs = NEROS-string
depth = substitution count

Quote:
body = original text
qode = enqoded text
quadranym = enqoding topic (foreign key)
src = original source
subs = NEROS-string
width = substitution count

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

Vote
user_id = voter (foreign key)

Queue
name = potential quadranym


tech.txt · Last modified: 2020/03/14 01:39 by scotty