View: office.work_center_view

Schema	office
Materialized View Name	work_center_view
Owner	postgres
Tablespace	DEFAULT
Description

 CREATE OR REPLACE VIEW office.work_center_view
 AS
 SELECT work_centers.work_center_id,
    ((offices.office_code::text || ' ('::text) || offices.office_name::text) || ')'::text AS office,
    work_centers.work_center_code,
    work_centers.work_center_name
   FROM office.work_centers
   JOIN office.offices ON work_centers.office_id = offices.office_id;