character_currency
Relationships
erDiagram
character_currency {
intunsigned id
}
character_data {
intunsigned id
varchar name
varchar nane
intunsigned zone_instance
intunsigned zone_id
}
character_currency ||--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 |
| platinum |
int |
Platinum |
| gold |
int |
Gold |
| silver |
int |
Silver |
| copper |
int |
Copper |
| platinum_bank |
int |
Banked Platinum |
| gold_bank |
int |
Banked Gold |
| silver_bank |
int |
Banked Silver |
| copper_bank |
int |
Banked Copper |
| platinum_cursor |
int |
Cursor Platinum |
| gold_cursor |
int |
Cursor Gold |
| silver_cursor |
int |
Cursor Silver |
| copper_cursor |
int |
Cursor Copper |
| radiant_crystals |
int |
Radiant Crystals |
| career_radiant_crystals |
int |
Career Radiant Crystals |
| ebon_crystals |
int |
Ebon Crystals |
| career_ebon_crystals |
int |
Career Ebon Crystals |