db.createView('week_schedule', 'club', [
    {
        $unwind: '$training_halls'
    },
    {
        $addFields: {
            trainings: '$training_halls.trainings'
        }
    },
    {
        $unwind: '$trainings'
    },
    {
        $lookup: {
            from: 'training',
            localField: 'trainings',
            foreignField: 'id',
            as: 'trainings'
        }
    },
    {
        $unwind: '$trainings'
    },
    {
        $lookup: {
            from: 'trainer',
            localField: 'trainings.trainer',
            foreignField: 'id',
            as: 'trainer'
        }
    },
    {
        $unwind: '$trainer'
    },
    {
        $lookup: {
            from: 'training_info',
            localField: 'trainings.training_info',
            foreignField: 'id',
            as: 'training_info'
        }
    },
    {
        $unwind: '$training_info'
    },
    {
        $project: {
            _id: 0,
            club_id: "$id",
            club_name: "$name",
            training_hall_name: '$training_halls.name',
            training_hall_type: '$training_halls.type',
            day_of_week: '$trainings.day_of_week',
            start_time: '$trainings.start_time',
            end_time: '$trainings.end_time',
            training_info_name: '$training_info.name',
            training_info_description: '$training_info.description',
            trainer_first_name: '$trainer.first_name',
            trainer_last_name: '$trainer.last_name',
        }
    },
    {
        $sort: {
            'start_time': 1,
            'end_time': 1,
        }
    },
])