item

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
item_id int4 10 √ null
in_archive bool 1 √ null
withdrawn bool 1 √ null
last_modified timestamptz 35,6 √ null
discoverable bool 1 √ null
uuid uuid 2147483647 gen_random_uuid()
collection2item.item_id collection2item_item_id_fkey R
cwf_workflowitem.item_id cwf_workflowitem_item_id_fkey R
harvested_item.item_id harvested_item_item_id_fkey R
item2bundle.item_id item2bundle_item_id_fkey R
notifypatterns_to_trigger.item_id notifypatterns_to_trigger_item_id_fkey C
orcid_history.entity_id orcid_history_entity_id_fkey R
orcid_history.owner_id orcid_history_owner_id_fkey R
orcid_queue.entity_id orcid_queue_entity_id_fkey R
orcid_queue.owner_id orcid_queue_owner_id_fkey R
orcid_token.profile_item_id orcid_token_profile_item_id_fkey R
qaevent_processed.item_uuid item_uuid_fkey R
relationship.left_id relationship_left_id_fkey R
relationship.right_id relationship_right_id_fkey R
requestitem.item_id requestitem_item_id_fkey R
supervision_orders.item_id supervision_orders_item_id_fkey C
versionitem.item_id versionitem_item_id_fkey R
workspaceitem.item_id workspaceitem_item_id_fkey R
dspaceobject.uuid item_uuid_fkey R
submitter_id uuid 2147483647 √ null
eperson.uuid item_submitter_id_fkey R
owning_collection uuid 2147483647 √ null
collection.uuid item_owning_collection_fkey R

Indexes

Constraint Name Type Sort Column(s)
item_pkey Primary key Asc uuid
item_collection Performance Asc owning_collection
item_id_idx Performance Asc item_id
item_id_unique Must be unique Asc uuid
item_submitter Performance Asc submitter_id
item_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation