Advertisement
Guest User

Untitled

a guest
Oct 17th, 2017
67,697
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.24 KB | None | 0 0
  1. CREATE TABLE `master_deeds` (
  2. `NEW_IDN` bigint(20) NOT NULL,
  3. `EXPORTED` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'This is used to determine what has not been exported yet',
  4. `ID10` bigint(20) DEFAULT NULL,
  5. `TITLE` varchar(20) DEFAULT NULL,
  6. `FIRST_NAME` varchar(60) DEFAULT NULL,
  7. `SURNAME` varchar(60) DEFAULT NULL,
  8. `DECEASED_STATUS` varchar(20) DEFAULT NULL,
  9. `CITIZENSHIP` varchar(20) DEFAULT NULL,
  10. `GENDER` varchar(20) DEFAULT NULL,
  11. `AGE_GROUP` varchar(20) DEFAULT NULL,
  12. `POPULATION_GROUP` varchar(20) DEFAULT NULL,
  13. `LOCATION` varchar(20) DEFAULT NULL,
  14. `MARITAL_STATUS1` varchar(20) DEFAULT NULL,
  15. `LSM_GROUP` varchar(20) DEFAULT NULL,
  16. `ESTIMATED_INCOME` varchar(20) DEFAULT NULL,
  17. `HOMEOWNERSHIP` varchar(20) DEFAULT NULL,
  18. `DIRECTORSHIP1` varchar(20) DEFAULT NULL,
  19. `CIV_NET` varchar(20) DEFAULT NULL,
  20. `MOST_RECENT_PHYSICAL_ADDR_LINE1` varchar(100) DEFAULT NULL,
  21. `MOST_RECENT_PHYSICAL_ADDR_LINE2` varchar(100) DEFAULT NULL,
  22. `MOST_RECENT_PHYSICAL_ADDR_LINE3` varchar(100) DEFAULT NULL,
  23. `MOST_RECENT_PHYSICAL_ADDR_LINE4` varchar(100) DEFAULT NULL,
  24. `MOST_MAIL_PHYSICAL_ADDR_LINE1` varchar(100) DEFAULT NULL,
  25. `MOST_MAIL_PHYSICAL_ADDR_LINE2` varchar(100) DEFAULT NULL,
  26. `MOST_MAIL_PHYSICAL_ADDR_LINE3` varchar(100) DEFAULT NULL,
  27. `MOST_MAIL_PHYSICAL_ADDR_LINE4` varchar(100) DEFAULT NULL,
  28. `MOST_RECENT_POSTAL_ADDR_LINE1` varchar(100) DEFAULT NULL,
  29. `MOST_RECENT_POSTAL_ADDR_LINE2` varchar(100) DEFAULT NULL,
  30. `MOST_RECENT_POSTAL_ADDR_LINE3` varchar(100) DEFAULT NULL,
  31. `MOST_RECENT_POSTAL_ADDR_LINE4` varchar(100) DEFAULT NULL,
  32. `POC` varchar(20) DEFAULT NULL,
  33. `POP` varchar(20) DEFAULT NULL,
  34. `CPC` varchar(20) DEFAULT NULL,
  35. `BAI` varchar(20) DEFAULT NULL,
  36. `CELL_1` varchar(20) DEFAULT NULL,
  37. `CELL_2` varchar(20) DEFAULT NULL,
  38. `CELL_3` varchar(20) DEFAULT NULL,
  39. `WORK_1` varchar(20) DEFAULT NULL,
  40. `WORK_2` varchar(20) DEFAULT NULL,
  41. `WORK_3` varchar(20) DEFAULT NULL,
  42. `HOME_1` varchar(20) DEFAULT NULL,
  43. `HOME_2` varchar(20) DEFAULT NULL,
  44. `HOME_3` varchar(20) DEFAULT NULL,
  45. `EMAIL_1` varchar(20) DEFAULT NULL,
  46. `EMAIL_2` varchar(20) DEFAULT NULL,
  47. `EMAIL_3` varchar(50) DEFAULT NULL,
  48. `OCCUPATION_1` varchar(20) DEFAULT NULL,
  49. `OCCUPATION_2` varchar(20) DEFAULT NULL,
  50. `OCCUPATION_3` varchar(20) DEFAULT NULL,
  51. `EMPLOYER_1` varchar(20) DEFAULT NULL,
  52. `EMPLOYER_2` varchar(20) DEFAULT NULL,
  53. `EMPLOYER_3` varchar(20) DEFAULT NULL,
  54. `PROPERTY_1_TRANSFER_DATE` varchar(20) DEFAULT NULL,
  55. `PROPERTY_ID10` varchar(50) DEFAULT NULL,
  56. `PROPERTY_1_PROVINCE` varchar(50) DEFAULT NULL,
  57. `PROPERTY_1_TOWNSHIP` varchar(50) DEFAULT NULL,
  58. `PROPERTY_1_ERF_NUMBER` varchar(20) DEFAULT NULL,
  59. `PROPERTY_1_UNIT_NUMBER` varchar(20) DEFAULT NULL,
  60. `PROPERTY_1_SALES_PRICE` varchar(20) DEFAULT NULL,
  61. `PROPERTY_1_BOND_AMOUNT` varchar(20) DEFAULT NULL,
  62. `PROPERTY_1_BOND_HOLDER` varchar(20) DEFAULT NULL,
  63. `PROPERTY_1_TITLE_DEED` varchar(20) DEFAULT NULL,
  64. `PROPERTY_2_TRANSFER_DATE` varchar(20) DEFAULT NULL,
  65. `PROPERTY_2_PROVINCE` varchar(50) DEFAULT NULL,
  66. `PROPERTY_2_TOWNSHIP` varchar(50) DEFAULT NULL,
  67. `PROPERTY_2_ERF_NUMBER` varchar(20) DEFAULT NULL,
  68. `PROPERTY_2_UNIT_NUMBER` varchar(20) DEFAULT NULL,
  69. `PROPERTY_2_SALES_PRICE` varchar(20) DEFAULT NULL,
  70. `PROPERTY_2_BOND_AMOUNT` varchar(20) DEFAULT NULL,
  71. `PROPERTY_2_BOND_HOLDER` varchar(20) DEFAULT NULL,
  72. `PROPERTY_2_TITLE_DEED` varchar(20) DEFAULT NULL,
  73. `PROPERTY_3_TRANSFER_DATE` varchar(20) DEFAULT NULL,
  74. `PROPERTY_3_PROVINCE` varchar(20) DEFAULT NULL,
  75. `PROPERTY_3_TOWNSHIP` varchar(20) DEFAULT NULL,
  76. `PROPERTY_3_ERF_NUMBER` varchar(20) DEFAULT NULL,
  77. `PROPERTY_3_UNIT_NUMBER` varchar(20) DEFAULT NULL,
  78. `PROPERTY_3_SALES_PRICE` varchar(20) DEFAULT NULL,
  79. `PROPERTY_3_BOND_AMOUNT` varchar(20) DEFAULT NULL,
  80. `PROPERTY_3_BOND_HOLDER` varchar(20) DEFAULT NULL,
  81. `PROPERTY_3_TITLE_DEED` varchar(20) DEFAULT NULL,
  82. PRIMARY KEY (`NEW_IDN`),
  83. KEY `MOST_RECENT_PHYSICAL_ADDR_LINE3` (`MOST_RECENT_PHYSICAL_ADDR_LINE3`),
  84. KEY `PROPERTY_1_TOWNSHIP` (`PROPERTY_1_TOWNSHIP`),
  85. KEY `PROPERTY_2_TOWNSHIP` (`PROPERTY_2_TOWNSHIP`),
  86. KEY `PROPERTY_3_TOWNSHIP` (`PROPERTY_3_TOWNSHIP`),
  87. KEY `EXPORTED` (`EXPORTED`)
  88. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  89. /*!40101 SET character_set_client = @saved_cs_client */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement