There are parent and child entities with foreign key constraints constructed with the option of NO ACTION. The primary key of the parent is known and retrieved from the DB, but the child is not loaded ...

Foreign keys can refer to another column in the same table. The top-level folder might need to be its own parent - I don't know if it'll let you have a NULL there.