blob: c5b1072020c67ff445f50d21ab5b84179a81f553 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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;
|
