asset.call_number_suffix

↑ asset schema

Data-Modifying Triggers: This table has BEFORE ROW trigger(s) that modify row data before write. Values you INSERT or UPDATE may differ from what is actually stored. See the Triggers section below.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('asset.call_number_suffix_id_seq'::regclass)

owning_lib FK

integer

No

→ actor.org_unit(id)

label

text

No

label_sortkey

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owning_lib

actor.org_unit(id)

NO ACTION

NO ACTION

No

call_number_suffix_owning_lib_fkey

Indexes

Index Method Definition

call_number_suffix_pkey PK

btree

CREATE UNIQUE INDEX call_number_suffix_pkey ON asset.call_number_suffix USING btree (id)

asset_call_number_suffix_once_per_lib UNIQUE

btree

CREATE UNIQUE INDEX asset_call_number_suffix_once_per_lib ON asset.call_number_suffix USING btree (label, owning_lib)

asset_call_number_suffix_sortkey_idx

btree

CREATE INDEX asset_call_number_suffix_sortkey_idx ON asset.call_number_suffix USING btree (label_sortkey)

Triggers

Trigger Timing Event Level Function

suffix_normalize_tgr

BEFORE

INSERT OR UPDATE

ROW

asset.normalize_affix_sortkey()

Trigger Bodies

suffix_normalize_tgr

Function: asset.normalize_affix_sortkey()
Timing: BEFORE INSERT OR UPDATE ROW

This trigger modifies the row before it is written (returns a modified NEW).

 
BEGIN
    NEW.label_sortkey := REGEXP_REPLACE(
        evergreen.lpad_number_substrings(
            naco_normalize(NEW.label),
            '0',
            10
        ),
        E'\\s+',
        '',
        'g'
    );
    RETURN NEW;
END;

Referenced By

The following tables have foreign keys pointing to asset.call_number_suffix (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

asset.call_number

suffix

id

call_number_suffix_fkey
Previous
Next