CREATE TABLE `master_deeds` (
  `NEW_IDN` bigint(20) NOT NULL,
  `EXPORTED` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'This is used to determine what has not been exported yet',
  `ID10` bigint(20) DEFAULT NULL,
  `TITLE` varchar(20) DEFAULT NULL,
  `FIRST_NAME` varchar(60) DEFAULT NULL,
  `SURNAME` varchar(60) DEFAULT NULL,
  `DECEASED_STATUS` varchar(20) DEFAULT NULL,
  `CITIZENSHIP` varchar(20) DEFAULT NULL,
  `GENDER` varchar(20) DEFAULT NULL,
  `AGE_GROUP` varchar(20) DEFAULT NULL,
  `POPULATION_GROUP` varchar(20) DEFAULT NULL,
  `LOCATION` varchar(20) DEFAULT NULL,
  `MARITAL_STATUS1` varchar(20) DEFAULT NULL,
  `LSM_GROUP` varchar(20) DEFAULT NULL,
  `ESTIMATED_INCOME` varchar(20) DEFAULT NULL,
  `HOMEOWNERSHIP` varchar(20) DEFAULT NULL,
  `DIRECTORSHIP1` varchar(20) DEFAULT NULL,
  `CIV_NET` varchar(20) DEFAULT NULL,
  `MOST_RECENT_PHYSICAL_ADDR_LINE1` varchar(100) DEFAULT NULL,
  `MOST_RECENT_PHYSICAL_ADDR_LINE2` varchar(100) DEFAULT NULL,
  `MOST_RECENT_PHYSICAL_ADDR_LINE3` varchar(100) DEFAULT NULL,
  `MOST_RECENT_PHYSICAL_ADDR_LINE4` varchar(100) DEFAULT NULL,
  `MOST_MAIL_PHYSICAL_ADDR_LINE1` varchar(100) DEFAULT NULL,
  `MOST_MAIL_PHYSICAL_ADDR_LINE2` varchar(100) DEFAULT NULL,
  `MOST_MAIL_PHYSICAL_ADDR_LINE3` varchar(100) DEFAULT NULL,
  `MOST_MAIL_PHYSICAL_ADDR_LINE4` varchar(100) DEFAULT NULL,
  `MOST_RECENT_POSTAL_ADDR_LINE1` varchar(100) DEFAULT NULL,
  `MOST_RECENT_POSTAL_ADDR_LINE2` varchar(100) DEFAULT NULL,
  `MOST_RECENT_POSTAL_ADDR_LINE3` varchar(100) DEFAULT NULL,
  `MOST_RECENT_POSTAL_ADDR_LINE4` varchar(100) DEFAULT NULL,
  `POC` varchar(20) DEFAULT NULL,
  `POP` varchar(20) DEFAULT NULL,
  `CPC` varchar(20) DEFAULT NULL,
  `BAI` varchar(20) DEFAULT NULL,
  `CELL_1` varchar(20) DEFAULT NULL,
  `CELL_2` varchar(20) DEFAULT NULL,
  `CELL_3` varchar(20) DEFAULT NULL,
  `WORK_1` varchar(20) DEFAULT NULL,
  `WORK_2` varchar(20) DEFAULT NULL,
  `WORK_3` varchar(20) DEFAULT NULL,
  `HOME_1` varchar(20) DEFAULT NULL,
  `HOME_2` varchar(20) DEFAULT NULL,
  `HOME_3` varchar(20) DEFAULT NULL,
  `EMAIL_1` varchar(20) DEFAULT NULL,
  `EMAIL_2` varchar(20) DEFAULT NULL,
  `EMAIL_3` varchar(50) DEFAULT NULL,
  `OCCUPATION_1` varchar(20) DEFAULT NULL,
  `OCCUPATION_2` varchar(20) DEFAULT NULL,
  `OCCUPATION_3` varchar(20) DEFAULT NULL,
  `EMPLOYER_1` varchar(20) DEFAULT NULL,
  `EMPLOYER_2` varchar(20) DEFAULT NULL,
  `EMPLOYER_3` varchar(20) DEFAULT NULL,
  `PROPERTY_1_TRANSFER_DATE` varchar(20) DEFAULT NULL,
  `PROPERTY_ID10` varchar(50) DEFAULT NULL,
  `PROPERTY_1_PROVINCE` varchar(50) DEFAULT NULL,
  `PROPERTY_1_TOWNSHIP` varchar(50) DEFAULT NULL,
  `PROPERTY_1_ERF_NUMBER` varchar(20) DEFAULT NULL,
  `PROPERTY_1_UNIT_NUMBER` varchar(20) DEFAULT NULL,
  `PROPERTY_1_SALES_PRICE` varchar(20) DEFAULT NULL,
  `PROPERTY_1_BOND_AMOUNT` varchar(20) DEFAULT NULL,
  `PROPERTY_1_BOND_HOLDER` varchar(20) DEFAULT NULL,
  `PROPERTY_1_TITLE_DEED` varchar(20) DEFAULT NULL,
  `PROPERTY_2_TRANSFER_DATE` varchar(20) DEFAULT NULL,
  `PROPERTY_2_PROVINCE` varchar(50) DEFAULT NULL,
  `PROPERTY_2_TOWNSHIP` varchar(50) DEFAULT NULL,
  `PROPERTY_2_ERF_NUMBER` varchar(20) DEFAULT NULL,
  `PROPERTY_2_UNIT_NUMBER` varchar(20) DEFAULT NULL,
  `PROPERTY_2_SALES_PRICE` varchar(20) DEFAULT NULL,
  `PROPERTY_2_BOND_AMOUNT` varchar(20) DEFAULT NULL,
  `PROPERTY_2_BOND_HOLDER` varchar(20) DEFAULT NULL,
  `PROPERTY_2_TITLE_DEED` varchar(20) DEFAULT NULL,
  `PROPERTY_3_TRANSFER_DATE` varchar(20) DEFAULT NULL,
  `PROPERTY_3_PROVINCE` varchar(20) DEFAULT NULL,
  `PROPERTY_3_TOWNSHIP` varchar(20) DEFAULT NULL,
  `PROPERTY_3_ERF_NUMBER` varchar(20) DEFAULT NULL,
  `PROPERTY_3_UNIT_NUMBER` varchar(20) DEFAULT NULL,
  `PROPERTY_3_SALES_PRICE` varchar(20) DEFAULT NULL,
  `PROPERTY_3_BOND_AMOUNT` varchar(20) DEFAULT NULL,
  `PROPERTY_3_BOND_HOLDER` varchar(20) DEFAULT NULL,
  `PROPERTY_3_TITLE_DEED` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`NEW_IDN`),
  KEY `MOST_RECENT_PHYSICAL_ADDR_LINE3` (`MOST_RECENT_PHYSICAL_ADDR_LINE3`),
  KEY `PROPERTY_1_TOWNSHIP` (`PROPERTY_1_TOWNSHIP`),
  KEY `PROPERTY_2_TOWNSHIP` (`PROPERTY_2_TOWNSHIP`),
  KEY `PROPERTY_3_TOWNSHIP` (`PROPERTY_3_TOWNSHIP`),
  KEY `EXPORTED` (`EXPORTED`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;