Change column type for the concrete attribute

General Questions/Discussions
1

Can I change column type for the concrete attribute?
I want to have follow functionality (please, see attachment): I will have the “ColumnType”-combobox in the Attribute Specification. In this combobox I can choose Oracle column type (if Oracle chosen as default DB). This type will generate in ERD.

column_type_in_attribute_specification.png800×653 52.6 KB

column_type_in_attribute_specification.png

2

Hi Eugeny,

Thanks for your post. In coming release (VP Suite 4.2), we will support configuration of default type of mapped attributes and columns when synchronization between class diagram and ERD (e.g. attribute type “string” <-> column type “varchar2”), and I think this will help you to decide which type the column will be when you specify type in attribute.

Will this help?

Best regards,
Lilian Wong

3

What about change column type for concrete attribute? For example, “Description: String” -> “Description: varchar2(100)” and “Description2: String” -> “Description2: varchar2(200)”.

4

[quote=LilianWong]Hi Eugeny,

Thanks for your post. In coming release (VP Suite 4.2), we will support configuration of default type of mapped attributes and columns when synchronization between class diagram and ERD (e.g. attribute type “string” <-> column type “varchar2”), and I think this will help you to decide which type the column will be when you specify type in attribute.

Will this help?

Best regards,
Lilian Wong[/quote]
Hi!
What algorithm of defining database type you supposed? Will it possible to define database atrribute type in UML classes? For examlple:
Uml
MyFirstClass
Id: int;
Name:string
Description: string

MySecondClass
Id: int;
Name:string
Description: string

Can i define Oracle database types for this classes?
DataBase
MyFirstClassTable
Id: number(10);
Name:varchar(50)
Description: varchar(200)

MySecondClassTable
Id: number(16);
Name:varchar(10)
Description: varchar(150)

5

Hi Eugeny,

How about the following approach (illustrated by the attached image as well)?

  1. configure the Auto Column Type at Tools > Options > Diagramming > ERD & ORM
    Name Type
    Description varchar2(100)
    Description2 varchar2(200)
  2. configure database at Tools > ORM > Database Configuration
  3. create the attributes with specified names and sync the class diagram to ERD

Or you actually considering the case Sergasd stated?

Best regards,
Lilian Wong

auto_column_type.png800×910 73.8 KB

auto_column_type.png

6

Yes, I actually considering the case Sergasd stated.

7

[quote=LilianWong]Hi Eugeny,

How about the following approach (illustrated by the attached image as well)?

  1. configure the Auto Column Type at Tools > Options > Diagramming > ERD & ORM
    Name Type
    Description varchar2(100)
    Description2 varchar2(200)
  2. configure database at Tools > ORM > Database Configuration
  3. create the attributes with specified names and sync the class diagram to ERD

Best regards,
Lilian Wong[/quote]

You suppose it is impossible existing tables with identical column name?
Let me undeceive you - it is a common occurrence!

8

Hi Sergasd, Eugeny,

Thanks for replying and all your details. I’ve passed this issue to our development team to study the feasibility to support this. I’ll keep you posted for any news.
At the moment you need to edit the column type manually, I’m sorry about this.

Best regards,
Lilian Wong

9

[quote=LilianWong]Hi Eugeny,

Thanks for your post. In coming release (VP Suite 4.2), we will support configuration of default type of mapped attributes and columns when synchronization between class diagram and ERD (e.g. attribute type “string” <-> column type “varchar2”), and I think this will help you to decide which type the column will be when you specify type in attribute.

Will this help?

Best regards,
Lilian Wong[/quote]

I just got confirmation from our engineers that VP Suite 4.2 will not support configuration of default type of mapped attributes and columns, I’m sorry about this. I’ll keep you posted for any further news or new time frame.

Best regards,
Lilian Wong

10

Thank you very much!

11

Hi Sergasd, Eugeny,

I would like to let you know that we will add additional column “Column Type” when synchronize class diagram to ERD - attached image shows our idea of this enhancement. I believe this can help you edit the column types and length easily for same attribute names but different type/length on entities.
This enhancement is planned to be available in VP Suite 4.2 SP1.

Best regards,
Lilian Wong

column_type_proposal.png480×600 28.8 KB

column_type_proposal.png