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