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
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
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
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
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
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
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
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
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
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
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
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
