Data Tables

Data Architecture

ERAS has 3 main tables that it pulls from. ERAS also heavily relies on Timescale's feature of Continuous Aggregates (which are materialized views of our 3 main tables bucketed by time).

ERAS also uses Composite Primary Keys to define our hypertables and in the schema. Composite primary keys are utilized to ensure the chunk table partitions of our hypertables are setup correctly https://docs.timescale.com/timescaledb/latest/quick-start/ruby/#step-3-create-a-table.

---

Main Tables

• comment_events
• classification_events
• classification_user_groups

---

comment_events

Column Name	Type	Description	Nullable?	Composite Primary Key?
comment_id	integer	Id of the Talk comment	No	✔️
event_time	timestamp	created_at of Talk comment	No	✔️
updated_at	timestamp	updated_at of Talk comment	No
project_id	integer	project_id of the Talk comment (sometimes null, because some Talk comments are not about a specific project)	Yes
user_id	integer	user_id of talk comment	Yes