What kind of lens is the AF Nikkor 50 mm f/1.8D?

What pictures is that lens for? Portrait
It's not a micro or macro lens, is it?

And what would be a good macro lens?

It's often used as a portrait lens.

A good macro lens, just about anything made by Nikon, Sigma, Tokina or Tamron. In fact it's difficult to find a bad one.

The 50mm is a PRIME lens (ie. No zoom - fixed focal length) it is also known as a STANDARD Lens - in the old days the 'kit' lens that most cameras would come with would be a 50mm.

The 1.8 wide aperture is great for shallow depth of field and it's a good portrait lens.

I have the canon 50mm f1.8 and it rarely leaves my camera.

for a Macro lens you want something that can focus close to the lens (for my 50mm the minimum distance is 45cm - not really close enough)
BUT - if you google 'reverse lens macro' you will see that you can get really good macro shots by mounting (or holding) your lens back-to-front on your camera, not ideal but handy!

True Macro lenses make objects appear in a scale of 1:1 on your sensor, but many lenses give great close-ups, the 50mm is not one of them unless you reverse mount it, or use extension tubes.

The AF-Nikkor 50mm 1:1.4D is Nikon's current version of their fast 'standard' prime lens, and while this specific model was introduced in 1995, the basic optical design dates back to the manual focus 50mm 1:1.4 AI of 1977.It features a traditional layout of 7 elements in 6 groups utilizing spherical surfaces only, which Nikon claims will deliver distortion-free images with superb resolution and colour accuracy, plus high contrast even at maximum aperture. The 50mm focal length classes it as a 'standard' lens on the FX format, with none of the 'perspective distortion' characteristic of wideangle or telephoto lenses, whilst on the vastly more popular and widespread DX format it behaves like a short telephoto, ideal for portraiture.