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)