[ADD] 預約單結案API

Jack

2022-01-13 03e918bf6861d9b62b2ad0c5d043086969e0d9f6

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