db.schema

CREATE TABLE id_space (id INTEGER PRIMARY KEY);
CREATE TABLE registered_ips (ip TEXT PRIMARY KEY, business_id TEXT, FOREIGN KEY (business_id) REFERENCES members(id));
CREATE TABLE members(id TEXT PRIMARY KEY, f_name TEXT NOT NULL, l_name TEXT NOT NULL, credit_score INTEGER, pass_hash TEXT, pin_hash TEXT);
CREATE TABLE accounts(id INTEGER PRIMARY KEY AUTOINCREMENT, balance INTEGER DEFAULT 0, type TEXT NOT NULL, member_id TEXT NOT NULL, r REAL, term INTEGER, FOREIGN KEY (member_id) REFERENCES members(id));
CREATE TABLE transactions (id INTEGER PRIMARY KEY AUTOINCREMENT, amount INTEGER NOT NULL, payer_id TEXT NOT NULL, recipient_id TEXT NOT NULL, date TEXT, FOREIGN KEY (payer_id) REFERENCES members(id), FOREIGN KEY (recipient_id) REFERENCES members(id));
CREATE TABLE loans (id INTEGER PRIMARY KEY AUTOINCREMENT, principal INTEGER NOT NULL, rate REAL NOT NULL, member_id TEXT NOT NULL, FOREIGN KEY (member_id) REFERENCES members(id));

INSERT INTO members (id, f_name, l_name) VALUES ("0000000000", "Le", "Gouvernement");
INSERT INTO accounts (type, member_id) VALUES ("checking", "0000000000");