+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)';
+