borkdominik / bigER

Entity Relationship Diagram modeling tool realized as a language server that is distributed as a VS Code extension.
https://marketplace.visualstudio.com/items?itemName=BIGModelingTools.erdiagram
MIT License
106 stars 13 forks source link

additional column specification for multivalued attributes in sql code generator #45

Open minaajafari opened 1 year ago

minaajafari commented 1 year ago

Description

There is no possibility to add some additional attribute in a table with a multivalued attribute for sql code generation . it will be better if set some option for assign number of its value to adding in table .(references to fig 4.1)

Picture12 Fig.4.1:screenshot of BigER : there is no additional column for multivalue attributes in sql code generation

Current Behavior

when user consider an attribute as multivalued attribute in ER , after sql code generation it does not consider additional column for adding this multi value attributes .

Expected Behavior

sql code generator should assign additional column for multivalued attributes . for example when we set phone number as a multivalued attribute it should be som option to assign two or three for value and consequently after sql code generation mentioned attribute should be have two or three additional column for data entry .

Steps to Reproduce

No response

Environment

No response

Additional Information

No response