Chapter 23. Schema serial

Table of Contents

Tables in serial
any_summary
basic_summary
caption_and_pattern
distribution
distribution_note
index_summary
issuance
item
item_note
materialized_holding_code
record_entry
routing_list_user
stream
subscription
subscription_note
supplement_summary
unit
Functions in serial

Below are the tables, views and functions for serial

Tables in serial

any_summary

  • summary_type text
  • id integer
  • distribution integer
  • generated_coverage text
  • textual_holdings text
  • show_generated boolean

basic_summary

  • id serial PRIMARY KEY
  • distribution integer NOT NULL REFERENCES serial.table.distribution
  • generated_coverage text NOT NULL
  • textual_holdings text
  • show_generated boolean NOT NULL DEFAULT true

Indexes on basic_summary

  • serial_basic_summary_dist_idx distribution

caption_and_pattern

  • id serial PRIMARY KEY
  • subscription integer NOT NULL REFERENCES serial.table.subscription
  • type text NOT NULL
  • create_date timestamp with time zone NOT NULL DEFAULT now()
  • start_date timestamp with time zone NOT NULL DEFAULT now()
  • end_date timestamp with time zone
  • active boolean NOT NULL DEFAULT false
  • pattern_code text NOT NULL
  • enum_1 text
  • enum_2 text
  • enum_3 text
  • enum_4 text
  • enum_5 text
  • enum_6 text
  • chron_1 text
  • chron_2 text
  • chron_3 text
  • chron_4 text
  • chron_5 text

