2222

Tables (4)

DiagnosticDetails (DiagnosticDetail)

  • FK (PatientID) — VARCHAR(20) — Foreign key → PatientInfo.PK — NOT NULL
  • FK (NurseID) — VARCHAR(20) — Foreign key → NurseInfo.PK — NOT NULL
  • FK (RegisterNumber) — INTEGER(10) — Foreign key → PatientInfo.FK — NOT NULL
  • Field (BloodPressure) — INTEGER(30)
  • Field (Pulse) — INTEGER(30)
  • Field2 (Temperature) — INTEGER(30)

MedicalCareInfo

  • PK (RegisterNumber) — INTEGER(10) — Primary key — NOT NULL
  • Field (CenterName) — VARCHAR(20) — NOT NULL

NurseInfo

  • PK (ID) — VARCHAR(20) — Primary key — NOT NULL
  • FK (RegisterNumber) — INTEGER(10) — Foreign key → MedicalCareInfo.PK — NOT NULL
  • Field (NAME) — VARCHAR(20) — NOT NULL
  • Field (PASSWORD) — INTEGER(10) — NOT NULL

PatientInfo

  • PK (ID) — VARCHAR(20) — Primary key — NOT NULL
  • FK (RegisterNumber) — INTEGER(10) — Foreign key → MedicalCareInfo.PK — NOT NULL
  • Field (NAME) — VARCHAR(20) — NOT NULL
  • Field (BIRTHDAY) — VARCHAR(20) — NOT NULL
  • Field2 (MedicalCareGrade) — INTEGER(10) — NOT NULL
  • Field (MedicalCareNumber) — INTEGER(10) — NOT NULL
  • Field (HospitalRoomNumber) — INTEGER(10) — NOT NULL