1
2
3
4
5
6
7
| -- 建立 已經通知客戶未處理預約單的紀錄 table
| CREATE TABLE public.appointment_expiring_notify_record (
| id bigserial NOT NULL,
| appointment_id bigserial NOT NULL,
| send_time timestamp NULL,
| CONSTRAINT appointment_expiring_notify_record_pk PRIMARY KEY (id)
| );
|
|
