IntegrityError: null value in column "consultation_id" of relation "facility_patientconsultationevent" violates n...

[sentry-io]

Sentry Issue: CARE-FBC

NotNullViolation: null value in column "consultation_id" of relation "facility_patientconsultationevent" violates not-null constraint
DETAIL:  Failing row contains (135829, 01J8J6W0TWCB7WGW8DYF33M6KY, 2024-09-24 14:27:22.572763+00, PatientNotes, 1211, t, {"external_id": "fe88b0cb-906d-449a-aa5b-ab8e3b427f73"}, {"note": "feawwafe", "user_type": "RemoteSpecialist"}, CREATED, 2788, null, 48, 2024-09-24 14:27:22.572763+00).
  File "django/db/backends/utils.py", line 105, in _execute
    return self.cursor.execute(sql, params)
  File "psycopg/cursor.py", line 97, in execute
    raise ex.with_traceback(None)

IntegrityError: null value in column "consultation_id" of relation "facility_patientconsultationevent" violates not-null constraint
DETAIL:  Failing row contains (135829, 01J8J6W0TWCB7WGW8DYF33M6KY, 2024-09-24 14:27:22.572763+00, PatientNotes, 1211, t, {"external_id": "fe88b0cb-906d-449a-aa5b-ab8e3b427f73"}, {"note": "feawwafe", "user_type": "RemoteSpecialist"}, CREATED, 2788, null, 48, 2024-09-24 14:27:22.572763+00).
(19 additional frame(s) were not displayed)
...
  File "care/facility/api/viewsets/patient.py", line 1057, in perform_create
    create_consultation_events(
  File "care/facility/events/handler.py", line 109, in create_consultation_events
    create_consultation_event_entry(
  File "care/facility/events/handler.py", line 74, in create_consultation_event_entry
    PatientConsultationEvent.objects.bulk_create(batch)

[rithviknishad]

To reproduce, post a message in discussion notes from the patient registration page. PatientConsultationEvent is attempted to be created, however, discussion notes from from Patient registration is not associated to a consultation.

[yash-learner]

I would like to give it a try, Can this be assigned to me ?