This was my original design and it is not working with sessions in all cases. For example if there is a change set from an other database the global key has to be used. In this cases translationTextId. It would be nice if if you could write: CREATE TABLE IF NOT EXISTS translatables(id AS (rowid), translationTextId TEXT PRIMARY KEY NOT NULL CHECK (translationTextId != ''), screenId TEXT, defaultText TEXT);