Skip to content



This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit


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


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