Author Topic: Glossary for data model domains  (Read 3034 times)

Sam Courtney

  • EA User
  • **
  • Posts: 58
  • Karma: +1/-0
    • View Profile
Glossary for data model domains
« on: March 08, 2014, 10:50:17 am »
Looking for possible waysto handle this:

A sort of glossary feature that will allow user to map certain names/terms to a designated word. Going hand-in-hand with this feature would be the ability to automatically map domain type (VARCHAR, INT, etc.) to a pre-defined column name. (i.e. If we set a column name ‘ZIP_CODE’ to domain type of VARCHAR(5), every time we reuse ‘ZIP_CODE’ as a column name, EA would automatically assign the domain type of VARCHAR(5) to it.)

Any guidance would be great!  :)
Thanks!

Helmut Ortmann

  • EA User
  • **
  • Posts: 967
  • Karma: +42/-1
    • View Profile
Re: Glossary for data model domains
« Reply #1 on: March 09, 2014, 09:46:59 pm »
Hello,

1. Glossary
EA has a powerful glossary

2. Domain specific rules (Column type from Column type)
You may write an Addin which handles the EA_OnPostNewAttribute event to set the right type of your column.

Helmut


 
 
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13240
  • Karma: +553/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Glossary for data model domains
« Reply #2 on: March 10, 2014, 06:48:05 pm »
The "proper" way to handle these kind of things is to create datatypes for zip-codes and the likes.
On the datatype you can then define constraints, transformation rules etc...

Geert