Database associations

User items must have coresponding template item, associations are:

• userItem.itemid and tempItem.id
• userItem.inventoryid and bagSlot.inventoryid

Database columns

• id (PK)
• inventoryid
• pid (player/principal id)
• itemtype (see list below)
• itemid (FK, see Database associations)
• oasisname (oasis id of the name)
• igcprice
• cashprice

Item types

Item type is the foreign key for SKU and template items:

1 bundle
2 weapon
3 armor insert
4 component
5 avatar
6 boost
7 consumable
8 armor item
9 apply item
10 armor tier
11 ability
12 ability upgrade
13 passive ability