hackathon2020
WWT Hackathon 2020 - 1st Place Prize!
Winners Winners Chicken Dinners
Code Flow
Creating the MySQL Tables
Quotes
CREATE TABLE mysql.ne_nj_tbl(quote_number VARCHAR(8), ext_rev DECIMAL(10,2), discount DECIMAL(3,2), gp DECIMAL(10,2), gp_perc DECIMAL(3,2), manuf VARCHAR(50), pnl VARCHAR(50), customer VARCHAR(100));
SOWs
CREATE TABLE innovation.services(IR VARCHAR(20), Revenue DECIMAL(10,2), Cost DECIMAL(10,2), Profit DECIMAL(10,2), Margin DECIMAL(10,2), Hours DECIMAL(10,0), Rate DECIMAL(10,2), Practice VARCHAR(50), Format VARCHAR(50), Account VARCHAR(100), Opportunity VARCHAR(100), Organization VARCHAR(100));