type of conflict: UPDATE vs UPDATE
detection: compare timestamp
resolution: only apply later UPDATE

type of conflict: INSERT vs INSERT
detection: uniqueness violation
resolution: convert INSERT into UPDATE, use UPDATE resolution

type of conflict: UPDATE vs DELETE
detection: primary key doesn't exist
resolution: skip update, it's going to (or has been) deleted anyway

type of conflict: DELETE vs DELETE
detection: primary key doesn't exist
resolution: skip
