1) We have eqp_id and location in the equipmentModels table 
 in each location we may have the multiple equipment

 eqp_id and location name

 { equipment_id: "PRE009", location: "Comp-01", eqp_sequence: null },

2) In equipment_planner table we have the we have eqp_id and time duration.   this is plan
    In equipment_log_books table we have the eqp_id and time duration.    this is actual

3) Each location we have the multiple options 
    based on the location option volume is decided.



4) They will select the eqp name 
    -> Based on the eqp name we need to take the eqp area from the master data.
    -> they will enter the product name.
    -> based on that product name we need to display the options avaliable.
    -> based on selected options and eqp area, we need to take the volume.
    -> need to display the planed volume and actual volume (completed batches actual volume == planed volume)




    req body:  {
        "is_active": true,
        "id": 2846,
        "start_date": "2026-02-02T18:30:00.000Z",
        "end_date": "2026-02-02T20:30:00.000Z",
        "eqp_plan_type": "Operation",
        "product_batch": "bhshcdj",
        "product_name": "ATS",
        "eqp_activity": "PRODUCTION",
        "eqp_id": "PRE005",
        "status": "draft",
        "plan_version": 0,
        "updatedAt": "2026-02-02T12:56:11.577Z",
        "createdAt": "2026-02-02T12:56:11.577Z",
        "dispensing_request_id": null,
        "version_id": null,
        "user_id": null
    }


---------------------------------------------------------------------------------------
1) table for 
        productCode, product_id, option_name,volume,location,equipment_id,eqp_name, 

        AMT,1,SB_option1_strength(10),

         







Comp, Coating, Cap, Imprinting ==> these we have same volume.
Gran, FBP, Blending ==> we have the same volume.

which catogory our planed eqp we can decide based on the "eqp name"