select name as file_name, storage_type from cr_items where item_id = ( select item_id from cr_revisions where revision_id = :revision_id )