diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-09-14 05:28:01 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-09-14 05:28:01 +0000 |
| commit | 675b4e3d8ffcb57a041db285417d81e61284d900 (patch) | |
| tree | 254f3d6a6c0ce39ae8fba35618f3810e08945f19 /db/migrations/0348_violet_blue_blade.sql | |
| parent | 39f12cb19f29cbc5568057e154e6adf4789ae736 (diff) | |
(대표님) RFQ-last, tbe-last, 기본계약 템플릿 내 견적,입찰,계약 추가, env.dev NAS_PATH 수정
Diffstat (limited to 'db/migrations/0348_violet_blue_blade.sql')
| -rw-r--r-- | db/migrations/0348_violet_blue_blade.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/db/migrations/0348_violet_blue_blade.sql b/db/migrations/0348_violet_blue_blade.sql new file mode 100644 index 00000000..5167bc68 --- /dev/null +++ b/db/migrations/0348_violet_blue_blade.sql @@ -0,0 +1,18 @@ +ALTER TABLE "rfq_last_vendor_responses" ALTER COLUMN "status" SET DEFAULT '대기중';--> statement-breakpoint +ALTER TABLE "rfq_last_vendor_responses" ADD COLUMN "participation_status" varchar(20) DEFAULT '미응답' NOT NULL;--> statement-breakpoint +ALTER TABLE "rfq_last_vendor_responses" ADD COLUMN "participation_replied_at" timestamp;--> statement-breakpoint +ALTER TABLE "rfq_last_vendor_responses" ADD COLUMN "participation_replied_by" integer;--> statement-breakpoint +ALTER TABLE "rfq_last_vendor_responses" ADD COLUMN "non_participation_reason" text;--> statement-breakpoint +ALTER TABLE "knox"."approval_logs" ADD COLUMN "contents_type" text DEFAULT 'HTML' NOT NULL;--> statement-breakpoint +ALTER TABLE "knox"."approval_logs" ADD COLUMN "sbm_dt" text;--> statement-breakpoint +ALTER TABLE "knox"."approval_logs" ADD COLUMN "sbm_lang" text DEFAULT 'ko' NOT NULL;--> statement-breakpoint +ALTER TABLE "knox"."approval_logs" ADD COLUMN "notify_option" text DEFAULT '0' NOT NULL;--> statement-breakpoint +ALTER TABLE "knox"."approval_logs" ADD COLUMN "urg_yn" text DEFAULT 'N' NOT NULL;--> statement-breakpoint +ALTER TABLE "knox"."approval_logs" ADD COLUMN "doc_secu_type" text DEFAULT 'PERSONAL' NOT NULL;--> statement-breakpoint +ALTER TABLE "knox"."approval_logs" ADD COLUMN "time_zone" text DEFAULT 'GMT+9' NOT NULL;--> statement-breakpoint +ALTER TABLE "knox"."approval_logs" ADD COLUMN "opinion" varchar(1000);--> statement-breakpoint +ALTER TABLE "knox"."approval_logs" ADD COLUMN "knox_user_id" text;--> statement-breakpoint +ALTER TABLE "knox"."approval_logs" ADD COLUMN "important_yn" varchar(1) DEFAULT 'N';--> statement-breakpoint +ALTER TABLE "knox"."approval_logs" ADD COLUMN "doc_mng_save_code" text DEFAULT '0' NOT NULL;--> statement-breakpoint +ALTER TABLE "rfq_last_vendor_responses" ADD CONSTRAINT "rfq_last_vendor_responses_participation_replied_by_users_id_fk" FOREIGN KEY ("participation_replied_by") REFERENCES "public"."users"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint +ALTER TABLE "knox"."approval_logs" DROP COLUMN "user_id";
\ No newline at end of file |