Documentation
Back to website >

Naming Conventions (EULANDA SQL API)

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.

Triggers

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:

OperationAbbr.
INSERTINS
UPDATEUPD
DELETEDEL
INSERT, UPDATEINSUPD
INSERT, DELETEINSDEL
UPDATE, DELETEUPDDEL
INSERT, UPDATE, DELETEALL

This can be followed by a concise term describing the trigger.

Examples

TR_USER_AF_UPD_StatusUeberwachung
TR_USER_AD_INSUPD_Historie
TR_DDHANDEL_RE_DEL_WaehrungsKurs

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).

User tables

The names of user tables may only begin with the prefix "user" without the following underscore. Exceptions are the Küzel registered solution partners.

Views

The names of user views must begin with"USER_" or the registered solution partner abbreviation.

Constraints

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.

Instances

CK_USER_AD_Pflichtfelder 
CK_USER_AR_UserI1_Plausibilitaet
CK_DDHANDEL_AF_Preispruefung /* fuer Solution Partner DDHANDEL */