ALTER TABLE omo.appointment ADD status varchar NULL;
ALTER TABLE omo.appointment ADD contact_time timestamp NULL;
ALTER TABLE omo.appointment ADD last_modified_date timestamp NULL;
ALTER TABLE omo.customer ADD agree_personal_information_time timestamp NULL;

UPDATE omo.appointment SET status = 'AVAILABLE';
UPDATE omo.appointment SET last_modified_date = appointment_date;

DROP VIEW omo.appointment_customer_view;

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
   FROM omo.appointment a
            LEFT JOIN omo.customer c ON a.customer_id = c.id;

ALTER TABLE omo.satisfaction ADD appointment_id bigserial NOT NULL;
