Skip to content

Instantly share code, notes, and snippets.

@luqmaan

luqmaan/tcadschema.sql

Last active March 22, 2016 15:48
Show Gist options
  • Save luqmaan/37191863d35967443269 to your computer and use it in GitHub Desktop.
Save luqmaan/37191863d35967443269 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
tcadschema.sql
-- Table structure for table `abs_subd`
--
DROP TABLE IF EXISTS `abs_subd`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `abs_subd` (
`abs_subdv_cd` varchar(10) DEFAULT NULL,
`abs_subdv_desc` varchar(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `abs_subd`
-- Table structure for table `agent`
--
DROP TABLE IF EXISTS `agent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agent` (
`agent_id` int(12) DEFAULT NULL,
`agent_name` varchar(70) DEFAULT NULL,
`agent_addr_line1` varchar(60) DEFAULT NULL,
`agent_addr_line2` varchar(60) DEFAULT NULL,
`agent_addr_line3` varchar(60) DEFAULT NULL,
`agent_city` varchar(50) DEFAULT NULL,
`agent_state` varchar(50) DEFAULT NULL,
`agent_country` varchar(5) DEFAULT NULL,
`agent_zip` varchar(5) DEFAULT NULL,
`agent_zip_cass` varchar(4) DEFAULT NULL,
`agent_zip_rt` varchar(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `agent`
-- Table structure for table `appr_hdr`
--
DROP TABLE IF EXISTS `appr_hdr`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `appr_hdr` (
`run_date_time` varchar(16) DEFAULT NULL,
`file_description` varchar(40) DEFAULT NULL,
`appraisal_year` float DEFAULT NULL,
`supplement_number` float DEFAULT NULL,
`entity_code` varchar(10) DEFAULT NULL,
`entity_description` varchar(40) DEFAULT NULL,
`office_name` varchar(30) DEFAULT NULL,
`operator` varchar(20) DEFAULT NULL,
`pacs_version` varchar(10) DEFAULT NULL,
`export_version` varchar(10) DEFAULT NULL,
`value_option` varchar(10) DEFAULT NULL,
`office_use_only` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `appr_hdr`
-- Table structure for table `arb`
--
DROP TABLE IF EXISTS `arb`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `arb` (
`prop_id` int(12) DEFAULT NULL,
`prop_val_yr` float DEFAULT NULL,
`geo_id` varchar(50) DEFAULT NULL,
`ref_id1` varchar(25) DEFAULT NULL,
`ref_id2` varchar(25) DEFAULT NULL,
`arb_status` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `arb`
-- Table structure for table `arbitration`
--
DROP TABLE IF EXISTS `arbitration`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `arbitration` (
`prop_id` int(12) DEFAULT NULL,
`prop_val_yr` float DEFAULT NULL,
`geo_id` varchar(50) DEFAULT NULL,
`ref_id1` varchar(25) DEFAULT NULL,
`ref_id2` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `arbitration`
-- Table structure for table `country`
--
DROP TABLE IF EXISTS `country`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `country` (
`country_cd` varchar(5) DEFAULT NULL,
`country_name` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `country`
-- Table structure for table `entity`
--
DROP TABLE IF EXISTS `entity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity` (
`entity_id` int(12) DEFAULT NULL,
`entity_cd` varchar(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `entity`
-- Table structure for table `imp_atr`
--
DROP TABLE IF EXISTS `imp_atr`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `imp_atr` (
`prop_id` int(12) DEFAULT NULL,
`prop_val_yr` float DEFAULT NULL,
`imprv_id` int(12) DEFAULT NULL,
`imprv_det_id` int(12) DEFAULT NULL,
`imprv_attr_id` int(12) DEFAULT NULL,
`imprv_attr_desc` varchar(25) DEFAULT NULL,
`imprv_attr_cd` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `imp_atr`
-- Table structure for table `imp_det`
--
DROP TABLE IF EXISTS `imp_det`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `imp_det` (
`prop_id` int(12) DEFAULT NULL,
`prop_val_yr` float DEFAULT NULL,
`imprv_id` int(12) DEFAULT NULL,
`imprv_det_id` int(12) DEFAULT NULL,
`imprv_det_type_cd` varchar(10) DEFAULT NULL,
`imprv_det_type_desc` varchar(25) DEFAULT NULL,
`imprv_det_class_cd` varchar(10) DEFAULT NULL,
`yr_built` float DEFAULT NULL,
`depreciation_yr` float DEFAULT NULL,
`imprv_det_area` float DEFAULT NULL,
`imprv_det_val` float DEFAULT NULL,
`sketch_cmds` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `imp_det`
-- Table structure for table `imp_info`
--
DROP TABLE IF EXISTS `imp_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `imp_info` (
`prop_id` int(12) DEFAULT NULL,
`prop_val_yr` float DEFAULT NULL,
`imprv_id` int(12) DEFAULT NULL,
`imprv_type_cd` varchar(10) DEFAULT NULL,
`imprv_type_desc` varchar(25) DEFAULT NULL,
`imprv_state_cd` varchar(5) DEFAULT NULL,
`imprv_homesite` varchar(1) DEFAULT NULL,
`imprv_val` float DEFAULT NULL,
`imprv_homesite_pct` float DEFAULT NULL,
`omitted` varchar(1) DEFAULT NULL,
`omitted_imprv_val` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `imp_info`
-- Table structure for table `land_det`
--
DROP TABLE IF EXISTS `land_det`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `land_det` (
`prop_id` int(12) DEFAULT NULL,
`prop_val_yr` float DEFAULT NULL,
`land_seg_id` int(12) DEFAULT NULL,
`land_type_cd` varchar(10) DEFAULT NULL,
`land_type_desc` varchar(25) DEFAULT NULL,
`state_cd` varchar(5) DEFAULT NULL,
`land_seg_homesite` varchar(1) DEFAULT NULL,
`size_acres` float DEFAULT NULL,
`size_square_feet` float DEFAULT NULL,
`effective_front` float DEFAULT NULL,
`effective_depth` float DEFAULT NULL,
`mkt_ls_method` varchar(5) DEFAULT NULL,
`mkt_ls_class` varchar(10) DEFAULT NULL,
`land_seg_mkt_val` float DEFAULT NULL,
`ag_apply` varchar(1) DEFAULT NULL,
`ag_ls_method` varchar(5) DEFAULT NULL,
`ag_ls_class` varchar(10) DEFAULT NULL,
`ag_value` float DEFAULT NULL,
`land_homesite_pct` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `land_det`
-- Table structure for table `lawsuit`
--
DROP TABLE IF EXISTS `lawsuit`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lawsuit` (
`prop_id` int(12) DEFAULT NULL,
`prop_val_yr` float DEFAULT NULL,
`geo_id` varchar(50) DEFAULT NULL,
`ref_id1` varchar(25) DEFAULT NULL,
`ref_id2` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `lawsuit`
-- Table structure for table `mobile_home_info`
--
DROP TABLE IF EXISTS `mobile_home_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mobile_home_info` (
`prop_id` int(12) DEFAULT NULL,
`prop_val_yr` float DEFAULT NULL,
`imprv_id` int(12) DEFAULT NULL,
`mbl_hm_make` varchar(100) DEFAULT NULL,
`mbl_hm_model` varchar(100) DEFAULT NULL,
`mbl_hm_title_num` varchar(100) DEFAULT NULL,
`mbl_hm_sn` varchar(100) DEFAULT NULL,
`mbl_hm_hud_num` varchar(100) DEFAULT NULL,
`mbl_hm_sn_2` varchar(100) DEFAULT NULL,
`mbl_hm_hud_num_2` varchar(100) DEFAULT NULL,
`mbl_hm_sn_3` varchar(100) DEFAULT NULL,
`mbl_hm_hud_num_3` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mobile_home_info`
-- Table structure for table `prop`
--
DROP TABLE IF EXISTS `prop`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `prop` (
`prop_id` int(12) DEFAULT NULL,
`prop_type_cd` varchar(5) DEFAULT NULL,
`prop_val_yr` float DEFAULT NULL,
`sup_num` int(12) DEFAULT NULL,
`geo_id` varchar(50) DEFAULT NULL,
`py_owner_id` int(12) DEFAULT NULL,
`py_owner_name` varchar(70) DEFAULT NULL,
`partial_owner` varchar(1) DEFAULT NULL,
`udi_group` int(12) DEFAULT NULL,
`py_addr_city` varchar(50) DEFAULT NULL,
`py_addr_state` varchar(50) DEFAULT NULL,
`py_addr_country` varchar(5) DEFAULT NULL,
`py_addr_zip` varchar(5) DEFAULT NULL,
`py_addr_zip_cass` varchar(4) DEFAULT NULL,
`py_addr_zip_rt` varchar(2) DEFAULT NULL,
`py_confidential_flag` varchar(1) DEFAULT NULL,
`py_address_suppress_flag` varchar(1) DEFAULT NULL,
`py_addr_ml_deliverable` varchar(1) DEFAULT NULL,
`situs_street_prefx` varchar(10) DEFAULT NULL,
`situs_street` varchar(50) DEFAULT NULL,
`situs_street_suffix` varchar(10) DEFAULT NULL,
`situs_city` varchar(30) DEFAULT NULL,
`situs_zip` varchar(10) DEFAULT NULL,
`legal_desc` mediumtext,
`legal_desc2` mediumtext,
`legal_acreage` float DEFAULT NULL,
`abs_subdv_cd` varchar(10) DEFAULT NULL,
`hood_cd` varchar(10) DEFAULT NULL,
`block` varchar(50) DEFAULT NULL,
`tract_or_lot` varchar(50) DEFAULT NULL,
`land_hstd_val` float DEFAULT NULL,
`land_non_hstd_val` float DEFAULT NULL,
`imprv_hstd_val` float DEFAULT NULL,
`imprv_non_hstd_val` float DEFAULT NULL,
`ag_use_val` float DEFAULT NULL,
`ag_market` float DEFAULT NULL,
`appraised_val` float DEFAULT NULL,
`ten_percent_cap` float DEFAULT NULL,
`assessed_val` float DEFAULT NULL,
`arb_protest_flag` varchar(1) DEFAULT NULL,
`deed_dt` varchar(25) DEFAULT NULL,
`mortgage_co_id` int(12) DEFAULT NULL,
`mortage_co_name` varchar(70) DEFAULT NULL,
`jan1_owner_id` int(12) DEFAULT NULL,
`jan1_owner_name` varchar(70) DEFAULT NULL,
`jan1_addr_line1` varchar(60) DEFAULT NULL,
`jan1_addr_line2` varchar(60) DEFAULT NULL,
`jan1_addr_line3` varchar(60) DEFAULT NULL,
`jan1_addr_city` varchar(50) DEFAULT NULL,
`jan1_addr_state` varchar(50) DEFAULT NULL,
`jan1_addr_country` varchar(5) DEFAULT NULL,
`jan1_addr_zip` varchar(5) DEFAULT NULL,
`jan1_addr_zip_cass` varchar(4) DEFAULT NULL,
`jan1_addr_zip_rt` varchar(2) DEFAULT NULL,
`jan1_confidential_flag` varchar(1) DEFAULT NULL,
`jan1_address_suppress_flag` varchar(1) DEFAULT NULL,
`jan1_ml_deliverable` varchar(1) DEFAULT NULL,
`hs_exempt` varchar(1) DEFAULT NULL,
`ov65_exempt` varchar(1) DEFAULT NULL,
`ov65_prorate_begin` varchar(25) DEFAULT NULL,
`ov65_prorate_end` varchar(25) DEFAULT NULL,
`ov65s_exempt` varchar(1) DEFAULT NULL,
`dp_exempt` varchar(1) DEFAULT NULL,
`dv1_exempt` varchar(1) DEFAULT NULL,
`dv1s_exempt` varchar(1) DEFAULT NULL,
`dv2_exempt` varchar(1) DEFAULT NULL,
`dv2s_exempt` varchar(1) DEFAULT NULL,
`dv3_exempt` varchar(1) DEFAULT NULL,
`dv3s_exempt` varchar(1) DEFAULT NULL,
`dv4_exempt` varchar(1) DEFAULT NULL,
`dv4s_exempt` varchar(1) DEFAULT NULL,
`ex_exempt` varchar(1) DEFAULT NULL,
`lve_exempt` varchar(1) DEFAULT NULL,
`ab_exempt` varchar(1) DEFAULT NULL,
`en_exempt` varchar(1) DEFAULT NULL,
`fr_exempt` varchar(1) DEFAULT NULL,
`ht_exempt` varchar(1) DEFAULT NULL,
`pro_exempt` varchar(1) DEFAULT NULL,
`pc_exempt` varchar(1) DEFAULT NULL,
`so_exempt` varchar(1) DEFAULT NULL,
`ex366_exempt` varchar(1) DEFAULT NULL,
`ch_exempt` varchar(1) DEFAULT NULL,
`imprv_state_cd` varchar(10) DEFAULT NULL,
`land_state_cd` varchar(10) DEFAULT NULL,
`personal_state_cd` varchar(10) DEFAULT NULL,
`mineral_state_cd` varchar(10) DEFAULT NULL,
`land_acres` float DEFAULT NULL,
`entity_agent_zip` varchar(5) DEFAULT NULL,
`entity_agent_cass` varchar(4) DEFAULT NULL,
`entity_agent_rt` varchar(2) DEFAULT NULL,
`ca_agent_id` int(12) DEFAULT NULL,
`ca_agent_name` varchar(70) DEFAULT NULL,
`ca_agent_addr_line1` varchar(60) DEFAULT NULL,
`ca_agent_addr_line2` varchar(60) DEFAULT NULL,
`ca_agent_addr_line3` varchar(60) DEFAULT NULL,
`ca_agent_city` varchar(50) DEFAULT NULL,
`ca_agent_state` varchar(50) DEFAULT NULL,
`ca_agent_country` varchar(5) DEFAULT NULL,
`ca_agent_zip` varchar(5) DEFAULT NULL,
`ca_agent_zip_cass` varchar(4) DEFAULT NULL,
`ca_agent_zip_rt` varchar(2) DEFAULT NULL,
`arb_agent_id` int(12) DEFAULT NULL,
`arb_agent_name` varchar(70) DEFAULT NULL,
`arb_agent_addr_line1` varchar(60) DEFAULT NULL,
`arb_agent_addr_line2` varchar(60) DEFAULT NULL,
`arb_agent_addr_line3` varchar(60) DEFAULT NULL,
`arb_agent_city` varchar(50) DEFAULT NULL,
`arb_agent_state` varchar(50) DEFAULT NULL,
`arb_agent_country` varchar(5) DEFAULT NULL,
`arb_agent_zip` varchar(5) DEFAULT NULL,
`arb_agent_zip_cass` varchar(4) DEFAULT NULL,
`arb_agent_zip_rt` varchar(2) DEFAULT NULL,
`mineral_type_of_int` varchar(5) DEFAULT NULL,
`mineral_int_pct` varchar(15) DEFAULT NULL,
`productivity_use_code` varchar(3) DEFAULT NULL,
`timber_78_market` int(12) DEFAULT NULL,
`ag_late_loss` int(12) DEFAULT NULL,
`late_freeport_penalty` int(12) DEFAULT NULL,
`dba` varchar(40) DEFAULT NULL,
`market_value` float DEFAULT NULL,
`ov65_deferral_date` varchar(25) DEFAULT NULL,
`dp_deferral_date` varchar(25) DEFAULT NULL,
`ref_id1` varchar(25) DEFAULT NULL,
`ref_id2` varchar(25) DEFAULT NULL,
`situs_num` varchar(15) DEFAULT NULL,
`situs_unit` varchar(5) DEFAULT NULL,
`appr_owner_id` int(12) DEFAULT NULL,
`appr_owner_name` varchar(70) DEFAULT NULL,
`appr_addr_line1` varchar(60) DEFAULT NULL,
`appr_addr_line2` varchar(60) DEFAULT NULL,
`appr_addr_line3` varchar(60) DEFAULT NULL,
`appr_addr_city` varchar(50) DEFAULT NULL,
`appr_addr_state` varchar(50) DEFAULT NULL,
`appr_addr_country` varchar(5) DEFAULT NULL,
`appr_addr_zip` varchar(5) DEFAULT NULL,
`appr_addr_zip_cass` varchar(4) DEFAULT NULL,
`appr_addr_zip_cass_route` varchar(2) DEFAULT NULL,
`appr_ml_deliverable` varchar(1) DEFAULT NULL,
`appr_confidential_flag` varchar(1) DEFAULT NULL,
`appr_address_suppress_flag` varchar(1) DEFAULT NULL,
`appr_confidential_name` varchar(70) DEFAULT NULL,
`py_confidential_name` varchar(70) DEFAULT NULL,
`jan1_confidential_name` varchar(70) DEFAULT NULL,
`rendition_filed` varchar(1) DEFAULT NULL,
`rendition_date` varchar(25) DEFAULT NULL,
`rendition_penalty` float DEFAULT NULL,
`rendition_penalty_date_paid` varchar(25) DEFAULT NULL,
`rendition_fraud_penalty` float DEFAULT NULL,
`rendition_fraud_penalty_date_paid` varchar(25) DEFAULT NULL,
`entities` varchar(140) DEFAULT NULL,
`eco_exempt` varchar(1) DEFAULT NULL,
`dataset_id` float DEFAULT NULL,
`deed_num` varchar(50) DEFAULT NULL,
`chodo_exempt` varchar(1) DEFAULT NULL,
`local_option_pct_only_flag_hs` varchar(1) DEFAULT NULL,
`local_option_pct_only_flag_ov65` varchar(1) DEFAULT NULL,
`local_option_pct_only_flag_ov65s` varchar(1) DEFAULT NULL,
`local_option_pct_only_flag_dp` varchar(1) DEFAULT NULL,
`freeze_only_flag_ov65` varchar(1) DEFAULT NULL,
`freeze_only_flag_ov65s` varchar(1) DEFAULT NULL,
`freeze_only_flag_dp` varchar(1) DEFAULT NULL,
`apply_percent_exemption_flag` varchar(1) DEFAULT NULL,
`exemption_percentage` float DEFAULT NULL,
`vit_flag` varchar(1) DEFAULT NULL,
`lih_exempt` varchar(1) DEFAULT NULL,
`git_exempt` varchar(1) DEFAULT NULL,
`dps_exempt` varchar(1) DEFAULT NULL,
`dps_deferral_date` varchar(25) DEFAULT NULL,
`local_option_pct_only_flag_dps` varchar(1) DEFAULT NULL,
`freeze_only_flag_dps` varchar(1) DEFAULT NULL,
`dvhs_exempt` varchar(1) DEFAULT NULL,
`hs_qualify_yr` float DEFAULT NULL,
`ov65_qualify_yr` float DEFAULT NULL,
`ov65s_qualify_yr` float DEFAULT NULL,
`dp_qualify_yr` float DEFAULT NULL,
`dps_qualify_yr` float DEFAULT NULL,
`dv1_qualify_yr` float DEFAULT NULL,
`dv1s_qualify_yr` float DEFAULT NULL,
`dv2_qualify_yr` float DEFAULT NULL,
`dv2s_qualify_yr` float DEFAULT NULL,
`dv3_qualify_yr` float DEFAULT NULL,
`dv3s_qualify_yr` float DEFAULT NULL,
`dv4_qualify_yr` float DEFAULT NULL,
`dv4s_qualify_yr` float DEFAULT NULL,
`dvhs_qualify_yr` float DEFAULT NULL,
`ex_qualify_yr` float DEFAULT NULL,
`ab_qualify_yr` float DEFAULT NULL,
`en_qualify_yr` float DEFAULT NULL,
`fr_qualify_yr` float DEFAULT NULL,
`ht_qualify_yr` float DEFAULT NULL,
`pro_qualify_yr` float DEFAULT NULL,
`pc_qualify_yr` float DEFAULT NULL,
`so_qualify_yr` float DEFAULT NULL,
`ex366_qualify_yr` float DEFAULT NULL,
`ch_qualify_yr` float DEFAULT NULL,
`eco_qualify_yr` float DEFAULT NULL,
`chodo_qualify_yr` float DEFAULT NULL,
`lih_qualify_yr` float DEFAULT NULL,
`git_qualify_yr` float DEFAULT NULL,
`mortgage_addr_line1` varchar(60) DEFAULT NULL,
`mortgage_addr_line2` varchar(60) DEFAULT NULL,
`mortgage_addr_line3` varchar(60) DEFAULT NULL,
`mortgage_addr_city` varchar(50) DEFAULT NULL,
`mortgage_addr_state` varchar(50) DEFAULT NULL,
`mortgage_addr_country` varchar(5) DEFAULT NULL,
`mortgage_addr_zip` varchar(5) DEFAULT NULL,
`mortgage_addr_zip_cass` varchar(4) DEFAULT NULL,
`mortgage_addr_zip_rt` varchar(2) DEFAULT NULL,
`mortgage_addr_ml_deliverable` varchar(1) DEFAULT NULL,
`sic_code` varchar(10) DEFAULT NULL,
`omitted_property_flag` varchar(1) DEFAULT NULL,
`hs_prorate_begin` varchar(25) DEFAULT NULL,
`hs_prorate_end` varchar(25) DEFAULT NULL,
`ov65s_prorate_begin` varchar(25) DEFAULT NULL,
`ov65s_prorate_end` varchar(25) DEFAULT NULL,
`dp_prorate_begin` varchar(25) DEFAULT NULL,
`dp_prorate_end` varchar(25) DEFAULT NULL,
`dv1_prorate_begin` varchar(25) DEFAULT NULL,
`dv1_prorate_end` varchar(25) DEFAULT NULL,
`dv1s_prorate_begin` varchar(25) DEFAULT NULL,
`dv1s_prorate_end` varchar(25) DEFAULT NULL,
`dv2_prorate_begin` varchar(25) DEFAULT NULL,
`dv2_prorate_end` varchar(25) DEFAULT NULL,
`dv2s_prorate_begin` varchar(25) DEFAULT NULL,
`dv2s_prorate_end` varchar(25) DEFAULT NULL,
`dv3_prorate_begin` varchar(25) DEFAULT NULL,
`dv3_prorate_end` varchar(25) DEFAULT NULL,
`dv3s_prorate_begin` varchar(25) DEFAULT NULL,
`dv3s_prorate_end` varchar(25) DEFAULT NULL,
`dv4_prorate_begin` varchar(25) DEFAULT NULL,
`dv4_prorate_end` varchar(25) DEFAULT NULL,
`dv4s_prorate_begin` varchar(25) DEFAULT NULL,
`dv4s_prorate_end` varchar(25) DEFAULT NULL,
`lve_prorate_begin` varchar(25) DEFAULT NULL,
`lve_prorate_end` varchar(25) DEFAULT NULL,
`ab_prorate_begin` varchar(25) DEFAULT NULL,
`ab_prorate_end` varchar(25) DEFAULT NULL,
`en_prorate_begin` varchar(25) DEFAULT NULL,
`en_prorate_end` varchar(25) DEFAULT NULL,
`fr_prorate_begin` varchar(25) DEFAULT NULL,
`fr_prorate_end` varchar(25) DEFAULT NULL,
`ht_prorate_begin` varchar(25) DEFAULT NULL,
`ht_prorate_end` varchar(25) DEFAULT NULL,
`pro_prorate_begin` varchar(25) DEFAULT NULL,
`pro_prorate_end` varchar(25) DEFAULT NULL,
`pc_prorate_begin` varchar(25) DEFAULT NULL,
`pc_prorate_end` varchar(25) DEFAULT NULL,
`so_prorate_begin` varchar(25) DEFAULT NULL,
`so_prorate_end` varchar(25) DEFAULT NULL,
`ex366_prorate_begin` varchar(25) DEFAULT NULL,
`ex366_prorate_end` varchar(25) DEFAULT NULL,
`ch_prorate_begin` varchar(25) DEFAULT NULL,
`ch_prorate_end` varchar(25) DEFAULT NULL,
`dps_prorate_begin` varchar(25) DEFAULT NULL,
`dps_prorate_end` varchar(25) DEFAULT NULL,
`eco_prorate_begin` varchar(25) DEFAULT NULL,
`eco_prorate_end` varchar(25) DEFAULT NULL,
`chodo_prorate_begin` varchar(25) DEFAULT NULL,
`chodo_prorate_end` varchar(25) DEFAULT NULL,
`lih_prorate_begin` varchar(25) DEFAULT NULL,
`lih_prorate_end` varchar(25) DEFAULT NULL,
`git_prorate_begin` varchar(25) DEFAULT NULL,
`git_prorate_end` varchar(25) DEFAULT NULL,
`clt_exempt` varchar(1) DEFAULT NULL,
`clt_prorate_begin` varchar(25) DEFAULT NULL,
`clt_prorate_end` varchar(25) DEFAULT NULL,
`clt_qualify_yr` float DEFAULT NULL,
`dvhss_exempt` varchar(1) DEFAULT NULL,
`dvhss_prorate_begin` varchar(25) DEFAULT NULL,
`dvhss_prorate_end` varchar(25) DEFAULT NULL,
`dvhss_qualify_yr` float DEFAULT NULL,
`omitted_imprv_hstd_val` float DEFAULT NULL,
`omitted_imprv_non_hstd_val` float DEFAULT NULL,
`dvhs_prorate_begin` varchar(25) DEFAULT NULL,
`dvhs_prorate_end` varchar(25) DEFAULT NULL,
`ex_xd_exempt` varchar(1) DEFAULT NULL,
`ex_xd_qualify_yr` float DEFAULT NULL,
`ex_xd_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xd_prorate_end` varchar(25) DEFAULT NULL,
`ex_xf_exempt` varchar(1) DEFAULT NULL,
`ex_xf_qualify_yr` float DEFAULT NULL,
`ex_xf_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xf_prorate_end` varchar(25) DEFAULT NULL,
`ex_xg_exempt` varchar(1) DEFAULT NULL,
`ex_xg_qualify_yr` float DEFAULT NULL,
`ex_xg_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xg_prorate_end` varchar(25) DEFAULT NULL,
`ex_xh_exempt` varchar(1) DEFAULT NULL,
`ex_xh_qualify_yr` float DEFAULT NULL,
`ex_xh_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xh_prorate_end` varchar(25) DEFAULT NULL,
`ex_xi_exempt` varchar(1) DEFAULT NULL,
`ex_xi_qualify_yr` float DEFAULT NULL,
`ex_xi_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xi_prorate_end` varchar(25) DEFAULT NULL,
`ex_xj_exempt` varchar(1) DEFAULT NULL,
`ex_xj_qualify_yr` float DEFAULT NULL,
`ex_xj_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xj_prorate_end` varchar(25) DEFAULT NULL,
`ex_xl_exempt` varchar(1) DEFAULT NULL,
`ex_xl_qualify_yr` float DEFAULT NULL,
`ex_xl_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xl_prorate_end` varchar(25) DEFAULT NULL,
`ex_xm_exempt` varchar(1) DEFAULT NULL,
`ex_xm_qualify_yr` float DEFAULT NULL,
`ex_xm_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xm_prorate_end` varchar(25) DEFAULT NULL,
`ex_xn_exempt` varchar(1) DEFAULT NULL,
`ex_xn_qualify_yr` float DEFAULT NULL,
`ex_xn_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xn_prorate_end` varchar(25) DEFAULT NULL,
`ex_xo_exempt` varchar(1) DEFAULT NULL,
`ex_xo_qualify_yr` float DEFAULT NULL,
`ex_xo_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xo_prorate_end` varchar(25) DEFAULT NULL,
`ex_xp_exempt` varchar(1) DEFAULT NULL,
`ex_xp_qualify_yr` float DEFAULT NULL,
`ex_xp_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xp_prorate_end` varchar(25) DEFAULT NULL,
`ex_xq_exempt` varchar(1) DEFAULT NULL,
`ex_xq_qualify_yr` float DEFAULT NULL,
`ex_xq_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xq_prorate_end` varchar(25) DEFAULT NULL,
`ex_xr_exempt` varchar(1) DEFAULT NULL,
`ex_xr_qualify_yr` float DEFAULT NULL,
`ex_xr_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xr_prorate_end` varchar(25) DEFAULT NULL,
`ex_xs_exempt` varchar(1) DEFAULT NULL,
`ex_xs_qualify_yr` float DEFAULT NULL,
`ex_xs_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xs_prorate_end` varchar(25) DEFAULT NULL,
`ex_xt_exempt` varchar(1) DEFAULT NULL,
`ex_xt_qualify_yr` float DEFAULT NULL,
`ex_xt_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xt_prorate_end` varchar(25) DEFAULT NULL,
`ex_xu_exempt` varchar(1) DEFAULT NULL,
`ex_xu_qualify_yr` float DEFAULT NULL,
`ex_xu_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xu_prorate_end` varchar(25) DEFAULT NULL,
`ex_xv_exempt` varchar(1) DEFAULT NULL,
`ex_xv_qualify_yr` float DEFAULT NULL,
`ex_xv_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xv_prorate_end` varchar(25) DEFAULT NULL,
`ex_xa_exempt` varchar(1) DEFAULT NULL,
`ex_xa_qualify_yr` float DEFAULT NULL,
`ex_xa_prorate_begin` varchar(25) DEFAULT NULL,
`ex_xa_prorate_end` varchar(25) DEFAULT NULL,
`lve_qualify_yr` float DEFAULT NULL,
`ppv_exempt` varchar(1) DEFAULT NULL,
`ppv_qualify_yr` float DEFAULT NULL,
`ppv_prorate_begin` varchar(25) DEFAULT NULL,
`ppv_prorate_end` varchar(25) DEFAULT NULL,
`dvch_exempt` varchar(1) DEFAULT NULL,
`dvch_qualify_yr` float DEFAULT NULL,
`dvch_prorate_begin` varchar(25) DEFAULT NULL,
`dvch_prorate_end` varchar(25) DEFAULT NULL,
`dvchs_exempt` varchar(1) DEFAULT NULL,
`dvchs_qualify_yr` float DEFAULT NULL,
`dvchs_prorate_begin` varchar(25) DEFAULT NULL,
`dvchs_prorate_end` varchar(25) DEFAULT NULL,
`masss_exempt` varchar(1) DEFAULT NULL,
`masss_qualify_yr` float DEFAULT NULL,
`masss_prorate_begin` varchar(25) DEFAULT NULL,
`masss_prorate_end` varchar(25) DEFAULT NULL,
`pp_late_interstate_allocation_val` float DEFAULT NULL,
KEY `appr_addr_zip_ind` (`appr_addr_zip`),
KEY `assessed_val_ind` (`assessed_val`),
KEY `appraised_val_ind` (`appraised_val`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `prop`
-- Table structure for table `prop_ent`
--
DROP TABLE IF EXISTS `prop_ent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `prop_ent` (
`prop_id` int(12) DEFAULT NULL,
`prop_val_yr` float DEFAULT NULL,
`sup_num` int(12) DEFAULT NULL,
`owner_id` int(12) DEFAULT NULL,
`entity_id` int(12) DEFAULT NULL,
`entity_cd` varchar(10) DEFAULT NULL,
`entity_name` varchar(50) DEFAULT NULL,
`entity_xref_id` varchar(20) DEFAULT NULL,
`assessed_val` float DEFAULT NULL,
`taxable_val` float DEFAULT NULL,
`ab_amt` float DEFAULT NULL,
`en_amt` float DEFAULT NULL,
`fr_amt` float DEFAULT NULL,
`ht_amt` float DEFAULT NULL,
`pro_amt` float DEFAULT NULL,
`pc_amt` float DEFAULT NULL,
`so_amt` float DEFAULT NULL,
`ex366_amt` float DEFAULT NULL,
`hs_amt` float DEFAULT NULL,
`ov65_amt` float DEFAULT NULL,
`dp_amt` float DEFAULT NULL,
`dv_amt` float DEFAULT NULL,
`ex_amt` float DEFAULT NULL,
`ch_amt` float DEFAULT NULL,
`market_value` float DEFAULT NULL,
`appraised_value` float DEFAULT NULL,
`hs_cap` float DEFAULT NULL,
`ag_late_loss` float DEFAULT NULL,
`freeport_late_loss` float DEFAULT NULL,
`hs_state_amt` float DEFAULT NULL,
`hs_local_amt` float DEFAULT NULL,
`land_hstd_val` float DEFAULT NULL,
`land_non_hstd_val` float DEFAULT NULL,
`imprv_hstd_val` float DEFAULT NULL,
`imprv_non_hstd_val` float DEFAULT NULL,
`ag_use_val` float DEFAULT NULL,
`ag_market_val` float DEFAULT NULL,
`tim_use_val` float DEFAULT NULL,
`tim_market_val` float DEFAULT NULL,
`partial_entity` varchar(1) DEFAULT NULL,
`freeze_yr` float DEFAULT NULL,
`freeze_ceiling` float DEFAULT NULL,
`freeze_transfer_flag` varchar(1) DEFAULT NULL,
`freeze_transfer_date` varchar(25) DEFAULT NULL,
`freeze_previous_tax` float DEFAULT NULL,
`freeze_previous_tax_unfrozen` float DEFAULT NULL,
`lve_amt` float DEFAULT NULL,
`eco_amt` float DEFAULT NULL,
`ag_use_val_ne` float DEFAULT NULL,
`ag_use_val_ex` float DEFAULT NULL,
`ag_market_ne` float DEFAULT NULL,
`ag_market_ex` float DEFAULT NULL,
`timber_use_ne` float DEFAULT NULL,
`timber_use_ex` float DEFAULT NULL,
`timber_market_ne` float DEFAULT NULL,
`timber_market_ex` float DEFAULT NULL,
`new_val_hs` float DEFAULT NULL,
`new_val_nhs` float DEFAULT NULL,
`new_val_p` float DEFAULT NULL,
`new_val_taxable` float DEFAULT NULL,
`dataset_id` float DEFAULT NULL,
`chodo_amt` float DEFAULT NULL,
`ent_pct_land_hs` float DEFAULT NULL,
`ent_pct_land_nonhs` float DEFAULT NULL,
`ent_pct_imprv_hs` float DEFAULT NULL,
`ent_pct_imprv_nonhs` float DEFAULT NULL,
`ent_pct_ag_use` float DEFAULT NULL,
`ent_pct_ag_mkt` float DEFAULT NULL,
`ent_pct_tim_use` float DEFAULT NULL,
`ent_pct_tim_mkt` float DEFAULT NULL,
`ent_pct_pers` float DEFAULT NULL,
`ent_pct_min` float DEFAULT NULL,
`ent_pct_auto` float DEFAULT NULL,
`lih_amt` float DEFAULT NULL,
`git_amt` float DEFAULT NULL,
`dvhs_amt` float DEFAULT NULL,
`tax_increment_flag` varchar(1) DEFAULT NULL,
`tax_increment_imprv_val` float DEFAULT NULL,
`tax_increment_land_val` float DEFAULT NULL,
`weed_taxable_acres` float DEFAULT NULL,
`hs_allocation_factor` float DEFAULT NULL,
`ov65_allocation_factor` float DEFAULT NULL,
`ov65s_allocation_factor` float DEFAULT NULL,
`dp_allocation_factor` float DEFAULT NULL,
`dps_allocation_factor` float DEFAULT NULL,
`dv1_allocation_factor` float DEFAULT NULL,
`dv1s_allocation_factor` float DEFAULT NULL,
`dv2_allocation_factor` float DEFAULT NULL,
`dv2s_allocation_factor` float DEFAULT NULL,
`dv3_allocation_factor` float DEFAULT NULL,
`dv3s_allocation_factor` float DEFAULT NULL,
`dv4_allocation_factor` float DEFAULT NULL,
`dv4s_allocation_factor` float DEFAULT NULL,
`dvhs_allocation_factor` float DEFAULT NULL,
`ex_allocation_factor` float DEFAULT NULL,
`ab_allocation_factor` float DEFAULT NULL,
`en_allocation_factor` float DEFAULT NULL,
`fr_allocation_factor` float DEFAULT NULL,
`ht_allocation_factor` float DEFAULT NULL,
`pro_allocation_factor` float DEFAULT NULL,
`pc_allocation_factor` float DEFAULT NULL,
`so_allocation_factor` float DEFAULT NULL,
`ex366_allocation_factor` float DEFAULT NULL,
`ch_allocation_factor` float DEFAULT NULL,
`eco_allocation_factor` float DEFAULT NULL,
`chodo_allocation_factor` float DEFAULT NULL,
`lih_allocation_factor` float DEFAULT NULL,
`git_allocation_factor` float DEFAULT NULL,
`freeze_exmpt_type_cd` varchar(5) DEFAULT NULL,
`freeze_transfer_exmpt_type_cd` varchar(5) DEFAULT NULL,
`tax_increment_zone_cd` varchar(10) DEFAULT NULL,
`tax_increment_zone_desc` varchar(50) DEFAULT NULL,
`omitted_imprv_hstd_val` float DEFAULT NULL,
`omitted_imprv_non_hstd_val` float DEFAULT NULL,
`clt_amt` float DEFAULT NULL,
`clt_allocation_factor` float DEFAULT NULL,
`dvhss_amt` float DEFAULT NULL,
`dvhss_allocation_factor` float DEFAULT NULL,
`homestead_group_exemption_factor` float DEFAULT NULL,
`ex_xd_amt` float DEFAULT NULL,
`ex_xd_allocation_factor` float DEFAULT NULL,
`ex_xf_amt` float DEFAULT NULL,
`ex_xf_allocation_factor` float DEFAULT NULL,
`ex_xg_amt` float DEFAULT NULL,
`ex_xg_allocation_factor` float DEFAULT NULL,
`ex_xh_amt` float DEFAULT NULL,
`ex_xh_allocation_factor` float DEFAULT NULL,
`ex_xi_amt` float DEFAULT NULL,
`ex_xi_allocation_factor` float DEFAULT NULL,
`ex_xj_amt` float DEFAULT NULL,
`ex_xj_allocation_factor` float DEFAULT NULL,
`ex_xl_amt` float DEFAULT NULL,
`ex_xl_allocation_factor` float DEFAULT NULL,
`ex_xm_amt` float DEFAULT NULL,
`ex_xm_allocation_factor` float DEFAULT NULL,
`ex_xn_amt` float DEFAULT NULL,
`ex_xn_allocation_factor` float DEFAULT NULL,
`ex_xo_amt` float DEFAULT NULL,
`ex_xo_allocation_factor` float DEFAULT NULL,
`ex_xp_amt` float DEFAULT NULL,
`ex_xp_allocation_factor` float DEFAULT NULL,
`ex_xq_amt` float DEFAULT NULL,
`ex_xq_allocation_factor` float DEFAULT NULL,
`ex_xr_amt` float DEFAULT NULL,
`ex_xr_allocation_factor` float DEFAULT NULL,
`ex_xs_amt` float DEFAULT NULL,
`ex_xs_allocation_factor` float DEFAULT NULL,
`ex_xt_amt` float DEFAULT NULL,
`ex_xt_allocation_factor` float DEFAULT NULL,
`ex_xu_amt` float DEFAULT NULL,
`ex_xu_allocation_factor` float DEFAULT NULL,
`ex_xv_amt` float DEFAULT NULL,
`ex_xv_allocation_factor` float DEFAULT NULL,
`ex_xa_amt` float DEFAULT NULL,
`ex_xa_allocation_factor` float DEFAULT NULL,
`lve_allocation_factor` float DEFAULT NULL,
`ppv_amt` float DEFAULT NULL,
`ppv_allocation_factor` float DEFAULT NULL,
`dvch_amt` float DEFAULT NULL,
`dvch_allocation_factor` float DEFAULT NULL,
`dvchs_amt` float DEFAULT NULL,
`dvchs_allocation_factor` float DEFAULT NULL,
`masss_amt` float DEFAULT NULL,
`masss_allocation_factor` float DEFAULT NULL,
`pp_late_interstate_allocation_val` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `prop_ent`
-- Table structure for table `abs_subd`
--
DROP TABLE IF EXISTS `abs_subd`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `abs_subd` (
`abs_subdv_cd` varchar(10) DEFAULT NULL,
`abs_subdv_desc` varchar(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `abs_subd`
-- Table structure for table `state_cd`
--
DROP TABLE IF EXISTS `state_cd`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `state_cd` (
`state_cd` varchar(10) DEFAULT NULL,
`state_cd_description` varchar(50) DEFAULT NULL,
`ptd_state_cd` varchar(10) DEFAULT NULL,
`ptd_state_cd_description` varchar(50) DEFAULT NULL,
`state_cd_year` varchar(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `state_cd`
-- Table structure for table `totals`
--
DROP TABLE IF EXISTS `totals`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `totals` (
`entity_id` int(12) DEFAULT NULL,
`entity_cd` varchar(5) DEFAULT NULL,
`entity_name` varchar(70) DEFAULT NULL,
`land_hstd_val` float DEFAULT NULL,
`land_non_hstd_val` float DEFAULT NULL,
`imprv_hstd_val` float DEFAULT NULL,
`imprv_non_hstd_val` float DEFAULT NULL,
`ag_use_val` float DEFAULT NULL,
`tim_use_val` float DEFAULT NULL,
`ag_market_val` float DEFAULT NULL,
`tim_market_val` float DEFAULT NULL,
`taxable_val` float DEFAULT NULL,
`mineral_val` float DEFAULT NULL,
`personal_val` float DEFAULT NULL,
`auto_val` float DEFAULT NULL,
`real_mobile_val` float DEFAULT NULL,
`num_real_mobile` int(12) DEFAULT NULL,
`num_personal` int(12) DEFAULT NULL,
`num_mineral` int(12) DEFAULT NULL,
`num_auto` int(12) DEFAULT NULL,
`num_records` int(12) DEFAULT NULL,
`market_value` float DEFAULT NULL,
`hs_cap_count` int(12) DEFAULT NULL,
`hs_cap` float DEFAULT NULL,
`hs_count` int(12) DEFAULT NULL,
`hs_local_amount` float DEFAULT NULL,
`hs_state_amount` float DEFAULT NULL,
`ov65_count` int(12) DEFAULT NULL,
`ov65_amt` float DEFAULT NULL,
`dp_count` int(12) DEFAULT NULL,
`dp_amt` float DEFAULT NULL,
`dv_count` int(12) DEFAULT NULL,
`dv_amt` float DEFAULT NULL,
`ab_count` int(12) DEFAULT NULL,
`ab_amt` float DEFAULT NULL,
`fr_count` int(12) DEFAULT NULL,
`fr_amt` float DEFAULT NULL,
`pc_count` int(12) DEFAULT NULL,
`pc_amt` float DEFAULT NULL,
`ex366_count` int(12) DEFAULT NULL,
`ex366_amt` float DEFAULT NULL,
`ht_count` int(12) DEFAULT NULL,
`ht_amt` float DEFAULT NULL,
`so_count` int(12) DEFAULT NULL,
`so_amt` float DEFAULT NULL,
`ex_count` int(12) DEFAULT NULL,
`ex_amt` float DEFAULT NULL,
`ch_count` int(12) DEFAULT NULL,
`ch_amt` float DEFAULT NULL,
`ag_late_count` int(12) DEFAULT NULL,
`ag_late_loss` float DEFAULT NULL,
`freeport_late_count` int(12) DEFAULT NULL,
`freeport_late_loss` float DEFAULT NULL,
`lve_count` int(12) DEFAULT NULL,
`lve_amt` float DEFAULT NULL,
`year` int(4) DEFAULT NULL,
`sup_num` int(12) DEFAULT NULL,
`eco_count` int(12) DEFAULT NULL,
`eco_amt` float DEFAULT NULL,
`ag_use_val_ne` float DEFAULT NULL,
`ag_use_val_ex` float DEFAULT NULL,
`ag_market_ne` float DEFAULT NULL,
`ag_market_ex` float DEFAULT NULL,
`timber_use_ne` float DEFAULT NULL,
`timber_use_ex` float DEFAULT NULL,
`timber_market_ne` float DEFAULT NULL,
`timber_market_ex` float DEFAULT NULL,
`en_count` int(15) DEFAULT NULL,
`en_amt` float DEFAULT NULL,
`dataset_id` float DEFAULT NULL,
`chodo_count` int(12) DEFAULT NULL,
`chodo_amt` float DEFAULT NULL,
`lih_count` int(12) DEFAULT NULL,
`lih_amt` float DEFAULT NULL,
`git_count` int(12) DEFAULT NULL,
`git_amt` float DEFAULT NULL,
`dvhs_count` int(12) DEFAULT NULL,
`dvhs_amt` float DEFAULT NULL,
`tax_increment_imprv_val` float DEFAULT NULL,
`tax_increment_land_val` float DEFAULT NULL,
`weed_taxable_acres` float DEFAULT NULL,
`omitted_imprv_hstd_val` float DEFAULT NULL,
`omitted_imprv_non_hstd_val` float DEFAULT NULL,
`clt_count` int(12) DEFAULT NULL,
`clt_amt` float DEFAULT NULL,
`dvhss_count` int(12) DEFAULT NULL,
`dvhss_amt` float DEFAULT NULL,
`ex_xd_count` int(12) DEFAULT NULL,
`ex_xd_amt` float DEFAULT NULL,
`ex_xf_count` int(12) DEFAULT NULL,
`ex_xf_amt` float DEFAULT NULL,
`ex_xg_count` int(12) DEFAULT NULL,
`ex_xg_amt` float DEFAULT NULL,
`ex_xh_count` int(12) DEFAULT NULL,
`ex_xh_amt` float DEFAULT NULL,
`ex_xi_count` int(12) DEFAULT NULL,
`ex_xi_amt` float DEFAULT NULL,
`ex_xj_count` int(12) DEFAULT NULL,
`ex_xj_amt` float DEFAULT NULL,
`ex_xl_count` int(12) DEFAULT NULL,
`ex_xl_amt` float DEFAULT NULL,
`ex_xm_count` int(12) DEFAULT NULL,
`ex_xm_amt` float DEFAULT NULL,
`ex_xn_count` int(12) DEFAULT NULL,
`ex_xn_amt` float DEFAULT NULL,
`ex_xo_count` int(12) DEFAULT NULL,
`ex_xo_amt` float DEFAULT NULL,
`ex_xp_count` int(12) DEFAULT NULL,
`ex_xp_amt` float DEFAULT NULL,
`ex_xq_count` int(12) DEFAULT NULL,
`ex_xq_amt` float DEFAULT NULL,
`ex_xr_count` int(12) DEFAULT NULL,
`ex_xr_amt` float DEFAULT NULL,
`ex_xs_count` int(12) DEFAULT NULL,
`ex_xs_amt` float DEFAULT NULL,
`ex_xt_count` int(12) DEFAULT NULL,
`ex_xt_amt` float DEFAULT NULL,
`ex_xu_count` int(12) DEFAULT NULL,
`ex_xu_amt` float DEFAULT NULL,
`ex_xv_count` int(12) DEFAULT NULL,
`ex_xv_amt` float DEFAULT NULL,
`ex_xa_count` int(12) DEFAULT NULL,
`ex_xa_amt` float DEFAULT NULL,
`ppv_count` int(12) DEFAULT NULL,
`ppv_amt` float DEFAULT NULL,
`dvch_count` int(12) DEFAULT NULL,
`dvch_amt` float DEFAULT NULL,
`dvchs_count` int(12) DEFAULT NULL,
`dvchs_amt` float DEFAULT NULL,
`masss_count` int(12) DEFAULT NULL,
`masss_amt` float DEFAULT NULL,
`pp_late_interstate_allocation_count` int(12) DEFAULT NULL,
`pp_late_interstate_allocation_val` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `totals`
-- Table structure for table `udi`
--
DROP TABLE IF EXISTS `udi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `udi` (
`original_pid` int(12) DEFAULT NULL,
`owner_id` int(12) DEFAULT NULL,
`owner_name` int(12) DEFAULT NULL,
`new_pid` int(12) DEFAULT NULL,
`udi_group` int(12) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment