Details
-
Type:
Story
-
Status: Invalid
-
Resolution: Done
-
Fix Version/s: None
-
Component/s: daf_butler
-
Epic Link:
-
Team:Data Release Production
Description
Make all autoincrement primary keys into a compound key containing an autoincrement key and a literal taken from config.
Compound primary keys that include autoincrement fields are not natively supported in SQLite. Work around this by separating each table with such a key into a "local" table with an autoincrement, non-compound primary key and a "remote" with a non-autoincrement compound primary key, joined by a union view when needed.
Michelle Gower has proposed "origin" instead of "site" for the name of these fields; I like that better, too.