abbreviations of tables

[former_member233011]

Hi,

is it possible to provide an abbreviation of a table. We use such abbreviation to build things like primary keys, foreign keys and so on from this.

Example:

table name: PARTNER_H

abbreviation: parth

this abbreviation is used for the other objects following a strict naming convention:

primary key column: parth_id

sequence for primary key column: seq_parth_id

primary key: pk_parth

alternate key: uk_parth

Is this possible? It would save a lot of time during design.

[GeorgeMcGeachie]

you can access the Naming Conventions via model options:

In this example I'm using the terms in the Glossary as my source for abbreviations. You could use a CSV file if you prefer, as Rafal suggested. In your case that would be better, as you wouldn't want to add Business Terms like PARTNER_H to your glossary.

If '_H' means this a history table, then you could use a combination of naming conventions and a script to generate the codes.

[former_member217396]

Is it not easier to have the abbreviations defined as codes in a mapping table for names? And then, in the naming conventions use this table, to map the names to the codes? The code will be used then in the primary key, sequence name etc. It's only an idea...