From 21d79d2a70b095545477472438d27a8827ee80b8 Mon Sep 17 00:00:00 2001
From: wayne <wayne8692wayne8692@gmail.com>
Date: 星期四, 10 二月 2022 14:01:00 +0800
Subject: [PATCH] [update] 嚴選搜尋新增匹配度分數

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