Database Schema

Database schema here

Users

column name	data type	details
id	integer	not null, primary key
name	string	not null
email	string	not null, unique
password	string	not null
created-at	datetime	not null
updated-at	datetime	not null

Friends Expenses

column name	data type	details
id	integer	not null, primary key
payer_id	integer	not null, foreign key
receiver_id	integer	not null, foreign key
description	string	not null
amount	integer	not null
expense_date	datetime	not null
settled	boolean	default value = False
notes	string
created-at	datetime	not null
updated-at	datetime	not null

• payer_id owes the money

Payments

column name	data type	details
id	integer	not null, primary key
expense_id	integer	not null, foreign key
user_id	integer	not null, foreign key
amount	integer	not null
payment_date	datetime	not null
created-at	datetime	not null
updated-at	datetime	not null

• user_id always sends money to the receiver_id