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 ;