Table item_definition
Legacy name, actually references collection definitions

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
deny_direct_contribution bool 1
reviewperiod int4 10
scorm_packaging_transformat varchar 25  √  null
wizardcategory varchar 100  √  null
id int8 19
dyna_collection_item_defs.entity_id fk5e8df130a9577dcb R
hierarchy_topic_add_idefs.entity_id fkda58f6bfa9577dcb R
hierarchy_topic_inh_idefs.entity_id fk5ee11c81a9577dcb R
item.item_definition_id fk317b13d0a6662f R
portlet_recent_contrib_collect.collections_id fk12786185e81286d9 R
power_search_itemdefs.itemdefs_id fk1f54941eae8bca4d R
base_entity.id fk983a75ffaa97c6e1 R
schema_id int8 19  √  null
tleschemas.id fk983a75ff9db92ecc R
slow_id int8 19  √  null
itemdef_blobs.id fk983a75ff25b0392b R
workflow_id int8 19  √  null
workflow.id fk983a75ffcbffa4b4 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc item_definition_pkey
slow_id Performance Asc collectionblobs
schema_id Performance Asc collectionschema
workflow_id Performance Asc collectionworkflow

Close relationships  within of separation: