postgres.oats

Table	Constraint Name	Constraint
oats_issues	avcon_1238100890_issu__000	(((issu_type)::text = ANY ((ARRAY['INQ'::character varying, 'CMP'::character varying])::text[])))
oats_issues	avcon_1238100890_recom_000	(((recommend_land_remediation_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_issues	avcon_1238100890_remed_000	(((remediation_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_issues	avcon_1238100890_swo_c_000	(((swo_complied_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_issues	oats_issu_chk	(((((issu_type)::text = 'CMP'::text) AND (inquiry_code IS NULL) AND (complaint_code IS NOT NULL)) OR (((issu_type)::text = 'INQ'::text) AND (inquiry_code IS NOT NULL) AND (complaint_code IS NULL) AND (swo_issued_by IS NULL) AND (swo_issued_by IS NULL) AND (swo_issued_date IS NULL) AND (swo_terms IS NULL) AND (swo_review_requested_date IS NULL) AND (swo_ceo_review_date IS NULL) AND (swo_ceo_review_description IS NULL) AND (swo_ceo_review_result IS NULL) AND (swo_complied_ind IS NULL) AND (recommend_fine_amt IS NULL) AND (recommend_land_remediation_ind IS NULL) AND (ceo_hearing_date IS NULL) AND (ceo_decision_date IS NULL) AND (fine_amt IS NULL) AND (fine_due_date IS NULL) AND (fine_received_date IS NULL) AND (remediation_required_ind IS NULL) AND (remediation_due_date IS NULL) AND (remediation_completion_date IS NULL))))
oats_alr_application_fees	avcon_1362772157_submi_000	(((submit_to_lg_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_appl_meeting_codes	avcon_1238100890_syste_024	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_financial_instrument_cds	avcon_1238100890_exter_000	(((externally_managed_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_financial_instrument_cds	avcon_1238100890_syste_006	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_nonfarm_use_type_codes	avcon_1238100890_syste_004	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_conditions	avcon_1238100890_appro_001	(((approval_dependant_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))) NOT VALID
oats_conditions	avcon_1238100890_secur_000	(((security_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))) NOT VALID
oats_relationship_codes	avcon_1238100890_syste_017	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_subdiv_design_parcels	avcon_1238100890_fully_000	(((fully_in_alr_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_subdiv_design_parcels	avcon_1238100890_remai_000	(((remainder_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_adjacent_land_uses	oats_ause_cd_ck	(((cardinal_direction)::text = ANY ((ARRAY['NORTH'::character varying, 'EAST'::character varying, 'SOUTH'::character varying, 'WEST'::character varying])::text[])))
oats_documents	oats_docu_chk	((((alr_application_id IS NOT NULL) AND (issue_id IS NULL) AND (planning_review_id IS NULL)) OR ((alr_application_id IS NULL) AND (issue_id IS NOT NULL) AND (planning_review_id IS NULL)) OR ((alr_application_id IS NULL) AND (issue_id IS NULL) AND (planning_review_id IS NOT NULL))))
oats_documents	oats_od_alvi_chk	(((app_lg_viewable_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_documents	oats_od_pvi_chk	(((publicly_viewable_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_documents	oats_od_risri_chk	(((referenced_in_staff_rpt_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_organizations	oats_org_chk	(((((org_type)::text = 'BGO'::text) AND (ministry_cd IS NOT NULL) AND (organization_unit_cd IS NOT NULL) AND (alias_name IS NULL)) OR (((org_type)::text = 'NBC'::text) AND (ministry_cd IS NULL) AND (organization_unit_cd IS NULL))))
oats_organizations	oats_org_ot_chk	(((org_type)::text = ANY ((ARRAY['BGO'::character varying, 'NBC'::character varying])::text[])))
oats_alr_appl_decisions	oats_aadc_chk	((((alr_application_id IS NOT NULL) AND (reconsideration_request_id IS NULL)) OR ((alr_application_id IS NULL) AND (reconsideration_request_id IS NOT NULL))))
oats_alr_appl_decisions	oats_aadc_nsri_chk	(((no_statistics_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_appl_decisions	oats_aadc_ori_chk	(((outright_refusal_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_capability_source_codes	avcon_1238100890_syste_019	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_planning_review_codes	avcon_1238100890_syste_021	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_reconsideration_requests	oats_rreq_eii_chk	(((error_information_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_reconsideration_requests	oats_rreq_nii_chk	(((new_information_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_reconsideration_requests	oats_rreq_npi_chk	(((new_proposal_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_reconsideration_requests	oats_rreq_sr_chk	(((staff_recommendation)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying, 'NR'::character varying])::text[])))
oats_planning_acceptance_codes	avcon_1238100890_syste_000	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_persons	avcon_1238100890_per_t_000	(((per_type)::text = ANY ((ARRAY['EMP'::character varying, 'BPA'::character varying])::text[])))
oats_persons	oats_per_chk	(((((per_type)::text = 'BPA'::text) AND (employee_id IS NULL)) OR (((per_type)::text = 'EMP'::text) AND ((employee_id IS NULL) OR (employee_id IS NOT NULL)))))
oats_subject_properties	oats_sbjp_aali_chk	(((alr_application_land_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_subject_properties	oats_sbjp_chk	((((alr_application_id IS NOT NULL) AND (issue_id IS NULL)) OR ((alr_application_id IS NULL) AND (issue_id IS NOT NULL))))
oats_subject_properties	oats_sp_isfi_000	(((farm_land_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_property_owner_type_codes	avcon_1238100890_syste_014	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_financial_institute_codes	avcon_1238100890_syste_013	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_permit_type_codes	avcon_1238100890_syste_002	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_property_interests	oats_prin_ai_chk	(((active_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_property_interests	oats_prin_chk	(((((prin_type)::text = 'CHG'::text) AND (property_owner_type_code IS NULL) AND (land_title_charge_code IS NOT NULL) AND (active_ind IS NULL) AND (charge_nbr IS NOT NULL) AND (charge_desc IS NOT NULL)) OR (((prin_type)::text = 'OWN'::text) AND (person_organization_id IS NOT NULL) AND (property_owner_type_code IS NOT NULL) AND (land_title_charge_code IS NULL) AND (active_ind IS NOT NULL) AND (charge_nbr IS NULL) AND (charge_desc IS NULL)) OR (((prin_type)::text = 'NOOWN'::text) AND (person_organization_id IS NULL) AND (property_owner_type_code IS NOT NULL) AND (active_ind IS NOT NULL))))
oats_property_interests	oats_prin_pt_chk	(((prin_type)::text = ANY ((ARRAY['OWN'::character varying, 'CHG'::character varying, 'NOOWN'::character varying])::text[])))
oats_accomplishment_codes	avcon_1238100890_publi_000	(((published_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_accomplishment_codes	avcon_1238100890_syste_023	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_local_gov_service_codes	avcon_1238100890_syste_001	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_change_codes	oats_alcc_sri_chk	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_committee_decision_codes	avcon_1238100890_syste_005	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_appl_components	oats_apcp_aai_ck	(((agricultural_activities_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_appl_components	oats_apcp_aii_ck	(((alr_impact_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_appl_components	oats_apcp_asi_ck	(((applicationshare_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_appl_components	oats_apcp_chk3	(((((alr_change_code)::text = 'NFU'::text) AND ((nonfarm_use_type_code IS NOT NULL) AND (nonfarm_use_subtype_code IS NOT NULL))) OR ((nonfarm_use_type_code IS NULL) AND (nonfarm_use_subtype_code IS NULL)) OR (((alr_change_code)::text = ANY ((ARRAY['INC'::character varying, 'EXC'::character varying, 'SDV'::character varying, 'SCH'::character varying])::text[])) AND (nonfarm_use_type_code IS NULL) AND (nonfarm_use_subtype_code IS NULL))))
oats_alr_appl_components	oats_apcp_hsi_ck	(((homesite_severance_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_appl_components	oats_apcp_mni_ck	(((material_need_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_appl_components	oats_apcp_oni_ck	(((owners_notified_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_inquiry_codes	avcon_1238100890_syste_008	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_applications	oats_appl_acc_ck	(((application_class_code)::text = ANY ((ARRAY['LOA'::character varying, 'BLK'::character varying, 'SCH'::character varying, 'NOI'::character varying, 'NAN'::character varying])::text[])))
oats_alr_applications	oats_appl_api_ck	(((agrologist_plan_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_applications	oats_appl_fni_ck	(((followup_noi_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_applications	oats_appl_fwi_ck	(((fee_waived_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_applications	oats_appl_mni_ck	(((ministry_notice_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_applications	oats_appl_ospi_ck	(((on_site_processing_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_applications	oats_appl_sfwlgi_ck	(((split_fee_with_local_gov_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_applications	oats_appl_srw_ck	(((srw_ind)::text = 'Y'::text))
oats_local_gov_action_codes	avcon_1238100890_syste_016	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_committee_type_codes	avcon_1238100890_syste_022	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_payment_type_codes	avcon_1238100900_syste_013	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))) NOT VALID
oats_complaint_codes	avcon_1238100890_syste_020	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_planning_reviews	avcon_1238100890_gis_c_000	(((gis_created_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_planning_reviews	avcon_1238100890_open__000	(((open_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_land_title_charge_codes	avcon_1238100890_syste_011	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_financial_instruments	avcon_1238100890_auto__000	(((auto_renew_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying, NULL::character varying])::text[]))) NOT VALID
oats_local_government_reports	avcon_1362772157_autho_000	(((authorization_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_local_government_reports	avcon_1362772157_commu_000	(((community_pln_compliance_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying, 'X'::character varying])::text[])))
oats_local_government_reports	avcon_1362772157_zonin_000	(((zoning_compliance_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying, 'X'::character varying])::text[])))
oats_nonfarm_use_subtype_codes	avcon_1238100890_syste_015	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_document_codes	oats_docd_pvi_chk	(((publicly_viewable_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_document_codes	oats_docd_sri_chk	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_alr_appl_role_codes	avcon_1238100890_syste_003	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_planning_decisions	avcon_1238100890_decis_000	(((decision_source)::text = ANY ((ARRAY['STAF'::character varying, 'COMM'::character varying])::text[])))
oats_agri_capability_codes	avcon_1238100890_syste_010	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_application_class_codes	avcon_1238100890_appli_001	(((application_class_code)::text = ANY ((ARRAY['LOA'::character varying, 'BLK'::character varying, 'SCH'::character varying, 'NOI'::character varying, 'NAN'::character varying])::text[])))
oats_application_class_codes	avcon_1238100890_syste_025	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_complaint_appeals	avcon_1238100890_uphel_000	(((upheld_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_condition_codes	avcon_1238100890_syste_009	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_related_alr_applications	avcon_1238100890_inclu_000	(((include_in_staff_report_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_soil_change_codes	avcon_1238100890_syste_012	(((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))