From 6fa4bba623713c396432ba8b863846883d6a1906 Mon Sep 17 00:00:00 2001
From: wayne <wayne8692wayne8692@gmail.com>
Date: 星期三, 26 一月 2022 10:52:23 +0800
Subject: [PATCH] Merge branch 'pollex-dev' into sit

---
 pamapi/src/doc/sql/20220112_j.sql |   66 +++++++++++++++++++++++++++++++++
 1 files changed, 66 insertions(+), 0 deletions(-)

diff --git a/pamapi/src/doc/sql/20220112_j.sql b/pamapi/src/doc/sql/20220112_j.sql
new file mode 100644
index 0000000..504c4da
--- /dev/null
+++ b/pamapi/src/doc/sql/20220112_j.sql
@@ -0,0 +1,66 @@
+-- �憓���甇瑞�able
+
+CREATE TABLE public.appointment_notice_log (
+	id bigserial NOT NULL,
+	appointment_id bigserial NOT NULL,
+	email varchar NULL,
+	phone varchar NULL,
+	"content" varchar NULL,
+	created_date timestamp NULL,
+	CONSTRAINT appointment_notice_log_pkey PRIMARY KEY (id)
+);
+
+
+-- �憓����酉table
+
+CREATE TABLE public.appointment_memo (
+	id bigserial NOT NULL,
+	"content" varchar NOT NULL,
+	appointment_id int8 NOT NULL,
+	created_date timestamp NOT NULL,
+	created_by varchar NOT NULL,
+	last_modified_date timestamp NOT NULL,
+	last_modified_by varchar NOT NULL,
+	CONSTRAINT appointment_memo_pkey PRIMARY KEY (id)
+);
+
+
+-- �憓�赤蝝���able
+
+CREATE TABLE public.interview_record (
+	id bigserial NOT NULL,
+	created_date timestamp NOT NULL,
+	created_by varchar NOT NULL,
+	last_modified_date timestamp NOT NULL,
+	last_modified_by varchar NOT NULL,
+	"content" varchar NULL,
+	interview_date timestamp NULL,
+	appointment_id bigserial NOT NULL,
+	status varchar NULL,
+	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