Kwyllie: Started the week 6 assignment...not that I got very far...

2015-10-09T19:52:28Z

Started the week 6 assignment...not that I got very far...

New page

==Protocol==

==Protocol - Creating the "Applications" Table==

# First, download the appropriate FDA file (found on the [[http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm|FDA's website]], and unzip it.
# View the "application.txt" file and note the column headings.
# Open pgAdminIII, login, and create a new table by right-clicking on "Databases" and selecting "New Database."
# Open the SQL window. Given the headings in application.txt, the appropriate command to create the table is:
<code>create table Applications_kwyllie (ApplNo int primary key, ApplType varchar, SponsorApplication varchar, MostRecentLabelAvailableFlag varchar, CurrentPatentFlag varchar, ActionType varchar, Chemical_Type int, Ther_potential varchar, Orphan_code varchar)</code>

Week 6/ - Revision history

Kwyllie: Started the week 6 assignment...not that I got very far...