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.

Hi all, We are rewriting a large Django application which uses a MySQL database, and the database schema needs to undergo major modifications. We're also porting the app to use PostgreSQL, for a ...