controlledvocabularyvalue

831 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('controlledvocabularyvalue_id_seq'::regclass)
controlledvocabalternate.controlledvocabularyvalue_id fk_controlledvocabalternate_controlledvocabularyvalue_idR
datasetfield_controlledvocabularyvalue.controlledvocabularyvalues_id dtasetfieldcontrolledvocabularyvaluecntrolledvocabularyvaluesidR
dataversesubjects.controlledvocabularyvalue_id fk_dataversesubjects_controlledvocabularyvalue_idR
displayorder int4 10 √ null
identifier varchar 255 √ null
strvalue text 2147483647 √ null
datasetfieldtype_id int8 19 √ null
datasetfieldtype.id fk_controlledvocabularyvalue_datasetfieldtype_idR

Indexes

Constraint Name Type Sort Column(s)
controlledvocabularyvalue_pkey Primary key Asc id
index_controlledvocabularyvalue_datasetfieldtype_id Performance Asc datasetfieldtype_id
index_controlledvocabularyvalue_displayorder Performance Asc displayorder

Relationships

Close relationships within degrees of separation