id-column (GN017)

Automatic fix is available.

What it does

Checks for usage of ID columns.

Why not?

The name "id" does not provide much information about what the column represents in the context of the table as it is so generic. Using a more descriptive name can improve clarity, readability, and maintainability of the database schema.

When should you?

Almost never.

Use instead:

Descriptive name.