
ALTER TABLE IF EXISTS public."OrderDetail"
    ADD COLUMN "EN_ConsumableFeeVerified" integer NOT NULL DEFAULT 0;

COMMENT ON COLUMN public."OrderDetail"."EN_ConsumableFeeVerified"
    IS '對帳狀態_耗材費$未對帳=0,已對帳=1';

ALTER TABLE IF EXISTS public."OrderDetail"
    ADD COLUMN "ConsumableFeeVerifiedMonth" timestamp without time zone;

COMMENT ON COLUMN public."OrderDetail"."ConsumableFeeVerifiedMonth"
    IS '對帳月份_耗材費';