...
In order to completely describe any datum in the database, one must find it in each of these tables. Fortunately, each datum as a unique Object_ID associated with it. These Object_IDs are associated with the same data in all of the database tables. Thus, once you find an object's Object_ID in t_object, you can query for that same Object_ID in the other tables to find all of the quantitative values and inter-object relationships associated with it.
Advantages of using CatSim classes for access
CatSim defines a class DBObject which is, essentially, a thin wrapper of functionality provided by sqlalchemy for connecting to SQL databases. Once connected to a database, DBObject provided methods that allow a user to list the tables provided by the database, list the columns in each of those tables, and execute arbitrary SQL queries on any of those tables, returning structured numpy arrays of the results. This may be advantageous in that it provides users with means to interactively explore the somewhat convoluted schema of the database underlying Enterprise Architect.
Specific CatSim classes written to access the Enterprise Architect database
The github repository mentioned at the top of this page implements a sub-class of DBObject specifically designed to access the SysArch database underlying Enterprise Architect.