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