Aggregate Activity Fact Table at Day Granularity
| Column Name | Type | Length | Nullable | Unicode | Description |
|---|---|---|---|---|---|
| activity_count | int | N/A | false | Count of the activities for the day | |
| activity_type | int | N/A | false | Activity type | |
| day_id | int | N/A | false | Time the activity occurred - foreign key to time dimension | |
| direct_dw_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 | |
| dw_container_id | bigint | N/A | true | Container of the target at the time of the activity | |
| indirect_dw_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 | |
| user_id | bigint | N/A | false | User that initiated the activity |