3
 Followers
24
 Likes

View Physical Table Name and add comments on Entity Diagram

Backend
On our radar
It would be great that when you export the entity Diagram, you had the option to see the physical table name.

Just because that when a customer asks for an entity model, despite understanding the connections, he actually wants to know which are the tables, and it would be nice to have that without querying ossys_entity.

It would also be nice to add comments to the entity diagram.
Created on 7 Sep 2010
Comments (14)
I found out you can add comments by right clicking ... maybe they need to add a comments icon to the menubar.
Bear in mind that physical table names can differ in different environments.
Merged this idea with '[Service Studio] Feature to set "physical" entity database table name' (created on 24 Oct 2011 16:59:47 by - -)
Feature to set "physical" entity database table name

This comment was:
- originally posted on idea '[Service Studio] Feature to set "physical" entity database table name' (created on 24 Oct 2011 by - -)
- merged to idea 'View Physical Table Name and add comments on Entity Diagram' on 04 Oct 2018 16:59:25 by Fernando Moitinho
Merged this idea with 'Show Entity's Physical_Table_Name in Server Studio' (created on 27 Apr 2018 14:22:08 by David Zangger)

To those of us that write a lot of queries outside of Server Studio, it would be very helpful to see the physical_table_name property of an entity in the entity properties.



This comment was:
- originally posted on idea 'Show Entity's Physical_Table_Name in Server Studio' (created on 27 Apr 2018 by David Zangger)
- merged to idea 'View Physical Table Name and add comments on Entity Diagram' on 04 Oct 2018 16:59:59 by Fernando Moitinho

Hi David,


Can you say what leads you to write a lot of queries outside of service studio?



This comment was:
- originally posted on idea 'Show Entity's Physical_Table_Name in Server Studio' (created on 27 Apr 2018 by David Zangger)
- merged to idea 'View Physical Table Name and add comments on Entity Diagram' on 04 Oct 2018 16:59:59 by Fernando Moitinho

If you are writing all of these queries for actual code, you should be using the View4Entity component from the Forge, so you can author them against names that are consistent in each environment, and masks the complexity of the meta data model.

Writing queries directly against the physical table name is bound to lead you to disaster.

J.Ja



This comment was:
- originally posted on idea 'Show Entity's Physical_Table_Name in Server Studio' (created on 27 Apr 2018 by David Zangger)
- merged to idea 'View Physical Table Name and add comments on Entity Diagram' on 04 Oct 2018 16:59:59 by Fernando Moitinho

If you right click on the entity and click "View Entity", you can track down the physical table name by looking at the Executed SQL.



This comment was:
- originally posted on idea 'Show Entity's Physical_Table_Name in Server Studio' (created on 27 Apr 2018 by David Zangger)
- merged to idea 'View Physical Table Name and add comments on Entity Diagram' on 04 Oct 2018 16:59:59 by Fernando Moitinho

Good tip, Rebecca. That's it.


Also: the physical table names may differ per environment.



This comment was:
- originally posted on idea 'Show Entity's Physical_Table_Name in Server Studio' (created on 27 Apr 2018 by David Zangger)
- merged to idea 'View Physical Table Name and add comments on Entity Diagram' on 04 Oct 2018 16:59:59 by Fernando Moitinho

Changed the category to Database




This comment was:
- originally posted on idea 'Show Entity's Physical_Table_Name in Server Studio' (created on 27 Apr 2018 by David Zangger)
- merged to idea 'View Physical Table Name and add comments on Entity Diagram' on 04 Oct 2018 16:59:59 by Fernando Moitinho

I'm on the side of André here, why do you write a lot of queries outside SS?




This comment was:
- originally posted on idea 'Show Entity's Physical_Table_Name in Server Studio' (created on 27 Apr 2018 by David Zangger)
- merged to idea 'View Physical Table Name and add comments on Entity Diagram' on 04 Oct 2018 16:59:59 by Fernando Moitinho

I get requests from audit, and other groups, with specific data requests.  I prefer to write the SQL in my database tool of choice. 



This comment was:
- originally posted on idea 'Show Entity's Physical_Table_Name in Server Studio' (created on 27 Apr 2018 by David Zangger)
- merged to idea 'View Physical Table Name and add comments on Entity Diagram' on 04 Oct 2018 16:59:59 by Fernando Moitinho

Yes, that makes sense, but there are simpler, more direct paths I think for this. Especially since an audit needs Production data, and that would mean that you are connecting Service Studio to a Production instance, which has been known to cause folks to make mistakes (like the next time they make a change, they think they are working in Dev and they are actually working in Prod).

My suggestion is to use the View4Entity component to get friendly names that are consistent across your environments (it supports the exporting/importing of its configuration across environments), and run your queries against that.

J.Ja



This comment was:
- originally posted on idea 'Show Entity's Physical_Table_Name in Server Studio' (created on 27 Apr 2018 by David Zangger)
- merged to idea 'View Physical Table Name and add comments on Entity Diagram' on 04 Oct 2018 16:59:59 by Fernando Moitinho
views
848
Followers
3