From 1d6d2d14200ed9432347ef8013e3fc117fa2161b Mon Sep 17 00:00:00 2001
From: Mila <Mila@pollex.com.tw>
Date: 星期四, 20 一月 2022 14:57:27 +0800
Subject: [PATCH] Merge branch 'master' into Phase3

---
 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