source text CHECK (source ~ '^https?://'),
thumb text[],
wptitle text,
+ story text,
creator integer REFERENCES login (id),
created timestamptz DEFAULT now(),
updated timestamptz,
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.wptitle IS 'reference Wikipedia article';
+COMMENT ON COLUMN word.story IS 'paragraph defining or describing the entity, wikipedia intro';
COMMENT ON COLUMN word.updated IS 'last significant change';
COMMENT ON COLUMN word.creator IS 'user responsible for initial submit';
coalesce(r.source, w.source ) source,
coalesce(r.thumb, w.thumb ) thumb,
coalesce(r.wptitle, w.wptitle) wptitle,
+ coalesce(r.story, w.story ) story,
r.creator, r.created, r.updated,
CASE WHEN r.source IS NULL THEN w.id ELSE r.id END id -- image id
FROM word r