TODO
Tables (6)
categories
- id — bigint
- name — varchar(100)
routine_items
- id — bigint
- list_id — bigint — Foreign key → routine_lists.id — NOT NULL
- content — Text
- done — bool
- category_id — bigint — Foreign key → categories.id
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- renewal_cycle — time
routine_lists
- id — bigint
- user_id — bigint — Foreign key → users.id
- name — varchar(100)
- show — bool
todo_items
- id — bigint
- list_id — bigint — Foreign key → todo_lists.id — NOT NULL
- content — Text
- done — bool
- category_id — bigint — Foreign key → categories.id
todo_lists
- id — bigint
- user_id — bigint — Foreign key → users.id
- name — varchar(100)
- show — bool
users
- id — bigint
- email — varchar(100)
- password_hashed — varchar(100)
- salt — varchar(100)
- guest — bool
- oauth_id — varchar(45)
- oauth_provider — varchar(45)