dataset

26 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
dvobject.id fk_dataset_id R
fileaccessrequest bool 1 √ null
harvestidentifier varchar 255 √ null
lastexporttime timestamp 29,6 √ null
storagedriver varchar 255 √ null
usegenericthumbnail bool 1 √ null
citationdatedatasetfieldtype_id int8 19 √ null
datasetfieldtype.id fk_dataset_citationdatedatasetfieldtype_id R
harvestingclient_id int8 19 √ null
harvestingclient.id fk_dataset_harvestingclient_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
trsa_id int8 19 √ null
trsa.id fk_dataset_trsa_id R
metadatalanguage text 2147483647 √ null
externallabelsetname varchar 32 √ null
template_id int8 19 √ null
template.id fx_dataset_template_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