bitstream

Includes all the DSpace bitstreams related to DSpace Items, Communities (logo), Collections (logo and template), process (output)

"uuid" uuid [not null]
"bitstream_id" integer
"bitstream_format_id" integer
"checksum" "character varying(64)"
"checksum_algorithm" "character varying(32)"
"internal_id" "character varying(256)"
"deleted" boolean
"store_number" integer
"sequence_id" integer
"size_bytes" bigint
}

uuid

bitstream_format_id → bitstreamformatregistry.bitstream_format_id

uuid → dspaceobject.uuid

bundle

bundle2bitstream

collection

checksum_history

process2bitstream

requestitem

bitstreamformatregistry

Includes the bitstream formats recognizable by DSpace

{
"bitstream_format_id" integer [not null]
"mimetype" "character varying(256)"
"short_description" "character varying(128)"
"description" text
"support_level" integer
"internal" boolean
}

"bitstream_format_id"

bitstream

bundle

Includes bundles by which the bitstreams related to DSpace items are divided

{
"bundle_id" integer
"uuid" uuid [default: gen_random_uuid()]
"primary_bitstream_id" uuid
}

"uuid"

primary_bitstream_id → bitstream.uuid

uuid → dspaceobject.uuid

item2bundle

bundle2bitstream

Manages the relationship between bundle and bitstreams

{
"bitstream_order_legacy" integer
"bundle_id" uuid [not null]
"bitstream_id" uuid [not null]
"bitstream_order" integer [not null]
}

"bitstream_order"
"bundle_id"
"bitstream_id"

bitstream_id → bitstream.uuid

bundle_id → bundle.uuid

checksum_history

List the result of the assetstore integrity check for a specific bitstream.

{
"check_id" bigint [not null]
"process_start_date" timestamp
"process_end_date" timestamp
"checksum_expected" "character varying"
"checksum_calculated" "character varying"
"result" "character varying"
"bitstream_id" uuid
}

"check_id"

result → checksum_results.result_code

bitstream_id → bitstream.uuid

checksum_results

Dictionary table to provide a description of the result_code used in other table

{
"result_code" "character varying" [not null]
"result_description" "character varying"
}

"result_code"

checksum_history

collection

Includes all the collections by which DSpace items are grouped

{
"collection_id" integer
"uuid" uuid [default: gen_random_uuid()]
"submitter" uuid
"template_item_id" uuid
"logo_bitstream_id" uuid
"admin" uuid
}

"uuid"

submitter → eperson.uuid

template_item_id → item.uuid

logo_bitstream_id → item.uuid

uuid → dspaceobject.uuid

item

collection2item

cwf_collectionrole

community2collection

harvested_collection

imp_record

subscription

collection2item

Manages the relationship between collections and items

{
"collection_id" uuid [not null]
"item_id" uuid [not null]
}

"collection_id"

"item_id"

collection_id → collection.uuid

item_id → item.uuid

community

Includes communites and subcommunities by which collections are grouped

{
"community_id" integer
"uuid" uuid [default: gen_random_uuid()]
"admin" uuid
"logo_bitstream_id" uuid
}

"uuid"

admin → epersongroup.uuid

logo_bitstream_id → item.uuid

uuid → dspaceobject.uuid

community2community

community2collection

community2collection

Manages the relationship between collections and communities

{
"collection_id" uuid [not null]
"community_id" uuid [not null]
}

"collection_id"

"community_id"

collection_id → collection.uuid

community_id → community.uuid

community2community

Manages the relationship between communities and subcommunites

{
"parent_comm_id" uuid [not null]
"child_comm_id" uuid [not null]
}

"parent_comm_id"

"child_comm_id"

parent_comm_id → community.uuid

child_comm_id → community.uuid

cris_layout_box

Manages the configuration of boxes within entities' pages layout

{
”id” integer [not null]
”entity_id” integer [not null]
”type” character varying(255)
”collapsed” boolean [not null]
”shortname” character varying(255)
”header” character varying(255)
”minor” boolean [not null]
”security” integer
”style” character varying(255)
”clear” boolean
}

"id"

entity_id → entity_type.id

cris_layout_box2securitymetadata

Define which metadata control the security of a box when the security level is set to 4 (Custom policy)

{
"box_id" integer [not null]
"metadata_field_id" integer [not null]
}

n/a

cris_layout_field

Define a single field to be included in a specific box (via the cris_layout_box2fields association table). A field can be of two type: “metadata” or “bitstream”

