datasetfieldtype

176 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('datasetfieldtype_id_seq'::regclass)
controlledvocabalternate.datasetfieldtype_id fk_controlledvocabalternate_datasetfieldtype_idR
controlledvocabularyvalue.datasetfieldtype_id fk_controlledvocabularyvalue_datasetfieldtype_idR
dataset.citationdatedatasetfieldtype_id fk_dataset_citationdatedatasetfieldtype_idR
datasetfield.datasetfieldtype_id fk_datasetfield_datasetfieldtype_idR
datasetfielddefaultvalue.datasetfield_id fk_datasetfielddefaultvalue_datasetfield_idR
datasetfieldtype.parentdatasetfieldtype_id fk_datasetfieldtype_parentdatasetfieldtype_idR
dataverse_citationdatasetfieldtypes.citationdatasetfieldtype_id dataverse_citationdatasetfieldtypes_citationdatasetfieldtype_idR
dataversefacet.datasetfieldtype_id fk_dataversefacet_datasetfieldtype_idR
dataversefieldtypeinputlevel.datasetfieldtype_id fk_dataversefieldtypeinputlevel_datasetfieldtype_idR
advancedsearchfieldtype bool 1 √ null
allowcontrolledvocabulary bool 1 √ null
allowmultiples bool 1 √ null
description text 2147483647 √ null
displayformat varchar 255 √ null
displayoncreate bool 1 √ null
displayorder int4 10 √ null
facetable bool 1 √ null
fieldtype varchar 255 null
name text 2147483647 √ null
required bool 1 √ null
title text 2147483647 √ null
uri text 2147483647 √ null
validationformat varchar 255 √ null
watermark varchar 255 √ null
metadatablock_id int8 19 √ null
metadatablock.id fk_datasetfieldtype_metadatablock_idR
parentdatasetfieldtype_id int8 19 √ null
datasetfieldtype.id fk_datasetfieldtype_parentdatasetfieldtype_idR

Indexes

Constraint Name Type Sort Column(s)
datasetfieldtype_pkey Primary key Asc id
datasetfieldtype_name_key Must be unique Asc name
index_datasetfieldtype_metadatablock_id Performance Asc metadatablock_id
index_datasetfieldtype_parentdatasetfieldtype_id Performance Asc parentdatasetfieldtype_id

Relationships

Close relationships within degrees of separation