object_contents¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
Relationships¶
| Relationship Type | Local Key | Relates to Table | Foreign Key |
|---|---|---|---|
| One-to-One | augslot1 | items | id |
| One-to-One | augslot2 | items | id |
| One-to-One | augslot3 | items | id |
| One-to-One | augslot4 | items | id |
| One-to-One | augslot5 | items | id |
| One-to-One | augslot6 | items | id |
| One-to-One | itemid | items | id |
| One-to-One | parentid | object | id |
| One-to-One | zoneid | zone | zoneidnumber |
Schema¶
| Column | Data Type | Description |
|---|---|---|
| zoneid | int | Zone Identifier |
| parentid | int | Object Identifier |
| bagidx | int | Bag Index |
| itemid | int | Item Identifier |
| charges | smallint | Charges |
| droptime | datetime | Drop Time |
| augslot1 | mediumint | Augment Slot 1 |
| augslot2 | mediumint | Augment Slot 2 |
| augslot3 | mediumint | Augment Slot 3 |
| augslot4 | mediumint | Augment Slot 4 |
| augslot5 | mediumint | Augment Slot 5 |
| augslot6 | mediumint | Augment Slot 6 |