item

0 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
harvested_item.item_id harvested_item_item_id_fkey R
item2bundle.item_id item2bundle_item_id_fkey R
requestitem.item_id requestitem_item_id_fkey R
versionitem.item_id versionitem_item_id_fkey R
workflowitem.item_id workflowitem_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