From 3b7c219a10fe0d3d4c9182cbcbc5cf05eb426f97 Mon Sep 17 00:00:00 2001 From: Tomas <tomasysh@gmail.com> Date: 星期三, 24 八月 2022 10:48:49 +0800 Subject: [PATCH] fix: [isLoginAuthGuard] agent: 'appointment-appointmentId-interview-new' --- 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