Activity Fact Table
| Column Name | Type | Length | Nullable | Unicode | Description |
|---|---|---|---|---|---|
| activity_ts | timestamp | N/A | false | Original timestamp of the activity | |
| 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 | |
| metadata | varchar | 256 | true | arbitrary metadata depending on the event | |
| user_id | bigint | N/A | false | User that initiated the activity |