You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
Trent Palmer d406ff6508 update deploy script 6 months ago
app initial commit 6 months ago
LICENSE initial commit 6 months ago
README.md add README 6 months ago
config.py initial commit 6 months ago
deploy_todo.bash update deploy script 6 months ago
todo.example.com.conf initial commit 6 months ago
todo.py initial commit 6 months ago
todo.service initial commit 6 months ago

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)