{
"field_id" integer [not null]
"metadata_field_id" integer
"bundle" "character varying(255)"
"rendering" "character varying(255)"
"row" integer [not null]
"priority" integer [not null]
"type" "character varying(255)"
"label" "character varying(255)"
"style" "character varying(255)"
"box_id" integer [not null]
"metadata_value" "character varying(255)"
"style_label" "character varying(255)"
"style_value" "character varying(255)"
}

"field_id"

cris_layout_field2nested

Define a relation between a field and some metadata to be displayed as nested

{
"nested_field_id" integer [not null]
"rendering" "character varying(255)"
"priority" integer [not null]
"label" "character varying(255)"
"style" "character varying(255)"
"style_label" "character varying(255)"
"style_value" "character varying(255)"
"metadata_field_id" integer [not null]
"field_id" integer [not null]
}

"nested_field_id"

field_id → cris_layout_field.field_id

medatada_field_id → metadatafieldregistry.metadata_field_id

cris_layout_metric2box

{
"metric_type" "character varying(255)" [not null]
"cris_layout_box_id" int4 [not null]
"position" int4 [not null]
"id" int4 [not null]
}

“id”

cris_layout_box_id → cris_layout_box.id

cris_layout_tab

Manages the tabs related to entities pages

{
"id" integer [not null]
"entity_id" integer [not null]
"priority" integer [not null]
"shortname" "character varying(255)"
"header" "character varying(255)"
"security" integer
}

"id"

cris_layout_tab2box

Manages the relationships between tabs and boxes

{
"cris_layout_tab_id" integer [not null]
"cris_layout_box_id" integer [not null]
”position” integer
}

"cris_layout_tab_id"
"cris_layout_box_id"

cris_layout_tab2securitymetadata

Define which metadata control the security of a tab when the security level is set to 4 (Custom policy)

{
"tab_id" integer [not null]
"metadata_field_id" integer [not null]
}

"tab_id" integer”
"metadata_field_id"

tab_id → cris_layout_tab.cris_layout_tab_id

metadata_field_id → metadatafieldregistry.metadata_field_id

cris_metrics

Collects metrics related to items having them

{
"id" integer [not null]
"metrictype" "character varying(255)"
"metriccount" float8 [not null]
"acquisitiondate" timestamp
"startdate" timestamp
"enddate" timestamp
"resource_id" uuid [not null]
"last" bool
"remark" text
"deltaperiod1" float8
"deltaperiod2" float8
"rank" float8
}

“id”

resource_id → item.uuid

cwf_claimtask

Manages the workflow tasks that have been claimed by an user

{
"claimtask_id" integer [not null, default: nextval('cwf_claimtask_seq')]
"workflowitem_id" integer
"workflow_id" text
"step_id" text
"action_id" text
"owner_id" uuid
}

"claimtask_id"

workflowitem_id → cwf_workflow.workflowitem_id

owner_id → eperson.uuid

cwf_collectionrole

Manages which groups perform a specific workflow role for a given collection

{
"collectionrole_id" integer [not null, default: nextval('cwf_collectionrole_seq')]
"role_id" text
"collection_id" uuid
"group_id" uuid
}

"collectionrole_id"

collection_id → collection.uuid

group_id → epersongroup.uuid

cwf_inprogressuser

Manages the relationship between the item in workflow and the users who are performing a workflow task

{
"in_progress_user_id" integer [not null, default: nextval('cwf_in_progress_user_seq')]
"workflowitem_id" integer
"finished" boolean
"user_id" uuid
}

"in_progress_user_id"

workflowitem_id → cwf_workflow.workflowitem_id

cwf_pooltask

Manages the tasks within the workflow that sit in the pool queue

{
"pooltask_id" integer [not null, default: nextval('cwf_pooltask_seq')]
"workflowitem_id" integer
"workflow_id" text
"step_id" text
"action_id" text
"group_id" uuid
"eperson_id" uuid
}

"pooltask_id"

workflowitem_id → cwf_workflow.workflowitem_id

group_id → epersongroup.uuid

eperson_id → eperson.uuid

cwf_workflowitem

Manages the items that are going in a workflow

{
"workflowitem_id" integer [not null, default: nextval('cwf_workflowitem_seq')]
"multiple_titles" boolean
"published_before" boolean
"multiple_files" boolean
"item_id" uuid
"collection_id" uuid
}

"workflowitem_id"

item_id → item.uuid

collection_id → collection.uuid

cwf_claimtask

cwf_inprogressuser

cwf_pooltask

cwf_workflowitemrole

