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 |