asset_copy_history

19355 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
audit_id int8 19 null
audit_time timestamptz 35,6 null
audit_action text 2147483647 null
audit_user int4 10 √ null
audit_ws int4 10 √ null
id int8 19 null
circ_lib int4 10 null
creator int8 19 null
call_number int8 19 null
editor int8 19 null
create_date timestamptz 35,6 √ null
edit_date timestamptz 35,6 √ null
copy_number int4 10 √ null
status int4 10 null
location int4 10 null
loan_duration int4 10 null
fine_level int4 10 null
age_protect int4 10 √ null
circulate bool 1 null
deposit bool 1 null
ref bool 1 null
holdable bool 1 null
deposit_amount numeric 6,2 null
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 null
deleted bool 1 null
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 null
cost numeric 8,2 √ null

Indexes

Constraint Name Type Sort Column(s)
asset_copy_history_pkey Primary key Asc audit_id
aud_asset_cp_hist_creator_idx Performance Asc creator
aud_asset_cp_hist_editor_idx Performance Asc editor

Relationships

Close relationships within degrees of separation