group_leaders

Relationships

erDiagram
    group_leaders {
        varchar assist
        varchar leadername
        varchar maintank
        varchar mentoree
        varchar puller
        int gid
    }
    group_id {
        int charid
        int groupid
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    group_leaders ||--o{ group_id : "Has-Many"
    group_leaders ||--o{ character_data : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
Has-Many	gid	group_id	groupid
One-to-One	leadername	character_data	name

Schema

Column	Data Type	Description
gid	int	Group Identifier
leadername	varchar	Leader Name
marknpc	varchar	Mark NPC: 0 = False, 1 = True
leadershipaa	tinyblob	Leadership AA
maintank	varchar	Main Tank: 0 = False, 1 = True
assist	varchar	Assist: 0 = False, 1 = True
puller	varchar	Puller: 0 = False, 1 = True
mentoree	varchar	Mentoree: 0 = False, 1 = True
mentor_percent	int	Main Tank: 0 = None, 100 = Max