todo

Tables (3)

activity (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • actor_id (Key2) — int — Foreign key → user.id — NOT NULL
  • todo_id (Key22) — int — Foreign key → todo.user_id — NOT NULL
  • act (Field) — varchar
  • time (Field3) — date
  • from (Field2) — varchar
  • to (Field4) — varchar

todo (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → user.id — NOT NULL
  • content (Field) — varchar
  • state (Field2) — varchar

user

  • id (Key) — int — Primary key — NOT NULL
  • user_name (Field) — varchar
  • password (Field2) — varchar