dataset

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
dvobject.id fk_dataset_id R
embargocitationdate timestamp 29,6 √ null
externallabelsetname varchar 255 √ null
fileaccessrequest bool 1 √ null
guestbookatrequest bool 1 √ null
harvestidentifier varchar 255 √ null
lastexporttime timestamp 29,6 √ null
metadatalanguage varchar 255 √ null
pidgeneratorspecs varchar 255 √ null
storagedriver varchar 255 √ null
usegenericthumbnail bool 1 √ null
citationdatedatasetfieldtype_id int8 19 √ null
datasetfieldtype.id fk_dataset_citationdatedatasetfieldtype_id R
datasettype_id int8 19 null
datasettype.id fk_dataset_datasettype_id R
harvestingclient_id int8 19 √ null
harvestingclient.id fk_dataset_harvestingclient_id R
template_id int8 19 √ null
template.id fx_dataset_template_id R
guestbook_id int8 19 √ null
guestbook.id fk_dataset_guestbook_id R
thumbnailfile_id int8 19 √ null
dvobject.id fk_dataset_thumbnailfile_id R

Indexes

Constraint Name Type Sort Column(s)
dataset_pkey Primary key Asc id
index_dataset_guestbook_id Performance Asc guestbook_id
index_dataset_thumbnailfile_id Performance Asc thumbnailfile_id

Relationships

Close relationships within degrees of separation