From 538bf02dcc06bdccda106e47f8f7092a717649c9 Mon Sep 17 00:00:00 2001
From: Jack <jack.su@pollex.com.tw>
Date: 星期三, 12 一月 2022 09:34:00 +0800
Subject: [PATCH] [ADD] 新增SQL(預約單通知歷程table,約單備註table,約訪紀錄table)

---
 pamapi/src/doc/sql/20220112_j.sql |   42 ++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 42 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..3d64d79
--- /dev/null
+++ b/pamapi/src/doc/sql/20220112_j.sql
@@ -0,0 +1,42 @@
+-- �憓���甇瑞�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)
+);
+

--
Gitblit v1.8.0