-- 新增預約單通知歷程table

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


-- 新增約訪紀錄table

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