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;
