Diagram SQL Server

[daniel.garciaSVTR9]

Hello, there is a document with the autocad plant 3D table diagram. I try to see how they are related in SQL Server. Thank you.

[Phil-22]

Good morning,

Sadly - it generally seems Autodesk is either lacking documentation, or not forthcoming with it.

I have spent a lot of time in the database, and feel I have a pretty good handle on it. Whether you're working in a local SQLite database, or central SQL database, I may be able to offer some insight.

What specifically are you trying to understand?

Phil

[jabowabo]

This is a good source of information: https://www.auxalia.com/en/product/database-explained/

more info here:

https://knowledge.autodesk.com/support/autocad-plant-3d/learn-explore/caas/simplecontent/content/pla...

https://knowledge.autodesk.com/support/autocad-plant-3d/learn-explore/caas/simplecontent/content/pid...

[daniel.garciaSVTR9]

Hello, sorry for the delay.
I need to know which is the table of the database where the information of the pipes is stored.

[matt.worland]

I'd start in the EngineeringItems table and use the rowid to see how it's linked to other tables.

[Phil-22]

There's not a singular table. It depends on what you're looking for. For example Pipe information can be seen with this query:

If you step through the views you'll get a general sense of how Plant 3D is identifying "parts" and their data. There's a correlation between the view structure and the class hierarchy which is seen in the class definitions seen in Project Administration.