shared_task_activity_state

Relationships

erDiagram
    shared_task_activity_state {
        int activity_id
        bigint shared_task_id
    }
    task_activities {
        intunsigned activityid
        varchar goalid
        varchar delivertonpc
        intunsigned taskid
        varchar zones
    }
    shared_tasks {
        bigint id
        int task_id
    }
    shared_task_activity_state ||--o{ task_activities : "One-to-One"
    shared_task_activity_state ||--o{ shared_tasks : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	activity_id	task_activities	activityid
One-to-One	shared_task_id	shared_tasks	id

Schema

Column	Data Type	Description
shared_task_id	bigint	Shared Task Identifier
activity_id	int	Activity Identifier
done_count	int	Done Count
updated_time	datetime	Updated Time
completed_time	datetime	Completed Time