If you’ve ever worked under the hood with OTM, you’ll know that there’s some pretty serious normalization. As I recently explained, deleting a single order can involve traversing over a hundred tables. So, what does this network of table relationships look like? After some quick SQL and a few minutes in Gephi, we get the visualization below:
If you’re interested, download a PDF copy of this OTM foreign key network here.