From aa109c6e83f23a3c81ccc4645ce233492364307d Mon Sep 17 00:00:00 2001 From: jack <jack.su@pollex.com.tw> Date: 星期一, 18 七月 2022 23:06:16 +0800 Subject: [PATCH] [UPDATE] 驗證碼驗證失敗改為回傳401 [BUG] 調整spring security設定 --- pamapi/src/doc/sql/20220112_j.sql | 24 ++++++++++++++++++++++++ 1 files changed, 24 insertions(+), 0 deletions(-) diff --git a/pamapi/src/doc/sql/20220112_j.sql b/pamapi/src/doc/sql/20220112_j.sql index 3d64d79..504c4da 100644 --- a/pamapi/src/doc/sql/20220112_j.sql +++ b/pamapi/src/doc/sql/20220112_j.sql @@ -40,3 +40,27 @@ CONSTRAINT interview_record_pkey PRIMARY KEY (id) ); +-- �憓��蝯���able + +-- Drop table + +-- DROP TABLE public.appointment_closed_info; + +-- Drop table + +-- DROP TABLE public.appointment_closed_info; + +CREATE TABLE public.appointment_closed_info ( + id bigserial NOT NULL, + policyholder_identity_id varchar NULL, + plan_code varchar NULL, + policy_entry_date date NULL, + remark varchar NULL, + closed_reason varchar NULL, + closed_other_reason varchar NULL, + appointment_id bigserial NOT NULL, + CONSTRAINT appointment_closed_info_pkey PRIMARY KEY (id) +); + + + -- Gitblit v1.8.0