COMMENT ON COLUMN word.form IS 'preferred textual representation';
COMMENT ON COLUMN word.alt IS 'alternate forms with equivalent meaning';
COMMENT ON COLUMN word.lang IS 'ISO 639 language code matching wikipedia subdomain';
-COMMENT ON COLUMN word.cat IS 'hierarchical classification';
+COMMENT ON COLUMN word.cat IS 'primary hierarchical classification';
COMMENT ON COLUMN word.ref IS 'reference to equivalent en translation';
COMMENT ON COLUMN word.prio IS 'difficulty level or importance; lower values have precedence';
COMMENT ON COLUMN word.grade IS 'ascending hierarchical order, preceding default alphabetical';
COMMENT ON COLUMN word.updated IS 'last significant change';
COMMENT ON COLUMN word.creator IS 'user responsible for initial submit';
+CREATE TABLE kind (
+ word integer NOT NULL REFERENCES word (id),
+ cat integer NOT NULL REFERENCES word (id),
+ UNIQUE (word, cat),
+ truth smallint NOT NULL DEFAULT '50',
+ creator integer REFERENCES login (id),
+ created timestamptz DEFAULT now(),
+ updated timestamptz,
+ id serial NOT NULL PRIMARY KEY
+);
+
+COMMENT ON COLUMN kind.truth IS 'link validity ranging from 0 (never) to 100 (always)';
+
CREATE OR REPLACE FUNCTION exportform(word) RETURNS text AS $$
SELECT concat(
$1.id, ':',