Part I. Getting started

Part II. UML modeling

Part III. Project glossary

Part IV. BPMN toolset

Part V. Project management

Part VI. Modeling toolset

Part VII. ArchiMate tools

Part VIII. Team collaboration

Part IX. Code engineering

Part X. Database design and engineering

Part XI. Advanced modeling toolset

Part XII. Document production

Part XIII. Business modeling

Part XIV. Business rule

Part XV. Agile development

Part XVI. Wireframe

Part XVII. Impact analysis

Part XVIII. CMMN toolset

Part XIX. SoaML modeling

Part XX. Design animation

Part XXI. IDE Integration

Part XXII. Interoperability and integration

Part XXIII. Process simulation

Part XXIV. Zachman and BMM

Part XXV. Appendix A - Application Options

Part XXVI. Appendix B - Project Options

Part XXVII. Appendix C

 

Using Auto Column

Auto Column provides you with a quick way in creating entities in ERD. Just by entering the name of a column when you create it, its type, nullable and default value will be specified, based on the pre-defined column schema.

Configuring Auto Column

You need to configure the auto columns in order to use them in ERD. To configure auto columns:

  1. Select Window > Application Options from the toolbar.
  2. In the Application Options window, open Diagramming > ERD & ORM.
  3. Click Add....
    Add an auto column
    Add an auto column
  4. Define the auto column by entering its name, type, nullable and default value. When you create columns by using the name specified, the type, nullable and default value will follow the definition here. Note that you can specify the length of datatype when specifying Type.
    Defining an auto column
    Defining an auto column
  5. Click OK to confirm.
  6. Click OK again to close the Application Options window.

Pattern matching using wildcard

Sometimes, columns are named based on the entities they are in. For example, for entity, Teacher, there may be a column named TeacherID and for entity, Student, there may be another column named StudentID. Although these columns are named differently, they may share the same type, nullable and default values. In such case, you can make use of pattern matching in defining an auto column.

When naming an auto column, you can use the '%' character to indicate the occurrence of ANY character. For example, naming an auto column %Name will result in causing TeacherName and StudentName apply the definition specified.

Using pattern matching in defining an auto column
Using pattern matching in defining an auto column

Adding a column to entity with Auto Column

When you create a column in entity, give it a name that follows an Auto Column defined. When you confirm editing, the type, nullable and default values will be automatically set for you. Note that if you enter a type yourself, Auto Column will NOT function.

Naming a column
Naming a column

Related Resources

The following resources may help you to learn more about the topic discussed in this page.

 
5. Applying Default Schema on ERD Table of Contents 7. Entering Sample Table Records for Entities

We use cookies to offer you a better experience. By visiting our website, you agree to the use of cookies as described in our Cookie Policy.OK