titles¶
Info
This page was last generated 2023.04.23
Relationship Diagram(s)¶
Relationships¶
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 |