Use filename as your primary key and folder structure as “table” Though, if you are doing a lot of joins your application is probably a better fit for a graph

Use filename as your primary key and folder structure as “table” Though, if you are doing a lot of joins your application is probably a better fit for a graph database instead of a “relational” one anyway