marc_field_for_ou

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

int4

√

null

marc_format

int4

√

null

marc_record_type

"config"."marc_record_type"

2147483647

√

null

tag

bpchar

√

null

name

text

2147483647

√

null

description

text

2147483647

√

null

fixed_field

bool

√

null

repeatable

bool

√

null

mandatory

bool

√

null

hidden

bool

√

null

owner

int4

√

null

depth

int4

√

null

Relationships

Close relationships within degrees of separation

View Definition

WITH RECURSIVE ou_marc_fields(id, marc_format, marc_record_type, tag, name, description, fixed_field, repeatable, mandatory, hidden, owner, depth) AS (
         SELECT marc_field.id,
            marc_field.marc_format,
            marc_field.marc_record_type,
            marc_field.tag,
            marc_field.name,
            marc_field.description,
            marc_field.fixed_field,
            marc_field.repeatable,
            marc_field.mandatory,
            marc_field.hidden,
            marc_field.owner,
            0 AS "?column?"
           FROM config.marc_field
          WHERE (marc_field.owner IS NULL)
        UNION
         SELECT marc_field.id,
            marc_field.marc_format,
            marc_field.marc_record_type,
            marc_field.tag,
            marc_field.name,
            marc_field.description,
            marc_field.fixed_field,
            marc_field.repeatable,
            marc_field.mandatory,
            marc_field.hidden,
            marc_field.owner,
            0
           FROM config.marc_field
          WHERE (NOT (ARRAY[(marc_field.marc_format)::text, (marc_field.marc_record_type)::text, (marc_field.tag)::text] IN ( SELECT ARRAY[(marc_field_1.marc_format)::text, (marc_field_1.marc_record_type)::text, (marc_field_1.tag)::text] AS "array"
                   FROM config.marc_field marc_field_1
                  WHERE (marc_field_1.owner IS NULL))))
        UNION
         SELECT c.id,
            c.marc_format,
            c.marc_record_type,
            c.tag,
            COALESCE(c.name, p.name) AS "coalesce",
            COALESCE(c.description, p.description) AS "coalesce",
            COALESCE(c.fixed_field, p.fixed_field) AS "coalesce",
            COALESCE(c.repeatable, p.repeatable) AS "coalesce",
            COALESCE(c.mandatory, p.mandatory) AS "coalesce",
            COALESCE(c.hidden, p.hidden) AS "coalesce",
            c.owner,
            (p.depth + 1)
           FROM ((config.marc_field c
             JOIN ou_marc_fields p USING (marc_format, marc_record_type, tag))
             JOIN actor.org_unit aou ON ((c.owner = aou.id)))
          WHERE ((aou.parent_ou = p.owner) OR ((aou.parent_ou IS NULL) AND (p.owner IS NULL)))
        )
 SELECT ou_marc_fields.id,
    ou_marc_fields.marc_format,
    ou_marc_fields.marc_record_type,
    ou_marc_fields.tag,
    ou_marc_fields.name,
    ou_marc_fields.description,
    ou_marc_fields.fixed_field,
    ou_marc_fields.repeatable,
    ou_marc_fields.mandatory,
    ou_marc_fields.hidden,
    ou_marc_fields.owner,
    ou_marc_fields.depth
   FROM ou_marc_fields;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views