From 1ac23eec19591f05ead299ec489e7f025a2c7627 Mon Sep 17 00:00:00 2001 From: HelenHuang <LinHuang@pollex.com.tw> Date: 星期四, 31 三月 2022 11:45:04 +0800 Subject: [PATCH] Fixed : UiDatePicker - icon 位置修改 --- 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