Evergreen
HomePrev Chapter 26. Database Schema Next

Schema container

Table: biblio_record_entry_bucket

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
owner : integer -- UNIQUE#1, NOT NULL, REFERENCES actor.usr.
name : text -- UNIQUE#1, NOT NULL,
btype : text -- UNIQUE#1, NOT NULL, DEFAULT 'misc'::text, REFERENCES container.biblio_record_entry_bucket_type.
pub : boolean -- NOT NULL, DEFAULT false,
create_time : timestamp with time zone -- NOT NULL, DEFAULT now(),

Tables referencing container.biblio_record_entry_bucket_item via Foreign Key Constraints: 

container.biblio_record_entry_bucket_itemcontainer.biblio_record_entry_bucket_note

Table: biblio_record_entry_bucket_item

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
bucket : integer -- NOT NULL, REFERENCES container.biblio_record_entry_bucket.
target_biblio_record_entry : bigint -- NOT NULL, REFERENCES biblio.record_entry.
pos : integer --
create_time : timestamp with time zone -- NOT NULL, DEFAULT now(),

Tables referencing container.biblio_record_entry_bucket_item_note via Foreign Key Constraints: 

container.biblio_record_entry_bucket_item_note 

Table: biblio_record_entry_bucket_item_note

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
item : integer -- NOT NULL, REFERENCES container.biblio_record_entry_bucket_item.
note : text -- NOT NULL,

Table: biblio_record_entry_bucket_note

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
bucket : integer -- NOT NULL, REFERENCES container.biblio_record_entry_bucket.
note : text -- NOT NULL,

Table: biblio_record_entry_bucket_type

Columns: 

field name : datatype -- parameters, contraints and notes
code : text -- PRIMARY KEY,
label : text -- UNIQUE, NOT NULL,

Tables referencing container.biblio_record_entry_bucket via Foreign Key Constraints: 

container.biblio_record_entry_bucket 

Table: call_number_bucket

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
owner : integer -- UNIQUE#1, NOT NULL, REFERENCES actor.usr.
name : text -- UNIQUE#1, NOT NULL,
btype : text -- UNIQUE#1, NOT NULL, DEFAULT 'misc'::text, REFERENCES container.call_number_bucket_type.
pub : boolean -- NOT NULL, DEFAULT false,
create_time : timestamp with time zone -- NOT NULL, DEFAULT now(),

Tables referencing container.call_number_bucket_item via Foreign Key Constraints: 

container.call_number_bucket_itemcontainer.call_number_bucket_note

Table: call_number_bucket_item

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
bucket : integer -- NOT NULL, REFERENCES container.call_number_bucket.
target_call_number : integer -- NOT NULL, REFERENCES asset.call_number.
pos : integer --
create_time : timestamp with time zone -- NOT NULL, DEFAULT now(),

Tables referencing container.call_number_bucket_item_note via Foreign Key Constraints: 

container.call_number_bucket_item_note 

Table: call_number_bucket_item_note

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
item : integer -- NOT NULL, REFERENCES container.call_number_bucket_item.
note : text -- NOT NULL,

Table: call_number_bucket_note

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
bucket : integer -- NOT NULL, REFERENCES container.call_number_bucket.
note : text -- NOT NULL,

Table: call_number_bucket_type

Columns: 

field name : datatype -- parameters, contraints and notes
code : text -- PRIMARY KEY,
label : text -- UNIQUE, NOT NULL,

Tables referencing container.call_number_bucket via Foreign Key Constraints: 

container.call_number_bucket 

Table: copy_bucket

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
owner : integer -- UNIQUE#1, NOT NULL, REFERENCES actor.usr.
name : text -- UNIQUE#1, NOT NULL,
btype : text -- UNIQUE#1, NOT NULL, DEFAULT 'misc'::text, REFERENCES container.copy_bucket_type.
pub : boolean -- NOT NULL, DEFAULT false,
create_time : timestamp with time zone -- NOT NULL, DEFAULT now(),

Tables referencing container.copy_bucket_item via Foreign Key Constraints: 

container.copy_bucket_itemcontainer.copy_bucket_note

Table: copy_bucket_item

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
bucket : integer -- NOT NULL, REFERENCES container.copy_bucket.
target_copy : integer -- NOT NULL, REFERENCES asset.copy.
pos : integer --
create_time : timestamp with time zone -- NOT NULL, DEFAULT now(),

Indexes: 

copy_bucket_item_bucket_idx : bucket

Tables referencing container.copy_bucket_item_note via Foreign Key Constraints: 

container.copy_bucket_item_note 

Table: copy_bucket_item_note

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
item : integer -- NOT NULL, REFERENCES container.copy_bucket_item.
note : text -- NOT NULL,

Table: copy_bucket_note

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
bucket : integer -- NOT NULL, REFERENCES container.copy_bucket.
note : text -- NOT NULL,

Table: copy_bucket_type

Columns: 

field name : datatype -- parameters, contraints and notes
code : text -- PRIMARY KEY,
label : text -- UNIQUE, NOT NULL,

Tables referencing container.copy_bucket via Foreign Key Constraints: 

container.copy_bucket 

Table: user_bucket

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
owner : integer -- UNIQUE#1, NOT NULL, REFERENCES actor.usr.
name : text -- UNIQUE#1, NOT NULL,
btype : text -- UNIQUE#1, NOT NULL, DEFAULT 'misc'::text, REFERENCES container.user_bucket_type.
pub : boolean -- NOT NULL, DEFAULT false,
create_time : timestamp with time zone -- NOT NULL, DEFAULT now(),

Tables referencing container.user_bucket_item via Foreign Key Constraints: 

container.user_bucket_itemcontainer.user_bucket_note

Table: user_bucket_item

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
bucket : integer -- NOT NULL, REFERENCES container.user_bucket.
target_user : integer -- NOT NULL, REFERENCES actor.usr.
pos : integer --
create_time : timestamp with time zone -- NOT NULL, DEFAULT now(),

Indexes: 

user_bucket_item_target_user_idx : target_user

Tables referencing container.user_bucket_item_note via Foreign Key Constraints: 

container.user_bucket_item_note 

Table: user_bucket_item_note

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
item : integer -- NOT NULL, REFERENCES container.user_bucket_item.
note : text -- NOT NULL,

Table: user_bucket_note

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
bucket : integer -- NOT NULL, REFERENCES container.user_bucket.
note : text -- NOT NULL,

Table: user_bucket_type

Columns: 

field name : datatype -- parameters, contraints and notes
code : text -- PRIMARY KEY,
label : text -- UNIQUE, NOT NULL,

Tables referencing container.user_bucket via Foreign Key Constraints: 

container.user_bucket 

clear_all_expired_circ_history_items()

Delete expired circulation bucket items for all users that have a setting for patron.max_reading_list_interval.

Function Properties
Language: PLPGSQL
Return Type: void

clear_expired_circ_history_items(ac_usr integer)

Delete old circulation bucket items for a specified user. "Old" means older than the interval specified by a user-level setting, if it is so specified.

Function Properties
Language: PLPGSQL
Return Type: void

Prev Up Next
Schema config Home Schema evergreen