-- View: public.user_information
 
-- DROP VIEW public.user_information;
 
CREATE OR REPLACE VIEW public.user_information
AS
SELECT concat(user_details.first_name, ' ', user_details.last_name) AS full_name,
    user_details.user_id,
    users.uuid AS uuid,
    user_details.company_id,
    users.status_id,
    users.email
   FROM users
     JOIN user_details ON users.id = user_details.user_id;
ALTER TABLE public.user_information
    OWNER TO postgres;