REDCDM NGS

Tables (4)

Untitled (variants_of_interest)

  • Key (varients_id) — int — Primary key — NOT NULL
  • Key (patient_info_id) — int — Foreign key → patient_info.Key — NOT NULL
  • Field (ACMG_class) — varchar(10)
  • Field (gene) — varchar(10)
  • Field (accession) — varchar(50)
  • Field (nucleotide) — varchar(100)
  • Field (amino_acid) — varchar(50)
  • Field (zygosity) — varchar(20)
  • Field (dbSNP) — varchar(50)
  • Field (disorder) — varchar(255)
  • Field (inheritance) — varchar(20)
  • Field (global) — float
  • Field (korean) — float
  • Field (comment) — nvarchar(255)

Untitled (note)

  • Key (note_id) — int — Primary key — NOT NULL
  • Key (patient_info_id) — int — Foreign key → patient_info.Key — NOT NULL
  • Field (comments) — nvarchar(max)
  • Field (methodology) — nvarchar(max)

Untitled (target_genes)

  • Key (target_genes_id) — int — Primary key — NOT NULL
  • Key (patient_info_id) — int — Foreign key → patient_info.Key — NOT NULL
  • Field (target_gene) — varchar(10)

patient_info

  • Key (patient_info_id) — int — Primary key — NOT NULL
  • Field (patient_name) — nvarchar(10)
  • Field (patient_id) — int
  • Field (birth_date) — date
  • Field (referring_diagnosis) — varchar(20)
  • Field (sex) — varchar(10)
  • Field (specimen_type) — varchar(50)
  • Field (date_collected) — date
  • Field (date_reported) — date
  • Field (referring_physician) — nvarchar(10)