cwf_workflowitemrole

Manages the custom workflow roles, if any, assigned for a specific item

{
"workflowitemrole_id" integer [not null, default: nextval('cwf_workflowitemrole_seq')]
"role_id" text
"workflowitem_id" integer
"group_id" uuid
"eperson_id" uuid
}

"workflowitemrole_id"

workflowitem_id → cwf_workflow.workflowitem_id

group_id → epersongroup.uuid

eperson_id → eperson.uuid

deduplication

Manages the decision recorded about the potential duplicate detected by the system

{
"deduplication_id" integer [not null]
"fake" boolean
"tofix" boolean
"note" "character varying(256)"
"admin_time" timestamp
"reader_time" timestamp
"reader_note" "character varying(256)"
"reject_time" timestamp
"submitter_decision" "character varying(256)"
"workflow_decision" "character varying(256)"
"admin_decision" "character varying(256)"
"eperson_id" uuid
"admin_id" uuid
"reader_id" uuid
"first_item_id" uuid
"second_item_id" uuid
}

"deduplication_id"

eperson_id → eperson.uuid

admin_id → eperson.uuid

reader_id → eperson.uuid

first_item_id → item.uuid

second_item_id → item.uuid

doi

Manages the DOI Mint by the platform

{
"doi_id" integer [not null]
"doi" "character varying(256)"
"resource_type_id" integer
"resource_id" integer
"status" integer
"dspace_object" uuid
}

"doi_id"

dspace_object → dspaceobject.uuid

dspaceobject

Manages the UUID of all the objects in DSpace (bitstrems, bundles, items, collections, communities, persons, groups)

{
"uuid" uuid [not null]
}

"uuid"

community

collection

item

bundle

bitstream

eperson

epersongroup

resourcepolicy

doi

handle

entitytype

Includes all the entities defined within DSpace-CRIS

{
"id" integer [not null]
"label" "character varying(32)" [not null]
}

"id"

cris_layout_tab

cris_layout_box

eperson

Includes all the accounts defined within DSpace-CRIS

{
"uuid" uuid [default: gen_random_uuid()]
"eperson_id" integer
"email" "character varying(64)"
"password" "character varying(128)"
"can_log_in" boolean
"require_certificate" boolean
"self_registered" boolean
"last_active" timestamp
"sub_frequency" integer
"netid" "character varying(64)"
"salt" "character varying(32)"
"digest_algorithm" "character varying(16)"
"session_salt" "character varying(32)"
}

"uuid"

uuid → dspaceobject.uuid

epersongroup2eperson

item

subscription

cwf_workflowitemrole

resourcepolicy

cwf_claimtask

cwf_pooltask

cwf_in_progress_user

imp_record

imp_workflow_nstate

epersongroup

Includes all the groups defined within DSpace

{
"eperson_group_id" integer
"uuid" uuid [default: gen_random_uuid()]
"permanent" boolean [default: false]
"name" "character varying(250)"
}

"eperson_group_id"

uuid → dspaceobject.uuid

epersongroup2eperson

group2group

group2groupcache

collection

cwf_collectionrole

cwf_workflowitemrole

resourcepolicy

cwf_claimtask

cwf_pooltask

epersongroup2eperson

Manages the relationship between groups and persons

{
"eperson_group_id" uuid [not null]
"eperson_id" uuid [not null]
}

"eperson_group_id"

"eperson_id"

eperson_group_id → epersongroup.uuid

eperson_id → eperson.uuid

epersongroup2workspaceitem

Manages the groups that have given access to a specific workspace item (deprecated: supervisor feature)

{
"workspace_item_id" integer [not null]
"eperson_group_id" uuid [not null]
}

"workspace_item_id"

"eperson_group_id"

workspace_item_id → workspaceitem.workspace_item_id

eperson_group_id → epersongroup.uuid

fileextension

Includes the file extensions to be associated with the bitstream formats

{
"file_extension_id" integer [not null]
"bitstream_format_id" integer
"extension" "character varying(16)"
}

file_extension_id

bitstream_format_id → bitstreamformatregistry.bitstream_format_id

group2group

Manages the direct relationships between groups

{
"parent_id" uuid [not null]
"child_id" uuid [not null]
}

"parent_id"

"child_id"

parent_id → group.uuid

child_id → group.uuid

group2groupcache

Cache table to improve the membership lookup performance. Includes all the group to group relation both direct (parent - children) than indirect (grandparent - grandchildren)

{
"parent_id" uuid [not null]
"child_id" uuid [not null]
}

