collection

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
collection_id int4 10 √ null
uuid uuid 2147483647 gen_random_uuid()
collection2item.collection_id collection2item_collection_id_fkey R
community2collection.collection_id community2collection_collection_id_fkey R
harvested_collection.collection_id harvested_collection_collection_id_fkey R
item.owning_collection item_owning_collection_fkey R
subscription.collection_id subscription_collection_id_fkey R
workflowitem.collection_id workflowitem_collection_id_fkey R
workspaceitem.collection_id workspaceitem_collection_id_fkey R
dspaceobject.uuid collection_uuid_fkey R
workflow_step_1 uuid 2147483647 √ null
epersongroup.uuid collection_workflow_step_1_fkey R
workflow_step_2 uuid 2147483647 √ null
epersongroup.uuid collection_workflow_step_2_fkey R
workflow_step_3 uuid 2147483647 √ null
epersongroup.uuid collection_workflow_step_3_fkey R
submitter uuid 2147483647 √ null
epersongroup.uuid collection_submitter_fkey R
template_item_id uuid 2147483647 √ null
logo_bitstream_id uuid 2147483647 √ null
admin uuid 2147483647 √ null
epersongroup.uuid collection_admin_fkey R

Indexes

Constraint Name Type Sort Column(s)
collection_pkey Primary key Asc uuid
collection_bitstream Performance Asc logo_bitstream_id
collection_id_idx Performance Asc collection_id
collection_id_unique Must be unique Asc uuid
collection_submitter Performance Asc submitter
collection_template Performance Asc template_item_id
collection_uuid_key Must be unique Asc uuid
collection_workflow1 Performance Asc workflow_step_1
collection_workflow2 Performance Asc workflow_step_2
collection_workflow3 Performance Asc workflow_step_3

Relationships

Close relationships within degrees of separation