Can not find linked table of Product to Model :
I am unable to find table where link for "Product to Model" is stored. For ex. If I have to find all Parts related to a Project then, I will query 'innovator.PROJECT_PART' table. Similarly I have to find all Models related to a Product. but I am unable to find such table in innovator server db. However, I am able to find table for all products i.e. innovator.PRODUCT and all models i.e innovator.MODEL.
Any lead would be appreciated. Thanks!
Hello,
There are two different kinds of relationships that can exist in Aras Innovator.
Items can be linked to other Items by using a RelationshipType. This can be seen in the Part BOM relationship where the structure of relating two Parts looks like: Part->Part BOM->Part
Items can be linked only to a RelationshipType. We call this a Null Relationship. This kind of relationship can be seen in the Part Changes relationship where the sturcture looks like: Part->Part Changes. Notice that there is no second ItemType linked to in this kind of relationship
The Model is actually a Null RelationshipType off of Product with a structure like: Product->Model. If we look at the Model ItemType, we can see that the "Is Relationship" flag is set to true to indicate this.
Because of this, you can get the Product to Model relationship simply by querying on the Model table itself.
Chris
___________________________
Christopher Gillis
Aras Labs Software Engineer
Hi Christopher,
Thank you for the info about the null relationship concept. But when I query the Model table I dont see any column where the related product information is stored. I see there is one column 'Related_Id' but the is also null. Am I missing something? :(
-----------------------------------------------------------------------------------------
Please also tell me the concept of 'config_id' in Innovator db, I mean there is this other column called 'id' right? then why config_id is used?
I have noticed that, when I create one record in Innovator, a row gets added in DB with same 'config_id' and 'id'. And when I modify that record again, a new row gets added into db with a new 'id' but same 'config_id'.
Thank you.
Hello,
In the Product to Model relationship, the Model is the child ItemType in the relationship. Because of this, the reference to the parent Product item will be stored in the source_id column. In a null relationship, the related_id will always be null.
To answer your second question, the config_id is a common id shared by all generations of a versionable item. The config_id is set to be equal to the id of the first generation of a versionable item. This allows for useful queries when you want to see the changes between different versions of the same item.
Chris
_____________________________
Christopher Gillis
Aras Labs Software Engineer
