Aivari

Tables (45)

clinicaltrials

  • id — VARCHAR(32) — Primary key — NOT NULL
  • overall_status — VARCHAR(32)
  • condition_n — TEXT
  • brief_title — TEXT
  • intervention_type_n — TEXT
  • intervention_name_n — TEXT
  • study_type — VARCHAR(32)
  • completion_date — VARCHAR(32)
  • study_first_post_date — VARCHAR(32)
  • lead_sponsor_name — TEXT

clinicaltrials_related_database

  • id — INT — Primary key — NOT NULL
  • clinicaltrials_id — VARCHAR(32) — Foreign key → clinicaltrials.id — NOT NULL
  • database_id — VARCHAR(32) — NOT NULL

clinvar_diseases

  • disease_id — VARCHAR(50) — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • mechanism — VARCHAR(255)

clinvar_genes

  • gene_id — INT — Primary key — NOT NULL
  • symbol — VARCHAR(50) — NOT NULL

clinvar_genomic_coordinates

  • coord_id — BIGINT — Primary key — NOT NULL
  • vcv_accession — VARCHAR(32) — Foreign key → clinvar_variants.vcv_accession — NOT NULL
  • assembly — VARCHAR(20) — NOT NULL
  • chromosome — VARCHAR(10)
  • position_vcf — BIGINT
  • start_pos — BIGINT
  • stop_pos — BIGINT
  • ref_allele — TEXT
  • alt_allele — TEXT
  • is_normalized — BOOLEAN
  • cpra — VARCHAR(255)
  • INDEX — `idx_coordinates_vcv_accession`
  • INDEX — `idx_coordinates_assembly`

clinvar_publications

  • pmid — INT — Primary key — NOT NULL
  • title — TEXT
  • journal — VARCHAR(255)

clinvar_rcv_publication_link

  • rcv_accession — VARCHAR(32) — Foreign key → clinvar_rcv_records.rcv_accession — NOT NULL
  • pmid — INT — Foreign key — NOT NULL
  • INDEX — `idx_rcv_publication_link_pmid`

clinvar_rcv_records

  • rcv_accession — VARCHAR(32) — Primary key — NOT NULL
  • clinvar_set_id — BIGINT — NOT NULL
  • title — TEXT
  • creation_date — DATETIME
  • last_updated — DATETIME
  • last_evaluated — DATE
  • review_status — VARCHAR(100)
  • star_rating — INT
  • pathogenicity — VARCHAR(100)
  • inheritance — TEXT
  • origin — VARCHAR(100)
  • individuals — INT
  • method — TEXT
  • rcv_reference — VARCHAR(255)

clinvar_related_database

  • id — INT — Primary key — NOT NULL
  • clinvar_id — VARCHAR(32) — NOT NULL — vcv_accession or gene_id
  • database_id — VARCHAR(32) — NOT NULL

clinvar_submissions

  • scv_accession — VARCHAR(32) — Primary key — NOT NULL
  • rcv_accession — VARCHAR(32) — NOT NULL
  • pathogenicity — VARCHAR(100)
  • review_status — VARCHAR(100)
  • origin — VARCHAR(100)
  • method — TEXT
  • affected_status — VARCHAR(100)
  • submitter — TEXT
  • last_evaluated — DATE
  • submit_date — DATE
  • reference — VARCHAR(255)
  • INDEX — `idx_submissions_rcv_accession`

clinvar_variant_disease_link

  • vcv_accession — VARCHAR(32) — Foreign key → clinvar_variants.vcv_accession — NOT NULL
  • disease_id — VARCHAR(50) — Foreign key → clinvar_diseases.disease_id — NOT NULL
  • INDEX — `idx_variant_disease_link_disease_id`

clinvar_variants

  • vcv_accession — VARCHAR(32) — Primary key — NOT NULL
  • gene_id — INT
  • variation_type — VARCHAR(255)
  • allele_id — BIGINT
  • molecular_consequence — TEXT
  • interpretation — VARCHAR(100)
  • review_status — VARCHAR(100)
  • star_rating — INT
  • hgvsc_maneselect — TEXT
  • hgvsp_maneselect — TEXT
  • hgvsg — TEXT
  • dbsnp_id — VARCHAR(50)
  • uniprot_id — VARCHAR(50)
  • INDEX — `idx_variants_gene_id`

database_map

  • id — INT — Primary key — NOT NULL
  • database_name — VARCHAR(32) — NOT NULL
  • database_symbol — VARCHAR(32) — NOT NULL
  • database_description — TEXT

gard

  • id — VARCHAR(32) — Primary key — NOT NULL
  • label — TEXT — NOT NULL
  • synonym — TEXT

