db.request_response.aggregate([
    {
        $lookup: {
            from: "projects",
            localField: "project_id",
            foreignField: "project_id",
            as: "project"
        }
    },
    {
        $unwind: "$project"
    },
    {
        $lookup: {
           from: "scenarios",
           localField: "scenario_id",
           foreignField: "scenario_id",
           as: "scenario"
        }
    },
    {
        $unwind: "$scenario"
    },
    {
        $lookup: {
            from: "flows",
            localField: "flow_id",
            foreignField: "flow_id",
            as: "flow"
        }
    },
    {
        $unwind: "$flow"
    }
])