Visual Paradigm Logo
     Build Quality Applications Faster, Better and Cheaper
 
Home | Products | Download | Documentation | Support | Resources | Partners | Quick Tour | Shop | Company |  
 
   Visual Paradigm Discussion Forum
  Login   [ Register ] Email: Password: Log me on automatically I lost my password  
Recent Topics
Advanced Search
display user-type of the table column in a ER diagram  
Forum Index -> DB Visual ARCHITECT (DB-VA)
Author Message
yanyh


Joined: 2007/01/20
Messages: 2

Offline

I am using the the VP enterprise edition to draw ER diagram, in a table, a column is of a user type, but in the diagram, it always show the system defined data type, even i put user type in the specification. this is wrong information when see it from the diagram. how to make the user type shown in the diagram?

Thanks
Noah
 
Jick


Joined: 2005/04/29
Messages: 2880

Offline

Dear Noah,

Thank you for your post. I guess the article below is what you are looking for:
http://resource.visual-paradigm.com/vpsuite2.3sp1/user_type.html

Please let me know if there are any questions.

Best regards,
Jick

Visual Paradigm International Ltd.
http://www.visual-paradigm.com

Build Quality Applications Faster, Better and Cheaper
 
yanyh


Joined: 2007/01/20
Messages: 2

Offline

Hi Jick,

thanks for your response. I saw this doc page before, and it is not what I mean.

but as in the example on the link you mentioned, in the diagram, the type of name filed is still showing "varchar", not enum('red", "green", "blue"). you may argu that one of the enum value is of varchar type. but here is what I want:

I have a table column with name "idList" and I want the idList to be a char [] type (which is supported by the database i am using). I put "char [] " in the "User Type" filed of column specification, but the "char []" is not displayed in the ER diagram and a system-defined type that I have to choose is displayed.

Hope i made my problem clear!
Noah
 
Jick


Joined: 2005/04/29
Messages: 2880

Offline

Hello Noah,

Thank you for your reply. I will consult our developers, and come back to you as soon as I can.

Best regards,
Jick

Visual Paradigm International Ltd.
http://www.visual-paradigm.com

Build Quality Applications Faster, Better and Cheaper
 
Jick


Joined: 2005/04/29
Messages: 2880

Offline

Hello Noah,

Please try this:
Right-click on the ER diagram and select Presentation Options > Show Column User Type from the popup menu.

Best regards,
Jick

Attached Image : No description given (41 kb)


Visual Paradigm International Ltd.
http://www.visual-paradigm.com

Build Quality Applications Faster, Better and Cheaper
 
 
   Forum Index -> DB Visual ARCHITECT (DB-VA)
Go to:   
Powered by JForum 2.1.4 © 2005 - Rafael Steil