Rules tagged with: Modeling

Database modeling and design.

• G-1210 Never create a table without a primary key.

  Reliability
• G-1220 Avoid composite primary keys.

  Maintainability
• G-1230 Avoid tables without relationships.

  Maintainability
• G-1240 Try to index foreign key columns.

  Reliability
• G-1250 Try to define a business key for each table.

  Reliability
• G-1260 Try to define a comment for each table.

  Maintainability
• G-1270 Try to define a comment for each column.

  Maintainability
• G-1280 Try to use domains instead of raw datatypes for table columns.

  Maintainability

8 total