Supervisors

Supervisors

FieldTypeDescription
supervisory_assignment_id 🔑INTEGERThe unique identifier for the supervisory assignment record.
agency_id 🔗INTEGERThe ID of the agency this supervisory assignment belongs to.
supervisor_id 🔗INTEGERThe ID of the agency worker who is the supervisor.
supervisee_id 🔗INTEGERThe ID of the agency worker who is the supervisee.
created_atTIMESTAMPThe timestamp when the supervisory assignment was created.
updated_atTIMESTAMPThe timestamp when the supervisory assignment was last updated.

Key Information

Primary Keys

  • supervisory_assignment_id - The unique identifier for the supervisory assignment record.

Foreign Keys

  • agency_id - The ID of the agency this supervisory assignment belongs to.
  • supervisor_id - The ID of the agency worker who is the supervisor.
  • supervisee_id - The ID of the agency worker who is the supervisee.