[update][todo 135158] 列出滿意度問卷也需要包含系統滿意度問卷

wayne

2022-02-10 d54da4786548ef4c4ea4d62b2754cfed2b24a698

 pamapi/src/doc/sql/20220112_j.sql

@@ -40,3 +40,27 @@
   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)
);