PowerDesigner provides default model checks to verify the validity of triggers and DBMS triggers.
Check |
Description and Correction |
---|---|
Trigger name and code uniqueness |
Trigger names and codes must be unique in the model. Manual correction: Modify the duplicate name/code Automatic correction: Appends a number to the duplicate name/code |
Trigger code length |
The trigger code length is limited by the maximum length specified in the DBMS definition (MaxLen). Manual correction: Modify the trigger code length to meet this requirement Automatic correction: Truncates the trigger code length to the maximum length specified in the DBMS definition |
Trigger event check |
The event specified in the DBMS trigger definition must be available in its chosen scope. Manual correction: Modify the trigger code to reference an event in the chosen scope. Automatic correction: None |