From 33d0d51a799302ebc3ff47b86dbce4c1912abd22 Mon Sep 17 00:00:00 2001
From: wayne <wayne8692wayne8692@gmail.com>
Date: 星期二, 30 十一月 2021 10:10:43 +0800
Subject: [PATCH] [update] 【todo 131218】嚴選配對 與 快速篩選 的滿意度評分皆改成 列出指定滿意度評分以上的顧問
---
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