From ef4c533ebacc2cdc97e518f30e9a9350004fcdfb Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Mon, 28 Apr 2025 02:13:30 +0000
Subject: ~20250428 작업사항
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/migrations/0012_cynical_the_twelve.sql | 2 ++
 1 file changed, 2 insertions(+)
 create mode 100644 db/migrations/0012_cynical_the_twelve.sql

(limited to 'db/migrations/0012_cynical_the_twelve.sql')

diff --git a/db/migrations/0012_cynical_the_twelve.sql b/db/migrations/0012_cynical_the_twelve.sql
new file mode 100644
index 00000000..030f4ea4
--- /dev/null
+++ b/db/migrations/0012_cynical_the_twelve.sql
@@ -0,0 +1,2 @@
+DROP VIEW "public"."vendor_candidates_with_vendor_info";--> statement-breakpoint
+CREATE VIEW "public"."vendor_candidates_with_vendor_info" AS (select "vendor_candidates"."id", "vendor_candidates"."company_name", "vendor_candidates"."contact_email", "vendor_candidates"."contact_phone", "vendor_candidates"."tax_id", "vendor_candidates"."address", "vendor_candidates"."country", "vendor_candidates"."source", "vendor_candidates"."status", "vendor_candidates"."remark", "vendor_candidates"."items", "vendor_candidates"."vendor_id", "vendor_candidates"."created_at", "vendor_candidates"."updated_at", "vendors"."vendor_name", "vendors"."vendor_code", "vendors"."status", "vendors"."email", "vendors"."website", "vendors"."phone", "vendors"."country", "vendors"."created_at", "vendors"."updated_at", "vendors"."representative_name", "vendors"."representative_email", "vendors"."representative_phone", "vendors"."credit_rating", "vendors"."corporate_registration_number" from "vendor_candidates" left join "vendors" on "vendor_candidates"."vendor_id" = "vendors"."id");
\ No newline at end of file
-- 
cgit v1.2.3

