1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
| ALTER TABLE omo.appointment ADD consultant_view_time timestamp NULL;
| ALTER TABLE omo.appointment ADD consultant_read_time timestamp NULL;
|
| DROP VIEW omo.appointment_customer_view;
| CREATE VIEW omo.appointment_customer_view AS SELECT a.id AS appointment_id,
| a.phone,
| a.email,
| a.contact_type,
| a.gender,
| a.age,
| a.job,
| a.requirement,
| a.communicate_status,
| a.hope_contact_time,
| a.other_requirement,
| a.agent_no,
| a.appointment_date,
| a.customer_id,
| a.consultant_view_time,
| a.consultant_read_time,
| c.name
| FROM omo.appointment a
| LEFT JOIN omo.customer c ON a.customer_id = c.id;
|
|
