For the record, that first link isn't me, but I was expressing similar ideas at the time. This was before we had laid eyes on the early dev relationship chart, but Tifa being derived from and representing Tifaret was common enough.
Actually man, looking at that FF Wiki page, we really need to start doing a sweep for "Aerith was one of the first designed characters" because it's just... so not correct. The character who would become Aerith was but she wasn't Aerith at the time.... It's a whole thing.
I already made note of it on the character pages for Tifa, Aerith, Sephiroth and Vincent but there's a lot more pages that need fixing.
Addendum: Found a very old LTD post from that same forum, and holy fucking hell, TOTP actually canonized a supposition I put forward in 2006.
You'll note I didn't call it the "Love Triangle" debate. That's because this isn't going to be your typical Aerith Vs Tifa debate for two reasons. Firstly, I think Aerith had as much chance as Yuffie, and secondly and more importantly, we're starting from square one- meaning all the girls...
home.eyesonff.com
Specifically that Tifa always liked Cloud but didn't realize she liked him liked him until the water tower. I was technically off by a couple hours, but still.