character_material

Relationships

erDiagram
    character_material {
        intunsigned id
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    character_material ||--o{ character_data : "One-to-One"

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

Schema

Column	Data Type	Description
id	int	Character Identifier
slot	tinyint	Slot
blue	tinyint	Blue: 0 = None, 255 = Max
green	tinyint	Green: 0 = None, 255 = Max
red	tinyint	Red: 0 = None, 255 = Max
use_tint	tinyint	Tint: 0 = None, 255 = MAx
color	int	Color