raid_members

Relationships

erDiagram
    raid_members {
        int charid
        varchar name
        int raidid
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    raid_details {
        int raidid
    }
    raid_members ||--o{ character_data : "One-to-One"
    raid_members ||--o{ character_data : "One-to-One"
    raid_members ||--o{ raid_details : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	charid	character_data	id
One-to-One	name	character_data	name
One-to-One	raidid	raid_details	raidid

Schema

Column	Data Type	Description
id	bigint	Unique Raid Member Identifier
raidid	int	Raid Identifier
charid	int	Character Identifier
bot_id	int	Bot Identifier
groupid	int	Group Identifier
_class	tinyint	Class
level	tinyint	Level
name	varchar	Name
isgroupleader	tinyint	Is Group Leader: 0 = False, 1 = True
israidleader	tinyint	Is Raid Leader: 0 = False, 1 = True
islooter	tinyint	Is Looter: 0 = False, 1 = True
is_marker	tinyint	Is Marker: 0 = False, 1 = True
is_assister	tinyint	Is Assister: 0 = False, 1 = True
note	varchar	Note