answers_as_content

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

application_id

int8

19

√

null

content

jsonb

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT t.application_id,
    jsonb_build_object('answers', jsonb_agg(jsonb_build_object('key', t.key, 'fieldType', t.field_type, 'value', t.value, 'duplikoitu-kysymys-hakukohde-oid', t.duplikoitu_kysymys_hakukohde_oid, 'original-question', t.original_question, 'duplikoitu-followup-hakukohde-oid', t.duplikoitu_followup_hakukohde_oid, 'original-followup', t.original_followup))) AS content
   FROM ( SELECT answers.application_id,
            answers.key,
            answers.field_type,
            to_jsonb(answers.value) AS value,
            answers.original_question,
            answers.duplikoitu_kysymys_hakukohde_oid,
            answers.original_followup,
            answers.duplikoitu_followup_hakukohde_oid
           FROM answers
        UNION ALL
         SELECT ma.application_id,
            ma.key,
            ma.field_type,
            ( SELECT COALESCE(jsonb_agg(multi_answer_values.value ORDER BY multi_answer_values.data_idx), '[]'::jsonb) AS "coalesce"
                   FROM multi_answer_values
                  WHERE ((multi_answer_values.application_id = ma.application_id) AND (multi_answer_values.key = ma.key))) AS value,
            ma.original_question,
            ma.duplikoitu_kysymys_hakukohde_oid,
            ma.original_followup,
            ma.duplikoitu_followup_hakukohde_oid
           FROM multi_answers ma
        UNION ALL
         SELECT ga.application_id,
            ga.key,
            ga.field_type,
            ( SELECT jsonb_agg(
                        CASE
                            WHEN gag.is_null THEN 'null'::jsonb
                            ELSE ( SELECT COALESCE(jsonb_agg(group_answer_values.value ORDER BY group_answer_values.data_idx), '[]'::jsonb) AS "coalesce"
                               FROM group_answer_values
                              WHERE ((group_answer_values.application_id = gag.application_id) AND (group_answer_values.key = gag.key) AND (group_answer_values.group_idx = gag.group_idx)))
                        END ORDER BY gag.group_idx) AS jsonb_agg
                   FROM group_answer_groups gag
                  WHERE ((gag.application_id = ga.application_id) AND (gag.key = ga.key))) AS value,
            NULL::text AS original_question,
            NULL::text AS duplikoitu_kysymys_hakukohde_oid,
            NULL::text AS original_followup,
            NULL::text AS duplikoitu_followup_hakukohde_oid
           FROM group_answers ga) t
  GROUP BY t.application_id;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views