From 513bf4d2d2b70be718f5c8d3f6a2aab5c6e7f4e9 Mon Sep 17 00:00:00 2001 From: HelenHuang <LinHuang@pollex.com.tw> Date: 星期一, 25 四月 2022 14:01:40 +0800 Subject: [PATCH] Fixed#138076 顧問端-成交與未成交資訊 增加 最後編輯時間 --- 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