titles

Relationships

erDiagram
    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

Schema

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