CREATE OR REPLACE VIEW public.unit_file_extension_view
AS
SELECT
    unit.id as id_unit,
    unit.id_user,
    unit.item_type,
    unit.type as unit_type,
    REVERSE(SPLIT_PART(REVERSE(unit.normalized_filename), '.', 1)) as extension
FROM unit;