adventure_members¶
Relationships¶
erDiagram
adventure_members {
intunsigned id
intunsigned charid
}
adventure_details {
intunsigned id
smallintunsigned adventure_id
int instance_id
}
character_data {
intunsigned id
varchar name
varchar nane
intunsigned zone_instance
intunsigned zone_id
}
adventure_members ||--o{ adventure_details : "One-to-One"
adventure_members ||--o{ character_data : "One-to-One"
| Relationship Type | Local Key | Relates to Table | Foreign Key |
|---|---|---|---|
| One-to-One | id | adventure_details | id |
| One-to-One | charid | character_data | id |
Schema¶
| Column | Data Type | Description |
|---|---|---|
| id | int | Adventure Identifier |
| charid | int | Character Identifier |