+CREATE VIEW backups_burned AS
+SELECT
+ backup_id,
+ count(backup_id) = count(backup_part_id) as burned
+FROM archive
+JOIN archive_parts ON archive.id = archive_id
+JOIN backup_parts ON backup_part_id = backup_id
+GROUP BY backup_id
+;
+
+-- triggers for backup_parts consistency