---

DELETE FROM report.unv_annual_setting
WHERE id = 1
  AND client_id = 5512
  AND contract_id = 13029594
RETURNING *;



SELECT
    ordinal_position,
    column_name,
    data_type,
    udt_name,
    is_nullable,
    column_default
FROM information_schema.columns
WHERE table_schema = 'report'
  AND table_name = 'smev_register'
ORDER BY ordinal_position;







SELECT
    id,
    number,
    "year",
    "date",
    "type",
    sample_status,
    guid,
    sent
FROM report.smev_register
WHERE smev_register_type_code = 'УНВ'
ORDER BY id DESC;



SELECT *
FROM report.smev_register_codes
WHERE short_name = 'УНВ';