copy_status

-1 rows


Description

Copy Statuses

The available copy statuses, and whether a copy in that status is available for hold request capture. 0 (zero) is the only special number in this set, meaning that the item is available for immediate checkout, and is counted as available in the OPAC.

Statuses with an ID below 100 are not removable, and have special meaning in the code. Do not change them except to translate the textual name.

You may add and remove statuses above 100, and these can be used to remove items from normal circulation without affecting the rest of the copy’s values or its location.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('config.copy_status_id_seq'::regclass)
transit_copy.copy_status transit_copy_copy_status_fkey R
copy.status copy_status_fkey R
copy_template.status copy_template_status_fkey R
course_module_course_materials.original_status course_module_course_materials_original_status_fkey R
name text 2147483647 null
holdable bool 1 false
opac_visible bool 1 false
copy_active bool 1 false
restrict_copy_delete bool 1 false
is_available bool 1 false
hopeless_prone bool 1 false

Indexes

Constraint Name Type Sort Column(s)
copy_status_pkey Primary key Asc id
copy_status_name_key Must be unique Asc name

Relationships

Close relationships within degrees of separation