public.maintenance_orders
iduuidtenant_iduuidmo_numbercharacter varyingasset_iduuidschedule_iduuid?order_typecharacter varyingprioritycharacter varyingstatuscharacter varyingdescriptiontext?reported_attimestamp with time zonestarted_attimestamp with time zone?completed_attimestamp with time zone?downtime_hoursnumericlabour_hoursnumericlabour_costnumericparts_costnumerictotal_costnumericroot_causetext?work_performedtext?assigned_touuid?created_byuuid?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zoneamc_contract_iduuid?scheduled_datedate?labour_ratenumeric?ext_reftext?
| id | tenant_id | mo_number | asset_id | schedule_id | order_type | priority | status | description | reported_at | started_at | completed_at | downtime_hours | labour_hours | labour_cost | parts_cost | total_cost | root_cause | work_performed | assigned_to | created_by | is_active | created_at | updated_at | amc_contract_id | scheduled_date | labour_rate | ext_ref |
|---|