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)