Spike. Refactoring source_record_view with foreign keys for _id fields

CREATE OR REPLACE VIEW source_records_view AS
  SELECT records._id,
  json_build_object('recordId', records.jsonb->>'id',
          'snapshotId', records.jsonb->>'snapshotId',
					'recordType', records.jsonb->>'recordType',
					'deleted', records.jsonb->>'deleted',
					'additionalInfo', records.jsonb->'additionalInfo',
					'metadata', records.jsonb->'metadata',
					'rawRecord', raw_records.jsonb,
 					'parsedRecord', COALESCE(marc_records.jsonb))
					AS jsonb
   FROM records
     JOIN raw_records ON records.jsonb->>'rawRecordId' = raw_records.jsonb->>'id'
     LEFT JOIN marc_records ON records.jsonb->>'parsedRecordId' = marc_records.jsonb->>'id'
     WHERE records.jsonb->>'parsedRecordId' IS NOT NULL;