shared_task_members

Relationships

erDiagram
    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
    }
    shared_task_members ||--o{ character_data : "One-to-One"
    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