"parent_id"

"child_id"

parent_id → group.uuid

child_id → group.uuid

handle

Manages the handles mint by DSpace

{
"handle_id" integer [not null]
"handle" "character varying(256)"
"resource_type_id" integer
"resource_legacy_id" integer
"resource_id" uuid
}

"handle_id"

resource_id → dspaceobject.uuid

harvested collection

Holds the harvesting configuration associated to some collection and the corresponding harvesting status

{
"harvest_type" integer
"oai_source" "character varying"
"oai_set_id" "character varying"
"harvest_message" "character varying"
"metadata_config_id" "character varying"
"harvest_status" integer
"harvest_start_time" timestamp
"last_harvested" timestamp
"id" integer [not null]
"collection_id" uuid
}

“id”

collection_id → collection.uuid

harvested_item

Includes the source information for items harvested via OAI-PMH

{
"last_harvested" timestamp
"oai_id" "character varying"
"id" integer [not null]
"item_id" uuid
}

“id”

item_id → item.uuid

imp_bitstream

Table used by the DBMS Import feature which includes bitstreams to be imported in DSpace-CRIS

{
"imp_id" integer [not null]
"imp_bitstream_id" integer [not null]
"filepath" "character varying(512)" [not null]
"description" "character varying(512)"
"bundle" "character varying(512)"
"bitstream_order" integer
"primary_bitstream" boolean
"assetstore" integer
"name" "character varying(512)"
"imp_blob" bytea
"embargo_policy" integer
"embargo_group" uuid
"embargo_start_date" "character varying(100)"
"md5value" "character varying(32)"
}

"imp_bitstream_id"

imp_id → imp_record.imp_id

imp_bitstream_metadatavalue

Table used by the DBMS Import feature which includes the metadata related to the bitstreams to be imported in DSpace-CRIS

{
"imp_bitstream_metadatavalue_id" integer [not null]
"imp_bitstream_id" integer [not null]
"imp_schema" "character varying(128)" [not null]
"imp_element" "character varying(128)" [not null]
"imp_qualifier" "character varying(128)"
"imp_value" text [not null]
"imp_authority" "character varying(256)"
"imp_confidence" integer
"metadata_order" integer [not null]
"text_lang" "character varying(32)"
}

"imp_bitstream_metadatavalue_id"

imp_bitstream_id → imp_bitstream.imp_bistream_id

imp_metadatavalue

Table used by the DBMS Import feature which includes the metadata related to the items to be imported in DSpace-CRIS

{
"imp_metadatavalue_id" integer [not null]
"imp_id" integer [not null]
"imp_schema" "character varying(128)" [not null]
"imp_element" "character varying(128)" [not null]
"imp_qualifier" "character varying(128)"
"imp_value" text [not null]
"imp_authority" "character varying(256)"
"imp_confidence" integer
"metadata_order" integer [not null]
"text_lang" "character varying(32)"
}

"imp_metadatavalue_id"

imp_id → imp_record.imp_id

imp_record

Table used by the DBMS Import feature which includes the items to be imported in DSpace-CRIS using the DBMS import framework

{
"imp_sourceref" "character varying(256)"
"imp_record_id" "character varying(256)" [not null]
"imp_id" integer [not null]
"imp_eperson_uuid" uuid [not null]
"imp_collection_uuid" uuid [not null]
"status" "character varying(1)"
"operation" "character varying(64)"
"last_modified" timestamp
"handle" "character varying(64)"
}

“imp_id”

imp_eperson_uuid → eperson.uuid

imp_collection_uuid → collection.uuid

imp_record_wstate

Table used by the DBMS Import feature which manages the association between the record and the operation to perform in hte workflow

{
"imp_id" integer [not null]
"imp_wnstate_op_id" integer [not null]
}

"imp_id"

"imp_wnstate_op_id"

imp_id → item_record.imp_id

imp_wnstate_od_id → imp_workflow_nstate.imp_wnstate_op_id

imp_workflow_nstate

Table used by the DBMS Import feature containing the details about each action to trigger into the workflow of the resulting item

{
"imp_wnstate_op_id" integer [not null]
"imp_wnstate_desc" "character varying(64)"
"imp_wnstate_op" "character varying(64)" [not null]
"imp_wnstate_op_par" "character varying(64)"
"imp_wnstate_order" integer [not null]
"imp_wnstate_eperson_uuid" uuid
}

"imp_wnstate_op_id"

imp_wnstate_eperson_uuid → eperson.uuid

