Constraint Help

Can someone tell me the difference between cylindrical and prismatic constraint, I have no idea what they are supposed to do and is struggling to find how they can be used differently.

So, pretend we have 2 parts, A and B, and A is anchored.

If they’re attached by a Prismatic Constraint, B moves like a sliding door, it is aligned with A along 2 axis and slides along the other axis and cannot rotate
In the sliding door example, the door can move left and right; cannot move up, down, forward, nor back; and can’t rotate in any direction

If they’re attached by a Cylindrical Constraint, B moves like a hula hoop, it is aligned with A along 2 axis and slides along the other axis, but can rotate around that 3rd axis
In the hula hoop example, the hula hoop can move up and down; cannot move left, right, forward, nor back; and can only rotate around the vertical axis