draft erd

Tables (4)

Mutation

  • mutation_id — INT — Primary key — NOT NULL
  • protein_id — INT — Foreign key → Protein.protein_id — NOT NULL
  • mutation_name — VARCHAR(50) — NOT NULL
  • position — INT — NOT NULL
  • original_aa — CHAR(1)
  • mutated_aa — CHAR(1)
  • mutation_type — VARCHAR(50)
  • domain_name — VARCHAR(100)
  • domain_start — INT
  • domain_end — INT
  • domain_function — TEXT
  • target_name — VARCHAR(100)
  • target_type — VARCHAR(50)
  • affinity_change — VARCHAR(50)
  • measurement_method — VARCHAR(100)
  • confidence_score — DECIMAL(4,2)
  • effect_type — VARCHAR(100)
  • risk_level — VARCHAR(50)
  • interpretation — TEXT

Organism

  • organism_id — INT — Primary key — NOT NULL
  • scientific_name — VARCHAR(100) — NOT NULL
  • common_name — VARCHAR(100)
  • taxonomy_id — VARCHAR(50)
  • organism_type — VARCHAR(50) — NOT NULL

Protein

  • protein_id — INT — Primary key — NOT NULL
  • organism_id — INT — Foreign key → Organism.organism_id — NOT NULL
  • protein_name — VARCHAR(100) — NOT NULL
  • gene_name — VARCHAR(100)
  • accession_number — VARCHAR(50)
  • protein_length — INT
  • function_summary — TEXT

Publication

  • publication_id — INT — Primary key — NOT NULL
  • mutation_id — INT — Foreign key → Mutation.mutation_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • journal — VARCHAR(100)
  • published_year — INT
  • doi — VARCHAR(100)
  • evidence_type — VARCHAR(100)
  • summary — TEXT