character_alt_currency¶
Relationships¶
erDiagram
character_alt_currency {
intunsigned currency_id
intunsigned char_id
}
character_data {
intunsigned id
varchar name
varchar nane
intunsigned zone_instance
intunsigned zone_id
}
alternate_currency {
int id
int item_id
}
character_alt_currency ||--o{ character_data : "One-to-One"
character_alt_currency ||--o{ alternate_currency : "One-to-One"
| Relationship Type | Local Key | Relates to Table | Foreign Key |
|---|---|---|---|
| One-to-One | char_id | character_data | id |
| One-to-One | currency_id | alternate_currency | id |
Schema¶
| Column | Data Type | Description |
|---|---|---|
| char_id | int | Character Identifier |
| currency_id | int | Currency Identifier |
| amount | int | Amount |