PRAGMA foreign_keys = ON; CREATE TABLE Reader (id INTEGER PRIMARY KEY); CREATE TABLE Loan ( id INTEGER PRIMARY KEY, reader_id INTEGER NOT NULL REFERENCES Reader(id) ); INSERT INTO Reader VALUES (3); INSERT INTO Loan VALUES (5, 3); SELECT * FROM Loan;