asset.copy_template

↑ asset schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: asset_copy_template_floating_fkey, copy_template_circ_lib_fkey, copy_template_creator_fkey, copy_template_editor_fkey, copy_template_location_fkey, copy_template_owning_lib_fkey, copy_template_status_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('asset.copy_template_id_seq'::regclass)

owning_lib FK

integer

No

→ actor.org_unit(id)

creator FK

bigint

No

→ actor.usr(id)

editor FK

bigint

No

→ actor.usr(id)

create_date

timestamp with time zone

Yes

now()

edit_date

timestamp with time zone

Yes

now()

name

text

No

circ_lib FK

integer

Yes

→ actor.org_unit(id)

status FK

integer

Yes

→ config.copy_status(id)

location FK

integer

Yes

→ asset.copy_location(id)

loan_duration

integer

Yes

fine_level

integer

Yes

age_protect

integer

Yes

circulate

boolean

Yes

deposit

boolean

Yes

ref

boolean

Yes

holdable

boolean

Yes

deposit_amount

numeric(6,2)

Yes

price

numeric(8,2)

Yes

circ_modifier

text

Yes

circ_as_type

text

Yes

alert_message

text

Yes

opac_visible

boolean

Yes

floating FK

integer

Yes

→ config.floating_group(id)

mint_condition

boolean

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

floating

config.floating_group(id)

NO ACTION

NO ACTION

DEFERRED

asset_copy_template_floating_fkey

circ_lib

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

copy_template_circ_lib_fkey

creator

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

copy_template_creator_fkey

editor

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

copy_template_editor_fkey

location

asset.copy_location(id)

NO ACTION

NO ACTION

DEFERRED

copy_template_location_fkey

owning_lib

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

copy_template_owning_lib_fkey

status

config.copy_status(id)

NO ACTION

NO ACTION

DEFERRED

copy_template_status_fkey

Check Constraints

  • valid_fine_level: CHECK

  • valid_loan_duration: CHECK

Indexes

Index Method Definition

copy_template_pkey PK

btree

CREATE UNIQUE INDEX copy_template_pkey ON asset.copy_template USING btree (id)

Referenced By

The following tables have foreign keys pointing to asset.copy_template (2 referencing table(s)):

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

serial.distribution

bind_unit_template

id

distribution_bind_unit_template_fkey

serial.distribution

receive_unit_template

id

distribution_receive_unit_template_fkey
Previous
Next