vw_foreign_units

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

idunit

int4

10

√

null

c_shipper

int4

10

√

null

c_owner

int4

10

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

WITH q AS (
         SELECT DISTINCT u.idunit,
            ug.idclient AS c_shipper,
            u.idclient AS c_owner
           FROM ((((unitgroup ug
             JOIN unit_unitgroup uu ON ((ug.idunitgroup = uu.idunitgroup)))
             JOIN unit u ON ((u.idunit = uu.idunit)))
             JOIN client c ON ((c.idclient = ug.idclient)))
             JOIN client c1 ON ((c1.idclient = u.idclient)))
          WHERE ((ug.idclient <> u.idclient) AND (u.enabled = true) AND (ug.enabled = true) AND (uu.enabled = true))
        ), q2 AS (
         SELECT DISTINCT u.idunit,
            ug1.idclient AS c_shipper,
            u.idclient AS c_owner
           FROM ((((((unitgroup ug
             JOIN unit_unitgroup uu ON ((uu.idunitgroup = ug.idunitgroup)))
             JOIN unit u ON ((u.idunit = uu.idunit)))
             JOIN shipperconf sp ON ((u.idclient = sp.idclientowner)))
             JOIN shipperconf_unitgroup spug ON ((spug.idunitgoup = ug.idunitgroup)))
             JOIN unitgroup ug1 ON ((ug1.idclient = sp.idclientshipper)))
             JOIN unit_unitgroup uu1 ON (((uu1.idunitgroup = ug1.idunitgroup) AND (uu.idunit = uu1.idunit))))
          WHERE ((sp.enabled = true) AND (u.enabled = true) AND (ug.enabled = true) AND (uu1.enabled = true))
        )
 SELECT q.idunit,
    q.c_shipper,
    q.c_owner
   FROM q
EXCEPT
 SELECT q2.idunit,
    q2.c_shipper,
    q2.c_owner
   FROM q2
  ORDER BY 1, 2;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views