If columnd does not accept NULLs it should be defined with NOT NULL constraint. Setting DEFAULT constraint does not prevent inserting NULL in the column.
>Should I make sure of NULL/NOT NULL constraint? Or, any comment if I set all non-mandatory fields as NULL with default constraint ('')/(0)?
--sb--