paitent-disease
Tables (3)
TB_Disease
- disease_code — int — Primary key — NOT NULL
- disease_name — varchar(100)
TB_Patient
- patient_id — int — Primary key — NOT NULL
- patient_name — varchar(50)
TB_Relate
- patient_id — int — Foreign key → TB_Patient.patient_id — NOT NULL
- disease_code — int — Foreign key → TB_Disease.disease_code — NOT NULL