Schema serial

Schema serial
Home Prev	Chapter 1. Database Schema	Next

Table: basic_summary

Columns:

field name : datatype -- parameters, contraints and notes

id : serial -- PRIMARY KEY,

distribution : integer -- NOT NULL, REFERENCES serial.distribution.

generated_coverage : text -- NOT NULL,

textual_holdings : text --

show_generated : boolean -- NOT NULL, DEFAULT true,

Indexes:

serial_basic_summary_dist_idx : distribution

Table: caption_and_pattern

Columns:

field name : datatype -- parameters, contraints and notes

id : serial -- PRIMARY KEY,

subscription : integer -- NOT NULL, REFERENCES serial.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:

cap_type : CHECK ((type = ANY (ARRAY['basic'::text, 'supplement'::text, 'index'::text])))

Indexes:

serial_caption_and_pattern_sub_idx : subscription

Tables referencing serial.issuance via Foreign Key Constraints:

serial.issuance

Table: distribution

Columns:

field name : datatype -- parameters, contraints and notes

id : serial -- PRIMARY KEY,

record_entry : bigint -- REFERENCES serial.record_entry.

summary_method : text --

subscription : integer -- NOT NULL, REFERENCES serial.subscription.

holding_lib : integer -- NOT NULL, REFERENCES actor.org_unit.

label : text -- NOT NULL,

receive_call_number : bigint -- REFERENCES asset.call_number.

receive_unit_template : integer -- REFERENCES asset.copy_template.

bind_call_number : bigint -- REFERENCES asset.call_number.

bind_unit_template : integer -- REFERENCES asset.copy_template.

unit_label_prefix : text --

unit_label_suffix : text --

Constraints:

sdist_summary_method_check : CHECK (((summary_method IS NULL) OR (summary_method = ANY (ARRAY['add_to_sre'::text, 'merge_with_sre'::text, 'use_sre_only'::text, 'use_sdist_only'::text]))))

Indexes:

serial_distribution_holding_lib_idx : holding_lib

serial_distribution_sub_idx : subscription

Tables referencing serial.basic_summary via Foreign Key Constraints:

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

Table: distribution_note

Columns:

field name : datatype -- parameters, contraints and notes

id : serial -- PRIMARY KEY,

distribution : integer -- NOT NULL, REFERENCES serial.distribution.

creator : integer -- NOT NULL, REFERENCES actor.usr.

create_date : timestamp with time zone -- DEFAULT now(),

pub : boolean -- NOT NULL, DEFAULT false,

title : text -- NOT NULL,

value : text -- NOT NULL,

Indexes:

serial_distribution_note_dist_idx : distribution

Table: index_summary

Columns:

field name : datatype -- parameters, contraints and notes

id : serial -- PRIMARY KEY,

distribution : integer -- NOT NULL, REFERENCES serial.distribution.

generated_coverage : text -- NOT NULL,

textual_holdings : text --

show_generated : boolean -- NOT NULL, DEFAULT true,

Indexes:

serial_index_summary_dist_idx : distribution

Table: issuance

Columns:

field name : datatype -- parameters, contraints and notes

id : serial -- PRIMARY KEY,

creator : integer -- NOT NULL, REFERENCES actor.usr.

editor : integer -- NOT NULL, REFERENCES actor.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.subscription.

label : text --

date_published : timestamp with time zone --

caption_and_pattern : integer -- REFERENCES serial.caption_and_pattern.

holding_code : text --

holding_type : text --

holding_link_id : integer --

Constraints:

valid_holding_type : CHECK (((holding_type IS NULL) OR (holding_type = ANY (ARRAY['basic'::text, 'supplement'::text, 'index'::text]))))

Indexes:

serial_issuance_caption_and_pattern_idx : caption_and_pattern

serial_issuance_date_published_idx : date_published

serial_issuance_sub_idx : subscription

Tables referencing serial.item via Foreign Key Constraints:

serial.item

Table: item

Columns:

field name : datatype -- parameters, contraints and notes

id : serial -- PRIMARY KEY,

creator : integer -- NOT NULL, REFERENCES actor.usr.

editor : integer -- NOT NULL, REFERENCES actor.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.issuance.

stream : integer -- NOT NULL, REFERENCES serial.stream.

unit : integer -- REFERENCES serial.unit.

uri : integer -- REFERENCES asset.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:

valid_status : CHECK ((status = ANY (ARRAY['Bindery'::text, 'Bound'::text, 'Claimed'::text, 'Discarded'::text, 'Expected'::text, 'Not Held'::text, 'Not Published'::text, 'Received'::text])))

