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)