Skip to main content
C
Chanhasen1-Visitor
1-Visitor
June 4, 2014
Question

Windchill objects link at DB level

  • June 4, 2014
  • 3 replies
  • 12592 views

Hi All,

I was exploring the objects link at db level. Is there any procedure or way/Utility get entity relationship links at db level.Need

guidance to understand.Kindly share your Ideas.

Example:

How "WTPART", WTDOCUMENT" "WTPartDescribeLink" tables are related in DB, which columns of part & document table has been mapped to WTPartDescribeLink table.

Thanks,

Chanhasen

3 replies

M
MikeLockwood22-Sapphire I
22-Sapphire I
June 4, 2014

Not easy - and not very productive. Getting to know and work with the object model is far more useful.

Javadoc provides a lot of help.

Playing with query builder reports (Site, Util, Report Manager) also gives a lot of clues. Can look at the "view as SQL" code at various points when building reports, although this is grayed out when using certain functionality.

in general, most every table's primary key is IDA2A2. Relationships of Versions to their Master object are also important to understand.

Not much published by PTC over the years on this.

    GregoryPERASSO
    GregoryPERASSO16-Pearl
    16-Pearl
    June 4, 2014

    Once upon a time ..... Windchill UML data model in Rational Rose ....

    No more since 10.0 .....

    If someone has a great Reverse Engineering tool to build an explicit and functionnal UML data model from Java Annotation in Windchill 10. Please share !

      B
      bschmidt-21-Visitor
      1-Visitor
      November 20, 2014

      Hi Chanhasen,

      possibly solved?!


      Right now I´m doing the same ... Working manually through the tables and searching for relationships.

      Here an example of my results. If you like to I could share the whole datamodel (as far as I could collect the relationships between the tables).

      Windchill.JPG

      greets

      Ben

        C
        Chanhasen1-VisitorAuthor
        1-Visitor
        November 20, 2014

        Hi Ben,

        Thanks for sharing the information.If possible ,please share the data model.

        Thanks,

        Chanhasen

        L
        LoriSood23-Emerald II
        23-Emerald II
        November 22, 2014

        This is a very complex question to answer. Mike is right.

        In general, though, objects are usually associated through some sort of link or reference table. The ida2a2 values of the objects themselves (in their own db tables (WTPart, EPMDocument, etc)) will be in the RoleA (ida2a5, ida2a7, etc.) or RoleB (ida2b5, ida2b7, etc.) columns. There are usualy classname column associated with the RoleA and Role B columns to indicate what type of object the ida columns refer to (e.g. classnamekeyrolebobjectref, classnamekeyroleaobjectref, classnamekeya2a5, classnamekeya2b5, etc.)

        Master tables (WTPartMaster, EPMDocumentMaster, WTDocumentMaster) are linked to the tables containing the info on the object iterations (WTPart, EPMDocument, WTDocument) are linked through the ida3masterreference column in the tables containing the iterated info.

          P
          ptc-49007431-Visitor
          1-Visitor
          December 31, 2014

          Hi,

          I explained main link tables in my blog http://maheshmhetre.blogspot.com/

          And to the specific question, to get the model diagram refer the article http://maheshmhetre.blogspot.com/2013/04/windchill-rose-web-publisher.html

          This will work for Windchill 9.1 but not sure about the Windchill 10.x. Try and let me know if the model diagram available in 10.x

          Regards,

          Mahesh

          MarcoTosin
          MarcoTosin21-Topaz I
          21-Topaz I
          November 14, 2019

          Starting from Windchill 11.0 the query builder tool can help you on this.

           

          For example if you want to know how to join objects you can see on attached image, select the two objects type and then try to create a join.

           

          On second image you can see a list of possible join but, if you check the above box, the system check for you only the real join (sometimes there aren't possible join and you have to add more objects to find a useful join).

          Marco
          Terms & ConditionsAccessibility statement