pets_equipmentset¶
Relationships¶
erDiagram
pets_equipmentset {
int set_id
}
pets {
int npcID
varchar type
int equipmentset
}
pets_equipmentset_entries {
int item_id
int set_id
}
pets_equipmentset ||--o{ pets : "Has-Many"
pets_equipmentset ||--o{ pets_equipmentset_entries : "Has-Many"
Relationship Type | Local Key | Relates to Table | Foreign Key |
---|---|---|---|
Has-Many | set_id | pets | equipmentset |
Has-Many | set_id | pets_equipmentset_entries | set_id |
Schema¶
Column | Data Type | Description |
---|---|---|
set_id | int | Unique Pet Equipment Set Identifier |
setname | varchar | Pet Equipment Set Name |
nested_set | int | Nested Set Identifier |