copy_template

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('asset.copy_template_id_seq'::regclass)
distribution.bind_unit_template distribution_bind_unit_template_fkey R
distribution.receive_unit_template distribution_receive_unit_template_fkey R
owning_lib int4 10 null
org_unit.id copy_template_owning_lib_fkey R
creator int8 19 null
usr.id copy_template_creator_fkey R
editor int8 19 null
usr.id copy_template_editor_fkey R
create_date timestamptz 35,6 √ now()
edit_date timestamptz 35,6 √ now()
name text 2147483647 null
circ_lib int4 10 √ null
org_unit.id copy_template_circ_lib_fkey R
status int4 10 √ null
copy_status.id copy_template_status_fkey R
location int4 10 √ null
copy_location.id copy_template_location_fkey R
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
circ_modifier text 2147483647 √ null
circ_as_type text 2147483647 √ null
alert_message text 2147483647 √ null
opac_visible bool 1 √ null
floating int4 10 √ null
floating_group.id asset_copy_template_floating_fkey R
mint_condition bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
copy_template_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
valid_fine_level (((fine_level IS NULL) OR (fine_level = ANY (ARRAY[1, 2, 3]))))
valid_loan_duration (((loan_duration IS NULL) OR (loan_duration = ANY (ARRAY[1, 2, 3]))))

Relationships

Close relationships within degrees of separation