scores_crosstab

0 rows


Description

This materialized view does a pivot on the public.fs_retrospective_scores table to yield a row for each GFP and YEAR with the FS scores 1-5 in columns. DD and NS scores (less than zero) are not included.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
gfp_id_year text 2147483647 √ null
gfp_id int4 10 √ null
year int4 10 √ null
fs_score_1 numeric 0 √ null
fs_score_2 numeric 0 √ null
fs_score_3 numeric 0 √ null
fs_score_4 numeric 0 √ null
fs_score_5 numeric 0 √ null