course_module_course_materials

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('asset.course_module_course_materials_id_seq'::regclass)
course int4 10 null
course_module_course.id course_module_course_materials_course_fkey R
item int4 10 √ null
copy.id course_module_course_materials_item_fkey R
relationship text 2147483647 √ null
record int4 10 √ null
record_entry.id course_module_course_materials_record_fkey R
temporary_record bool 1 √ null
original_location int4 10 √ null
copy_location.id course_module_course_materials_original_location_fkey R
original_status int4 10 √ null
copy_status.id course_module_course_materials_original_status_fkey R
original_circ_modifier text 2147483647 √ null
circ_modifier.code original_circ_mod_fkey N
original_callnumber int4 10 √ null
call_number.id course_module_course_materials_original_callnumber_fkey R
original_circ_lib int4 10 √ null
org_unit.id course_module_course_materials_original_circ_lib_fkey R

Indexes

Constraint Name Type Sort Column(s)
course_module_course_materials_pkey Primary key Asc id
course_module_course_materials_course_item_record_key Must be unique Asc/Asc/Asc course + item + record

Relationships

Close relationships within degrees of separation