     pgp_key_expiration INTEGER,
     presentation_order INTEGER,
     UNIQUE(name),
-    FOREIGN KEY(id) REFERENCES user(id) ON DELETE CASCADE,
+    FOREIGN KEY (id) REFERENCES user(id) ON DELETE CASCADE,
     PRIMARY KEY (id)
 );
 

    internaltip_id TEXT NOT NULL,
    last_access TEXT,
    receipt_hash TEXT NOT NULL,
    FOREIGN KEY(internaltip_id) REFERENCES internaltip(id) ON DELETE CASCADE,
    PRIMARY KEY (id)
);


    type TEXT NOT NULL CHECK (type IN ('receiver', 'whistleblower')),
    content TEXT NOT NULL,
    new INTEGER NOT NULL,
    FOREIGN KEY (receivertip_id) REFERENCES receivertip(id) ON DELETE CASCADE,
    PRIMARY KEY (id)
);

