todo_app_flask/README.md

tables in your postgresql todo database

List of relations

Schema	Name	Type	Owner
public	category	table	todo
public	category_id_seq	sequence	todo
public	contributor	table	todo
public	contributor_id_seq	sequence	todo
public	email_white_list	table	todo
public	email_white_list_id_seq	sequence	todo
public	task	table	todo
public	task_id_seq	sequence	todo

(8 rows)

email_white_list

Table "public.email_white_list"

Column	Type	Collation	Nullable	Default
id	integer		not null	nextval('email_white_list_id_seq'::regclass)
email	character varying(120)		not null

Indexes:
    "email_white_list_pkey" PRIMARY KEY, btree (id)
    "email_white_list_email_key" UNIQUE CONSTRAINT, btree (email)

contributor

Table "public.contributor"

Column	Type	Collation	Nullable	Default
id	integer		not null	nextval('contributor_id_seq'::regclass)
name	character varying(64)		not null
email	character varying(120)		not null
password_hash	character varying(128)
totp_key	character(16)
use_totp	boolean			false

Indexes:
    "contributor_pkey" PRIMARY KEY, btree (id)
    "contributor_email_key" UNIQUE CONSTRAINT, btree (email)
    "contributor_name_key" UNIQUE CONSTRAINT, btree (name)

category

Table "public.category"

Column	Type	Collation	Nullable	Default
id	integer		not null	nextval('category_id_seq'::regclass)
name	character varying(128)		not null
contributor_id	integer		not null
hidden	boolean			false

Indexes:
    "category_pkey" PRIMARY KEY, btree (id)
    "category_name_key" UNIQUE CONSTRAINT, btree (name)

task

Table "public.task"

Column	Type	Collation	Nullable	Default
id	integer		not null	nextval('task_id_seq'::regclass)
content	text		not null
contributor_id	integer		not null
catid	integer		not null
done	boolean			false
priority	integer
timestamp	timestamp without time zone

Indexes:
    "task_pkey" PRIMARY KEY, btree (id)