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