as far as i know :
NOT NULL as a real constraint indicating the column can never be empty
NULL is not a constraint. Using the NULL in your table definition doesn’t show up NULL when you do a describe from your table. The keyword NULL is just ignored… and NULL means “it can be empty yes or no”, so this includes ALL situations without any constraint.