The frame works like a bridge and it's trusses would, each node transfering the weight and forces into tension and compression trough the tubes. Most of the weight sits on the bottom bracket, so the downtube and chainstays work in tension, while the seatube, seatstays and top tube work in compression.