related_feature

792610 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
related_feature_num serial 10 nextval('related_feature_related_feature_num_seq'::regclass)
sampling_feature_num int4 10 null
sampling_feature.sampling_feature_num fk_current_sampling_feature_numR
relationship_type_num int4 10 null
relationship_type.relationship_type_num fk_related_feature_relationship_typeR
related_sampling_feature_num int4 10 null
sampling_feature.sampling_feature_num fk_related_parent_sampling_feature_numR
spatial_offset_num int4 10 null
spatial_offset.spatial_offset_num fk_feature_parent_spatial_offsetR

Indexes

Constraint Name Type Sort Column(s)
related_feature_pkey Primary key Asc related_feature_num
rf_sf_num_idx Performance Asc sampling_feature_num
uc_related_feature Must be unique Asc/Asc/Asc sampling_feature_num + relationship_type_num + related_sampling_feature_num

Relationships