WN_lawyer

Tables (3)

Assignment (Untitled3)

  • id (Key) — Foreign key → Case.id — NOT NULL
  • id (Key2) — Foreign key → Attorney.id — NOT NULL

Attorney (Untitled)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • id (Field2)
  • password (Field3)
  • role (Field4)
  • department (Field5)
  • email (Field6)
  • enrollmentNumber (Field7)
  • enrollmentDate (Field8)

Case (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • caseEnrollmentNumber (Field)
  • caseNumber (Field2)
  • court (Field3)
  • plaintiff (Field4)
  • defendant (Field5)
  • update (Field6)