gard_related_database

  • id — INT — Primary key — NOT NULL
  • gard_id — VARCHAR(32) — Foreign key → gard.id — NOT NULL
  • database_id — VARCHAR(32) — NOT NULL
  • INDEX — `idx_gard_related_database_gard_id`

genereviews

  • id — VARCHAR(32) — Primary key — NOT NULL
  • short_name — VARCHAR(32) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • pmid — INT — NOT NULL

genereviews_related_database

  • id — INT — Primary key — NOT NULL
  • genereviews_id — VARCHAR(32) — Foreign key → genereviews.id — NOT NULL
  • database_id — VARCHAR(32) — NOT NULL

hgnc

  • id — VARCHAR(32) — Primary key — NOT NULL
  • gene_symbol — VARCHAR(255) — NOT NULL
  • gene_name — TEXT — NOT NULL
  • locus_group — VARCHAR(64)
  • locus_type — VARCHAR(64)
  • status — VARCHAR(16)
  • location — VARCHAR(255)
  • location_sortable — VARCHAR(255)
  • prev_symbol_n — TEXT
  • prev_name_n — TEXT
  • gene_group_n — TEXT
  • gene_group_id_n — TEXT
  • date_approved_reserved — DATE
  • date_symbol_changed — DATE
  • date_name_changed — DATE
  • date_modified — DATE
  • entrez_id — INT — NOT NULL
  • ensembl_gene_id — TEXT
  • INDEX — `idx_hgnc_entrez_id`

hgnc_gene_name_synonym

  • id — INT — Primary key — NOT NULL
  • hgnc_id — VARCHAR(32) — Foreign key → hgnc.id — NOT NULL
  • gene_name — TEXT — NOT NULL
  • INDEX — `idx_hgnc_gene_name_synonym_hgnc_id`

hgnc_gene_symbol_synonym

  • id — INT — Primary key — NOT NULL
  • hgnc_id — VARCHAR(32) — Foreign key → hgnc.id — NOT NULL
  • entrez_id — INT
  • gene_symbol — VARCHAR(255) — NOT NULL
  • INDEX — `idx_hgnc_gene_symbol_synonym_hgnc_id`
  • INDEX — `idx_hgnc_gene_symbol_synonym_gene_symbol`
  • INDEX — `idx_hgnc_gene_symbol_synonym_entrez_id`

hgnc_related_database

  • id — INT — Primary key — NOT NULL
  • hgnc_id — VARCHAR(32) — Foreign key → hgnc.id — NOT NULL
  • database_id — VARCHAR(32) — NOT NULL

hpo

  • id — VARCHAR(32) — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL

hpo_disease_hgnc_related_database

  • id — INT — Primary key — NOT NULL
  • disease_id — VARCHAR(32) — NOT NULL
  • database_id — VARCHAR(32) — NOT NULL

hpo_related_database

  • id — INT — Primary key — NOT NULL
  • hpo_id — VARCHAR(32) — Foreign key → hpo.id — NOT NULL
  • database_id — VARCHAR(32) — NOT NULL

journal_citation_reports

  • id — INT — Primary key — NOT NULL
  • year — CHAR(4) — NOT NULL
  • journal_name — VARCHAR(255) — NOT NULL
  • issn — CHAR(9) — NOT NULL
  • impact_factor — DECIMAL(10,3)
  • INDEX — `idx_journal_citation_reports_issn`

journal_citation_reports_quartile

  • id — INT — Primary key — NOT NULL
  • journal_citation_reports_id — INT — Foreign key → journal_citation_reports.id — NOT NULL
  • category — VARCHAR(45) — NOT NULL
  • quartile — CHAR(8) — NOT NULL
  • INDEX — `idx_jcrq_journal_citation_reports_id`

mondo

  • id — VARCHAR(32) — Primary key — NOT NULL
  • label — TEXT — NOT NULL
  • definition — TEXT

mondo_label_synonym

  • id — INT — Primary key — NOT NULL
  • mondo_id — VARCHAR(32) — Foreign key → mondo.id — NOT NULL
  • label — TEXT — NOT NULL
  • INDEX — `idx_mondo_label_synonym_mondo_id`

mondo_related_database

  • id — INT — Primary key — NOT NULL
  • mondo_id — VARCHAR(32) — Foreign key → mondo.id — NOT NULL
  • database_id — VARCHAR(32) — NOT NULL

