Malverso Week 6
From LMU BioDB 2015
Contents
FDA Drug Database
Direct Download/Unzipping Commands
- I logged onto PuTTy and also brought up my public folder on the web browser at the web address my.cs.lmu.edu/~malverso/
- I downloaded and unzipped my files through the command line, using the curl and unzip commands.
- I put the untouched file onto my public web page so I could visually see my progress.
- My database is saved under the student account of PgAdminIII under the name FDA-malverso.
#1
application.txt
- I viewed the application.txt file using the more command to see the column titles, which are:
ApplNo ApplType SponsorApplicant MostRecentLabelAvailableFlag CurrentPatentFlag ActionType Chemical_Type Ther_Potential Orphan_Code
- I referenced the PostgreSQL Tutorial for how to create a table and http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm for primary key information. I then created a table using this command:
create table application (ApplNo varchar primary key, ApplType varchar, SponsorApplicant varchar, MostRecentLabelAvailableFlag boolean, CurrentPatentFlag boolean, ActionType varchar, Chemical_Type varchar, Therapeutic_Potential varchar, Orphan_Code varchar)
Product.txt
- I viewed the Product.txt file using the more command to see the column titles, which are:
ApplNo ProductNo Form Dosage ProductMktStatus TECode ReferenceDrug drugname activeingred
- I created a table for Product.txt using this command:
create table Product(ApplNo varchar, productNo varchar, Form varchar, Dosage varchar, ProductMktStatus int, TECode varchar, ReferenceDrug boolean, Drugname varchar, Activeingred varchar)
Team Page
Assignments
- Week 1
- Week 2
- Week 3
- Week 4
- Week 5
- Week 6
- Week 7
- Week 8
- Week 9
- Week 10
- Week 11
- Week 12
- Week 13
- Week 14
- Week 15
Individual Journal Entries
- Malverso User Page (Week 1)
- Week 2
- Week 3
- Week 4
- Week 5
- Week 6
- Week 7
- Week 8
- Week 9
- Week 10
- Week 11
- Week 12
- Week 13
- Week 14
- Week 15
