db_HW
Tables (4)
Assignment (Untitled4)
- (SSN,CASE_NUMBER) (Key) — VARCHAR(20) — Primary key — NOT NULL
- Social_security_number (SSN) — VARCHAR(20) — Foreign key → Nurse.Social_security_number — NOT NULL
- Case_number (CASE_NUMBER) — VARCHAR(20) — Foreign key → Case.Case_number — NOT NULL
- Assigned_at (ASSIGNED_AT) — TIMESTAMP
Case (Untitled2)
- Case_number (CASE_NUMBER) — VARCHAR(20) — Primary key — NOT NULL
- Patient_name (PATIENT_NAME) — VARCHAR(60)
- Diagnosis (DIAGNOSIS) — VARCHAR(100)
- Drid (DRID) — VARCHAR(20) — Foreign key → Doctor.Drid — NOT NULL
Doctor (Untitled3)
- Drid (DRID) — VARCHAR(20) — Primary key — NOT NULL
- Name (NAME) — VARCHAR(60)
- Address (ADDRESS) — VARCHAR(100)
Nurse (Untitled)
- Social_security_number (SSN) — VARCHAR(20) — Primary key — NOT NULL
- Last_name (Last_Name) — VARCHAR(30)
- First_name (first_name) — VARCHAR(30)
- Classification (classification) — VARCHAR(40)