Home > Forum > Data sources > Database diagram / physical data model

Database diagram / physical data model
0

Hi to all. As a consultant who needs to dive regularly into the database using SQL I'm surprised that there is no physical data model diagram in the documentation. A visual representation of tables and their dependancies provides a very useful overview about how data is structured, maintained and related. In SQL server there is a option to add a new database diagram and thus my question: could Webcon, as a software vendor, provide and maintain the database diagram OR is it up to the implementation team to build their diagrams? Or maybe this is already documented and I'm just missing the link?

Later edit: I wanted to add the post to the „Database” topic but unfortunately it ended up in the „Data Sources” one. If an admin can move it, I will be obliged.

MVP

Hi Roman,
there is a documentation* to the database, but it's not a diagram, if you need the diagram then the best way would be to create one yourself in the SSMS.
Relationships are maintained with proper keys, so the diagram basically builds itself.

Main tables you will need:
* WFElements
* WFElementDetails

* WFDocTypes
* WorkFlows
* WFConfigurations
* WFDefinitions
* WFApplications

* WFHistoryElements
* WFHistoryElementDetails


*https://developer.webcon.com/2025/resources/db/?PageSpeed=off

MVP

HI Roman,

there's also this knowledgebase post which describes the tables in which the elements of the Designer Studio are stored.

https://community.webcon.com/posts/post/configuration-tables-in-webcon-bps/158/26

This is a bit outdated as the automations didn't exist in 2020. Don't ask how we worked before them, you don't want to know the answer. :)

There's also one other important information.
In English the term "Fields" is used in the Designer Studio but in polish it's something similar to 'Attribute''. As attribute already sounds like English you will see some posts which use 'attribute ' instead of 'field'

Best regards,
Daniel