Data Warehouse Table for Tracking User Activity.
| Column Name | Type | Length | Nullable | Unicode | Description |
|---|---|---|---|---|---|
| activity_ts | timestamp | N/A | false | Timestamp of user activity | |
| activity_type | int | N/A | false | What the user did | |
| container_id | bigint | N/A | true | id of container direct object resides in | |
| container_type | int | N/A | true | type of container direct object resides in | |
| direct_object_id | bigint | N/A | false | id of direct object of action | |
| direct_object_type | int | N/A | false | type of direct object of action | |
| indirect_object_id | bigint | N/A | true | id of indirect object of action | |
| indirect_object_type | int | N/A | true | type of indirect object of action | |
| metadata | varchar | 256 | true | arbitrary metadata depending on the event | |
| user_id | bigint | N/A | false | User that performed activity |