Skip to content

completed_shared_tasks

Relationships

erDiagram
    completed_shared_tasks {
        int task_id
    }
    tasks {
        intunsigned id
        tinyint type
        intunsigned dz_template_id
    }
    completed_shared_tasks ||--o{ tasks : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One task_id tasks id

Schema

Column Data Type Description
id bigint Shared Task Identifier
task_id int Shared Task Identifier
accepted_time datetime Accepted Time
expire_time datetime Expire TIme
completion_time datetime Completion TIme
is_locked tinyint Is Locked: 0 = False, 1 = True