This content has been marked as final. Show 1 reply
it can be done with glossary but it looks to me what you want is not that native to glossary approach.
it's good to look here for basics http://www.oracle.com/technetwork/developer-tools/datamodeler/datamodelernamingstandards-167685.pdf
Example here also could be useful if you want to go with glossary - Re: Data Modeler: Naming
If you want to use preferred abbreviation then it should be CDCD_CURRENT_DB.
For me CDCD_ is just a prefix - you can handle it separately in relational model - on whole model, on subview and in both cases classification types also can be used to determine how objects are prefixed.
You don't want Current to be abbreviated then do not put it in glossary however you need to check "Incomplete modifiers" check box in glossary.
Entity property "Short name" goes to table abbreviation during engineering. There is a transformation script which will prefix table columns with table abbreviation if you need it. And another one can remove the prefix.
You can define plural name in glossary and if entity name is a single word then plural will be used during name translation.