ritesh

top navigation
 
Ritesh Mandal Dr.
   

MedDRA Database Structure - Sample medDRA 9.1 SQL

 
   
     
     


The MedDRA documentation is good enough to create the table structure and import the supplied ASCII files. Given below is the example how I tested the import of MedDRA 9.0 into MySQL. "LOAD DATA LOCAL INFILE" command was used to import the ASCII files :

TABLE low_level_term

CREATE TABLE 1_low_level_term (
llt_code bigint not null,
llt_name varchar(100) not null,
pt_code bigint,
llt_whoart_code varchar(7),
llt_harts_code bigint,
llt_costart_sym varchar(21),
llt_icd9_code varchar(8),
llt_icd9cm_code varchar(8),
llt_icd10_code varchar(8),
llt_currency varchar(1),
llt_jart_code varchar(6),

CREATE UNIQUE INDEX ix1_pt_llt01 ON 1_low_level_term (llt_code);
CREATE UNIQUE INDEX ix1_pt_llt02 ON 1_low_level_term (llt_name);
CREATE UNIQUE INDEX ix1_pt_llt03 ON 1_low_level_term (pt_code);

) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;

-----------------------------------------------------------------------------------------

TABLE pref_term

CREATE TABLE 1_pref_term (
pt_code bigint not null,
pt_name varchar(100) not null,
null_field char(1),
pt_soc_code bigint,
pt_whoart_code varchar(7),
pt_harts_code bigint,
pt_costart_sym varchar(21),
pt_icd9_code varchar(8),
pt_icd9cm_code varchar(8),
pt_icd10_code varchar(8),
pt_jart_code varchar(6)

CREATE UNIQUE INDEX ix1_pt01 ON 1_pref_term (pt_code);
CREATE UNIQUE INDEX ix1_pt02 ON 1_pref_term (pt_name);
CREATE UNIQUE INDEX ix1_pt03 ON 1_pref_term (pt_soc_code);

) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;


     
     

 
         
  MY TUTORIALS FOR BEGINNERS :
Medical Coding | Web Designing | Oracle | MySQL | Linux | Java | ICH GCP | Clinical Data Management | Indian Clinical Trials | 21 CFR Part 11 | Web server | PHP | 443 & SSL | Web Hosting | GXP India | Apache | Other Databases | Image Editing | Software validation | Networking | Guitar | Disclaimer of use
 
 
 
 
© www.riteshmandal.com
Contact : ritesh@riteshmandal.com