Possible Joins in the Public Interface

The following table definitions list only the table name and those columns that represent some form of key. Each table definition lists the model_ID and unique table ID. Each also lists the columns that represent foreign keys (foreign key names end in the letters _ID). The last column (Tables with Which to Join) lists possible joins for each column that represents a foreign key.

In each instance, the possible joins column should be joined with the ID column of the target table. For example, in table ACTIV_USAGE, column PARENT_ ACTIV_ID can be joined with column ID of tables FUNCTION_DEF or PROCESS_DEF. Further, column CHILD_ACTIV_ID can be joined with the ID column of tables FUNCTION_DEF or PROCESS_DEF.

Most tables contain ORG_ID in column 4. This is the Original Object ID used to establish common ancestry among objects. ORG_ID can be used with objects of the same type in performing joins but not with dissimilar objects types. For example, you cannot join an entity type to an attribute using ORG_ID as there could never be a match.