CDM NGS Extend

Tables (10)

Untitled (genomic_test)

  • Key (genomic_test_id) — INTEGER — Primary key — NOT NULL
  • care_site_id — INTEGER — Foreign key → care_site.care_site_id — NOT NULL
  • Field (genomic_test_name) — VARCHAR(255)
  • Field (genomic_test_version) — VARCHAR(50)
  • Field (reference_genome) — VARCHAR(50)
  • Field (sequencing_device) — VARCHAR(50)
  • Field (library_preparation) — VARCHAR(50)
  • Field (target_capture) — VARCHAR(50)
  • Field (read_type) — VARCHAR(50)
  • Field (read_length) — INTEGER
  • Field (quality_control_tools) — VARCHAR(255)
  • Field (total_reads) — INTEGER
  • Field (mean_target_coverage) — FLOAT
  • Field (per_target_base_cover_100x) — FLOAT
  • Field (alignment_tools) — VARCHAR(255)
  • Field (variant_calling_tools) — VARCHAR(255)
  • Field (chromosome_corrdinate) — VARCHAR(255)
  • Field (annotation_tools) — VARCHAR(255)
  • Field (annotation_databases) — VARCHAR(255)

Untitled (target_gene)

  • Key (target_gene_id) — INTEGER — Primary key — NOT NULL
  • Key (genomic_test_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Field (hgnc_id) — VARCHAR(50)
  • Field (hgnc_symbol) — VARCHAR(50)
  • Field (chromosome_id)
  • Field (start_position)
  • Field (end_position)

Untitled (variant_occurence)

  • Key (variant_occurence_id) — INTEGER — Primary key — NOT NULL
  • procedure_occurrence_id — INTEGER — Foreign key → procedure_occurrence.procedure_occurrence_id — NOT NULL
  • specimen_id — INTEGER — Foreign key → specimen.specimen_id — NOT NULL
  • specimen_id (reference_specimen_id) — INTEGER — Foreign key → specimen.specimen_id — NOT NULL
  • Key (target_gene_id1) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Key (target_gene_id2) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Field (reference_sequence) — VARCHAR(50)
  • Field (rs_id) — VARCHAR(50)
  • Field (reference_allele) — VARCHAR(255)
  • Field (alternate_allele) — VARCHAR(255)
  • Field (hgvs_c) — VARCHAR(MAX)
  • Field (hgvs_p) — VARCHAR(MAX)
  • Field (variant_read_depth) — INTEGER
  • Field (total_read_depth) — INTEGER
  • Field (variant_exon_number) — INTEGER
  • Field (copy_number) — FLOAT
  • Field (cnv_locus) — VARCHAR(MAX)
  • Field (fusion_breakpoint) — INTEGER
  • Field (fusion_supporting_reads) — INTEGER
  • Field (sequence_alteration) — VARCHAR(MAX)
  • Field (variant_feature) — VARCHAR(MAX)
  • Field (genetic_origin) — VARCHAR(50)
  • Field (genotype) — VARCHAR(50)

Untitled (variant_annotation)

  • Key (variant_annotation_id) — INTEGER — Primary key — NOT NULL
  • Key (variant_occurence_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Field (annotation_field) — VARCHAR(MAX)
  • Field (value_as_string) — VARCHAR(MAX)
  • Field (value_as_number) — FLOAT
  • Field (variant_pathogeny)
  • Field (variant_class_level)
  • Field (variant_tier_level)
  • Field (allele_frequency)
  • Field (medication)
  • Field (clinical_trail_information)

care_site

  • care_site_id — INTEGER — Primary key — NOT NULL
  • care_site_name — VARCHAR(255)
  • place_of_service_concept_id — INTEGER
  • location_id — INTEGER — Foreign key → location.location_id
  • care_site_source_value — VARCHAR(50)
  • place_of_service_source_value — VARCHAR(50)

location

  • location_id — INTEGER — Primary key — NOT NULL
  • address_1 — VARCHAR(50)
  • address_2 — VARCHAR(50)
  • city — VARCHAR(50)
  • state — VARCHAR(2)
  • zip — VARCHAR(9)
  • county — VARCHAR(20)
  • location_source_value — VARCHAR(50)

person

  • person_id — INTEGER — Primary key — NOT NULL
  • gender_concept_id — INTEGER — NOT NULL
  • year_of_birth — INTEGER — NOT NULL
  • month_of_birth — INTEGER
  • day_of_birth — INTEGER
  • birth_datetime — DATETIME2
  • race_concept_id — INTEGER — NOT NULL
  • ethnicity_concept_id — INTEGER — NOT NULL
  • location_id — INTEGER — Foreign key → location.location_id
  • provider_id — INTEGER
  • care_site_id — INTEGER — Foreign key → care_site.care_site_id
  • person_source_value — VARCHAR(50)
  • gender_source_value — VARCHAR(50)
  • gender_source_concept_id — INTEGER
  • race_source_value — VARCHAR(50)
  • race_source_concept_id — INTEGER
  • ethnicity_source_value — VARCHAR(50)
  • ethnicity_source_concept_id — INTEGER

procedure_occurrence

  • procedure_occurrence_id — INTEGER — Primary key — NOT NULL
  • person_id — INTEGER — Foreign key → person.person_id — NOT NULL
  • procedure_concept_id — INTEGER — NOT NULL
  • procedure_date — DATE — NOT NULL
  • procedure_datetime — DATETIME2 — NOT NULL
  • procedure_type_concept_id — INTEGER — NOT NULL
  • modifier_concept_id — INTEGER
  • quantity — INTEGER
  • provider_id — INTEGER
  • visit_occurrence_id — INTEGER — Foreign key → visit_occurrence.visit_occurrence_id
  • procedure_source_value — VARCHAR(50)
  • procedure_source_concept_id — INTEGER
  • qualifier_source_value — VARCHAR(50)
  • person_id (person_id2) — INTEGER — Foreign key → person.person_id — NOT NULL

specimen

  • specimen_id — INTEGER — Primary key — NOT NULL
  • person_id — INTEGER — Foreign key → person.person_id — NOT NULL
  • specimen_concept_id — INTEGER — NOT NULL
  • specimen_type_concept_id — INTEGER — NOT NULL
  • specimen_date — DATE — NOT NULL
  • specimen_datetime — DATETIME2
  • quantity — FLOAT
  • unit_concept_id — INTEGER
  • anatomic_site_concept_id — INTEGER
  • disease_status_concept_id — INTEGER
  • specimen_source_id — VARCHAR(50)
  • specimen_source_value — VARCHAR(50)
  • unit_source_value — VARCHAR(50)
  • anatomic_site_source_value — VARCHAR(50)
  • disease_status_source_value — VARCHAR(50)
  • person_id (person_id2) — INTEGER — Foreign key → person.person_id — NOT NULL

visit_occurrence

  • visit_occurrence_id — INTEGER — Primary key — NOT NULL
  • person_id — INTEGER — Foreign key → person.person_id — NOT NULL
  • visit_concept_id — INTEGER — NOT NULL
  • visit_start_date — DATE — NOT NULL
  • visit_start_datetime — DATETIME2
  • visit_end_date — DATE — NOT NULL
  • visit_end_datetime — DATETIME2
  • visit_type_concept_id — INTEGER — NOT NULL
  • provider_id — INTEGER
  • care_site_id — INTEGER — Foreign key → care_site.care_site_id
  • visit_source_value — VARCHAR(50)
  • visit_source_concept_id — INTEGER
  • admitting_source_concept_id — INTEGER
  • admitting_source_value — VARCHAR(50)
  • discharge_to_concept_id — INTEGER
  • discharge_to_source_value — VARCHAR(50)
  • preceding_visit_occurrence_id — INTEGER
  • person_id (person_id2) — INTEGER — Foreign key → person.person_id — NOT NULL