[[Augi Liebster (Work Log)]]
===Relevant Former Projects===
#[[Venture Capital (Data)]]
#[[Retrieving US VC Data From SDC]]
===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:
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.
===Pulling from SDC===
Finding what to enter into the SDC in order to run the reports that were already created is not always intuitive. As such I have included the process for each table here.
#USVCPortCoPresent-1980: VentureXpert -> Portfolio Companies ->