CREATE TABLE identity (
CREATE TABLE mechanism (
mechanismUID TEXT UNIQUE,
version INTEGER,
REFERENCES identity ( issuer, accountName ));
CREATE TABLE notification (
pending INT,
approved INT,
FOREIGN KEY( mechanismUID )
REFERENCES mechanism ( mechanismUID ),