Skip to content

completed_shared_task_activity_state

Relationships

erDiagram
    completed_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
    }
    completed_shared_task_activity_state ||--o{ task_activities : "One-to-One"
    completed_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