resource_checkpoint
This table is aggregated at the event ID level and contains all Resource Events (such as in game currency spent and gained).
| Field Name | Type | Description | Example |
|---|---|---|---|
| checkpoint | date | ||
| game_id | int | ||
| user_id | string | ||
| player_id | string | ||
| flow_type | string | either Sink (virtual currency lost) or Source (virtual currency gained) | Sink |
| resource_currency | string | name of the virtual currency used, e.g. Gems | Gems |
| item_type | string | item type, depending on the game, e.g. "Armour" | Armour |
| item_id | string | item id, depending on the game, e.g. "IronArmour" | IronArmour |
| resource_amount_sum | float | sum of virtual currency for that particular event id (event_id e.g. "Sink:Gems:Armour:IronArmour") | -60 |
| resource_amount_avg | float | average virtual currency for that particular event id (event_id e.g. "Sink:Gems:Armour:IronArmour") | -20 |
| resource_amount_min | float | min virtual currency for that particular event id (event_id e.g. "Sink:Gems:Armour:IronArmour") | -30 |
| resource_amount_max | float | max virtual currency for that particular event id (event_id e.g. "Sink:Gems:Armour:IronArmour") | -10 |
| resource_transaction_count | int | number of events with that particular event id (event_id e.g. "Sink:Gems:Armour:IronArmour") | 3 |