sampling_feature_type

48 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sampling_feature_type_num serial 10 nextval('sampling_feature_type_sampling_feature_type_num_seq'::regclass)
sampling_feature.sampling_feature_type_num fk_sampling_feature_sampling_feature_typeR
sampling_feature_type.sampling_feature_parent_type_num sampling_feature_type_sampling_feature_parent_type_num_fkey1R
v_analyzed_samples.sampling_feature_type_num Implied ConstraintR
v_specimens.sampling_feature_type_num Implied ConstraintR
v_stations.sampling_feature_type_num Implied ConstraintR
sampling_feature_type_name varchar 256 null
sampling_feature_type_category varchar 256 null
sampling_feature_type_description varchar 2000 null
sampling_feature_parent_type_num int4 10 null
sampling_feature_type.sampling_feature_type_num sampling_feature_type_sampling_feature_parent_type_num_fkey1R

Indexes

Constraint Name Type Sort Column(s)
sampling_feature_type_pkey Primary key Asc sampling_feature_type_num
uc_sampling_feature_type Must be unique Asc sampling_feature_type_name

Relationships