emergency_closing_status

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

int4

√

null

creator

int4

√

null

create_time

timestamptz

35,6

√

null

process_start_time

timestamptz

35,6

√

null

process_end_time

timestamptz

35,6

√

null

last_update_time

timestamptz

35,6

√

null

circulations

int8

√

null

circulations_complete

int8

√

null

reservations

int8

√

null

reservations_complete

int8

√

null

holds

int8

√

null

holds_complete

int8

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT e.id,
    e.creator,
    e.create_time,
    e.process_start_time,
    e.process_end_time,
    e.last_update_time,
    COALESCE(c.count, (0)::bigint) AS circulations,
    COALESCE(c.completed, (0)::bigint) AS circulations_complete,
    COALESCE(b.count, (0)::bigint) AS reservations,
    COALESCE(b.completed, (0)::bigint) AS reservations_complete,
    COALESCE(h.count, (0)::bigint) AS holds,
    COALESCE(h.completed, (0)::bigint) AS holds_complete
   FROM (((action.emergency_closing e
     LEFT JOIN ( SELECT emergency_closing_circulation.emergency_closing,
            count(*) AS count,
            sum(((emergency_closing_circulation.process_time IS NOT NULL))::integer) AS completed
           FROM action.emergency_closing_circulation
          GROUP BY emergency_closing_circulation.emergency_closing) c ON ((c.emergency_closing = e.id)))
     LEFT JOIN ( SELECT emergency_closing_reservation.emergency_closing,
            count(*) AS count,
            sum(((emergency_closing_reservation.process_time IS NOT NULL))::integer) AS completed
           FROM action.emergency_closing_reservation
          GROUP BY emergency_closing_reservation.emergency_closing) b ON ((b.emergency_closing = e.id)))
     LEFT JOIN ( SELECT emergency_closing_hold.emergency_closing,
            count(*) AS count,
            sum(((emergency_closing_hold.process_time IS NOT NULL))::integer) AS completed
           FROM action.emergency_closing_hold
          GROUP BY emergency_closing_hold.emergency_closing) h ON ((h.emergency_closing = e.id)));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views