You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Tasks belong to a single assignee but store due_date and trial_count.
Proposed:
Create AssignedTasks table. Each AssignedTask stores an assignee and a task and seen boolean. This allows a single task to be assigned to multiple assignees. All assignees can contribute toward the same trial_count.
Index on task_id
Uniqueness constraint on (task_id, assignee_id)
The text was updated successfully, but these errors were encountered:
Currently:
Tasks belong to a single assignee but store due_date and trial_count.
Proposed:
Create AssignedTasks table. Each AssignedTask stores an assignee and a task and
seen
boolean. This allows a single task to be assigned to multiple assignees. All assignees can contribute toward the same trial_count.Index on task_id
Uniqueness constraint on (task_id, assignee_id)
The text was updated successfully, but these errors were encountered: