cat integer REFERENCES word (id),
ref integer REFERENCES word (id),
prio smallint NOT NULL DEFAULT '1',
cat integer REFERENCES word (id),
ref integer REFERENCES word (id),
prio smallint NOT NULL DEFAULT '1',
COMMENT ON COLUMN word.cat IS 'hierarchical classification';
COMMENT ON COLUMN word.ref IS 'reference to equivalent eng translation';
COMMENT ON COLUMN word.prio IS 'difficulty level or importance; lower values have precedence';
COMMENT ON COLUMN word.cat IS 'hierarchical classification';
COMMENT ON COLUMN word.ref IS 'reference to equivalent eng translation';
COMMENT ON COLUMN word.prio IS 'difficulty level or importance; lower values have precedence';
COMMENT ON COLUMN word.cover IS 'highlight if selected';
COMMENT ON COLUMN word.source IS 'URI of downloaded image';
COMMENT ON COLUMN word.thumb IS 'ImageMagick convert options to create thumbnail from source image';
COMMENT ON COLUMN word.cover IS 'highlight if selected';
COMMENT ON COLUMN word.source IS 'URI of downloaded image';
COMMENT ON COLUMN word.thumb IS 'ImageMagick convert options to create thumbnail from source image';
CREATE OR REPLACE VIEW _cat_words AS
SELECT exportform(word.*) form, sub.*, word.lang, word.ref
FROM word RIGHT JOIN (
CREATE OR REPLACE VIEW _cat_words AS
SELECT exportform(word.*) form, sub.*, word.lang, word.ref
FROM word RIGHT JOIN (