character_exp_modifiers

Relationships

erDiagram
    character_exp_modifiers {
        int character_id
        int zone_id
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    character_exp_modifiers ||--o{ character_data : "One-to-One"
    character_exp_modifiers ||--o{ zone : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	character_id	character_data	id
One-to-One	zone_id	zone	zoneidnumber

Schema

Column	Data Type	Description
character_id	int	Character Identifier
zone_id	int	Zone Identifier (0 for Global)
instance_version	int	Instance Version
aa_modifier	float	AA Experience Modifier (.5 = 50%, 1 = 100%, 1.5 = 150%)
exp_modifier	float	Experience Modifier (.5 = 50%, 1 = 100%, 1.5 = 150%)