-- What Wikipedia said about an artist, kept as it said it, with the page it came from. -- The text is CC BY-SA 4.0: the page, its link and the language are what a reader needs -- to give credit, so they are stored with it. -- -- One row per artist. status 'none' records that the chain was followed and there was -- nothing to show (no Wikidata link, or no usable page), so it is not followed again at -- once. wikidata_id is the item MusicBrainz linked to the artist, or ''. CREATE TABLE artist_descriptions ( artist_id INTEGER PRIMARY KEY REFERENCES artists(id) ON DELETE CASCADE, status TEXT NOT NULL CHECK (status IN ('ok', 'none')), wikidata_id TEXT NOT NULL DEFAULT '', language TEXT NOT NULL DEFAULT '', title TEXT NOT NULL DEFAULT '', short TEXT NOT NULL DEFAULT '', -- one line, like "gruppo musicale inglese" body TEXT NOT NULL DEFAULT '', -- the text url TEXT NOT NULL DEFAULT '', retrieved_at INTEGER NOT NULL -- unix seconds );