Difference between revisions of "VentureXpert Data"
Jump to navigation
Jump to search
Adliebster (talk | contribs) |
Adliebster (talk | contribs) |
||
| Line 16: | Line 16: | ||
===Goal=== | ===Goal=== | ||
I will be looking to redesign the VC Database in a way that is more intuitively built than the previous one. I will also update the database with current data. | I will be looking to redesign the VC Database in a way that is more intuitively built than the previous one. I will also update the database with current data. | ||
| + | |||
| + | ===Initial Stages=== | ||
| + | The first step of the project was to figure out what primary keys to use for each major table that I create. I looked at the primary keys used in the creation of the [[VC Database Rebuild]] and found primary keys that are decent. I have updated them and list them below: | ||
| + | |||
| + | #CompanyBaseCore- coname, statecode, datefirstinv | ||
| + | #IPOCore- issuer, issuedate, statecode | ||
| + | #MACore- target name, target state code, announceddate | ||
| + | #Geo - city, statecode, coname, datefirst, year | ||
| + | #DeadDate - conname, statecode, datefirst, rounddate (tentative could still change) | ||
| + | #RoundCore- conname, statecode, datefirst, rounddate | ||
| + | #FirmBaseCore - firmname | ||
| + | #FundBaseCore - fund name, firstinvdate | ||
| + | |||
| + | These are my initial listings and I will come back to update them if needed. | ||
| + | |||
| + | The second part of the initial stage has been to pull data from the SDC Platinum platform with updated dates to make the pull as recent as possible. | ||
Revision as of 13:42, 26 June 2018
| VentureXpert Data | |
|---|---|
| Project Information | |
| Project Title | VentureXpert Data |
| Owner | Augi Liebster |
| Start Date | June 20, 2018 |
| Deadline | |
| Primary Billing | |
| Notes | |
| Has project status | Active |
| Copyright © 2016 edegan.com. All Rights Reserved. | |
Relevant Former Projects
Venture Capital (Data) Retrieving US VC Data From SDC VC Database Rebuild
Goal
I will be looking to redesign the VC Database in a way that is more intuitively built than the previous one. I will also update the database with current data.
Initial Stages
The first step of the project was to figure out what primary keys to use for each major table that I create. I looked at the primary keys used in the creation of the VC Database Rebuild and found primary keys that are decent. I have updated them and list them below:
- CompanyBaseCore- coname, statecode, datefirstinv
- IPOCore- issuer, issuedate, statecode
- MACore- target name, target state code, announceddate
- Geo - city, statecode, coname, datefirst, year
- DeadDate - conname, statecode, datefirst, rounddate (tentative could still change)
- RoundCore- conname, statecode, datefirst, rounddate
- FirmBaseCore - firmname
- FundBaseCore - fund name, firstinvdate
These are my initial listings and I will come back to update them if needed.
The second part of the initial stage has been to pull data from the SDC Platinum platform with updated dates to make the pull as recent as possible.
