not NULL columns corresponding schema, add 'name' to character table