``default`` defines what values will go in to a field when a value is not defined, which is similar to ``CHECK([field] IS NOT NULL)``, but with the extra behavior of automatic value substitution when the check fails.

Regardless of that interpretation of it's behavior, some databases treat and explicitly document ``default`` as a constraint.