Git Repository Public Repository

namibia

URLs

Copy to Clipboard
 
1074a2d61ec9d93a0ac7e0181875a2202b1225c4
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;



Commits for namibia/data/old_b4c stuff/mig_db_tuhpi.sql

Diff revisions: vs.
Revision Author Commited Message
df0489 ... Mark Fri 14 Oct, 2016 10:01:00 +0000

initial commit