result

5928052 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
result_num serial 10 √ nextval('result_result_num_seq'::regclass)
numeric_data.result_num fk_numeric_data_resultR
related_result.related_result_num fk_related_result_num_result_numR
related_result.result_num fk_related_result_resultR
result_annotation.result_num fk_result_annotation_result_numR
text_data.result_num fk_text_data_resultC
result_uuid uuid 2147483647 null
feature_action_num int4 10 null
feature_action.feature_action_num fk_result_feature_actionR
result_type_num int4 10 null
result_type.result_type_num fk_result_result_typeR

Points to Measurement,Temporal Observation,Count Observation,Truth Observation,Category Observation,Time Series Coverage,Point Coverage,Profile Converage
variable_num int4 10 null
variable.variable_num fk_result_variableR
taxonomic_classifier_num int4 10 √ null
taxonomic_classifier.taxonomic_classifier_num fk_result_taxonomic_classifierR
processing_level_num int4 10 null
processing_level.processing_level_num fk_result_processing_levelR

1: Raw data, etc.
result_date_time timestamp 29,6 √ null
result_date_time_utc_offset int4 10 √ null
valid_time_period varchar 512 √ null
status varchar 256 √ null
value_count int4 10 null
value_type varchar 8 null

array,text,numeric,novalue
intended_observation_spacing float8 17,17 √ null
reference_material_value_num int4 10 √ null
reference_material_value.reference_material_value_num fk_result_reference_material_valueR

point to normalization value table

Indexes

Constraint Name Type Sort Column(s)
result_pkey Primary key Asc result_num
result_fa_num_idx Performance Asc feature_action_num
result_result_uuid_key Must be unique Asc result_uuid
result_v_num_idx Performance Asc variable_num
result_variable_num_idx Performance Asc variable_num
uc_result Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc feature_action_num + result_type_num + variable_num + taxonomic_classifier_num + processing_level_num + result_date_time + result_date_time_utc_offset + valid_time_period + intended_observation_spacing + reference_material_value_num

Relationships

Close relationships within degrees of separation