dvobject

127 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_id R
auxiliaryfile.datafile_id fk_auxiliaryfile_datafile_id R
datafile.id fk_datafile_id R
datafilecategory.dataset_id fk_datafilecategory_dataset_id R
datafiletag.datafile_id fk_datafiletag_datafile_id R
dataset.id fk_dataset_id R
dataset.thumbnailfile_id fk_dataset_thumbnailfile_id R
datasetexternalcitations.dataset_id fk_datasetexternalcitations_dataset_id R
datasetlinkingdataverse.dataset_id fk_datasetlinkingdataverse_dataset_id R
datasetlinkingdataverse.linkingdataverse_id fk_datasetlinkingdataverse_linkingdataverse_id R
datasetlock.dataset_id fk_datasetlock_dataset_id R
datasetmetrics.dataset_id fk_datasetmetrics_dataset_id R
datasetversion.dataset_id fk_datasetversion_dataset_id R
datatable.datafile_id fk_datatable_datafile_id R
dataverse.id fk_dataverse_id R
dataverse_citationdatasetfieldtypes.dataverse_id fk_dataverse_citationdatasetfieldtypes_dataverse_id R
dataverse_metadatablock.dataverse_id fk_dataverse_metadatablock_dataverse_id R
dataversecontact.dataverse_id fk_dataversecontact_dataverse_id R
dataversefacet.dataverse_id fk_dataversefacet_dataverse_id R
dataversefeatureddataverse.dataverse_id fk_dataversefeatureddataverse_dataverse_id R
dataversefeatureddataverse.featureddataverse_id fk_dataversefeatureddataverse_featureddataverse_id R
dataversefieldtypeinputlevel.dataverse_id fk_dataversefieldtypeinputlevel_dataverse_id R
dataverselinkingdataverse.dataverse_id fk_dataverselinkingdataverse_dataverse_id R
dataverselinkingdataverse.linkingdataverse_id fk_dataverselinkingdataverse_linkingdataverse_id R
dataversemetadatablockfacet.dataverse_id fk_dataversemetadatablockfacet_dataverse_id R
dataverserole.owner_id fk_dataverserole_owner_id R
dataversesubjects.dataverse_id fk_dataversesubjects_dataverse_id R
dataversetheme.dataverse_id fk_dataversetheme_dataverse_id R
dvobject.owner_id fk_dvobject_owner_id R
explicitgroup.owner_id fk_explicitgroup_owner_id R
fileaccessrequests.datafile_id fk_fileaccessrequests_datafile_id R
filemetadata.datafile_id fk_filemetadata_datafile_id R
guestbook.dataverse_id fk_guestbook_dataverse_id R
guestbookresponse.datafile_id fk_guestbookresponse_datafile_id R
guestbookresponse.dataset_id fk_guestbookresponse_dataset_id R
harvestingclient.dataverse_id fk_harvestingclient_dataverse_id R
harvestingdataverseconfig.dataverse_id fk_harvestingdataverseconfig_dataverse_id R
ingestreport.datafile_id fk_ingestreport_datafile_id R
ingestrequest.datafile_id fk_ingestrequest_datafile_id R
metadatablock.owner_id fk_metadatablock_owner_id R
pendingworkflowinvocation.dataset_id fk_pendingworkflowinvocation_dataset_id R
roleassignment.definitionpoint_id fk_roleassignment_definitionpoint_id R
savedsearch.definitionpoint_id fk_savedsearch_definitionpoint_id R
template.dataverse_id fk_template_dataverse_id R
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
protocol varchar 255 √ null
publicationdate timestamp 29,6 √ null
storageidentifier varchar 255 √ null
creator_id int8 19 √ null
authenticateduser.id fk_dvobject_creator_id R
owner_id int8 19 √ null
dvobject.id fk_dvobject_owner_id R
releaseuser_id int8 19 √ null
authenticateduser.id fk_dvobject_releaseuser_id R

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