DROP VIEW IF EXISTS PUBLIC.regenerating_thumbnail_view CASCADE;
CREATE VIEW PUBLIC.regenerating_thumbnail_view AS
  SELECT
    u.id,
    u.id_user,
    u.filename,
    u.type AS unit_type,
    t.status,
    t.type AS thumbnail_type
  FROM
    unit u
    JOIN thumbnail t ON u.id = t.id_unit
    AND t.type = 0
    AND t.status >= 100;