Constraints on caption_and_pattern

  • cap_type CHECK type = ANY (ARRAY['basic'::text

Indexes on caption_and_pattern

  • serial_caption_and_pattern_sub_idx subscription

Tables referencing via foreign key constraints

  • serial.issuance

distribution

  • id serial PRIMARY KEY
  • record_entry bigint REFERENCES serial.table.record-entry
  • summary_method text
  • subscription integer NOT NULL REFERENCES serial.table.subscription
  • holding_lib integer NOT NULL REFERENCES actor.table.org-unit
  • label text NOT NULL
  • display_grouping text NOT NULL DEFAULT 'chron'::text
  • receive_call_number bigint REFERENCES asset.table.call-number
  • receive_unit_template integer REFERENCES asset.table.copy-template
  • bind_call_number bigint REFERENCES asset.table.call-number
  • bind_unit_template integer REFERENCES asset.table.copy-template
  • unit_label_prefix text
  • unit_label_suffix text

Constraints on distribution

  • distribution_display_grouping_check CHECK display_grouping = ANY (ARRAY['enum'::text
  • sdist_summary_method_check CHECK

Indexes on distribution

  • serial_distribution_holding_lib_idx holding_lib
  • serial_distribution_sub_idx subscription

Tables referencing via foreign key constraints

  • serial.basic_summary
  • serial.distribution_note
  • serial.index_summary
  • serial.stream
  • serial.supplement_summary

distribution_note

  • id serial PRIMARY KEY
  • distribution integer NOT NULL REFERENCES serial.table.distribution
  • creator integer NOT NULL REFERENCES actor.table.usr
  • create_date timestamp with time zone DEFAULT now()
  • pub boolean NOT NULL DEFAULT false
  • alert boolean NOT NULL DEFAULT false
  • title text NOT NULL
  • value text NOT NULL

Indexes on distribution_note

  • serial_distribution_note_dist_idx distribution

index_summary

  • id serial PRIMARY KEY
  • distribution integer NOT NULL REFERENCES serial.table.distribution
  • generated_coverage text NOT NULL
  • textual_holdings text
  • show_generated boolean NOT NULL DEFAULT true

Indexes on index_summary

  • serial_index_summary_dist_idx distribution

issuance

  • id serial PRIMARY KEY
  • creator integer NOT NULL REFERENCES actor.table.usr
  • editor integer NOT NULL REFERENCES actor.table.usr
  • create_date timestamp with time zone NOT NULL DEFAULT now()
  • edit_date timestamp with time zone NOT NULL DEFAULT now()
  • subscription integer NOT NULL REFERENCES serial.table.subscription
  • label text
  • date_published timestamp with time zone
  • caption_and_pattern integer REFERENCES serial.table.caption-and-pattern
  • holding_code text
  • holding_type text
  • holding_link_id integer

Constraints on issuance

  • issuance_holding_code_check CHECK
  • issuance_holding_code_check1 CHECK
  • valid_holding_type CHECK

Indexes on issuance

  • serial_issuance_caption_and_pattern_idx caption_and_pattern
  • serial_issuance_date_published_idx date_published
  • serial_issuance_sub_idx subscription

Tables referencing via foreign key constraints

  • serial.item
  • serial.materialized_holding_code

item

  • id serial PRIMARY KEY
  • creator integer NOT NULL REFERENCES actor.table.usr
  • editor integer NOT NULL REFERENCES actor.table.usr
  • create_date timestamp with time zone NOT NULL DEFAULT now()
  • edit_date timestamp with time zone NOT NULL DEFAULT now()
  • issuance integer NOT NULL REFERENCES serial.table.issuance
  • stream integer NOT NULL REFERENCES serial.table.stream
  • unit integer REFERENCES serial.table.unit
  • uri integer REFERENCES asset.table.uri
  • date_expected timestamp with time zone
  • date_received timestamp with time zone
  • status text DEFAULT 'Expected'::text
  • shadowed boolean NOT NULL DEFAULT false

Constraints on item

  • valid_status CHECK status = ANY (ARRAY['Bindery'::text

Indexes on item

  • serial_item_date_received_idx date_received
  • serial_item_issuance_idx issuance
  • serial_item_status_idx status
  • serial_item_stream_idx stream
  • serial_item_unit_idx unit
  • serial_item_uri_idx uri

Tables referencing via foreign key constraints

  • acq.serial_claim
  • serial.item_note

item_note

  • id serial PRIMARY KEY
  • item integer NOT NULL REFERENCES serial.table.item
  • creator integer NOT NULL REFERENCES actor.table.usr
  • create_date timestamp with time zone DEFAULT now()
  • pub boolean NOT NULL DEFAULT false
  • alert boolean NOT NULL DEFAULT false
  • title text NOT NULL
  • value text NOT NULL

Indexes on item_note

  • serial_item_note_item_idx item

materialized_holding_code

  • id bigserial PRIMARY KEY
  • issuance integer NOT NULL REFERENCES serial.table.issuance
  • subfield character(1)
  • value text

Indexes on materialized_holding_code

  • assist_holdings_display issuance, subfield

record_entry

  • id bigserial PRIMARY KEY
  • record bigint REFERENCES biblio.table.record-entry
  • owning_lib integer NOT NULL DEFAULT 1 REFERENCES actor.table.org-unit
  • creator integer NOT NULL DEFAULT 1
  • editor integer NOT NULL DEFAULT 1
  • source integer
  • create_date timestamp with time zone NOT NULL DEFAULT now()
  • edit_date timestamp with time zone NOT NULL DEFAULT now()
  • active boolean NOT NULL DEFAULT true
  • deleted boolean NOT NULL DEFAULT false
  • marc text
  • last_xact_id text NOT NULL

Indexes on record_entry

  • serial_record_entry_creator_idx creator
  • serial_record_entry_editor_idx editor
  • serial_record_entry_owning_lib_idx owning_lib, deleted
  • serial_record_entry_record_idx record

Tables referencing via foreign key constraints

  • serial.distribution

routing_list_user

  • id serial PRIMARY KEY
  • stream integer UNIQUE #1 NOT NULL REFERENCES serial.table.stream
  • pos integer UNIQUE #1 NOT NULL DEFAULT 1
  • reader integer REFERENCES actor.table.usr
  • department text
  • note text

Constraints on routing_list_user

  • reader_or_dept CHECK ((((reader IS NOT NULL) AND (department IS NULL)) OR reader IS NULL) AND (department IS NOT NULL))

Indexes on routing_list_user

  • serial_routing_list_user_reader_idx reader
  • serial_routing_list_user_stream_idx stream

stream

  • id serial PRIMARY KEY
  • distribution integer NOT NULL REFERENCES serial.table.distribution
  • routing_label text

Indexes on stream

  • serial_stream_dist_idx distribution

Tables referencing via foreign key constraints

  • serial.item
  • serial.routing_list_user

subscription

  • id serial PRIMARY KEY
  • owning_lib integer NOT NULL DEFAULT 1 REFERENCES actor.table.org-unit
  • start_date timestamp with time zone NOT NULL
  • end_date timestamp with time zone
  • record_entry bigint REFERENCES biblio.table.record-entry
  • expected_date_offset interval

Indexes on subscription

  • serial_subscription_owner_idx owning_lib
  • serial_subscription_record_idx record_entry

Tables referencing via foreign key constraints

  • serial.caption_and_pattern
  • serial.distribution
  • serial.issuance
  • serial.subscription_note

subscription_note

  • id serial PRIMARY KEY
  • subscription integer NOT NULL REFERENCES serial.table.subscription
  • creator integer NOT NULL REFERENCES actor.table.usr
  • create_date timestamp with time zone DEFAULT now()
  • pub boolean NOT NULL DEFAULT false
  • alert boolean NOT NULL DEFAULT false
  • title text NOT NULL
  • value text NOT NULL

Indexes on subscription_note

  • serial_subscription_note_sub_idx subscription

supplement_summary

  • id serial PRIMARY KEY
  • distribution integer NOT NULL REFERENCES serial.table.distribution
  • generated_coverage text NOT NULL
  • textual_holdings text
  • show_generated boolean NOT NULL DEFAULT true

Indexes on supplement_summary

  • serial_supplement_summary_dist_idx distribution

unit

  • id bigint PRIMARY KEY DEFAULT nextval('asset.copy_id_seq'::regclass)
  • circ_lib integer NOT NULL
  • creator bigint NOT NULL REFERENCES actor.table.usr
  • call_number bigint NOT NULL REFERENCES asset.table.call-number
  • editor bigint NOT NULL REFERENCES actor.table.usr
  • create_date timestamp with time zone DEFAULT now()
  • edit_date timestamp with time zone DEFAULT now()
  • copy_number integer
  • status integer NOT NULL
  • location integer NOT NULL DEFAULT 1
  • loan_duration integer NOT NULL
  • fine_level integer NOT NULL
  • age_protect integer
  • circulate boolean NOT NULL DEFAULT true
  • deposit boolean NOT NULL DEFAULT false
  • ref boolean NOT NULL DEFAULT false
  • holdable boolean NOT NULL DEFAULT true
  • deposit_amount numeric(6,2) NOT NULL DEFAULT 0.00
  • price numeric(8,2)
  • barcode text NOT NULL
  • circ_modifier text
  • circ_as_type text
  • dummy_title text
  • dummy_author text
  • alert_message text
  • opac_visible boolean NOT NULL DEFAULT true
  • deleted boolean NOT NULL DEFAULT false
  • floating integer
  • dummy_isbn text
  • status_changed_time timestamp with time zone
  • active_date timestamp with time zone
  • mint_condition boolean NOT NULL DEFAULT true
  • cost numeric(8,2)
  • sort_key text
  • detailed_contents text NOT NULL
  • summary_contents text NOT NULL

Constraints on unit

  • copy_fine_level_check CHECK fine_level = ANY (ARRAY[1
  • copy_loan_duration_check CHECK loan_duration = ANY (ARRAY[1

Indexes on unit

  • unit_avail_cn_idx call_number
  • unit_cn_idx call_number
  • unit_creator_idx creator
  • unit_editor_idx editor

Tables referencing via foreign key constraints

  • serial.item