--liquibase formatted sql

--changeset vin:drop and create common fields

DROP TABLE IF EXISTS `common_field`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `common_field` (
  `id` int NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdBy` varchar(30) DEFAULT NULL,
  `version` int NOT NULL DEFAULT '0',
  `modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modifiedBy` varchar(30) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `clientId` bigint NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `dateOfBirth` varchar(30) DEFAULT NULL,
  `idCard` varchar(30) DEFAULT NULL,
  `occupation` varchar(50) DEFAULT NULL,
  `firstName` varchar(50) DEFAULT NULL,
  `genderMale` varchar(10) DEFAULT NULL,
  `genderFemale` varchar(10) DEFAULT NULL,
  `givenName` varchar(50) DEFAULT NULL,
  `ddDateOfBirth` varchar(10) DEFAULT NULL,
  `mmDateOfBirth` varchar(10) DEFAULT NULL,
  `yyyyDateOfBirth` varchar(10) DEFAULT NULL,
  `nameChi` varchar(50) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `maritalStatus` varchar(20) DEFAULT NULL,
  `noOfDependents` varchar(20) DEFAULT NULL,
  `fna_c1a_amount` varchar(45) DEFAULT NULL,
  `fna_c1b_amount` varchar(45) DEFAULT NULL,
  `fna_c1c_1_amount` varchar(45) DEFAULT NULL,
  `fna_c1c_2_amount` varchar(45) DEFAULT NULL,
  `fna_c1c_3_amount` varchar(45) DEFAULT NULL,
  `fna_c1d_amount` varchar(45) DEFAULT NULL,
  `fna_c2a_amount` varchar(45) DEFAULT NULL,
  `fna_c2b_amount` varchar(45) DEFAULT NULL,
  `fna_c2c_amount` varchar(45) DEFAULT NULL,
  `fna_c2d_amount` varchar(45) DEFAULT NULL,
  `fna_c2e_amount` varchar(45) DEFAULT NULL,
  `fna_b1_a` varchar(10) DEFAULT NULL,
  `fna_b1_a_amount` varchar(45) DEFAULT NULL,
  `fna_b1_b` varchar(10) DEFAULT NULL,
  `fna_b1a_4_amount` varchar(45) DEFAULT NULL,
  `fna_b1_c` varchar(10) DEFAULT NULL,
  `fna_b1_d` varchar(10) DEFAULT NULL,
  `fna_b1_d_year` varchar(30) DEFAULT NULL,
  `fna_b1_d_amount` varchar(45) DEFAULT NULL,
  `fna_b1_e` varchar(10) DEFAULT NULL,
  `fna_b1_f` varchar(10) DEFAULT NULL,
  `fna_b1_f_other` varchar(45) DEFAULT NULL,
  `fna_b1_f_desc` varchar(45) DEFAULT NULL,
  `fna_b1b_1` varchar(10) DEFAULT NULL,
  `fna_b1b_2` varchar(10) DEFAULT NULL,
  `fna_b1b_3` varchar(10) DEFAULT NULL,
  `fna_b2_a` varchar(10) DEFAULT NULL,
  `fna_b2_b` varchar(10) DEFAULT NULL,
  `fna_b2_c` varchar(10) DEFAULT NULL,
  `fna_b2_d` varchar(10) DEFAULT NULL,
  `fna_b2_e` varchar(10) DEFAULT NULL,
  `fna_b2_f` varchar(10) DEFAULT NULL,
  `fna_b2_g` varchar(10) DEFAULT NULL,
  `fna_c3a_2_5` varchar(10) DEFAULT NULL,
  `fna_c3a_6_10` varchar(10) DEFAULT NULL,
  `fna_c3a_11_15` varchar(10) DEFAULT NULL,
  `fna_c3a_16_20` varchar(10) DEFAULT NULL,
  `fna_c3a_20` varchar(10) DEFAULT NULL,
  `fna_c3a_life` varchar(10) DEFAULT NULL,
  `fna_c3a_single_pay` varchar(10) DEFAULT NULL,
  `fna_a_retire` varchar(20) DEFAULT NULL,
  `fna_c3b_salary` varchar(10) DEFAULT NULL,
  `fna_c3b_income` varchar(10) DEFAULT NULL,
  `fna_c3b_saving` varchar(10) DEFAULT NULL,
  `fna_c3b_investments` varchar(10) DEFAULT NULL,
  `fna_c3b_policy` varchar(10) DEFAULT NULL,
  `fna_c3b_others` varchar(45) DEFAULT NULL,
  `fna_c3b_desc` varchar(45) DEFAULT NULL,
  `fna_c3c_yes` varchar(10) DEFAULT NULL,
  `fna_c3c_no` varchar(10) DEFAULT NULL,
  `fna_c1e_10` varchar(10) DEFAULT NULL,
  `fna_c1e_10_20` varchar(10) DEFAULT NULL,
  `fna_c1e_21_30` varchar(10) DEFAULT NULL,
  `fna_c1e_31_40` varchar(10) DEFAULT NULL,
  `fna_c1e_41_50` varchar(10) DEFAULT NULL,
  `fna_c1e_50` varchar(10) DEFAULT NULL,
  `fna_c2f_10` varchar(10) DEFAULT NULL,
  `fna_c2f_10_20` varchar(10) DEFAULT NULL,
  `fna_c2f_21_30` varchar(10) DEFAULT NULL,
  `fna_c2f_31_40` varchar(10) DEFAULT NULL,
  `fna_c2f_41_50` varchar(10) DEFAULT NULL,
  `fna_c2f_50` varchar(10) DEFAULT NULL,
  `contactNo` varchar(45) DEFAULT NULL,
  `eduPri` varchar(10) DEFAULT NULL,
  `eduSec` varchar(10) DEFAULT NULL,
  `eduPostSec` varchar(10) DEFAULT NULL,
  `own_income` varchar(10) DEFAULT NULL,
  `savings` varchar(10) DEFAULT NULL,
  `premium_financing` varchar(10) DEFAULT NULL,
  `others_funds` varchar(10) DEFAULT NULL,
  `others_funds_desc` varchar(45) DEFAULT NULL,
  `fna_a_life_0` varchar(10) DEFAULT NULL,
  `fna_a_life_less_5` varchar(10) DEFAULT NULL,
  `fna_a_life_above_5` varchar(10) DEFAULT NULL,
  `fna_c2a_cash` varchar(10) DEFAULT NULL,
  `fna_c2a_market_account` varchar(10) DEFAULT NULL,
  `fna_c2a_bank_account` varchar(10) DEFAULT NULL,
  `fna_c2a_bonds` varchar(10) DEFAULT NULL,
  `fna_c2a_stocks` varchar(10) DEFAULT NULL,
  `fna_c2a_us` varchar(10) DEFAULT NULL,
  `fna_c2a_others` varchar(45) DEFAULT NULL,
  `fna_c2a_desc` varchar(45) DEFAULT NULL,
  `fna_d_1` varchar(10) DEFAULT NULL,
  `fna_d_2` varchar(10) DEFAULT NULL,
  `fna_d_3` varchar(10) DEFAULT NULL,
  `fna_d_desc` varchar(45) DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  `address1` varchar(100) DEFAULT NULL,
  `address2` varchar(100) DEFAULT NULL,
  `placeOfBirth` varchar(30) DEFAULT NULL,
  `countryOfIssue` varchar(30) DEFAULT NULL,
  `countryOfCitizenship` varchar(30) DEFAULT NULL,
  `passportNo` varchar(50) DEFAULT NULL,
  `occupationTitle` varchar(50) DEFAULT NULL,
  `companyName` varchar(100) DEFAULT NULL,
  `companyAddress1` varchar(100) DEFAULT NULL,
  `companyAddress2` varchar(100) DEFAULT NULL,
  `companyNature1` varchar(60) DEFAULT NULL,
  `companyNature2` varchar(60) DEFAULT NULL,
  `taxResidency1` varchar(60) DEFAULT NULL,
  `taxResidency2` varchar(60) DEFAULT NULL,
  `taxResidency3` varchar(60) DEFAULT NULL,
  `taxPin1` varchar(50) DEFAULT NULL,
  `taxPin2` varchar(50) DEFAULT NULL,
  `taxPin3` varchar(50) DEFAULT NULL,
  `taxReason1` varchar(45) DEFAULT NULL,
  `taxReason2` varchar(45) DEFAULT NULL,
  `taxReason3` varchar(45) DEFAULT NULL,
  `taxReasonB1` varchar(50) DEFAULT NULL,
  `taxReasonB2` varchar(50) DEFAULT NULL,
  `taxReasonB3` varchar(50) DEFAULT NULL,
  `eduUni` varchar(45) DEFAULT NULL,
  `insuranceCompany1_1` varchar(60) DEFAULT NULL,
  `insuranceCompany1_2` varchar(60) DEFAULT NULL,
  `insuranceCompany1_3` varchar(60) DEFAULT NULL,
  `insuranceCompany2_1` varchar(60) DEFAULT NULL,
  `insuranceCompany2_2` varchar(60) DEFAULT NULL,
  `insuranceCompany2_3` varchar(60) DEFAULT NULL,
  `insuranceCompany3_1` varchar(60) DEFAULT NULL,
  `insuranceCompany3_2` varchar(60) DEFAULT NULL,
  `insuranceCompany3_3` varchar(60) DEFAULT NULL,
  `insuranceSumInsured1` varchar(30) DEFAULT NULL,
  `insuranceSumInsured2` varchar(30) DEFAULT NULL,
  `insuranceSumInsured3` varchar(30) DEFAULT NULL,
  `insuranceLife1` varchar(10) DEFAULT NULL,
  `insuranceSaving1` varchar(10) DEFAULT NULL,
  `insuranceCritical1` varchar(10) DEFAULT NULL,
  `insuranceOther1` varchar(10) DEFAULT NULL,
  `insuranceOtherDesc1` varchar(50) DEFAULT NULL,
  `insuranceLife2` varchar(10) DEFAULT NULL,
  `insuranceSaving2` varchar(10) DEFAULT NULL,
  `insuranceCritical2` varchar(10) DEFAULT NULL,
  `insuranceOther2` varchar(10) DEFAULT NULL,
  `insuranceOtherDesc2` varchar(50) DEFAULT NULL,
  `insuranceLife3` varchar(10) DEFAULT NULL,
  `insuranceSaving3` varchar(10) DEFAULT NULL,
  `insuranceCritical3` varchar(10) DEFAULT NULL,
  `insuranceOther3` varchar(10) DEFAULT NULL,
  `insuranceOtherDesc3` varchar(50) DEFAULT NULL,
  `insuranceYear1` varchar(20) DEFAULT NULL,
  `insuranceYear2` varchar(20) DEFAULT NULL,
  `insuranceYear3` varchar(20) DEFAULT NULL,
  `insuranceCurrency1` varchar(20) DEFAULT NULL,
  `insuranceCurrency2` varchar(20) DEFAULT NULL,
  `insuranceCurrency3` varchar(20) DEFAULT NULL,
  `crAddress1` varchar(100) DEFAULT NULL,
  `crAddress2` varchar(100) DEFAULT NULL,
  `employed` varchar(10) DEFAULT NULL,
  `homemaker` varchar(10) DEFAULT NULL,
  `student` varchar(10) DEFAULT NULL,
  `investor` varchar(10) DEFAULT NULL,
  `retired` varchar(10) DEFAULT NULL,
  `employedSelf` varchar(10) DEFAULT NULL,
  `employedNon` varchar(10) DEFAULT NULL,
  `partTime` varchar(10) DEFAULT NULL,
  `ultimateTotalLife` varchar(100) DEFAULT NULL,
  `declinedYes` varchar(10) DEFAULT NULL,
  `declinedNo` varchar(10) DEFAULT NULL,
  `declinedDesc` varchar(60) DEFAULT NULL,
  `hazardousActivity` varchar(100) DEFAULT NULL,
  `incomeSalary` varchar(45) DEFAULT NULL,
  `incomeSalaryLastYear` varchar(45) DEFAULT NULL,
  `incomeBonus` varchar(45) DEFAULT NULL,
  `incomeBonusLastYear` varchar(45) DEFAULT NULL,
  `incomeOther` varchar(45) DEFAULT NULL,
  `incomeOtherLastYear` varchar(45) DEFAULT NULL,
  `incomeInterest` varchar(45) DEFAULT NULL,
  `incomeInterestLastYear` varchar(45) DEFAULT NULL,
  `incomeDividents` varchar(45) DEFAULT NULL,
  `incomeDividentsLastYear` varchar(45) DEFAULT NULL,
  `incomeRentals` varchar(45) DEFAULT NULL,
  `incomeRentalsLastYear` varchar(45) DEFAULT NULL,
  `totalAnnualIncome` varchar(45) DEFAULT NULL,
  `assetCash` varchar(45) DEFAULT NULL,
  `assetInvestment` varchar(45) DEFAULT NULL,
  `assetRealEstate` varchar(45) DEFAULT NULL,
  `assetNetBusinessInterest` varchar(45) DEFAULT NULL,
  `assetProperties` varchar(45) DEFAULT NULL,
  `liaLoan` varchar(45) DEFAULT NULL,
  `liaMargin` varchar(45) DEFAULT NULL,
  `liaLoanGurantee` varchar(45) DEFAULT NULL,
  `liaMortgage` varchar(45) DEFAULT NULL,
  `liaOther` varchar(45) DEFAULT NULL,
  `realEstateAddress1_1` varchar(100) DEFAULT NULL,
  `realEstateAddress1_2` varchar(100) DEFAULT NULL,
  `realEstateAddress2_1` varchar(100) DEFAULT NULL,
  `realEstateAddress2_2` varchar(100) DEFAULT NULL,
  `realEstateAddress3_1` varchar(100) DEFAULT NULL,
  `realEstateAddress3_2` varchar(100) DEFAULT NULL,
  `realEstatePurchaseDate1` varchar(45) DEFAULT NULL,
  `realEstatePurchaseDate2` varchar(45) DEFAULT NULL,
  `realEstatePurchaseDate3` varchar(45) DEFAULT NULL,
  `common_fieldcol` varchar(45) DEFAULT NULL,
  `bankruptYes` varchar(10) DEFAULT NULL,
  `bankruptNo` varchar(10) DEFAULT NULL,
  `bankruptDesc` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;