Week 6/

Protocol - Creating the "Applications" Table

1. First, download the appropriate FDA file (found on the [website], and unzip it.
2. View the "application.txt" file and note the column headings.
3. Open pgAdminIII, login, and create a new table by right-clicking on "Databases" and selecting "New Database."
4. Open the SQL window. Given the headings in application.txt, the appropriate command to create the table is:

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)