terraware Database

Table	Constraint Name	Constraint
species	species_common_name_check	((common_name !~ similar_to_escape(' *'::text)))
species	species_family_name_check	((family_name !~ similar_to_escape(' *'::text)))
organizations	country_code_matches_subdivision	(((country_subdivision_code IS NULL) OR (substr(country_subdivision_code, 1, 2) = country_code)))
organizations	organizations_country_code_check	((country_code !~ similar_to_escape(' *'::text)))
organizations	organizations_country_subdivision_code_check	((country_subdivision_code !~ similar_to_escape(' *'::text)))
organizations	organizations_description_check	((description !~ similar_to_escape(' *'::text)))
organizations	other_type_details_null_or_not_empty	(((organization_type_details IS NULL) OR ((organization_type_details)::text <> ''::text)))
organizations	other_type_details_only_for_other	((((organization_type_details IS NULL) AND (organization_type_id <> 6)) OR ((organization_type_details IS NOT NULL) AND (organization_type_id = 6))))
reports	cannot_submit_while_locked	(((locked_time IS NULL) OR (submitted_time IS NULL)))
reports	locked_by_and_time_both_set	((((locked_by IS NULL) AND (locked_time IS NULL)) OR ((locked_by IS NOT NULL) AND (locked_time IS NOT NULL))))
reports	quarter_in_range	(((quarter >= 1) AND (quarter <= 4)))
reports	status_reflects_locked	((((locked_by IS NULL) AND (status_id <> 3)) OR ((locked_by IS NOT NULL) AND (status_id = 3))))
reports	status_reflects_submitted	((((submitted_by IS NULL) AND (status_id <> 4)) OR ((submitted_by IS NOT NULL) AND (status_id = 4))))
reports	submitted_by_and_time_both_set	((((submitted_by IS NULL) AND (submitted_time IS NULL)) OR ((submitted_by IS NOT NULL) AND (submitted_time IS NOT NULL))))
countries	countries_code_caps	((code = upper(code)))
countries	countries_code_length	((length(code) = 2))
device_templates	device_templates_address_check	((address !~ similar_to_escape(' *'::text)))
device_templates	device_templates_description_check	((description !~ similar_to_escape(' *'::text)))
device_templates	device_templates_protocol_check	((protocol !~ similar_to_escape(' *'::text)))
files	content_type_cannot_be_empty_string	((length(content_type) > 0))
files	file_name_cannot_be_empty_string	((length(file_name) > 0))
country_subdivisions	country_subdivisions_code_length	(((length(code) >= 4) AND (length(code) <= 6)))
country_subdivisions	country_subdivisions_code_matches_country	((substr(code, 1, 2) = country_code))
upload_problems	upload_problems_field_check	((field !~ similar_to_escape(' *'::text)))
upload_problems	upload_problems_message_check	((message !~ similar_to_escape(' *'::text)))
upload_problems	upload_problems_value_check	((value !~ similar_to_escape(' *'::text)))
users	users_auth_id_check	((auth_id !~ similar_to_escape(' *'::text)))
users	users_first_name_check	((first_name !~ similar_to_escape(' *'::text)))
users	users_last_name_check	((last_name !~ similar_to_escape(' *'::text)))
automations	automations_description_check	((description !~ similar_to_escape(' *'::text)))
automations	automations_timeseries_name_check	((timeseries_name !~ similar_to_escape(' *'::text)))
species_problems	species_problems_suggested_value_check	((suggested_value !~ similar_to_escape(' *'::text)))
facilities	facilities_description_check	((description !~ similar_to_escape(' *'::text)))
device_managers	device_managers_user_iff_facility	((((user_id IS NOT NULL) AND (facility_id IS NOT NULL)) OR ((user_id IS NULL) AND (facility_id IS NULL))))
devices	devices_address_check	((address !~ similar_to_escape(' *'::text)))
devices	devices_protocol_check	((protocol !~ similar_to_escape(' *'::text)))
timeseries	timeseries_decimal_places_check	((decimal_places >= 0))
timeseries	timeseries_units_check	((units !~ similar_to_escape(' *'::text)))