crashes_change_log_view

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

text

2147483647

√

null

record_type

text

2147483647

√

null

crash_pk

int4

10

√

null

record_id

int4

10

√

null

operation_type

text

2147483647

√

null

record_json

jsonb

2147483647

√

null

created_at

timestamptz

35,6

√

null

created_by

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT concat('crash_', change_log_crashes.id) AS id,
    'crash'::text AS record_type,
    change_log_crashes.record_id AS crash_pk,
    change_log_crashes.record_id,
        CASE
            WHEN (change_log_crashes.operation_type = 'INSERT'::text) THEN 'create'::text
            ELSE lower(change_log_crashes.operation_type)
        END AS operation_type,
    change_log_crashes.record_json,
    change_log_crashes.created_at,
    change_log_crashes.created_by
   FROM change_log_crashes
UNION ALL
 SELECT concat('unit_', change_log_units.id) AS id,
    'unit'::text AS record_type,
    units.crash_pk,
    change_log_units.record_id,
        CASE
            WHEN (change_log_units.operation_type = 'INSERT'::text) THEN 'create'::text
            ELSE lower(change_log_units.operation_type)
        END AS operation_type,
    change_log_units.record_json,
    change_log_units.created_at,
    change_log_units.created_by
   FROM (change_log_units
     LEFT JOIN units ON ((change_log_units.record_id = units.id)))
UNION ALL
 SELECT concat('people_', change_log_people.id) AS id,
    'person'::text AS record_type,
    crashes.id AS crash_pk,
    change_log_people.record_id,
        CASE
            WHEN (change_log_people.operation_type = 'INSERT'::text) THEN 'create'::text
            ELSE lower(change_log_people.operation_type)
        END AS operation_type,
    change_log_people.record_json,
    change_log_people.created_at,
    change_log_people.created_by
   FROM (((change_log_people
     LEFT JOIN people ON ((change_log_people.record_id = people.id)))
     LEFT JOIN units ON ((people.unit_id = units.id)))
     LEFT JOIN crashes ON ((units.crash_pk = crashes.id)));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views