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)