collection

-1 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
cwf_collectionrole.collection_id cwf_collectionrole_collection_id_fkey R
cwf_workflowitem.collection_id cwf_workflowitem_collection_id_fkey R
harvested_collection.collection_id harvested_collection_collection_id_fkey R
item.owning_collection item_owning_collection_fkey R
workspaceitem.collection_id workspaceitem_collection_id_fkey R
dspaceobject.uuid collection_uuid_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

Relationships

Close relationships within degrees of separation