--
-- Table structure for table `tuhpi`
--

DROP TABLE IF EXISTS `tuhpi`;

CREATE TABLE `tuhpi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `created_by_profile_id` int(11) NOT NULL,
  `stock_valuation_id` int(11) DEFAULT NULL,
  `price_guide_id` int(11) DEFAULT NULL,
  `auction_id` int(11) DEFAULT NULL,
  `stock_id` int(11) NOT NULL,
  `f_financeProvider` varchar(255)  DEFAULT NULL,
  `f_financeBranch` varchar(255)  DEFAULT NULL,
  `f_agreementOrAccountNumber` varchar(255)  DEFAULT NULL,
  `f_agreementType` varchar(255)  DEFAULT NULL,
  `f_telephoneNumber` varchar(255)  DEFAULT NULL,
  `f_resultCode` varchar(255)  DEFAULT NULL,
  `fh_financeHouse` varchar(255)  DEFAULT NULL,
  `fh_agreementOrAccountNumber` varchar(255)  DEFAULT NULL,
  `fh_agreementType` varchar(255)  DEFAULT NULL,
  `fh_telephoneNumber` varchar(255)  DEFAULT NULL,
  `fh_startDate` varchar(255)  DEFAULT NULL,
  `fh_endDate` varchar(255)  DEFAULT NULL,
  `fh_resultCode` varchar(255)  DEFAULT NULL,
  `ah_source` varchar(255)  DEFAULT NULL,
  `ah_assessmentDate` varchar(255)  DEFAULT NULL,
  `ah_vehicleDescription` varchar(255)  DEFAULT NULL,
  `ah_vinMatch` varchar(255)  DEFAULT NULL,
  `ah_regMatch` varchar(255)  DEFAULT NULL,
  `ah_estimatedRepairCost` varchar(255)  DEFAULT NULL,
  `ah_assessmentNumber` varchar(255)  DEFAULT NULL,
  `ah_engineMatch` varchar(255)  DEFAULT NULL,
  `ah_estimatePercentageOfRetailValue` varchar(255)  DEFAULT NULL,
  `ah_resultCode` varchar(255)  DEFAULT NULL,
  `si_policeStation` varchar(255)  DEFAULT NULL,
  `si_caseNumber` varchar(255)  DEFAULT NULL,
  `si_dateStolen` varchar(255)  DEFAULT NULL,
  `si_vinMatch` varchar(255)  DEFAULT NULL,
  `si_engineMatch` varchar(255)  DEFAULT NULL,
  `si_registrationMatch` varchar(255)  DEFAULT NULL,
  `si_resultCode` varchar(255)  DEFAULT NULL,
  `ai_company` varchar(255)  DEFAULT NULL,
  `ai_referenceNumber` varchar(255)  DEFAULT NULL,
  `ai_alertReason` varchar(255)  DEFAULT NULL,
  `ai_telephoneNumber` varchar(255)  DEFAULT NULL,
  `ai_resultCode` varchar(255)  DEFAULT NULL,
  `ivid_responseCode` varchar(255)  DEFAULT NULL,
  `ivid_responseDescription` varchar(255)  DEFAULT NULL,
  `ivid_referenceNumber` varchar(255)  DEFAULT NULL,
  `ivid_contactNumber` varchar(255)  DEFAULT NULL,
  `ivid_resultCode` varchar(255)  DEFAULT NULL,
  `mi_company` varchar(255)  DEFAULT NULL,
  `mi_referenceNumber` varchar(255)  DEFAULT NULL,
  `mi_contactNumber` varchar(255)  DEFAULT NULL,
  `mi_dateApplied` varchar(255)  DEFAULT NULL,
  `mi_resultCode` varchar(255)  DEFAULT NULL,
  `vesa_CertificateNumber` varchar(255)  DEFAULT NULL,
  `vesa_dateFitted` varchar(255)  DEFAULT NULL,
  `vesa_brandName` varchar(255)  DEFAULT NULL,
  `vesa_brandModel` varchar(255)  DEFAULT NULL,
  `vesa_deviceDescriptionType` varchar(255)  DEFAULT NULL,
  `vesa_resultCode` varchar(255)  DEFAULT NULL,
  `rh_dateRegistered` varchar(255)  DEFAULT NULL,
  `rh_registrationNumber` varchar(255)  DEFAULT NULL,
  `rh_resultCode` varchar(255)  DEFAULT NULL,
  `eh_source` varchar(255)  DEFAULT NULL,
  `eh_transactionDate` varchar(255)  DEFAULT NULL,
  `eh_resultCode` varchar(255)  DEFAULT NULL,
  `mh_source` varchar(255)  DEFAULT NULL,
  `mh_vehicleMileage` varchar(255)  DEFAULT NULL,
  `mh_dateRegistered` varchar(255)  DEFAULT NULL,
  `mh_resultCode` varchar(255)  DEFAULT NULL,
  `vc_month` int(11) DEFAULT NULL,
  `vc_year` int(11) DEFAULT NULL,
  `vc_newOptionCode` int(11) DEFAULT NULL,
  `vc_usedOptionCode` int(11) DEFAULT NULL,
  `vc_maximumRange` int(11) DEFAULT NULL,
  `vc_minimunRange` int(11) DEFAULT NULL,
  `vc_newPrice` int(11) DEFAULT NULL,
  `vc_retailPrice` int(11) DEFAULT NULL,
  `vc_tradePrice` int(11) DEFAULT NULL,
  `vc_resultCode` varchar(255)  DEFAULT NULL,
  `vvi_guideMonth` int(11) DEFAULT NULL,
  `vvi_guideYear` int(11) DEFAULT NULL,
  `vvi_newListPrice` int(11) DEFAULT NULL,
  `vvi_retailPrice` int(11) DEFAULT NULL,
  `vvi_tradePrice` int(11) DEFAULT NULL,
  `vvi_costPrice` int(11) DEFAULT NULL,
  `vvi_adjustedRetailPrice_mileageAndCondition` int(11) DEFAULT NULL,
  `vvi_AdjustedTradePrice_MileageAndCondition` int(11) DEFAULT NULL,
  `vvi_adjustedRetailPrice` int(11) DEFAULT NULL,
  `vvi_adjustedTradePrice` int(11) DEFAULT NULL,
  `vvi_estimatedRetailPrice` int(11) DEFAULT NULL,
  `vvi_estimatedTradePrice` int(11) DEFAULT NULL,
  `vvi_estimatedCostPrice` int(11) DEFAULT NULL,
  `vvi_adjustedEstimatedRetailPrice_mileageAndCondition` int(11) DEFAULT NULL,
  `vvi_adjustedEstimatedTradePrice_mileageAndCondition` int(11) DEFAULT NULL,
  `vvi_adjustedEstimatedcostprice_mileageandcondition` int(11) DEFAULT NULL,
  `vvi_adjustedEstimatedRetailPrice` int(11) DEFAULT NULL,
  `vvi_adjustedEstimatedTradePrice` int(11) DEFAULT NULL,
  `vvi_adjustedEstimatedCostPrice` int(11) DEFAULT NULL,
  `vvi_resultCode` varchar(255)  DEFAULT NULL,
  `error_code` int(11) DEFAULT NULL,
  `reset` datetime DEFAULT NULL,
  `previous_status` varchar(25)  DEFAULT NULL,
  `status` varchar(25)  DEFAULT NULL,
  `created` datetime NOT NULL,
  `updated` datetime DEFAULT NULL,
  `archived` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_CB04DB2E979B1AD6` (`company_id`),
  KEY `IDX_CB04DB2EFFA30A58` (`created_by_profile_id`),
  KEY `IDX_CB04DB2E37A85F5` (`stock_valuation_id`),
  KEY `IDX_CB04DB2EB55B265C` (`price_guide_id`),
  KEY `IDX_CB04DB2E57B8F0DE` (`auction_id`),
  KEY `IDX_CB04DB2EDCD6110` (`stock_id`),
  CONSTRAINT `FK_CB04DB2EDCD6110` FOREIGN KEY (`stock_id`) REFERENCES `stock` (`id`),
  CONSTRAINT `FK_CB04DB2E37A85F5` FOREIGN KEY (`stock_valuation_id`) REFERENCES `stock_valuation` (`id`),
  CONSTRAINT `FK_CB04DB2E57B8F0DE` FOREIGN KEY (`auction_id`) REFERENCES `auction` (`id`),
  CONSTRAINT `FK_CB04DB2E979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`),
  CONSTRAINT `FK_CB04DB2EB55B265C` FOREIGN KEY (`price_guide_id`) REFERENCES `price_guide` (`id`),
  CONSTRAINT `FK_CB04DB2EFFA30A58` FOREIGN KEY (`created_by_profile_id`) REFERENCES `profile` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;