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)