diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-11 09:02:00 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-11 09:02:00 +0000 |
| commit | cbb4c7fe0b94459162ad5e998bc05cd293e0ff96 (patch) | |
| tree | 0a26712f7685e4f6511e637b9a81269d90a47c8f /db/migrations/0272_low_the_hood.sql | |
| parent | eb654f88214095f71be142b989e620fd28db3f69 (diff) | |
(대표님) 입찰, EDP 변경사항 대응, spreadJS 오류 수정, 벤더실사 수정
Diffstat (limited to 'db/migrations/0272_low_the_hood.sql')
| -rw-r--r-- | db/migrations/0272_low_the_hood.sql | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/db/migrations/0272_low_the_hood.sql b/db/migrations/0272_low_the_hood.sql new file mode 100644 index 00000000..35680454 --- /dev/null +++ b/db/migrations/0272_low_the_hood.sql @@ -0,0 +1,28 @@ +CREATE TABLE "pr_items_for_bidding" ( + "id" serial PRIMARY KEY NOT NULL, + "bidding_id" integer NOT NULL, + "item_number" varchar(50), + "project_info" varchar(300), + "item_info" varchar(300), + "shi" varchar(100), + "requested_delivery_date" date, + "annual_unit_price" numeric(15, 2), + "currency" varchar(3) DEFAULT 'KRW', + "quantity" numeric(10, 2), + "quantity_unit" "quantity_unit", + "total_weight" numeric(10, 2), + "weight_unit" "weight_unit", + "material_description" text, + "pr_number" varchar(50), + "has_spec_document" boolean DEFAULT false, + "created_at" timestamp DEFAULT now() NOT NULL, + "updated_at" timestamp DEFAULT now() NOT NULL +); +--> statement-breakpoint +ALTER TABLE "bidding_documents" DROP CONSTRAINT "bidding_documents_pr_item_id_pr_items_id_fk"; +--> statement-breakpoint +ALTER TABLE "company_pr_item_bids" DROP CONSTRAINT "company_pr_item_bids_pr_item_id_pr_items_id_fk"; +--> statement-breakpoint +ALTER TABLE "pr_items_for_bidding" ADD CONSTRAINT "pr_items_for_bidding_bidding_id_biddings_id_fk" FOREIGN KEY ("bidding_id") REFERENCES "public"."biddings"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint +ALTER TABLE "bidding_documents" ADD CONSTRAINT "bidding_documents_pr_item_id_pr_items_for_bidding_id_fk" FOREIGN KEY ("pr_item_id") REFERENCES "public"."pr_items_for_bidding"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint +ALTER TABLE "company_pr_item_bids" ADD CONSTRAINT "company_pr_item_bids_pr_item_id_pr_items_for_bidding_id_fk" FOREIGN KEY ("pr_item_id") REFERENCES "public"."pr_items_for_bidding"("id") ON DELETE no action ON UPDATE no action;
\ No newline at end of file |