unit

71 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
unit_num serial 10 √ nextval('unit_unit_num_seq'::regclass)
numeric_data.unit_num fk_numeric_data_unitR
reference_material_value.unit_num fk_reference_material_value_unitR
spatial_offset.offset1_unit_num fk_spatial_offset1_unitR
spatial_offset.offset2_unit_num fk_spatial_offset2_unitR
spatial_offset.offset3_unit_num fk_spatial_offset3_unitR
unit_type varchar 16 null
unit_abbreviation varchar 16 null
unit_name varchar 256 null

Indexes

Constraint Name Type Sort Column(s)
unit_pkey Primary key Asc unit_num
uc_unit Must be unique Asc/Asc unit_type + unit_abbreviation
uc_unit_name Must be unique Asc unit_name

Relationships

Close relationships within degrees of separation