CREATE TYPE "public"."score_type" AS ENUM('fixed', 'variable');--> statement-breakpoint
ALTER TABLE "reg_eval_criteria" ADD COLUMN "variable_score_min " numeric(5, 2);--> statement-breakpoint
ALTER TABLE "reg_eval_criteria" ADD COLUMN "variable_score_max  " numeric(5, 2);--> statement-breakpoint
ALTER TABLE "reg_eval_criteria" ADD COLUMN "variable_score_unit " varchar(100);--> statement-breakpoint
ALTER TABLE "reg_eval_criteria" ADD COLUMN "score_type" "score_type" DEFAULT 'fixed' NOT NULL;