todolist

Tables (4)

Untitled (TodoItems)

  • Key (itemsId) — Primary key — NOT NULL
  • Key (user_id) — Foreign key → Users.Key — NOT NULL
  • Field (title)
  • Field2 (content)
  • Field3 (created_at)
  • Field4 (modified_at)
  • Field (du_date)
  • Field5 (completed)
  • Field2
  • Field3

Untitled (Todo-share)

  • Key (shareId) — Primary key — NOT NULL
  • Key (itemsId) — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at)

Untitled (Todo-share-users)

  • Key (id) — Primary key — NOT NULL
  • Key (shareId) — Foreign key → Untitled.Key — NOT NULL
  • Key (itemsId) — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — Foreign key → Users.Key — NOT NULL
  • Field

Users (User)

  • Key (user_id) — Primary key — NOT NULL
  • Field (User_name)
  • Field2 (email)
  • Field3 (phone)
  • Field (created_at)
  • Field (modified_at)