From eb2d7d3d9fc64ac74a5f6575057d1566e6657b96 Mon Sep 17 00:00:00 2001
From: Jack <jack.su@pollex.com.tw>
Date: 星期三, 29 十二月 2021 19:37:01 +0800
Subject: [PATCH] [ADD] 新增預約單備註API [ADD] 更新預約單備註API [ADD] 刪除預約單備註API [ADD] 顧問查詢自己的預約單清單時帶出備註資料
---
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