A lot of knowledgeable people have answered your question. A couple of months ago I took a snapshot of a YouTube video that succinctly summarizes and logically organizes the most common bottom bracket standards in use today. It was very helpful to me, I hope you find it helpful too.