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
create_time timestamp with time zone NOT NULL DEFAULT now()

Tables referencing via foreign key constraints

container.table.biblio-record-entry-bucket-item
container.table.biblio-record-entry-bucket-note
url-verify.table.session
vandelay.table.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.table.biblio-record-entry-bucket-item-note
url-verify.table.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.table.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
create_time timestamp with time zone NOT NULL DEFAULT now()

Tables referencing via foreign key constraints

container.table.call-number-bucket-item
container.table.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.table.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.table.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
create_time timestamp with time zone NOT NULL DEFAULT now()

Tables referencing via foreign key constraints

container.table.copy-bucket-item
container.table.copy-bucket-note

copy_bucket_item

id serial PRIMARY KEY
bucket integer NOT NULL REFERENCES container.table.copy-bucket
target_copy integer NOT NULL REFERENCES asset.table.copy
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.table.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.table.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
create_time timestamp with time zone NOT NULL DEFAULT now()

Tables referencing via foreign key constraints

container.table.user-bucket-item
container.table.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.table.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.table.user-bucket