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)