-- 新增consultation_method欄位

CREATE OR REPLACE 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,
    a.contact_time,
    a.status,
    a.last_modified_date,
    c.name,
    a.consultation_method
   FROM appointment a
     LEFT JOIN customer c ON a.customer_id = c.id;