pwm

Tables (8)

follow (Untitled4)

  • follow_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • target_user_id (Key3) — Foreign key → user.user_id — NOT NULL

permission (Untitled5)

  • permission_id (Key) — Primary key — NOT NULL
  • name (Field)
  • value (Field2)

scope (Untitled7)

  • scope_id (Key) — Primary key — NOT NULL
  • name (Field)
  • value (Field2)

todo (Untitled6)

  • todo_id (Key) — Primary key — NOT NULL
  • todogroup_id (Key2) — Foreign key → todogroup.todogroup_id — NOT NULL
  • scope_id (Key22) — Foreign key → todogroup.scope_id — NOT NULL
  • title (Field)
  • content (Field2)
  • Field3
  • Field4

todo_user (Untitled8)

  • Key — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • todo_id (Key3) — Foreign key → todo.todo_id — NOT NULL
  • todogroup_id (Key22) — Foreign key → todo.todogroup_id — NOT NULL
  • scope_id (Key222) — Foreign key → todo.scope_id — NOT NULL

todogroup (Untitled2)

  • todogroup_id (Key) — Primary key — NOT NULL
  • scope_id (Key2) — Foreign key → scope.scope_id — NOT NULL
  • name (Field)
  • description (Field3)

todogroup_user (Untitled3)

  • Key — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • todogroup_id (Key3) — Foreign key → todogroup.todogroup_id — NOT NULL
  • permission_id (Key4) — Foreign key → permission.permission_id — NOT NULL
  • scope_id (Key22) — Foreign key → todogroup.scope_id — NOT NULL

user (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • social_type (Field)
  • uid (Field2)
  • name (Field3)
  • introduction (Field4)
  • image (Field5)