From 7548e2ad6948f1c6aa102fcac408bc6c9c0f9796 Mon Sep 17 00:00:00 2001 From: dujinkim Date: Wed, 27 Aug 2025 12:06:26 +0000 Subject: (대표님, 최겸) 기본계약, 입찰, 파일라우트, 계약서명라우트, 인포메이션, 메뉴설정, PQ(메일템플릿 관련) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/migrations/0304_faulty_wrecking_crew.sql | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 db/migrations/0304_faulty_wrecking_crew.sql (limited to 'db/migrations/0304_faulty_wrecking_crew.sql') diff --git a/db/migrations/0304_faulty_wrecking_crew.sql b/db/migrations/0304_faulty_wrecking_crew.sql new file mode 100644 index 00000000..c5b10720 --- /dev/null +++ b/db/migrations/0304_faulty_wrecking_crew.sql @@ -0,0 +1,24 @@ +ALTER TABLE "contracts" ADD COLUMN "shippment_place" varchar(255);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "po_version" integer;--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "purchase_doc_type" varchar(10);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "purchase_org" varchar(10);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "purchase_group" varchar(10);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "exchange_rate" numeric(9, 5);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "po_confirm_status" varchar(10);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "contract_guarantee_code" varchar(2);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "defect_guarantee_code" varchar(2);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "guarantee_period_code" varchar(2);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "advance_payment_yn" varchar(1);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "budget_amount" numeric(17, 2);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "budget_currency" varchar(5);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "total_amount_krw" numeric(17, 2);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "electronic_contract_yn" varchar(1);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "electronic_approval_date" date;--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "electronic_approval_time" varchar(6);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "owner_approval_yn" varchar(1);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "planned_in_out_flag" varchar(1);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "settlement_standard" varchar(1);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "weight_settlement_flag" varchar(1);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "price_index_yn" varchar(1);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "written_contract_no" varchar(20);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "contract_version" integer; \ No newline at end of file -- cgit v1.2.3