add test scenarios and comments on how to push missing parent paths into files table