Database Schema - lucascostamonteiro/RememberTheBread Wiki

Database Schema

users

column name data type details
id integer not null, primary key
firstName string not null
lastName string not null
email string not null, unique
password string not null

list

column name data type details
id integer not null, primary key
user_id integer not null, foreign key
name string not null
completed boolean not null

task

column name data type details
id integer not null, primary key
user_id integer not null, foreign key
list_id integer not null, foreign key
task string not null
completed boolean not null
expected_completion timestamp not null
actual_completion timestamp