unit

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('asset.copy_id_seq'::regclass)
item.unit item_unit_fkey N
circ_lib int4 10 null
creator int8 19 null
usr.id serial_unit_creator_fkey N
call_number int8 19 null
call_number.id serial_unit_call_number_fkey R
editor int8 19 null
usr.id serial_unit_editor_fkey N
create_date timestamptz 35,6 √ now()
edit_date timestamptz 35,6 √ now()
copy_number int4 10 √ null
status int4 10 0
location int4 10 1
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_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
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
sort_key text 2147483647 √ null
detailed_contents text 2147483647 null
summary_contents text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
unit_pkey Primary key Asc id
unit_avail_cn_idx Performance Asc call_number
unit_barcode_key Must be unique Asc barcode
unit_cn_idx Performance Asc call_number
unit_creator_idx Performance Asc creator
unit_editor_idx Performance Asc editor
unit_extant_by_circ_lib_idx Performance Asc circ_lib

Check Constraints

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

Relationships

Close relationships within degrees of separation