ToDoDB

Tables (5)

Untitled (settings)

  • Key (user_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (bg) — varchar(255)

Untitled (user)

  • Key (user_id) — bigint(20) — Primary key — NOT NULL
  • Field (name) — varchar(255)
  • Field (password) — varchar(255)

item_list_tags (item_list_map)

  • itemID (item_id) — bigint(20) — Foreign key → items.itemID — NOT NULL
  • Key (list_id) — bigint(20) — Foreign key → lists.Key — NOT NULL
  • Key (user_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (order) — bigint(20)

items

  • itemID (item_id) — bigint(20) — Primary key — NOT NULL
  • Field (title) — varchar(255)
  • Field2 (completed) — tinyint(1)

lists

  • Key (list_id) — bigint(20) — Primary key — NOT NULL
  • Field (title) — varchar(255)
  • Field (order) — bigint(20)