spatial_offset

0 rows


Description

depth_interval

Columns

Column Type Size Nulls Auto Default Children Parents Comments
spatial_offset_num serial 10 √ nextval('spatial_offset_spatial_offset_num_seq'::regclass)
related_feature.spatial_offset_num fk_feature_parent_spatial_offsetR
spatial_offset_type_num int4 10 null
spatial_offset_type.spatial_offset_type_num fk_spatial_offset_spatial_offset_typeR
offset1_value float8 17,17 null
offset1_unit_num int4 10 null
unit.unit_num fk_spatial_offset1_unitR
offset2_value float8 17,17 √ null
offset2_unit_num int4 10 √ null
unit.unit_num fk_spatial_offset2_unitR
offset3_value float8 17,17 √ null
offset3_unit_num int4 10 √ null
unit.unit_num fk_spatial_offset3_unitR

Indexes

Constraint Name Type Sort Column(s)
spatial_offset_pkey Primary key Asc spatial_offset_num
uc_spatial_offset Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc spatial_offset_type_num + offset1_value + offset1_unit_num + offset2_value + offset2_unit_num + offset3_value + offset3_unit_num

Relationships

Close relationships within degrees of separation