Drugs@FDA Data Files
Below you will find a compressed data file of the Drugs@FDA database. It does not include the scripts (programming) we use to produce the online version of Drugs@FDA. We are providing this technical information for users who are familiar with working with databases or spreadsheets. All fields are double-quoted and separated by commas. Each table's primary key, data types, field lengths and nulls appear in the list below. While the official online application, Drugs@FDA, is updated daily, this data file is updated once per week, on Wednesday.
Once you have downloaded the compressed file (drugsatfda.zip), you can unzip the file into 9 text tables. You can then import the tables into a database, spreadsheet or word processing program. Generally, a database program is the best program to use for these types of files. We cannot offer guidance on how to construct your database design, as each user has different requirements or uses.
Download the Drugs@FDA Data File (1.2 MB zip file) Last updated: 5/9/2007.
Entity Relationship Diagram
Drugs@FDA consists of 9 tables:
Application Documents (AppDoc): Document addresses or URLs to letters, labels, reviews, Consumer Information Sheets, FDA Talk Papers, and other types.
AppDocID (Primary Key)
ApplNo
SeqNo
DocType
DocTitle
DocURL
DocDate
ActionType
DuplicateCounter
Application Document Type Lookup (AppDocType_Lookup): Type of document that is linked, which relates to the AppDoc table.
AppDocType (Primary Key)
SortOrder
Application (Application): Application number and sponsor name.
ApplNo (Primary Key)
ApplType
SponsorApplicant
MostRecentLabelAvailableFlag
CurrentPatentFlag
ActionType
Chemical_Type
Therapeutic_Potential
Orphan_Code
Document Type Lookup (DocType_Lookup): Supplement type code and description to the application number.
DocType (Primary Key)
DocTypeDesc
Product (Product): This table contains the products included in each application. Includes form, dosage, and route.
ApplNo (Primary Key)
ProductNo (Primary Key)
Form
Dosage
ProductMktStatus (1=prescription, 2=OTC, 3=discontinued, 4=tentative approval) (Primary Key)
TECode
ReferenceDrug
Drugname
Activeingred
Product_TECode: Therapeutic Equivalence Code for Products.
ApplNo (Primary Key)
ProductNo (Primary Key)
TECode
TESequence (Primary Key)
ProdMktStatus (Primary Key)
Supplements (RegActionDate): Approval history for each application. Includes supplement number and dates of approval.
ApplNo (Primary Key)
ActionType
InDocTypeSeqNo (Primary Key)
DuplicateCounter (Primary Key)
ActionDate
DocType
ChemicalType_Lookup
ChemicalTypeID (Primary Key)
ChemicalTypeCode
ChemicalTypeDescription
ReviewClass_Lookup
ReviewClassID (Primary Key)
ReviewCode
LongDescritption
ShortDescription
请教各位有经验的兄弟，帮忙了，一直没有弄明白。
怎么没人知道，求助了
不明白你想知道什么？你想帮FDA管理药品数据库？
Drugs@FDA 随时可上网查询，我是不想自己再建立一个数据库。
我也想知道这个怎么弄，怎么没人关注？
刚看下面的，应该是access+sql
刚才看错了
个人感觉。
刚看下面的，应该是access+sql
刚才看错了
个人感觉。
这个我做过，可以导入access做成mdb文件，如果想要发布到网站的话可以用asp+access，这需要编写界面及相关的查询脚本。不过FDA每周都要更新数据库，为保证时效性，你也每周都得更新数据，不如直接查FDA来得快。
Below you will find a compressed data file of the Drugs@FDA database. It does not include the scripts (programming) we use to produce the online version of Drugs@FDA. We are providing this technical information for users who are familiar with working with databases or spreadsheets. All fields are double-quoted and separated by commas. Each table's primary key, data types, field lengths and nulls appear in the list below. While the official online application, Drugs@FDA, is updated daily, this data file is updated once per week, on Wednesday.
Once you have downloaded the compressed file (drugsatfda.zip), you can unzip the file into 9 text tables. You can then import the tables into a database, spreadsheet or word processing program. Generally, a database program is the best program to use for these types of files. We cannot offer guidance on how to construct your database design, as each user has different requirements or uses.
Download the Drugs@FDA Data File (1.2 MB zip file) Last updated: 5/9/2007.
Entity Relationship Diagram
Drugs@FDA consists of 9 tables:
Application Documents (AppDoc): Document addresses or URLs to letters, labels, reviews, Consumer Information Sheets, FDA Talk Papers, and other types.
AppDocID (Primary Key)
ApplNo
SeqNo
DocType
DocTitle
DocURL
DocDate
ActionType
DuplicateCounter
Application Document Type Lookup (AppDocType_Lookup): Type of document that is linked, which relates to the AppDoc table.
AppDocType (Primary Key)
SortOrder
Application (Application): Application number and sponsor name.
ApplNo (Primary Key)
ApplType
SponsorApplicant
MostRecentLabelAvailableFlag
CurrentPatentFlag
ActionType
Chemical_Type
Therapeutic_Potential
Orphan_Code
Document Type Lookup (DocType_Lookup): Supplement type code and description to the application number.
DocType (Primary Key)
DocTypeDesc
Product (Product): This table contains the products included in each application. Includes form, dosage, and route.
ApplNo (Primary Key)
ProductNo (Primary Key)
Form
Dosage
ProductMktStatus (1=prescription, 2=OTC, 3=discontinued, 4=tentative approval) (Primary Key)
TECode
ReferenceDrug
Drugname
Activeingred
Product_TECode: Therapeutic Equivalence Code for Products.
ApplNo (Primary Key)
ProductNo (Primary Key)
TECode
TESequence (Primary Key)
ProdMktStatus (Primary Key)
Supplements (RegActionDate): Approval history for each application. Includes supplement number and dates of approval.
ApplNo (Primary Key)
ActionType
InDocTypeSeqNo (Primary Key)
DuplicateCounter (Primary Key)
ActionDate
DocType
ChemicalType_Lookup
ChemicalTypeID (Primary Key)
ChemicalTypeCode
ChemicalTypeDescription
ReviewClass_Lookup
ReviewClassID (Primary Key)
ReviewCode
LongDescritption
ShortDescription
请教各位有经验的兄弟，帮忙了，一直没有弄明白。
怎么没人知道，求助了
不明白你想知道什么？你想帮FDA管理药品数据库？
Drugs@FDA 随时可上网查询，我是不想自己再建立一个数据库。
我也想知道这个怎么弄，怎么没人关注？
刚看下面的，应该是access+sql
刚才看错了
个人感觉。
刚看下面的，应该是access+sql
刚才看错了
个人感觉。
这个我做过，可以导入access做成mdb文件，如果想要发布到网站的话可以用asp+access，这需要编写界面及相关的查询脚本。不过FDA每周都要更新数据库，为保证时效性，你也每周都得更新数据，不如直接查FDA来得快。