datasetfield

890 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('datasetfield_id_seq'::regclass)
datasetfield_controlledvocabularyvalue.datasetfield_id fk_datasetfield_controlledvocabularyvalue_datasetfield_idR
datasetfieldcompoundvalue.parentdatasetfield_id fk_datasetfieldcompoundvalue_parentdatasetfield_idR
datasetfieldvalue.datasetfield_id fk_datasetfieldvalue_datasetfield_idR
datasetfieldtype_id int8 19 null
datasetfieldtype.id fk_datasetfield_datasetfieldtype_idR
datasetversion_id int8 19 √ null
datasetversion.id fk_datasetfield_datasetversion_idR
parentdatasetfieldcompoundvalue_id int8 19 √ null
datasetfieldcompoundvalue.id fk_datasetfield_parentdatasetfieldcompoundvalue_idR
template_id int8 19 √ null
template.id fk_datasetfield_template_idR

Indexes

Constraint Name Type Sort Column(s)
datasetfield_pkey Primary key Asc id
index_datasetfield_datasetfieldtype_id Performance Asc datasetfieldtype_id
index_datasetfield_datasetversion_id Performance Asc datasetversion_id
index_datasetfield_parentdatasetfieldcompoundvalue_id Performance Asc parentdatasetfieldcompoundvalue_id
index_datasetfield_template_id Performance Asc template_id

Relationships

Close relationships within degrees of separation