GR5_UserItem

Database associations

User items must have coresponding template item, keys are userItem.ItemID and tempItem.id, as well as an inventory slot, joined on inventoryid for both.

Fields

• 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
2 weapon
3 armor insert
4 component
5 avatar
6 boost
7
8 armor item
9 apply item
10 armor tier
11 ability
12 ability upgrade
13 passive ability