MedDRA
Tables (12)
1_hlgt_hlt_comp (hlgt_hlt_comp)
- hlgt_code — int — Foreign key → 1_hlgt_pref_term.hlgt_code — NOT NULL
- hlt_code — int — Foreign key → 1_hlt_pref_term.hlt_code — NOT NULL
1_hlgt_pref_term (hlgt_pref_term)
- hlgt_code — int — Primary key — NOT NULL
- hlgt_name — varchar(100)
- hlgt_whoart_code — varchar(7)
- hlgt_harts_code — int
- hlgt_costart_sym — varchar(21)
- hlgt_icd9_code — varchar(8)
- hlgt_icd9cm_code — varchar(8)
- hlgt_icd10_code — varchar(8)
- hlgt_jart_code — varchar(6)
1_hlt_pref_comp (hlt_pref_comp)
- hlt_code — int — Foreign key → 1_hlt_pref_term.hlt_code — NOT NULL
- pt_code — int — Foreign key → 1_pref_term.pt_code — NOT NULL
1_hlt_pref_term (hlt_pref_term)
- hlt_code — int — Primary key — NOT NULL
- hlt_name — varchar(100)
- hlt_whoart_code — varchar(7)
- hlt_harts_code — int
- hlt_costart_sym — varchar(21)
- hlt_icd9_code — varchar(8)
- hlt_icd9cm_code — varchar(8)
- hlt_icd10_code — varchar(8)
- hlt_jart_code — varchar(8)
1_low_level_term (low_level_term)
- llt_code — int — Primary key — NOT NULL
- llt_name — varchar(100)
- pt_code — int — Foreign key → 1_pref_term.pt_code — NOT NULL
- llt_whoart_code — varchar(7)
- llt_harts_code — int
- llt_costart_sym — varchar(21)
- llt_icd9_code — varchar(21)
- llt_icd9cm_code — varchar(8)
- llt_icd10_code — varchar(8)
- llt_currency — varchar(1)
- llt_jart_code — varchar(6)
1_md_hierarchy (md_hierarchy)
- pt_code — int — Foreign key → 1_pref_term.pt_code — NOT NULL
- hlt_code — int — Foreign key → 1_hlt_pref_term.hlt_code — NOT NULL
- hlgt_code — int — Foreign key → 1_hlgt_pref_term.hlgt_code — NOT NULL
- soc_code — int — Foreign key → 1_soc_term.soc_code — NOT NULL
- pt_name — varchar(100)
- hlt_name — varchar(100)
- hlgt_name — varchar(100)
- soc_name — varchar(100)
- soc_abbrev — varchar(5)
- null_field — varchar(1)
- pt_soc_code — int
- primary_soc_fg — varchar(1)
1_pref_term (pref_term)
- pt_code — int — Primary key — NOT NULL
- pt_name — varchar(100)
- null_field — varchar(1)
- pt_soc_code — int — Foreign key → 1_soc_term.soc_code — NOT NULL
- pt_whoart_code — varchar(7)
- pt_harts_code — int
- pt_costart_sym — varchar(21)
- pt_icd9_code — varchar(8)
- pt_icd9cm_code — varchar(8)
- pt_icd10_code — varchar(8)
- pt_jart_code — varchar(8)
1_smq_content (smq_content)
- smq_code — int — Foreign key → 1_smq_list.smq_code — NOT NULL
- term_code — int — Foreign key → 1_pref_term.pt_code — NOT NULL
- term_level — int
- term_scope — int
- term_category — varchar(1)
- term_weight — int
- term_status — varchar(1)
- term_addition_version — varchar(5)
- term_last_modified_version — varchar(5)
1_smq_list (smq_list)
- smq_code — int — Primary key — NOT NULL
- smq_name — varchar(100)
- smq_level — int
- smq_description — varchar(max)
- smq_source — varchar(max)
- smq_note — varchar(max)
- MedDRA_version — varchar(5)
- status — varchar(1)
- smq_algorithm — varchar(max)
1_soc_hlgt_comp (soc_hlgt_comp)
- hlgt_code — int — Foreign key → 1_hlgt_pref_term.hlgt_code — NOT NULL
- soc_code — int — Foreign key → 1_soc_term.soc_code — NOT NULL
1_soc_intl_order (soc_intl_order)
- intl_ord_code — int — Primary key — NOT NULL
- soc_code — int — Foreign key → 1_soc_term.soc_code — NOT NULL
1_soc_term (soc_term)
- soc_code — int — Primary key — NOT NULL
- soc_name — varchar(100)
- soc_abbrev — varchar(5)
- soc_whoart_code — varchar(7)
- soc_harts_code — int
- soc_costart_sym — varchar(21)
- soc_icd9_code — varchar(8)
- soc_icd9cm_code — varchar(8)
- soc_icd10_code — varchar(8)
- soc_jart_code — varchar(6)