copy

4852 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('asset.copy_id_seq'::regclass)
course_module_course_materials.item course_module_course_materials_item_fkey R
circ_lib int4 10 null
org_unit.id copy_circ_lib_fkey R
creator int8 19 null
usr.id asset_copy_creator_fkey N
call_number int8 19 null
call_number.id asset_copy_call_number_fkey R
editor int8 19 null
usr.id asset_copy_editor_fkey N
create_date timestamptz 35,6 √ now()
edit_date timestamptz 35,6 √ now()
copy_number int4 10 √ null
status int4 10 0
copy_status.id copy_status_fkey R
location int4 10 1
copy_location.id copy_location_fkey R
loan_duration int4 10 null
fine_level int4 10 null
age_protect int4 10 √ null
circulate bool 1 true
deposit bool 1 false
ref bool 1 false
holdable bool 1 true
deposit_amount numeric 6,2 0.00
price numeric 8,2 √ null
barcode text 2147483647 null
circ_modifier text 2147483647 √ null
circ_modifier.code circ_mod_fkey N
circ_as_type text 2147483647 √ null
dummy_title text 2147483647 √ null
dummy_author text 2147483647 √ null
alert_message text 2147483647 √ null
opac_visible bool 1 true
deleted bool 1 false
floating int4 10 √ null
floating_group.id asset_copy_floating_fkey R
dummy_isbn text 2147483647 √ null
status_changed_time timestamptz 35,6 √ null
active_date timestamptz 35,6 √ null
mint_condition bool 1 true
cost numeric 8,2 √ null

Indexes

Constraint Name Type Sort Column(s)
copy_pkey Primary key Asc id
copy_barcode_key Must be unique Asc barcode
cp_avail_cn_idx Performance Asc call_number
cp_cn_idx Performance Asc call_number
cp_create_date Performance Asc create_date
cp_creator_idx Performance Asc creator
cp_editor_idx Performance Asc editor
cp_extant_by_circ_lib_idx Performance Asc circ_lib

Check Constraints

Constraint Name Constraint
copy_loan_duration_check ((loan_duration = ANY (ARRAY[1, 2, 3])))
copy_fine_level_check ((fine_level = ANY (ARRAY[1, 2, 3])))

Relationships

Close relationships within degrees of separation