Drugs@FDA数据文件
正文 · 中文译文
Drugs@FDA 数据文件 药品批准与数据库 药品试验快照 信息 | 已批准药品 资源 以下您将找到 Drugs@FDA 数据库的压缩数据文件。它不包含我们用于生成在线版 Drugs@FDA 的脚本（程序）。我们向熟悉数据库或电子表格操作的用户提供此技术信息。所有字段均以制表符分隔。每个表的主键、数据类型、字段长度和空值均列于下方。数据文件每天上午更新，周一至周五。 下载压缩文件（drugsatfda.zip）后，您可以将其解压为 12 个文本表。然后您可以将这些表导入数据库、电子表格或文字处理程序。通常，数据库程序是处理此类文件的最佳程序。 我们无法就如何构建您的数据库设计提供指导，因为每个用户都有不同的需求或用途。 下载文件 Drugs@FDA 下载文件（ZIP - 5.95KB） 数据最后更新：2026年11月2日 Drugs@FDA 的数据定义和 ERD（截至2025年1月10日） 实体关系图 Drugs@FDA 由 12 个表组成： ActionTypes_Lookup [ActionTypes_LookupID] [int] IDENTITY(1,1) NOT NULL [ActionTypes_LookupDescription] [varchar](100) NOT NULL [SupplCategoryLevel1Code] [varchar](100) NULL [SupplCategoryLevel2Code] [varchar](100) NULL ApplicationDocs [ApplicationDocsID] [int] IDENTITY(1,1) NOT NULL [ApplicationDocsTypeID] [int] NOT NULL [ApplNo] [char](6) NOT NULL [SubmissionType] [char](10) NOT NULL [SubmissionNo] [int] NOT NULL [ApplicationDocsTitle] [varchar](100) NULL [ApplicationDocsURL] [varchar](200) NULL [ApplicationDocsDate] [datetime] NULL Applications [ApplNo] [char](6) NOT NULL [ApplType] [char](5) NOT NULL [ApplPublicNotes] [text] NULL [SponsorName] [char](500) NULL ApplicationsDocsType_Lookup [ApplicationDocsType_Lookup_ID] [int] IDENTITY(1,1) NOT NULL [ApplicationDocsType_Lookup_Description] [varchar](200) NOT NULL Join_Submission_ActionType_Lookup [J_SubmissionActionTypeID] [int] IDENTITY(1,1) NOT NULL [SubmissionNo] [int] NOT NULL [SubmissionType] [char](10) NOT NULL [ApplNo] [char](6) NOT NULL [ActionTypes_LookupID] [int] NOT NULL MarketingStatus [ApplNo] [char](6) NOT NULL， [ProductNo] [char](3) NOT NULL， [MarketingStatusID] [int] NOT NULL MarketingStatus_Lookup [MarketingStatusID] [int] IDENTITY(1,1) NOT NULL [MarketingStatusDescription] [varchar](200) NOT NULL Products [ApplNo] [char](6) NOT NULL [ProductNo] [char](6) NOT NULL [Form] [varchar](255) NULL [Strength] varchar](240) NULL [ReferenceDrug] [int] NULL [DrugName] [varchar](125) NULL [ActiveIngredient] [varchar](255) NULL [ReferenceStandard] [int] NULL SubmissionClass_Lookup [SubmissionClassCodeID] [int] IDENTITY(1,1) NOT NULL [SubmissionClassCode] [varchar](50) NOT NULL [SubmissionClassCodeDescription] [varchar](500) NULL SubmissionPropertyType [ApplNo] [char](6) NOT NULL [SubmissionType] [char](10) NOT NULL [SubmissionNo] [int] NOT NULL [SubmissionPropertyTypeCode] [varchar](50) NOT NULL（孤儿或 NULL） SubmissionPropertyTypeID [int] NOT NULL Submissions [ApplNo] [char](6) NOT NULL [SubmissionClassCodeID] [int] NULL [SubmissionType] [char](10) NOT NULL [SubmissionNo] [int] NOT NULL [SubmissionStatus] [char](2) NULL [SubmissionStatusDate] [datetime] NULL [SubmissionsPublicNotes] [text] NULL [ReviewPriority] [varchar](20)（Standard、Priority、NULL） TE [ApplNo] [char](6) NOT NULL [ProductNo] [char](3) NOT NULL [MarketingStatusID] [int] NOT NULL [TECode] [varchar](100) NOT NULL 内容截至： 2026年11月2日 受监管产品 生物制品 药品
正文 · 英文原文
Drugs@FDA Data Files Drug Approvals and Databases Drug Trials Snapshots Resources for Information | Approved Drugs 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 separated by tab delimiters. Each table's primary key, data types, field lengths and nulls appear in the list below. The data file is updated each morning, Monday through Friday. Once you have downloaded the compressed file (drugsatfda.zip), you can unzip the file into 12 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 File Drugs@FDA Download File (ZIP - 5.95KB) Data Last Updated: November 2, 2026 Data Definitions and ERD for Drugs@FDA (as of January 10, 2025) Entity Relationship Diagram Drugs@FDA consists of 12 tables: ActionTypes_Lookup [ActionTypes_LookupID] [int] IDENTITY(1,1) NOT NULL [ActionTypes_LookupDescription] [varchar](100) NOT NULL [SupplCategoryLevel1Code] [varchar](100) NULL [SupplCategoryLevel2Code] [varchar](100) NULL ApplicationDocs [ApplicationDocsID] [int] IDENTITY(1,1) NOT NULL [ApplicationDocsTypeID] [int] NOT NULL [ApplNo] [char](6) NOT NULL [SubmissionType] [char](10) NOT NULL [SubmissionNo] [int] NOT NULL [ApplicationDocsTitle] [varchar](100) NULL [ApplicationDocsURL] [varchar](200) NULL [ApplicationDocsDate] [datetime] NULL Applications [ApplNo] [char](6) NOT NULL [ApplType] [char](5) NOT NULL [ApplPublicNotes] [text] NULL [SponsorName] [char](500) NULL ApplicationsDocsType_Lookup [ApplicationDocsType_Lookup_ID] [int] IDENTITY(1,1) NOT NULL [ApplicationDocsType_Lookup_Description] [varchar](200) NOT NULL Join_Submission_ActionType_Lookup [J_SubmissionActionTypeID] [int] IDENTITY(1,1) NOT NULL [SubmissionNo] [int] NOT NULL [SubmissionType] [char](10) NOT NULL [ApplNo] [char](6) NOT NULL [ActionTypes_LookupID] [int] NOT NULL MarketingStatus [ApplNo] [char](6) NOT NULL, [ProductNo] [char](3) NOT NULL, [MarketingStatusID] [int] NOT NULL MarketingStatus_Lookup [MarketingStatusID] [int] IDENTITY(1,1) NOT NULL [MarketingStatusDescription] [varchar](200) NOT NULL Products [ApplNo] [char](6) NOT NULL [ProductNo] [char](6) NOT NULL [Form] [varchar](255) NULL [Strength] varchar](240) NULL [ReferenceDrug] [int] NULL [DrugName] [varchar](125) NULL [ActiveIngredient] [varchar](255) NULL [ReferenceStandard] [int] NULL SubmissionClass_Lookup [SubmissionClassCodeID] [int] IDENTITY(1,1) NOT NULL [SubmissionClassCode] [varchar](50) NOT NULL [SubmissionClassCodeDescription] [varchar](500) NULL SubmissionPropertyType [ApplNo] [char](6) NOT NULL [SubmissionType] [char](10) NOT NULL [SubmissionNo] [int] NOT NULL [SubmissionPropertyTypeCode] [varchar](50) NOT NULL (Orphan or NULL) SubmissionPropertyTypeID [int] NOT NULL Submissions [ApplNo] [char](6) NOT NULL [SubmissionClassCodeID] [int] NULL [SubmissionType] [char](10) NOT NULL [SubmissionNo] [int] NOT NULL [SubmissionStatus] [char](2) NULL [SubmissionStatusDate] [datetime] NULL [SubmissionsPublicNotes] [text] NULL [ReviewPriority] [varchar](20) (Standard, Priority, NULL) TE [ApplNo] [char](6) NOT NULL [ProductNo] [char](3) NOT NULL [MarketingStatusID] [int] NOT NULL [TECode] [varchar](100) NOT NULL Content current as of: 11/02/2026 Regulated Product(s) Biologics Drugs