The naming of all objects in the SQL server, such as tables, views, procedures, must follow strict rules to ensure an error-free flow of the EULAND® business logic and also to ensure compatibility with future updates. This page contains a summary of these rules.
TR_[USER oder Ersteller]_[Tabelle oder Kürzel]_[Trigger-Operation]_[Optionale Info]
The individual name components of the triggers are separated by underscores. Only the letters"A" to"Z" and the digits"0" to"9" may be used next to this special character. Except for the short description, only uppercase letters are used for all parts of the name.
The trigger name always begins with the two letters "TR" followed by the creator's alias. This is either "USER" or if you are an EULANDA® solution partner, your registered alias. Then follows the table alias. This can be found in the list of abbreviations. If EULANDA® does not provide an abbreviation for a table the complete table name is used instead.
This is followed by an abbreviation for the monitored table operations:
|INSERT, UPDATE, DELETE||ALL|
This can be followed by a concise term describing the trigger.
Stored Procedure (Stored Procedures)
Procedure names begin with"cn_". User procedures begin with "cn_user_". There are no other conventions. A good practice is to use the abbreviation of the table that is primarily affected (see also list of abbreviations).
The names of user tables may only begin with the prefix "user" without the following underscore. Exceptions are the Küzel registered solution partners.
The names of user views must begin with"USER_" or the registered solution partner abbreviation.
Constraint names must begin with the standard abbreviation for the container type followed by an underscore (see Naming Conventions).
<Constraint-Typ> "_" [ <kürzel ersteller="" />Ersteller "_" ] <Tabellen Alias> "_" [ Feldname "_" ] 
The identifier for the creator is mandatory for all constraints that are not delivered with EULANDA®. Only "USER" or the registered solution partner abbreviation are permitted here.
CK_DDHANDEL_AF_Preispruefung /* fuer Solution Partner DDHANDEL */