ALTER TABLE tb_accident_info ALTER COLUMN accident_loss_type TYPE varchar(16) USING accident_loss_type::varchar;

ALTER TABLE public.tb_repair_info ADD cancel_time timestamp NULL;
COMMENT ON COLUMN public.tb_repair_info.cancel_time IS '作废时间';

ALTER TABLE public.tb_upkeep_plan ADD cancel_time timestamp NULL;
COMMENT ON COLUMN public.tb_upkeep_plan.cancel_time IS '作废时间';

ALTER TABLE public.tb_upkeep_bill ADD cancel_time timestamp NULL;
COMMENT ON COLUMN public.tb_upkeep_bill.cancel_time IS '作废时间';

ALTER TABLE public.tb_upkeep_offer ALTER COLUMN total_work_hours TYPE numeric(10, 2) USING total_work_hours::numeric;
ALTER TABLE public.tb_repair_offer ALTER COLUMN total_work_hours TYPE numeric(10, 2) USING total_work_hours::numeric;
