sampling_feature

825305 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sampling_feature_num serial 10 √ nextval('sampling_feature_sampling_feature_num_seq'::regclass)
feature_action.sampling_feature_num fk_feature_action_result_sampling_featureR
feature_of_interest.sampling_feature_num fk_feature_of_interest_sampling_featureR
related_feature.related_sampling_feature_num fk_related_parent_sampling_feature_numR
related_feature.sampling_feature_num fk_current_sampling_feature_numR
sampling_feature_annotation.sampling_feature_num fk_sampling_feature_annotation_sampling_feature_numR
sampling_feature_external_identifier.sample_feature_num sampling_feature_external_identifier_sample_feature_num_fkeyR
sampling_feature_taxonomic_classifier.sampling_feature_num fk_sampling_feature_taxonomic_classifier_sampling_featureR
specimen.sampling_feature_num specimen_sampling_feature_num_fkeyR
sampling_feature_type_num int4 10 null
sampling_feature_type.sampling_feature_type_num fk_sampling_feature_sampling_feature_typeR
sampling_feature_code varchar 50 null
sampling_feature_name varchar 256 √ null
sampling_feature_description varchar 2000 √ null
sampling_feature_geotype varchar 16 √ null

Eg: LINESTRING, POLYGON, MULTIPOINT,POINT
feature_geometry geometry 2147483647 √ null
elevation_min float8 17,17 √ null

meter as unit
elevation_datum varchar 256 √ null
elevation_max float8 17,17 √ null

Indexes

Constraint Name Type Sort Column(s)
sampling_feature_pkey Primary key Asc sampling_feature_num
uc_sampling_feature_type_num_code_idx Must be unique Asc/Asc sampling_feature_type_num + sampling_feature_code

Relationships

Close relationships within degrees of separation