unsigned -> Type of Field
NOT NULL -> Field cannot be NULL
auto_increment -> will be an auto increment field
ENGINE=MyISAM -> There are quite a few engines in MySQL and default is MyISAM and so I would suggest don't get into its details right now.