From e3f99ddc4a3cff6910f33db8f8578c7c3a2d8f17 Mon Sep 17 00:00:00 2001
From: wayne <wayne8692wayne8692@gmail.com>
Date: 星期一, 29 十一月 2021 16:35:25 +0800
Subject: [PATCH] [update] 調整sql schema，修正成與保誠相同的omo schema
---
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