Skip to content



    titles {
        int char_id
        int title_set
        int item_id
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    player_titlesets {
        intunsigned char_id
        intunsigned title_set
    titles ||--o{ character_data : "One-to-One"
    titles ||--o{ items : "One-to-One"
    titles ||--o{ player_titlesets : "Has-Many"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One char_id character_data id
One-to-One item_id items id
Has-Many title_set player_titlesets title_set


Column Data Type Description
id int Unique Title Identifier
skill_id tinyint Skill Identifier
min_skill_value mediumint Minimum Skill Value
max_skill_value mediumint Maximum Skill Value
min_aa_points mediumint Minimum AA Points
max_aa_points mediumint Maximum AA Points
class tinyint Class
gender tinyint Gender
char_id int Unique Character Identifier
status int Required Status
item_id int Item Identifier
prefix varchar Prefix
suffix varchar Suffix
title_set int Title Set Identifier