We can also insert records with specific values into a table and leave other fields blank.

Perfect! The fields that don't receive a value use their default value or NULL. We can't skip fields that have a NOT NULL constraint, though.

Didn't we place a constraint on id and name that don't allow them to be NULL?