auth_user

1 rows


Description

details about the user from hmpps-auth

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id text 2147483647 null
action_plan.approved_by_id fk_action_plan_approved_byR
action_plan.created_by_id fk_created_by_idR
action_plan.submitted_by_id fk_submitted_by_idR
appointment.appointment_feedback_submitted_by_id fk_feedback_submitted_byR
appointment.attendance_behaviour_submitted_by_id fk_attendance_behaviour_submitted_by_idR
appointment.attendance_submitted_by_id fk_attendance_submitted_by_idR
appointment.created_by_id fk_appt_to_created_byR
appointment.session_feedback_submitted_by_id fk_session_feedback_submitted_by_idR
case_note.sent_by_id fk_case_note_sent_by_idR
changelog.changed_by_id changelog_changed_by_id_fkeyR
draft_oasys_risk_information.updated_by_id fk_case_note_updated_by_idR
end_of_service_report.created_by_id fk_created_by_idR
end_of_service_report.submitted_by_id fk_submitted_by_idR
referral.created_by_id fk_created_by_idR
referral.end_requested_by_id fk_ended_by_idR
referral.sent_by_id fk_sent_by_idR
referral_assignments.assigned_by_id fk_assigned_by_id_auth_userR
referral_assignments.assigned_to_id fk_assigned_to_id_auth_userR

the user ID
auth_source text 2147483647 null

where the user has come from
user_name text 2147483647 'unknown'::text

the username
deleted bool 1 √ null

soft deleted flag

Indexes

Constraint Name Type Sort Column(s)
auth_user_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation