character_buffs

Relationships

erDiagram
    character_buffs {
        intunsigned character_id
        smallintunsigned spell_id
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    spells_new {
        int id
        int descnum
        int effectdescnum
        int effectdescnum2
        int typedescnum
        varchar teleport_zone
    }
    character_buffs ||--o{ character_data : "One-to-One"
    character_buffs ||--o{ spells_new : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	character_id	character_data	id
One-to-One	spell_id	spells_new	id

Schema

Column	Data Type	Description
character_id	int	Character Identifier
slot_id	tinyint	Buff Slot
spell_id	smallint	Buff Spell Identifier
caster_level	tinyint	Caster Level
caster_name	varchar	Caster Name
ticsremaining	int	Tics Remaining
counters	int	Counters
numhits	int	Number of Hits
melee_rune	int	Melee Rune
magic_rune	int	Magic Rune
persistent	tinyint	Persistent: 0 = False, 1 = True
dot_rune	int	Damage Over Time Rune
caston_x	int	X Coordinate
caston_y	int	Y Coordinate
caston_z	int	Z Coordinate
ExtraDIChance	int	Extra DI Chance
instrument_mod	int	Instrument Modifier