activity_key_result_events

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

int8

√

null

before_progress_rate

int4

√

null

after_progress_rate

int4

√

null

before_initial_value

float8

17,17

√

null

after_initial_value

float8

17,17

√

null

before_target_value

float8

17,17

√

null

after_target_value

float8

17,17

√

null

before_target_value_unit

text

2147483647

√

null

after_target_value_unit

text

2147483647

√

null

before_actual_value

float8

17,17

√

null

after_actual_value

float8

17,17

√

null

before_confidence

int2

√

null

after_confidence

int2

√

null

message

text

2147483647

√

null

unit

text

2147483647

√

null

View Definition

SELECT DISTINCT checkin_key_results.id,
    (kre_progress_rate.before)::integer AS before_progress_rate,
    (kre_progress_rate.after)::integer AS after_progress_rate,
    (kre_initial_value.before)::double precision AS before_initial_value,
    (kre_initial_value.after)::double precision AS after_initial_value,
    (kre_target_value.before)::double precision AS before_target_value,
    (kre_target_value.after)::double precision AS after_target_value,
    kre_target_value_unit.before AS before_target_value_unit,
    kre_target_value_unit.after AS after_target_value_unit,
    (kre_actual_value.before)::double precision AS before_actual_value,
    (kre_actual_value.after)::double precision AS after_actual_value,
    krc.before_confidence,
    krc.after_confidence,
    checkin_key_results.message,
    kre_unit.unit
   FROM (((((((okr.checkin_key_results
     LEFT JOIN ( SELECT key_result_events.item,
            key_result_events.before,
            key_result_events.after,
            key_result_events.checkin_key_result_id
           FROM okr.key_result_events
          WHERE (key_result_events.item = ANY (ARRAY['PROGRESS_RATE'::text, 'PROGRESS_RATE_AGGREGATION'::text]))) kre_progress_rate ON ((kre_progress_rate.checkin_key_result_id = checkin_key_results.id)))
     LEFT JOIN ( SELECT key_result_events.item,
            key_result_events.before,
            key_result_events.after,
            key_result_events.checkin_key_result_id
           FROM okr.key_result_events
          WHERE (key_result_events.item = 'INITIAL_VALUE'::text)) kre_initial_value ON ((kre_initial_value.checkin_key_result_id = checkin_key_results.id)))
     LEFT JOIN ( SELECT key_result_events.item,
            key_result_events.before,
            key_result_events.after,
            key_result_events.checkin_key_result_id
           FROM okr.key_result_events
          WHERE (key_result_events.item = 'TARGET_VALUE'::text)) kre_target_value ON ((kre_target_value.checkin_key_result_id = checkin_key_results.id)))
     LEFT JOIN ( SELECT key_result_events.item,
            key_result_events.before,
            key_result_events.after,
            key_result_events.checkin_key_result_id
           FROM okr.key_result_events
          WHERE (key_result_events.item = 'TARGET_VALUE_UNIT'::text)) kre_target_value_unit ON ((kre_target_value_unit.checkin_key_result_id = checkin_key_results.id)))
     LEFT JOIN ( SELECT key_result_events.item,
            key_result_events.before,
            key_result_events.after,
            key_result_events.checkin_key_result_id
           FROM okr.key_result_events
          WHERE (key_result_events.item = 'ACTUAL_VALUE'::text)) kre_actual_value ON ((kre_actual_value.checkin_key_result_id = checkin_key_results.id)))
     LEFT JOIN ( SELECT key_result_events.unit,
            key_result_events.checkin_key_result_id
           FROM okr.key_result_events
          WHERE (key_result_events.unit IS NOT NULL)) kre_unit ON ((kre_unit.checkin_key_result_id = checkin_key_results.id)))
     LEFT JOIN ( SELECT lag(krc_1.confidence) OVER (PARTITION BY krc_1.key_result_id, krc_1.user_id ORDER BY krc_1.created_at) AS before_confidence,
            krc_1.confidence AS after_confidence,
            krc_1.checkin_key_result_id
           FROM okr.key_result_confidences krc_1) krc ON ((krc.checkin_key_result_id = checkin_key_results.id)))
  WHERE ((kre_progress_rate.before IS NOT NULL) OR (kre_progress_rate.after IS NOT NULL) OR ((kre_initial_value.before IS NOT NULL) OR (kre_initial_value.after IS NOT NULL)) OR ((kre_target_value.before IS NOT NULL) OR (kre_target_value.after IS NOT NULL)) OR ((kre_target_value_unit.before IS NOT NULL) OR (kre_target_value_unit.after IS NOT NULL)) OR ((kre_actual_value.before IS NOT NULL) OR (kre_actual_value.after IS NOT NULL)) OR ((krc.before_confidence IS NOT NULL) OR (krc.after_confidence IS NOT NULL)));

Columns

View Definition

Possibly Referenced Tables/Views