-- 新增預約單通知歷程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)
);

-- 新增預約單結案資料table

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