Create Schema Review Policy
There are two ways to create the
Schema Review Policy.
One is from
Schema Review Policy dashboard in
The other is from
Schema Review Policy is a 3-step process.
Specify the basic information, including display name for schema review policy, selected environment and schema review policy template.
Schema Review Rule, including error level and rule-specific fields.
Change rule level
You can choose one of
Error will block the automatic run of
Warning will not.
When the rule is
Disabled, it will not take effect.
Change rule configuration
There are currently three types of rules that need to be configured.
The rule Table Naming Convention and Column Naming Convention use regular expression as format.
The rule Index Naming Convention, Unique Key Naming Convention and Foreign Key Naming Convention use
Template as format.
The rule Enforce the Required Columns in Each Table needs
Details of the rules can be found here.
Preview and confirm the
Schema Review Rule.