vw_validation

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

uuid

2147483647

√

null

geometry

2147483647

√

null

last_modification_date

timestamp

29,6

√

null

needs_validation

bool

1

√

null

support_needs_validation

bool

1

√

null

azimuts_need_validation

_uuid

2147483647

√

null

frames_need_validation

_uuid

2147483647

√

null

signs_need_validation

_uuid

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT DISTINCT ON (su.id) su.id,
    su.geometry,
    GREATEST(su._last_modification_date, a._last_modification_date, f._last_modification_date, si._last_modification_date) AS last_modification_date,
    (su.needs_validation OR a.needs_validation OR f.needs_validation OR si.needs_validation) AS needs_validation,
    su.needs_validation AS support_needs_validation,
    ( SELECT array_agg(a_1.id) AS array_agg
           FROM signalo_db.azimut a_1
          WHERE ((a_1.fk_support = su.id) AND (a_1.needs_validation = true))) AS azimuts_need_validation,
    ( SELECT array_agg(f_1.id) AS array_agg
           FROM (signalo_db.frame f_1
             JOIN signalo_db.azimut a_1 ON ((f_1.fk_azimut = a_1.id)))
          WHERE ((a_1.fk_support = su.id) AND (f_1.needs_validation = true))) AS frames_need_validation,
    ( SELECT array_agg(sgn.id) AS array_agg
           FROM ((signalo_db.sign sgn
             JOIN signalo_db.frame f_1 ON ((sgn.fk_frame = f_1.id)))
             JOIN signalo_db.azimut a_1 ON ((f_1.fk_azimut = a_1.id)))
          WHERE ((a_1.fk_support = su.id) AND (sgn.needs_validation = true))) AS signs_need_validation
   FROM (((signalo_db.support su
     LEFT JOIN ( SELECT azimut.id,
            azimut.fk_support,
            azimut.needs_validation,
            max(azimut._last_modification_date) OVER (PARTITION BY azimut.fk_support ORDER BY azimut.needs_validation DESC NULLS LAST) AS _last_modification_date
           FROM signalo_db.azimut) a ON ((a.fk_support = su.id)))
     LEFT JOIN ( SELECT frame.id,
            frame.fk_azimut,
            frame.needs_validation,
            max(frame._last_modification_date) OVER (PARTITION BY frame.fk_azimut ORDER BY frame.needs_validation DESC NULLS LAST) AS _last_modification_date
           FROM signalo_db.frame) f ON ((f.fk_azimut = a.id)))
     LEFT JOIN ( SELECT sign.id,
            sign.fk_frame,
            sign.needs_validation,
            max(sign._last_modification_date) OVER (PARTITION BY sign.fk_frame ORDER BY sign.needs_validation DESC NULLS LAST) AS _last_modification_date
           FROM signalo_db.sign) si ON ((si.fk_frame = f.id)));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views