Indexes:

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 acq.serial_claim via Foreign Key Constraints:

acq.serial_claim

serial.item_note

Table: item_note

Columns:

field name : datatype -- parameters, contraints and notes

id : serial -- PRIMARY KEY,

item : integer -- NOT NULL, REFERENCES serial.item.

creator : integer -- NOT NULL, REFERENCES actor.usr.

create_date : timestamp with time zone -- DEFAULT now(),

pub : boolean -- NOT NULL, DEFAULT false,

title : text -- NOT NULL,

value : text -- NOT NULL,

Indexes:

serial_item_note_item_idx : item

Table: record_entry

Columns:

field name : datatype -- parameters, contraints and notes

id : bigserial -- PRIMARY KEY,

record : bigint -- REFERENCES biblio.record_entry.

owning_lib : integer -- NOT NULL, DEFAULT 1, REFERENCES actor.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:

serial_record_entry_creator_idx : creator

serial_record_entry_editor_idx : editor

serial_record_entry_owning_lib_idx : owning_lib, deleted

Tables referencing serial.distribution via Foreign Key Constraints:

serial.distribution

Table: routing_list_user

Columns:

field name : datatype -- parameters, contraints and notes

id : serial -- PRIMARY KEY,

stream : integer -- UNIQUE#1, NOT NULL, REFERENCES serial.stream.

pos : integer -- UNIQUE#1, NOT NULL, DEFAULT 1,

reader : integer -- REFERENCES actor.usr.

department : text --

note : text --

Constraints:

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

Indexes:

serial_routing_list_user_reader_idx : reader

serial_routing_list_user_stream_idx : stream

Table: stream

Columns:

field name : datatype -- parameters, contraints and notes

id : serial -- PRIMARY KEY,

distribution : integer -- NOT NULL, REFERENCES serial.distribution.

routing_label : text --

Indexes:

serial_stream_dist_idx : distribution

Tables referencing serial.item via Foreign Key Constraints:

serial.item

serial.routing_list_user

Table: subscription

Columns:

field name : datatype -- parameters, contraints and notes

id : serial -- PRIMARY KEY,

owning_lib : integer -- NOT NULL, DEFAULT 1, REFERENCES actor.org_unit.

start_date : timestamp with time zone -- NOT NULL,

end_date : timestamp with time zone --

record_entry : bigint -- REFERENCES biblio.record_entry.

expected_date_offset : interval --

Indexes:

serial_subscription_owner_idx : owning_lib

serial_subscription_record_idx : record_entry

Tables referencing serial.caption_and_pattern via Foreign Key Constraints:

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

Table: subscription_note

Columns:

field name : datatype -- parameters, contraints and notes

id : serial -- PRIMARY KEY,

subscription : integer -- NOT NULL, REFERENCES serial.subscription.

creator : integer -- NOT NULL, REFERENCES actor.usr.

create_date : timestamp with time zone -- DEFAULT now(),

pub : boolean -- NOT NULL, DEFAULT false,

title : text -- NOT NULL,

value : text -- NOT NULL,

Indexes:

serial_subscription_note_sub_idx : subscription

Table: supplement_summary

Columns:

field name : datatype -- parameters, contraints and notes

id : serial -- PRIMARY KEY,

distribution : integer -- NOT NULL, REFERENCES serial.distribution.

generated_coverage : text -- NOT NULL,

textual_holdings : text --

show_generated : boolean -- NOT NULL, DEFAULT true,

Indexes:

serial_supplement_summary_dist_idx : distribution

Table: unit

Columns:

field name : datatype -- parameters, contraints and notes

id : bigint -- PRIMARY KEY, DEFAULT nextval('asset.copy_id_seq'::regclass),

circ_lib : integer -- NOT NULL,

creator : bigint -- NOT NULL, REFERENCES actor.usr.

call_number : bigint -- NOT NULL, REFERENCES asset.call_number.

editor : bigint -- NOT NULL, REFERENCES actor.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 : boolean -- NOT NULL, DEFAULT false,

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:

copy_fine_level_check : CHECK ((fine_level = ANY (ARRAY[1, 2, 3])))

copy_loan_duration_check : CHECK ((loan_duration = ANY (ARRAY[1, 2, 3])))

Indexes:

unit_avail_cn_idx : call_number

unit_cn_idx : call_number

unit_creator_idx : creator

unit_editor_idx : editor

Tables referencing serial.item via Foreign Key Constraints:

serial.item