asset.course_module_course_materials

↑ asset schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: original_circ_mod_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('asset.course_module_course_materials_id_seq'::regclass)

course FK

integer

No

→ asset.course_module_course(id)

item FK

integer

Yes

→ asset.copy(id)

relationship

text

Yes

record FK

integer

Yes

→ biblio.record_entry(id)

temporary_record

boolean

Yes

original_location FK

integer

Yes

→ asset.copy_location(id)

original_status FK

integer

Yes

→ config.copy_status(id)

original_circ_modifier FK

text

Yes

→ config.circ_modifier(code)

original_callnumber FK

integer

Yes

→ asset.call_number(id)

original_circ_lib FK

integer

Yes

→ actor.org_unit(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

course

asset.course_module_course(id)

NO ACTION

NO ACTION

No

course_module_course_materials_course_fkey

item

asset.copy(id)

NO ACTION

NO ACTION

No

course_module_course_materials_item_fkey

original_callnumber

asset.call_number(id)

NO ACTION

NO ACTION

No

course_module_course_materials_original_callnumber_fkey

original_circ_lib

actor.org_unit(id)

NO ACTION

NO ACTION

No

course_module_course_materials_original_circ_lib_fkey

original_location

asset.copy_location(id)

NO ACTION

NO ACTION

No

course_module_course_materials_original_location_fkey

original_status

config.copy_status(id)

NO ACTION

NO ACTION

No

course_module_course_materials_original_status_fkey

record

biblio.record_entry(id)

NO ACTION

NO ACTION

No

course_module_course_materials_record_fkey

original_circ_modifier

config.circ_modifier(code)

SET NULL

CASCADE

DEFERRED

original_circ_mod_fkey

Unique Constraints

  • course_module_course_materials_course_item_record_key: (course, item, record)

Indexes

Index Method Definition

course_module_course_materials_pkey PK

btree

CREATE UNIQUE INDEX course_module_course_materials_pkey ON asset.course_module_course_materials USING btree (id)

course_module_course_materials_course_item_record_key UNIQUE

btree

CREATE UNIQUE INDEX course_module_course_materials_course_item_record_key ON asset.course_module_course_materials USING btree (course, item, record)
Previous
Next