item

Includes all the DSpace items

{
"owning_collection" uuid
"item_id" integer
"in_archive" boolean
"withdrawn" boolean
"last_modified" timestamp
"discoverable" boolean
"uuid" uuid [default: gen_random_uuid()]
"submitter_id" uuid
}

"uuid"

owning_collection → collection.uuid

submitter_id → eperson.uuid

uuid → dspaceobject.uuid

collection2item

collection

item2bundle

harvested_item

deduplication

relationship

requestitem

versionitem

workspaceitem

cwf_workflowitem

item2bundle

Manages the relationship between items and bundles

{
"bundle_id" uuid [not null]
"item_id" uuid [not null]
}

"bundle_id"

"item_id"

bundle_id → bundle.uuid

item_id → item.uuid

metadatafieldregistry

Includes the metadata used within DSpace.CRIS

{
"metadata_schema_id" integer [not null]
"metadata_field_id" integer [not null, default: nextval('metadatafieldregistry_seq')]
"element" "character varying(64)"
"qualifier" "character varying(64)"
"scope_note" text
}

"metadata_field_id"

metadata_schema_id → metadataschemaregistry.metadata_shema_id

metadatavalue

metadataschemaregistry

Includes the metadata schema to which the metadata used within DSpace-CRIS are related

{
"metadata_schema_id" integer [not null, default: nextval('metadataschemaregistry_seq')]
"namespace" "character varying(256)"
"short_id" "character varying(32)"
}

"metadata_schema_id"

metadatafieldregistry

metadatavalue

Includes the values of the metadata related to all DSpace-CRIS objects

{
"metadata_value_id" integer [not null, default: nextval('metadatavalue_seq')]
"metadata_field_id" integer
"text_value" text
"text_lang" "character varying(24)"
"place" integer
"authority" "character varying(100)"
"confidence" integer
"dspace_object_id" uuid "security_level" integer
}

"metadata_value_id"

dspace_object_id → dspaceobject.uuid

metadata_field_id → metadatafieldregistry.,metadata_field_id

most_recent_checksum

Process table used by the integrity checed to identify which bitstream needs to be checked

{
"to_be_processed" boolean [not null]
"expected_checksum" "character varying" [not null]
"current_checksum" "character varying" [not null]
"last_process_start_date" timestamp [not null]
"last_process_end_date" timestamp [not null]
"checksum_algorithm" "character varying" [not null]
"matched_prev_checksum" boolean [not null]
"result" "character varying"
"bitstream_id" uuid
}

none

bitstream_id → bitstream.uuid

nbevent_processed

Stores technical informations about processed notifications of broker events

{
"nbevent_id" "character varying(255)"
"nbevent_timestamp" timestamp
"eperson_uuid" uuid
"item_uuid" uuid
}

nbevent_id

eperson_uuid → eperson.uuid

item_uuid → item.uuid

openurltracker

Tracks openurl failed transmissions

{
"tracker_id" integer
"tracker_url" "character varying(100)"
"uploaddate" date
}

tracker_id

orcid_history

Stores the attempts and results of sending an entity to ORCID.

{

"id" integer [not null]
"owner_id" uuid [not null]
"entity_id" uuid
"put_code" "character varying"
"timestamp_last_attempt" timestamp
response_message text
status integer
"metadata" text
"operation" "character varying(255)"
"record_type" "character varying(255)"
"description" "character varying(255)"

}

“id”

owner_id → item
entity_id → item

orcid_queue

Stores the entities to be sent to ORCID

{

"id" integer [not null]
"owner_id" uuid [not null]
"entity_id" uuid
"attempts" integer
"put_code" "character varying(255)"
"record_type" "character varying(255)"
"description" "character varying(255)"
"operation" "character varying(255)"
"metadata" text

}

“id”

owner_id → item
entity_id → item

process

Includes information about processes started via REST in DSpace-CRIS

{
"process_id" integer [not null]
"user_id" uuid [not null]
"start_time" timestamp
"finished_time" timestamp
"creation_time" timestamp [not null]
"script" "character varying(256)" [not null]
"status" "character varying(32)"
"parameters" "character varying(512)"
}

"process_id"

process2bitstream

process2bitstream

Manages the relationship between processes and the involved bitstreams

{
"bitstream_id" uuid [not null]
"process_id" integer [not null]
}

"bitstream_id"

"process_id"

bitstream_id → bitstream.uuid

process_id → processes.process_id

process2group

Relationship between a process and group(s) user was

