dvobject

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('dvobject_id_seq'::regclass)
alternativepersistentidentifier.dvobject_id fk_alternativepersistentidentifier_dvobject_idR
auxiliaryfile.datafile_id fk_auxiliaryfile_datafile_idR
datafile.id fk_datafile_idR
datafilecategory.dataset_id fk_datafilecategory_dataset_idR
datafiletag.datafile_id fk_datafiletag_datafile_idR
dataset.id fk_dataset_idR
dataset.thumbnailfile_id fk_dataset_thumbnailfile_idR
datasetexternalcitations.dataset_id fk_datasetexternalcitations_dataset_idR
datasetlinkingdataverse.dataset_id fk_datasetlinkingdataverse_dataset_idR
datasetlinkingdataverse.linkingdataverse_id fk_datasetlinkingdataverse_linkingdataverse_idR
datasetlock.dataset_id fk_datasetlock_dataset_idR
datasetmetrics.dataset_id fk_datasetmetrics_dataset_idR
datasetversion.dataset_id fk_datasetversion_dataset_idR
datatable.datafile_id fk_datatable_datafile_idR
dataverse.id fk_dataverse_idR
dataverse_citationdatasetfieldtypes.dataverse_id fk_dataverse_citationdatasetfieldtypes_dataverse_idR
dataverse_metadatablock.dataverse_id fk_dataverse_metadatablock_dataverse_idR
dataversecontact.dataverse_id fk_dataversecontact_dataverse_idR
dataversefacet.dataverse_id fk_dataversefacet_dataverse_idR
dataversefeatureddataverse.dataverse_id fk_dataversefeatureddataverse_dataverse_idR
dataversefeatureddataverse.featureddataverse_id fk_dataversefeatureddataverse_featureddataverse_idR
dataversefieldtypeinputlevel.dataverse_id fk_dataversefieldtypeinputlevel_dataverse_idR
dataverselinkingdataverse.dataverse_id fk_dataverselinkingdataverse_dataverse_idR
dataverselinkingdataverse.linkingdataverse_id fk_dataverselinkingdataverse_linkingdataverse_idR
dataversemetadatablockfacet.dataverse_id fk_dataversemetadatablockfacet_dataverse_idR
dataverserole.owner_id fk_dataverserole_owner_idR
dataversesubjects.dataverse_id fk_dataversesubjects_dataverse_idR
dataversetheme.dataverse_id fk_dataversetheme_dataverse_idR
dvobject.owner_id fk_dvobject_owner_idR
explicitgroup.owner_id fk_explicitgroup_owner_idR
fileaccessrequests.datafile_id fk_fileaccessrequests_datafile_idR
filemetadata.datafile_id fk_filemetadata_datafile_idR
guestbook.dataverse_id fk_guestbook_dataverse_idR
guestbookresponse.datafile_id fk_guestbookresponse_datafile_idR
guestbookresponse.dataset_id fk_guestbookresponse_dataset_idR
harvestingclient.dataverse_id fk_harvestingclient_dataverse_idR
harvestingdataverseconfig.dataverse_id fk_harvestingdataverseconfig_dataverse_idR
ingestreport.datafile_id fk_ingestreport_datafile_idR
ingestrequest.datafile_id fk_ingestrequest_datafile_idR
metadatablock.owner_id fk_metadatablock_owner_idR
metric.dataverse_id fk_metric_dataverse_idR
pendingworkflowinvocation.dataset_id fk_pendingworkflowinvocation_dataset_idR
roleassignment.definitionpoint_id fk_roleassignment_definitionpoint_idR
savedsearch.definitionpoint_id fk_savedsearch_definitionpoint_idR
storagequota.definitionpoint_id fk_storagequota_definitionpoint_idR
storageuse.dvobjectcontainer_id fk_storageuse_dvobjectcontainer_idR
template.dataverse_id fk_template_dataverse_idR
dtype varchar 31 √ null
authority varchar 255 √ null
createdate timestamp 29,6 null
globalidcreatetime timestamp 29,6 √ null
identifier varchar 255 √ null
identifierregistered bool 1 √ null
indextime timestamp 29,6 √ null
modificationtime timestamp 29,6 null
permissionindextime timestamp 29,6 √ null
permissionmodificationtime timestamp 29,6 √ null
previewimageavailable bool 1 √ null
previewimagefail bool 1 √ null
protocol varchar 255 √ null
publicationdate timestamp 29,6 √ null
storageidentifier varchar 255 √ null
creator_id int8 19 √ null
authenticateduser.id fk_dvobject_creator_idR
owner_id int8 19 √ null
dvobject.id fk_dvobject_owner_idR
releaseuser_id int8 19 √ null
authenticateduser.id fk_dvobject_releaseuser_idR

Indexes

Constraint Name Type Sort Column(s)
dvobject_pkey Primary key Asc id
index_dvobject_creator_id Performance Asc creator_id
index_dvobject_dtype Performance Asc dtype
index_dvobject_owner_id Performance Asc owner_id
index_dvobject_releaseuser_id Performance Asc releaseuser_id
unq_dvobject_0 Must be unique Asc/Asc/Asc authority + protocol + identifier
unq_dvobject_1 Must be unique Asc/Asc owner_id + storageidentifier
unq_dvobject_storageidentifier Must be unique Asc/Asc owner_id + storageidentifier

Check Constraints

Constraint Name Constraint
chk_dvobject_storageidentifier ((strpos((storageidentifier)::text, '..'::text) = 0))

Relationships

Close relationships within degrees of separation