From aa84ac15ed832152d080f60320d3647c4b870a80 Mon Sep 17 00:00:00 2001
From: Tomas <tomasysh@gmail.com>
Date: 星期三, 12 一月 2022 11:18:50 +0800
Subject: [PATCH] Merge branch 'Phase3' of https://dev.pollex.com.tw:8443/r/pcalife/PAM into Phase3

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