diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-07-02 00:45:49 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-07-02 00:45:49 +0000 |
| commit | 2acf5f8966a40c1c9a97680c8dc263ee3f1ad3d1 (patch) | |
| tree | f406b5c86f563347c7fd088a85fd1a82284dc5ff /db/migrations/0175_slippery_morph.sql | |
| parent | 6a9ca20deddcdcbe8495cf5a73ec7ea5f53f9b55 (diff) | |
(대표님/최겸) 20250702 변경사항 업데이트
Diffstat (limited to 'db/migrations/0175_slippery_morph.sql')
| -rw-r--r-- | db/migrations/0175_slippery_morph.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/db/migrations/0175_slippery_morph.sql b/db/migrations/0175_slippery_morph.sql new file mode 100644 index 00000000..8143708b --- /dev/null +++ b/db/migrations/0175_slippery_morph.sql @@ -0,0 +1,4 @@ +ALTER TABLE "reg_eval_criteria" ADD COLUMN "created_by" integer NOT NULL;--> statement-breakpoint +ALTER TABLE "reg_eval_criteria" ADD COLUMN "updated_by" integer NOT NULL;--> statement-breakpoint +ALTER TABLE "reg_eval_criteria" ADD CONSTRAINT "reg_eval_criteria_created_by_users_id_fk" FOREIGN KEY ("created_by") REFERENCES "public"."users"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint +ALTER TABLE "reg_eval_criteria" ADD CONSTRAINT "reg_eval_criteria_updated_by_users_id_fk" FOREIGN KEY ("updated_by") REFERENCES "public"."users"("id") ON DELETE set null ON UPDATE no action;
\ No newline at end of file |