--SQL to create the table schema---
create table raw_data(
RefId varchar(200),
IsBadBuy varchar(200),
PurchDate varchar(200),
Auction varchar(200),
VehYear varchar(200),
VehicleAge varchar(200),
Make varchar(200),
Model varchar(200),
Trim varchar(200),
SubModel varchar(200),
Color varchar(200),
Transmission varchar(200),
WheelTypeID varchar(200),
WheelType varchar(200),
VehOdo varchar(200),
Nationality varchar(200),
Size varchar(200),
TopThreeAmericanName varchar(200),
MMRAcquisitionAuctionAveragePrice varchar(200),
MMRAcquisitionAuctionCleanPrice varchar(200),
MMRAcquisitionRetailAveragePrice varchar(200),
MMRAcquisitonRetailCleanPrice varchar(200),
MMRCurrentAuctionAveragePrice varchar(200),
MMRCurrentAuctionCleanPrice varchar(200),
MMRCurrentRetailAveragePrice varchar(200),
MMRCurrentRetailCleanPrice varchar(200),
PRIMEUNIT varchar(200),
AUCGUART varchar(200),
BYRNO varchar(200),
VNZIP1 varchar(200),
VNST varchar(200),
VehBCost varchar(200),
IsOnlineSale varchar(200),
WarrantyCost varchar(200)
);
