Rules to implement

[tbordinat]

List of rules the tool have to check :

Keywords and Reserved words

• Don't use any keyword or reserved word
  It depends on DBMS, so implement it for :
  • MySQL
  • MariaDB
  • PostgreSQL
  • Oracle

Tables

• Table name max length
• Prefix : Table name should start with *
• Suffix : Table name should end with *

Columns

• Column name max length
• Prefix : Column name should start with *
• Suffix : Column name should end with *

Constraints

Primary Key

• Primary Key name max length
• Prefix : Primary Key name should start with *
• Suffix : Primary Key name should end with *

Foreign Key

• Foreign Key name max length
• Prefix : Foreign Key name should start with *
• Suffix : Foreign Key name should end with *

Unique Constraint

• Unique constraint name max length
• Prefix : Unique constraint name should start with *
• Suffix : Unique constraint name should end with *

Indexes

• Index name max length
• Prefix : Index name should start with *
• Suffix : Index name should end with *

Views

• View name max length
• Prefix : View name should start with *
• Suffix : View name should end with *

Triggers

• Triggers allowed or not ?
  If they are allowed :
• Trigger name max length
• Prefix : Trigger name should start with *
• Suffix : Trigger name should end with *