1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
--
-- 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;
|