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.

As size and load grow, performance tends to slow. Keep these keys in mind to keep MySQL running ... (such as UNIQUE and FOREIGN KEY). ... A better Jupyter-like notebook system for Python. May 13 ...