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)