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 |