trello
Tables (4)
employees (Untitled3)
- officer_id (Key) — Primary key — NOT NULL
- org_id (Key2) — Foreign key → organisations.org_id — NOT NULL
- name (Field)
- phone (Field2)
- email (Field3)
- created_at (Field4)
- updated_at (Field5)
- deleted_at (Field6)
grades (Untitled2)
- grade_id (Key) — Primary key — NOT NULL
- officer_id (Key2) — Foreign key → employees.officer_id — NOT NULL
- org_id (Key22) — Foreign key → employees.org_id — NOT NULL
- grade (Field)
organisations (Untitled4)
- org_id (Key) — Primary key — NOT NULL
- org_name (Field)
positions (Untitled)
- role_id (Key) — Primary key — NOT NULL
- officer_id (Key2) — Foreign key → employees.officer_id — NOT NULL
- org_id (Key22) — Foreign key → employees.org_id — NOT NULL
- role (Field)