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)