From ad6aae4541dac41b172cd345e8b772f873fe6d07 Mon Sep 17 00:00:00 2001
From: Jack <jack.su@pollex.com.tw>
Date: 星期三, 30 三月 2022 15:56:22 +0800
Subject: [PATCH] [ADD] 移除顧問年資欄位sql
---
pamapi/src/doc/sql/20211108_w.sql | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/pamapi/src/doc/sql/20211108_w.sql b/pamapi/src/doc/sql/20211108_w.sql
index 315eef3..54cf8aa 100644
--- a/pamapi/src/doc/sql/20211108_w.sql
+++ b/pamapi/src/doc/sql/20211108_w.sql
@@ -1,4 +1,4 @@
-CREATE TABLE public.custom_favorite_consultant (
+CREATE TABLE omo.custom_favorite_consultant (
id serial4 NOT NULL,
consultant_id int8 NOT NULL,
custom_id int8 NOT NULL,
@@ -8,5 +8,5 @@
last_modified_by varchar NULL,
contact_status varchar NULL,
CONSTRAINT custom_consultant_list_pk PRIMARY KEY (id),
- CONSTRAINT custom_consultant_list_fk FOREIGN KEY (consultant_id) REFERENCES public.consultant(id)
+ CONSTRAINT custom_consultant_list_fk FOREIGN KEY (consultant_id) REFERENCES omo.consultant(id)
);
--
Gitblit v1.8.0