status-im/status-go

View on GitHub
protocol/anonmetrics/migrations/postgres/1619446565_postgres_make_anon_metrics_table.up.sql

Summary

Maintainability
Test Coverage
CREATE TABLE app_metrics (
    id SERIAL PRIMARY KEY,

    /* Incoming metric data */
    message_id VARCHAR UNIQUE NOT NULL,
    event VARCHAR NOT NULL,
    value JSON NOT NULL,
    app_version VARCHAR NOT NULL,
    operating_system VARCHAR NOT NULL,
    session_id VARCHAR NOT NULL,
    created_at TIMESTAMP NOT NULL,

    /* Row metadata */
    processed BOOLEAN NOT NULL DEFAULT FALSE,
    received_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP);