I would guess that there are thousands of types of rot, but for your purposes there really is only one, as all act similarly unless you are scientist looking at the finest points.
There are two things to know Copper stops rot and Iron assists or even causes it. Because raw lumber has very little iron (the trees have the same problem so try to exclude it from anywhere but the leaves) any iron staining will make any rot critters very happy.
That gets to the water part, it the wood is only wet occasionally you will get dry rot, if it is wet all the time they call it wet rot, in any case if it is very dry at all times it will not rot.
There is wood that has been in the desert for hundreds of years without rotting, and indeed this is true in many old houses.
When in doubt pressure treated wood will stay good for a very long time unless it gets wet often enough to leach away all the protection. Copper Napthanate will kill rot on the outside but will not soak very far into good wood, and insects can stay beyond it.. A rusty nail will defeat all as it will counteract the copper, and favor the rot.
There are also organic poisons but copper is forever if it does not leach away.