database

0..*

1

disease

PK id:INT name:VARCHAR ... ...

PK_disease

gene

PK id:INT name: VARCHAR start: INT end: INT exons: VARCHAR func: VARCHAR seq: VARCHAR pro: VARCHAR GO: VARCHAR ... ...

PK_gene

mutation

PK_mutation FK_mutation mutation_exon_boole mutation_gt mutation_index_gi

patient

PK id:INT name: VARCHAR age: INT(3) sex: INT(1)FK disease_id: INTFK office_id: INT ... ...

PK_patient FK_disease_in_patient FK_office_in_patient

office

PK_office