diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-27 12:06:26 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-27 12:06:26 +0000 |
| commit | 7548e2ad6948f1c6aa102fcac408bc6c9c0f9796 (patch) | |
| tree | 8e66703ec821888ad51dcc242a508813a027bf71 /db/migrations/0304_faulty_wrecking_crew.sql | |
| parent | 7eac558470ef179dad626a8e82db5784fe86a556 (diff) | |
(대표님, 최겸) 기본계약, 입찰, 파일라우트, 계약서명라우트, 인포메이션, 메뉴설정, PQ(메일템플릿 관련)
Diffstat (limited to 'db/migrations/0304_faulty_wrecking_crew.sql')
| -rw-r--r-- | db/migrations/0304_faulty_wrecking_crew.sql | 24 |
1 files changed, 24 insertions, 0 deletions
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 |