After running one small example with two sites, it seems that we may need a different approach to dealing with the concept of foreign keys and data validadtion.
I ran some tests and while I never like to add more deps to a project, Pandera seems to do much of what I was writing my own code to do as far as 1) validating the schema, and 2) validating the data in the columns.
After running one small example with two sites, it seems that we may need a different approach to dealing with the concept of foreign keys and data validadtion.