omim

  • id — VARCHAR(32) — Primary key — NOT NULL
  • label — TEXT — NOT NULL
  • definition — TEXT
  • mim_number — VARCHAR(10)
  • titles — TEXT
  • status — VARCHAR(50)
  • inheritance — TEXT
  • growth — TEXT
  • head_and_neck — TEXT
  • cardiovascular — TEXT
  • respiratory — TEXT
  • chest — TEXT
  • abdomen — TEXT
  • genitourinary — TEXT
  • skeletal — TEXT
  • muscle_soft_tissue — TEXT
  • skin_nails_hair — TEXT
  • neurologic — TEXT
  • behavioral — TEXT
  • endocrine_features — TEXT
  • laboratory_abnormalities — TEXT
  • miscellaneous — TEXT
  • molecular_basis — TEXT
  • old_format_data — JSON
  • source — VARCHAR(255) — 데이터 출처 (예: omim_xml_2025-08-27)

omim_external_links

  • id — INT
  • omim_id — VARCHAR(32) — NOT NULL
  • link_name — VARCHAR(100) — NOT NULL
  • link_url — TEXT
  • link_type — VARCHAR(50)
  • INDEX — `idx_link_omim_id`

omim_label_synonym

  • id — INT — Primary key — NOT NULL
  • omim_id — VARCHAR(32) — Foreign key → omim.id — NOT NULL
  • label — TEXT — NOT NULL
  • INDEX — `idx_omim_label_synonym_omim_id`

omim_references

  • id — INT
  • omim_id — VARCHAR(32) — NOT NULL
  • reference_number — INT
  • authors — TEXT
  • title — TEXT
  • source — TEXT — 문헌의 출처 (저널 등)
  • pubmed_id — VARCHAR(20)
  • INDEX — `idx_reference_omim_id`

omim_related_database

  • id — INT — Primary key — NOT NULL
  • omim_id — VARCHAR(32) — Foreign key → omim.id — NOT NULL
  • database_id — VARCHAR(32) — NOT NULL

omim_text_sections

  • id — INT
  • omim_id — VARCHAR(32) — NOT NULL
  • text_section_name — VARCHAR(100) — NOT NULL
  • text_section_title — VARCHAR(255)
  • text_section_content — TEXT
  • INDEX — `idx_section_omim_id`

orphanet

  • id — VARCHAR(32) — Primary key — NOT NULL
  • label — TEXT — NOT NULL
  • definition — TEXT
  • expert_link — TEXT
  • has_age_of_onset_n — TEXT
  • has_inheritance_n — TEXT
  • tree_view_n — TEXT
  • symbol — VARCHAR(32)
  • present_in_n — TEXT
  • parents_n — TEXT
  • part_of_n — TEXT
  • class1 — VARCHAR(32)
  • class2 — VARCHAR(32)
  • INDEX — `idx_orphanet_class1`
  • INDEX — `idx_orphanet_class2`

orphanet_label_synonym

  • id — INT — Primary key — NOT NULL
  • orphanet_id — VARCHAR(32) — Foreign key → orphanet.id — NOT NULL
  • label — TEXT — NOT NULL
  • INDEX — `idx_orphanet_label_synonym_orphanet_id`

orphanet_ontology

  • id — INT — Primary key — NOT NULL
  • orphanet_id — VARCHAR(32) — Foreign key → orphanet.id — NOT NULL
  • label — TEXT
  • attribute — VARCHAR(16)
  • parent_orphanet_id — VARCHAR(32)
  • INDEX — `idx_orphanet_ontology_orphanet_id`
  • INDEX — `idx_orphanet_ontology_parent_orphanet_id`

orphanet_related_database

  • id — INT — Primary key — NOT NULL
  • orphanet_id — VARCHAR(32) — Foreign key → orphanet.id — NOT NULL
  • database_id — VARCHAR(32) — NOT NULL

pubmed

  • id — VARCHAR(32) — Primary key — NOT NULL

refseq

  • id — VARCHAR(32) — Primary key — NOT NULL
  • gene_symbol — VARCHAR(32)
  • summary — TEXT

refseq_related_database

  • id — INT — Primary key — NOT NULL
  • refseq_id — VARCHAR(32) — Foreign key → refseq.id — NOT NULL
  • database_id — VARCHAR(32) — NOT NULL

treatment

  • id — VARCHAR(32) — Primary key — NOT NULL
  • treatment — TINYTEXT
  • purpose — TEXT
  • action — TEXT
  • score — FLOAT

treatment_pmid

  • id — INT — Primary key — NOT NULL
  • treatment_id — VARCHAR(32) — Foreign key → treatment.id — NOT NULL
  • pmid — VARCHAR(32) — NOT NULL
  • score — FLOAT
  • INDEX — `idx_treatment_pmid_pmid`
  • INDEX — `idx_treatment_pmid_treatment_id`

treatment_related_database

  • id — INT — Primary key — NOT NULL
  • treatment_id — VARCHAR(32) — Foreign key → treatment.id — NOT NULL
  • database_id — VARCHAR(32) — NOT NULL