public.boms
iduuidtenant_iduuiditem_iduuidrevisionintegeroutput_qtynumericstatuscharacter varyingnotestext?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zoneproduces_componentbooleanbom_typetextversion_labeltext?cost_methodcharacter varyingcost_price_list_iduuid?material_costnumericlabour_costnumericbyproduct_creditnumerictotal_costnumericunit_costnumericcost_updated_attimestamp with time zone?
| id | tenant_id | item_id | revision | output_qty | status | notes | is_active | created_at | updated_at | produces_component | bom_type | version_label | cost_method | cost_price_list_id | material_cost | labour_cost | byproduct_credit | total_cost | unit_cost | cost_updated_at |