datasetfield

860 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_id R
datasetfieldcompoundvalue.parentdatasetfield_id fk_datasetfieldcompoundvalue_parentdatasetfield_id R
datasetfieldvalue.datasetfield_id fk_datasetfieldvalue_datasetfield_id R
datasetfieldtype_id int8 19 null
datasetfieldtype.id fk_datasetfield_datasetfieldtype_id R
datasetversion_id int8 19 √ null
datasetversion.id fk_datasetfield_datasetversion_id R
parentdatasetfieldcompoundvalue_id int8 19 √ null
datasetfieldcompoundvalue.id fk_datasetfield_parentdatasetfieldcompoundvalue_id R
template_id int8 19 √ null
template.id fk_datasetfield_template_id R

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