-- Modify "MedicationItem" table ALTER TABLE "public"."MedicationItem" ADD COLUMN "Quantity" numeric NULL; -- Modify "MedicineMix" table ALTER TABLE "public"."MedicineMix" ADD COLUMN "Note" text NULL; -- Modify "Prescription" table ALTER TABLE "public"."Prescription" ADD COLUMN "Status_Code" text NULL; -- Modify "PrescriptionItem" table ALTER TABLE "public"."PrescriptionItem" ADD COLUMN "Quantity" numeric NULL;