Table dvnDb.public.datavariable Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id serial 10  √  nextval('datavariable_id_seq'::regclass)
datavariablemapping.datavariable_id fk_datavariablemapping_datavariable_id R
summarystatistic.datavariable_id fk_summarystatistic_datavariable_id R
variablecategory.datavariable_id fk_variablecategory_datavariable_id R
variablerange.datavariable_id fk_variablerange_datavariable_id R
variablerangeitem.datavariable_id fk_variablerangeitem_datavariable_id R
weightedvarrelationship.variable_id fk_weightedvarrelationship_variable_id R
weightedvarrelationship.weighted_variable_id fk_weightedvarrelationship_weighted_variable_id R
concept varchar 255  √  null
fileendposition int8 19  √  null
fileorder int4 10  √  null
filestartposition int8 19  √  null
formatcategory varchar 255  √  null
formatschema varchar 255  √  null
formatschemaname varchar 255  √  null
label text 2147483647  √  null
name varchar 255  √  null
numberofdecimalpoints int8 19  √  null
orderedfactor bool 1  √  null
questiontext text 2147483647  √  null
recordsegmentnumber int8 19  √  null
unf varchar 255  √  null
universe varchar 255  √  null
version int8 19  √  null
weighted bool 1  √  null
datatable_id int8 19
datatable.id fk_datavariable_datatable_id R
variableformattype_id int8 19
variableformattype.id fk_datavariable_variableformattype_id R
variableintervaltype_id int8 19  √  null
variableintervaltype.id fk_datavariable_variableintervaltype_id R

Table contained 0 rows at Fri May 30 15:33 MDT 2014

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc datavariable_pkey
datatable_id Performance Asc datavariable_datatable_id_index
id Performance Asc datavariable_id_index

Close relationships  within of separation: