Thread:Talk:Requests for comment/New sites system/Database schema proposal

Denny Vrandečić proposed this database schema on the page.

Mapping of use cases to schema

 * (1) GlobalIDs:
 * (2) Multiple IDs: there can be several  for a single
 * (3) Types and Typed data:  and , for local differences also
 * (4) Languages:
 * (5) Arbitrary language links: ,
 * (6) Groups:
 * (7) Custom URLs:,  ,  , as well as further data in   and
 * (8) Unprefixed sites: no entry in  for a   means an unprefixed site, basically
 * (9) Synchronization: the split between  and   splits the global and local data
 * (10) Site title: not present now. Is there consensus for this?
 * (11) iw_api: covered by  and   (or  )
 * (12) iw_wikiid: covered either by  or
 * (13) iw_local:
 * (14) iw_trans:  or
 * (15) UI: not covered by schema