{
"process_id" integer [not null]
"group_id" uuid [not null]
}

"process_id"
"group_id"

process_id → process.process_id

group_id → epersongroup.group_id

registrationdata

Manages the self-registration procedure

{
"registrationdata_id" integer [not null]
"email" "character varying(64)"
"token" "character varying(48)"
"expires" timestamp
}

"registrationdata_id"

registrationdata2group

Links registration data to eperson group

{
"registrationdata_id" integer [not null]
"group_id" uuid [not null]
}

"registrationdata_id"
"group_id"

registrationdata_id → registrationdata.registrationdata_id

group_id → epersongroup.eperson_group_id

relationship

Manages functional relationships between DSpace-CRIS items

{
"id" integer [not null]
"left_id" uuid [not null]
"type_id" integer [not null]
"right_id" uuid [not null]
"left_place" integer
"right_place" integer
"leftward_value" "character varying"
"rightward_value" "character varying"
}

"id"

left_id → item.uuid

right_id → item.uuid

type_id → relationship_type.id

relationship_type

Describes the functional relationships types between DSpace-CRIS items

{
"id" integer [not null]
"left_type" integer
"right_type" integer
"leftward_type" "character varying(32)" [not null]
"rightward_type" "character varying(32)" [not null]
"left_min_cardinality" integer
"left_max_cardinality" integer
"right_min_cardinality" integer
"right_max_cardinality" integer
"copy_to_left" boolean [not null, default: false]
"copy_to_right" boolean [not null, default: false]
"tilted" integer
}

"id"

relationship

requestitem

Manages requests for accessing non public items and bitstreams

{
"requestitem_id" integer [not null]
"token" "character varying(48)"
"allfiles" boolean
"request_email" "character varying(64)"
"request_name" "character varying(64)"
"request_date" timestamp
"accept_request" boolean
"decision_date" timestamp
"expires" timestamp
"request_message" text
"item_id" uuid
"bitstream_id" uuid
}

"requestitem_id"

item_id → item.uuid

bitstream_id → bitstream.uuid

resourcepolicy

Manages the access policies related to all DSpace objects

{
"policy_id" integer [not null]
"resource_type_id" integer
"resource_id" integer
"action_id" integer
"start_date" date
"end_date" date
"rpname" "character varying(30)"
"rptype" "character varying(30)"
"rpdescription" text
"eperson_id" uuid
"epersongroup_id" uuid
"dspace_object" uuid
}

"policy_id"

dspace_object → dspaceobject.uuid

eperson_id → eperson.uuid

epersongroup_id → epersongroup.uuid

schema_version

Contains information about the current version of the system and any performed upgrade

{
"installed_rank" integer [not null]
"version" "character varying(50)"
"description" "character varying(200)" [not null]
"type" "character varying(20)" [not null]
"script" "character varying(1000)" [not null]
"checksum" integer
"installed_by" "character varying(100)" [not null]
"installed_on" timestamp [not null, default: now()]
"execution_time" integer [not null]
"success" boolean [not null]
}

"installed_rank"

site

Single row table for future use. Holds the uuid assigned to the whole repository

{
"uuid" uuid [not null]
}

"uuid"

uuid → dspaceobject.uuid

subscription

Manages the user email subscription to new content

{
"subscription_id" integer [not null]
"eperson_id" uuid
"collection_id" uuid
}

"subscription_id"

eperson_id → eperson.uuid

collection_id → collection.uuid

versionhistory

Used by the versioning system to generate an unique ID common to all the versions of a specific item

{
"versionhistory_id" integer [not null]
}

"versionhistory_id"

versionitem

versionitem

Manages the different versions of the items

{
"versionitem_id" integer [not null]
"version_number" integer
"version_date" timestamp
"version_summary" "character varying(255)"
"versionhistory_id" integer
"eperson_id" uuid
"item_id" uuid
}

"versionitem_id"

versionhistory_id → versionhistory.versionhistory_id

item_id → item.uuid

webapp

Holds the information about the webapplication connected to the database

{
"webapp_id" integer [not null]
"appname" "character varying(32)"
"url" "character varying"
"started" timestamp
"isui" integer
}

"webapp_id"

workspaceitem

Manages items in persons' workspace

{
"workspace_item_id" integer [not null]
"multiple_titles" boolean
"published_before" boolean
"multiple_files" boolean
"stage_reached" integer
"page_reached" integer
"item_id" uuid
"collection_id" uuid
}

"workspace_item_id"

item_id → item.uuid

collection_id → collection.uuid