Continuous Aggregates Views Structure

ERAS utilizes Continuous aggregates which are materialized views bucketed by time in order to optimize some of it's queries. Continuous aggregates can be queried similarly as a postgres table.

Listed below are our current continuous aggregates and its structures.

daily_classification_count

Column Name	Type	Description
day	date
classification_count	integer

daily_classification_count_per_project

Column Name	Type	Description
day	date
project_id	integer
classification_count	integer

daily_classification_count_per_workflow

Column Name	Type	Description
day	date
workflow_id	integer
classification_count	integer

daily_user_classification_count_and_time

Column Name	Type	Description
day	date
user_id	integer
classification_count	integer
total_session_time	float

daily_user_classification_count_and_time_per_project

Column Name	Type	Description
day	date
user_id	integer
project_id	integer
classification_count	integer
total_session_time	float

daily_user_classification_count_and_time_per_workflow

Column Name	Type	Description
day	date
user_id	integer
workflow_id	integer
classification_count	integer
total_session_time	float

daily_group_classification_count_and_time

Column Name	Type	Description
day	date
user_group_id	integer
classification_count	integer
total_session_time	float

daily_group_classification_count_and_time_per_project

Column Name	Type	Description
day	date
user_group_id	integer
project_id	integer
classification_count	integer
total_session_time	float

daily_group_classification_count_and_time_per_workflow

Column Name	Type	Description
day	date
user_group_id	integer
workflow_id	integer
classification_count	integer
total_session_time	float

daily_group_classification_count_and_time_per_user

Column Name	Type	Description
day	date
user_group_id	integer
user_id	integer
classification_count	integer
total_session_time	float

daily_group_classification_count_and_time_per_user_per_project

Column Name	Type	Description
day	date
user_group_id	integer
user_id	integer
project_id	integer
classification_count	integer
total_session_time	float

daily_group_classification_count_and_time_per_user_per_workflow

Column Name	Type	Description
day	date
user_group_id	integer
user_id	integer
workflow_id	integer
classification_count	integer
total_session_time	float

daily_comment_count

Column Name	Type	Description
day	date
comment_count	integer

daily_comment_count_per_user

Column Name	Type	Description
day	date
user_id	integer
comment_count	integer

daily_comment_count_per_project_and_user

Column Name	Type	Description
day	date
project_id	integer
user_id	integer
comment_count	integer