Miners don't really fight for it but yea, that is essentially what happens.
The blockchain isn't a DB. Saved information in the block chain will usually consist of sender address, received address and amount. The contract can input extra information if required.
I don't think the node that "mined" the transaction is actually in the block. But the proof is seen by the fact that the transaction was turned into a hash and completed.