Skip to content

completed_shared_task_members

Relationships

erDiagram
    completed_shared_task_members {
        bigint character_id
        bigint shared_task_id
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    shared_tasks {
        bigint id
        int task_id
    }
    completed_shared_task_members ||--o{ character_data : "One-to-One"
    completed_shared_task_members ||--o{ shared_tasks : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One character_id character_data id
One-to-One shared_task_id shared_tasks id

Schema

Column Data Type Description
shared_task_id bigint Shared Task Identifier
character_id bigint Character Identifier
is_leader tinyint Is Leader: 0 = False, 1 = True