CREATE TABLE `fs` (
  `unique_transaction_id` varchar(255) DEFAULT NULL,
  `transaction_status` varchar(255) DEFAULT NULL,
  `dollarsobligated` double DEFAULT NULL,
  `baseandexercisedoptionsvalue` double DEFAULT NULL,
  `baseandalloptionsvalue` double DEFAULT NULL,
  `maj_agency_cat` varchar(255) DEFAULT NULL,
  `mod_agency` varchar(255) DEFAULT NULL,
  `maj_fund_agency_cat` varchar(255) DEFAULT NULL,
  `contractingofficeagencyid` varchar(255) DEFAULT NULL,
  `contractingofficeid` varchar(255) DEFAULT NULL,
  `fundingrequestingagencyid` varchar(255) DEFAULT NULL,
  `fundingrequestingofficeid` varchar(255) DEFAULT NULL,
  `signeddate` varchar(255) DEFAULT NULL,
  `effectivedate` varchar(255) DEFAULT NULL,
  `currentcompletiondate` varchar(255) DEFAULT NULL,
  `ultimatecompletiondate` varchar(255) DEFAULT NULL,
  `lastdatetoorder` varchar(255) DEFAULT NULL,
  `contractactiontype` varchar(255) DEFAULT NULL,
  `typeofcontractpricing` varchar(255) DEFAULT NULL,
  `subcontractplan` varchar(255) DEFAULT NULL,
  `multiyearcontract` varchar(255) DEFAULT NULL,
  `descriptionofcontractrequirement` varchar(4096) DEFAULT NULL,
  `purchasecardaspaymentmethod` varchar(255) DEFAULT NULL,
  `numberofactions` double DEFAULT NULL,
  `nationalinterestactioncode` varchar(255) DEFAULT NULL,
  `vendorname` varchar(255) DEFAULT NULL,
  `vendordoingasbusinessname` varchar(255) DEFAULT NULL,
  `streetaddress` varchar(255) DEFAULT NULL,
  `streetaddress2` varchar(255) DEFAULT NULL,
  `streetaddress3` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zipcode` double DEFAULT NULL,
  `vendorcountrycode` varchar(255) DEFAULT NULL,
  `vendor_state_code` varchar(255) DEFAULT NULL,
  `vendor_cd` varchar(255) DEFAULT NULL,
  `dunsnumber` varchar(255) DEFAULT NULL,
  `parentdunsnumber` varchar(255) DEFAULT NULL,
  `phoneno` double DEFAULT NULL,
  `registrationdate` varchar(255) DEFAULT NULL,
  `renewaldate` varchar(255) DEFAULT NULL,
  `mod_parent` varchar(255) DEFAULT NULL,
  `placeofperformancecity` varchar(255) DEFAULT NULL,
  `pop_state_code` varchar(255) DEFAULT NULL,
  `placeofperformancecountrycode` varchar(255) DEFAULT NULL,
  `placeofperformancezipcode` double DEFAULT NULL,
  `productorservicecode` varchar(255) DEFAULT NULL,
  `principalnaicscode` double DEFAULT NULL,
  `informationtechnologycommercialitemcategory` varchar(255) DEFAULT NULL,
  `agencyid` varchar(255) DEFAULT NULL,
  `fiscal_year` double DEFAULT NULL,
  `solicitationid` varchar(255) DEFAULT NULL,
  `extentcompeted` varchar(255) DEFAULT NULL,
  `reasonnotcompeted` varchar(255) DEFAULT NULL,
  `solicitationprocedures` varchar(255) DEFAULT NULL,
  `typeofsetaside` varchar(255) DEFAULT NULL,
  `fedbizopps` varchar(255) DEFAULT NULL,
  `organizationaltype` varchar(255) DEFAULT NULL,
  `numberofemployees` double DEFAULT NULL,
  `annualrevenue` double DEFAULT NULL,
  `firm8aflag` varchar(255) DEFAULT NULL,
  `hubzoneflag` varchar(255) DEFAULT NULL,
  `sdbflag` varchar(255) DEFAULT NULL,
  `womenownedflag` varchar(255) DEFAULT NULL,
  `veteranownedflag` varchar(255) DEFAULT NULL,
  `srdvobflag` varchar(255) DEFAULT NULL,
  `prime_awardee_executive1` varchar(255) DEFAULT NULL,
  `prime_awardee_executive2` varchar(255) DEFAULT NULL,
  `prime_awardee_executive3` varchar(255) DEFAULT NULL,
  `prime_awardee_executive4` varchar(255) DEFAULT NULL,
  `prime_awardee_executive5` varchar(255) DEFAULT NULL,
  `last_modified_date` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;