Yeah the shell of a bayonet is connected to equipment ground, there are of course older Edison like bases
View attachment 2575671
While Europe (then Aisa then the rest of the world) standardized on 230V 50hz but thats it.
Whats not simple is all their earthing systems, unlike us they did not standardize on how AC systems are grounded or if they are even required to be, so they have all these different 'earthing systems'.
What we mandate here with a multi grounded neutral (MGN) on the utility side then floating neutral after the service mains is called 'Terra Neutral Combined - Separate' (TN-C-S)
However across the pond in various countries like Norway you can find systems where there is no connection between the equipment ground and the neutral or there is no neutral its a 230v delta secondary (IT) , or the utility floats the neutral and also provides an equipment ground (TN-S).
In remote rural areas with just single phase distribution think its the same as here in a way you find split phase but they never use the 115V side for anything its just a ground reference at the pole.
In Places like Berlin and Spain the '220' was from a 220Y/127 system (now 230Y/133) so its not always a 230Y400.