config.copy_status

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 Nullable Default Notes

Column	Type	Nullable	Default
id PK	`integer`	No	nextval('config.copy_status_id_seq'::regclass)
name	`text`	No
holdable	`boolean`	No	false
opac_visible	`boolean`	No	false
copy_active	`boolean`	No	false
restrict_copy_delete	`boolean`	No	false
is_available	`boolean`	No	false
hopeless_prone	`boolean`	No	false

id PK

integer

nextval('config.copy_status_id_seq'::regclass)

name

text

holdable

boolean

false

opac_visible

boolean

false

copy_active

boolean

false

restrict_copy_delete

boolean

false

is_available

boolean

false

hopeless_prone

boolean

false

Primary Key

(id)

Unique Constraints

copy_status_name_key: (name)

Indexes

Index Method Definition

Index	Method	Definition
`copy_status_pkey` PK	btree	`CREATE UNIQUE INDEX copy_status_pkey ON config.copy_status USING btree (id)`
`copy_status_name_key` UNIQUE	btree	`CREATE UNIQUE INDEX copy_status_name_key ON config.copy_status USING btree (name)`

copy_status_pkey PK

btree

CREATE UNIQUE INDEX copy_status_pkey ON config.copy_status USING btree (id)

copy_status_name_key UNIQUE

btree

CREATE UNIQUE INDEX copy_status_name_key ON config.copy_status USING btree (name)

Referenced By

The following tables have foreign keys pointing to config.copy_status (4 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
action.transit_copy	`copy_status`	`id`	`transit_copy_copy_status_fkey`
asset.copy	`status`	`id`	`copy_status_fkey`
asset.copy_template	`status`	`id`	`copy_template_status_fkey`
asset.course_module_course_materials	`original_status`	`id`	`course_module_course_materials_original_status_fkey`