tier_prediction_grades - certrhythm.public

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

domain

text

2147483647

√

null

psource

text

2147483647

√

null

predicted_tier

int2

5

√

null

asource

text

2147483647

√

null

measured_tier

int2

5

√

null

delta

int2

5

√

null

measured_at

timestamptz

35,6

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

WITH pred AS (
         SELECT DISTINCT ON (tier_predictions.domain) tier_predictions.domain,
            tier_predictions.tier AS ptier,
            tier_predictions.source AS psource,
            tier_predictions.created_at AS pat
           FROM tier_predictions
          WHERE tier_predictions.is_prediction
          ORDER BY tier_predictions.domain, tier_predictions.created_at DESC
        ), act AS (
         SELECT DISTINCT ON (tier_predictions.domain) tier_predictions.domain,
            tier_predictions.tier AS atier,
            tier_predictions.source AS asource,
            tier_predictions.created_at AS aat
           FROM tier_predictions
          WHERE (NOT tier_predictions.is_prediction)
          ORDER BY tier_predictions.domain, tier_predictions.created_at DESC
        )
 SELECT p.domain,
    p.psource,
    p.ptier AS predicted_tier,
    a.asource,
    a.atier AS measured_tier,
    (a.atier - p.ptier) AS delta,
    a.aat AS measured_at
   FROM (pred p
     JOIN act a USING (domain));

Possibly Referenced Tables/Views

tier_predictions