Chapter 11. Schema container


Home Prev		Next

Below are the tables, views and functions for container

Tables in container

biblio_record_entry_bucket

id serial PRIMARY KEY
owner integer UNIQUE #1 NOT NULL REFERENCES actor.table.usr
name text UNIQUE #1 NOT NULL
btype text UNIQUE #1 NOT NULL DEFAULT 'misc'::text REFERENCES container.table.biblio-record-entry-bucket-type
description text
pub boolean NOT NULL DEFAULT false
owning_lib integer REFERENCES actor.table.org-unit
create_time timestamp with time zone NOT NULL DEFAULT now()

Tables referencing via foreign key constraints

container.biblio_record_entry_bucket_item
container.biblio_record_entry_bucket_note
url_verify.session
vandelay.bib_queue

biblio_record_entry_bucket_item

id serial PRIMARY KEY
bucket integer NOT NULL REFERENCES container.table.biblio-record-entry-bucket
target_biblio_record_entry bigint NOT NULL REFERENCES biblio.table.record-entry
pos integer
create_time timestamp with time zone NOT NULL DEFAULT now()

Tables referencing via foreign key constraints

container.biblio_record_entry_bucket_item_note
url_verify.url

biblio_record_entry_bucket_item_note

id serial PRIMARY KEY
item integer NOT NULL REFERENCES container.table.biblio-record-entry-bucket-item
note text NOT NULL

biblio_record_entry_bucket_note

id serial PRIMARY KEY
bucket integer NOT NULL REFERENCES container.table.biblio-record-entry-bucket
note text NOT NULL

biblio_record_entry_bucket_type

code text PRIMARY KEY
label text UNIQUE NOT NULL

Tables referencing via foreign key constraints

container.biblio_record_entry_bucket

call_number_bucket

id serial PRIMARY KEY
owner integer UNIQUE #1 NOT NULL REFERENCES actor.table.usr
name text UNIQUE #1 NOT NULL
btype text UNIQUE #1 NOT NULL DEFAULT 'misc'::text REFERENCES container.table.call-number-bucket-type
description text
pub boolean NOT NULL DEFAULT false
owning_lib integer REFERENCES actor.table.org-unit
create_time timestamp with time zone NOT NULL DEFAULT now()

Tables referencing via foreign key constraints

container.call_number_bucket_item
container.call_number_bucket_note

call_number_bucket_item

id serial PRIMARY KEY
bucket integer NOT NULL REFERENCES container.table.call-number-bucket
target_call_number integer NOT NULL REFERENCES asset.table.call-number
pos integer
create_time timestamp with time zone NOT NULL DEFAULT now()

Tables referencing via foreign key constraints

container.call_number_bucket_item_note

call_number_bucket_item_note

id serial PRIMARY KEY
item integer NOT NULL REFERENCES container.table.call-number-bucket-item
note text NOT NULL

call_number_bucket_note

id serial PRIMARY KEY
bucket integer NOT NULL REFERENCES container.table.call-number-bucket
note text NOT NULL

call_number_bucket_type

code text PRIMARY KEY
label text UNIQUE NOT NULL

Tables referencing via foreign key constraints

container.call_number_bucket

copy_bucket

id serial PRIMARY KEY
owner integer UNIQUE #1 NOT NULL REFERENCES actor.table.usr
name text UNIQUE #1 NOT NULL
btype text UNIQUE #1 NOT NULL DEFAULT 'misc'::text REFERENCES container.table.copy-bucket-type
description text
pub boolean NOT NULL DEFAULT false
owning_lib integer REFERENCES actor.table.org-unit
create_time timestamp with time zone NOT NULL DEFAULT now()

Tables referencing via foreign key constraints

container.copy_bucket_item
container.copy_bucket_note

copy_bucket_item

id serial PRIMARY KEY
bucket integer NOT NULL REFERENCES container.table.copy-bucket
target_copy integer NOT NULL
pos integer
create_time timestamp with time zone NOT NULL DEFAULT now()

Indexes on copy_bucket_item

copy_bucket_item_bucket_idx bucket

Tables referencing via foreign key constraints

container.copy_bucket_item_note

copy_bucket_item_note

id serial PRIMARY KEY
item integer NOT NULL REFERENCES container.table.copy-bucket-item
note text NOT NULL

copy_bucket_note

id serial PRIMARY KEY
bucket integer NOT NULL REFERENCES container.table.copy-bucket
note text NOT NULL

copy_bucket_type

code text PRIMARY KEY
label text UNIQUE NOT NULL

Tables referencing via foreign key constraints

container.copy_bucket

user_bucket

id serial PRIMARY KEY
owner integer UNIQUE #1 NOT NULL REFERENCES actor.table.usr
name text UNIQUE #1 NOT NULL
btype text UNIQUE #1 NOT NULL DEFAULT 'misc'::text REFERENCES container.table.user-bucket-type
description text
pub boolean NOT NULL DEFAULT false
owning_lib integer REFERENCES actor.table.org-unit
create_time timestamp with time zone NOT NULL DEFAULT now()

Tables referencing via foreign key constraints

container.user_bucket_item
container.user_bucket_note

user_bucket_item

id serial PRIMARY KEY
bucket integer NOT NULL REFERENCES container.table.user-bucket
target_user integer NOT NULL REFERENCES actor.table.usr
pos integer
create_time timestamp with time zone NOT NULL DEFAULT now()

Indexes on user_bucket_item

user_bucket_item_target_user_idx target_user

Tables referencing via foreign key constraints

container.user_bucket_item_note

user_bucket_item_note

id serial PRIMARY KEY
item integer NOT NULL REFERENCES container.table.user-bucket-item
note text NOT NULL

user_bucket_note

id serial PRIMARY KEY
bucket integer NOT NULL REFERENCES container.table.user-bucket
note text NOT NULL

user_bucket_type

code text PRIMARY KEY
label text UNIQUE NOT NULL

Tables referencing via foreign key constraints

container.user_bucket