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.
|
2 years ago | |
---|---|---|
app | 2 years ago | |
LICENSE | 2 years ago | |
README.md | 2 years ago | |
config.py | 2 years ago | |
deploy_todo.bash | 2 years ago | |
todo.example.com.conf | 2 years ago | |
todo.py | 2 years ago | |
todo.service | 2 years ago |
README.md
tables in your postgresql todo database
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
Column | Type | Collation | Nullable | Default |
---|---|---|---|---|
id | integer | not null | nextval('email_white_list_id_seq'::regclass) | |
character varying(120) | not null |
Indexes:
"email_white_list_pkey" PRIMARY KEY, btree (id)
"email_white_list_email_key" UNIQUE CONSTRAINT, btree (email)
contributor
Column | Type | Collation | Nullable | Default |
---|---|---|---|---|
id | integer | not null | nextval('contributor_id_seq'::regclass) | |
name | character varying(64) | not null | ||
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
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
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)