Skip to content

Persistence

Lucy Ciara Herud-Thomassen edited this page Apr 23, 2026 · 15 revisions

Persistence in this project is achieved using an H2 database, which stores donation history and user accounts.

Structure

users

user_id INT (PRI) role VARCHAR(32) NOT NULL first_name VARCHAR(32) NOT NULL last_name VARCHAR(32) NOT NULL email VARHAR(32) NOT NULL password_hash VARHCAR(72) NOT NULL

donations

donation_id INT (PRI) user_id INT (FK) NOT NULL organization_id INT NOT NULL amount DECIMAL(32, 16) NOT NULL dating TIMESTAMP NOT NULL payment_method VARCHAR(32) NOT NULL