For the articletopic search, we'll need a table like
keyword | ORES name(s) | Human name |
---|---|---|
economics | History_And_Society.Business and economics | Economics |
popular-culture | Culture.Internet culture, Culture.Language and literature | Popular culture |
The keyword is what we use internally (e.g. in the API), and what you can use in the wiki's search field (in queries like dragon articletopic:film). Or that could be two different columns, if we feel the need from an UX point of view, but it seems unnecessary.
ORES names are the drafttopic keywords returned by ORES (which are basically wikiproject names) - those could be one-to-one or there could be multiple ORES categories for a keyword.