MySQL will soon store FOREIGN KEY definitions so that a client can ask for and receive an answer about how the original connection was made. The current `.frm' file format does not have any place for ...

Yes. 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 long as the interface ...