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