Time-series metrics table schema

[ryscheng]

What is it?

We probably should brainstorm a good name for this. Some candidates:

• metrics_table
• metrics_over_time
• metrics_time_series
• metrics_results
• metrics_values

This could be as simple as these columns for metrics_by_artifact

• metric_id
• artifact_id
• sample_date
• amount
• unit (e.g. ETH, USD) - optional

Where you'd join against the metrics_v1 table to get more details about the metric itself https://github.com/opensource-observer/oso/issues/1772

This implies that all metrics are calculated first at the artifact level, but can be aggregated in later stages.

A metrics_by_project could similarly look like

• metric_id
• project_id
• sample_date
• amount
• unit

[ryscheng]

CC @ccerv1 thoughts?

[ryscheng]

Implemented the scaffolding here, there's lots more to flesh out tho https://github.com/opensource-observer/oso/pull/1899