Constraints

16 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
dataprofile_submission_fkey
data_profile.submission_id
submission.submission_id
Restrict delete
dataprofile_dataposition_fkey
data_profile.submission_id
data_profile.tag_id
data_profile.position_date_time
data_position.submission_id
data_position.tag_id
data_position.date_time
Restrict delete
dataprofile_observationtypes_fkey
data_profile.variable_id
observation_types.variable_id
Restrict delete
data_time_series_data_submission_id_fkey
data_time_series.submission_id
submission.submission_id
Restrict delete
datetimeseries_datapositions_fkey
data_time_series.submission_id
data_time_series.tag_id
data_time_series.position_date_time
data_position.submission_id
data_position.tag_id
data_position.date_time
Restrict delete
data_time_series_variable_id_fkey
data_time_series.variable_id
observation_types.variable_id
Restrict delete
datahistogrambindata_observationtypes_fkey
data_histogram_bin_data.variable_id
observation_types.variable_id
Restrict delete
histogrambindata_dataposition_fkey
data_histogram_bin_data.submission_id
data_histogram_bin_data.tag_id
data_histogram_bin_data.position_date_time
data_position.submission_id
data_position.tag_id
data_position.date_time
Restrict delete
histogrambindata_histogrambininfo_fkey
data_histogram_bin_data.bin_id
data_histogram_bin_data.bin_class
data_histogram_bin_info.bin_id
data_histogram_bin_info.bin_class
Restrict delete
data_histogram_bin_data_submission_id_fkey
data_histogram_bin_data.submission_id
submission.submission_id
Cascade on delete
data_position_submission_id_fkey
data_position.submission_id
submission.submission_id
Cascade on delete
data_histogram_bin_info
data_histogram_bin_info.variable_id
observation_types.variable_id
Restrict delete
metadata_submission_id_fkey
metadata.submission_id
submission.submission_id
Cascade on delete
metadata_attribute_id_fkey
metadata.attribute_id
metadata_types.attribute_id
Restrict delete
proc_observations_submission_id_fkey
proc_observations.submission_id
submission.submission_id
Cascade on delete
proc_observations_variable_id_fkey
proc_observations.variable_id
observation_types.variable_id
Restrict delete

Check Constraints

Table Constraint Name Constraint