Table item
Items/resources. This is the main table for content stored in EQUELLA.

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
id int8 19
activate_request.item_id fk590bcb436f7f1a9c R
attachment.item_id fk8af759236f7f1a9c R
bookmark.item_id fk7787a5366f7f1a9c R
cal_holding.item_id fk7ec66f526f7f1a9c R
cal_portion.item_id fk26541c766f7f1a9c R
catalogue_assignment.item_id fkac8764636f7f1a9c R
cla_holding.item_id fk9efd869c6f7f1a9c R
cla_portion.item_id fk468b33c06f7f1a9c R
comments.item_id fkdc17ddf46f7f1a9c R
drm_acceptance.item_id fkaf6118f76f7f1a9c R
hierarchy_topic_key_resources.element fka591802b8e3f7fd1 R
item_collaborators.item_id fk5b4901016f7f1a9c R
item_history.item_id fke56a43686f7f1a9c R
item_lock.item_id fk805cf6d76f7f1a9c R
item_navigation_node.item_id fka57d4216f7f1a9c R
item_notifications.item_id fk8aeb84bc6f7f1a9c R
item_referenced_urls.item_id fk1e51e5be6f7f1a9c R
pricing_tier_assignment.item_id fk76d892d16f7f1a9c R
pss_callback_log.item_id fk854811596f7f1a9c R
qti_assessment_test.item_id fk98d8b0566f7f1a9c R
relation.first_item_id fkdef3f9fc65f7e40d R
relation.second_item_id fkdef3f9fcf78851d1 R
share_pass.item_id fk956be0716f7f1a9c R
task_history.item_id fk608e6bda6f7f1a9c R
curricula text 2147483647  √  null
date_created timestamp 29,6
date_for_index timestamp 29,6
date_modified timestamp 29,6
metadata_security_targets varchar 512  √  null
moderating bool 1
manual_navigation bool 1
show_split_option bool 1  √  null
owner varchar 255
rating float4 8,8
search_details text 2147483647  √  null
status varchar 16  √  null
thumb varchar 512
total_file_size int8 19
uuid varchar 40  √  null
version int4 10
description_id int8 19  √  null
language_bundle.id fk317b13888c44ea R
drm_settings_id int8 19  √  null
drm_settings.id fk317b13eddc9ef7 R
institution_id int8 19
institution.id fk317b13bc711081 R
item_definition_id int8 19
item_definition.id fk317b13d0a6662f R
item_xml_id int8 19
item_xml.id fk317b135e8657f1 R
moderation_id int8 19  √  null
moderation_status.id fk317b13172b24e R
name_id int8 19  √  null
language_bundle.id fk317b13d4838ffb R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc item_pkey
institution_id + uuid + version Must be unique Asc/Asc/Asc item_institution_id_uuid_version_key
item_xml_id Must be unique Asc item_item_xml_id_key
date_for_index Performance Asc itemdateforindexindex
description_id Performance Asc itemdescription
drm_settings_id Performance Asc itemdrmsettings
institution_id Performance Asc iteminstitutionindex
item_definition_id Performance Asc itemitemdefinition
item_xml_id Performance Asc itemitemxmlindex
moderation_id Performance Asc itemmoderationstatus
name_id Performance Asc itemname
uuid Performance Asc itemuuidindex
version Performance Asc itemversionindex

Close relationships  within of separation: