220
edits
Changes
Jump to navigation
Jump to search
no edit summary
VC Partnership
Other
==Building companybase and round==
Both are built from roundbase. The scripts are below.
CREATE TABLE companybase AS
SELECT DISTINCT
coname,updateddate,foundingdate,datelastinv,datefirstinv,investedk,city,description,msa,msacode,nationcode,statecode,addr1,a
ddr2,indclass,indsubgroup3,indminor,url,zip
FROM roundbase
ORDER BY coname;
CREATE TABLE round AS
SELECT DISTINCT coname,statecode,datefirstinv,rounddate,stage1,stage3,rndamtdisck,rndamtestk,roundnum,numinvestors
FROM roundbase
ORDER BY coname;
