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[]))
oats_conditions	avcon_1238100890_secur_000	((security_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))
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[]))
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[]))
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[]))