Why is there a "userid" and a redundant "handle" field in table qa_eventlog?

Question

I just realized that we do not need the handle in qa_eventlog.

Especially when the handle (username) is changed be the user, all those saved handles are wrong!

Can somebody elaborate why this is done?

PS: I checked if there is any case where we have userid==NULL and handle NOT NULL, there is none in my production forum.

Comments

I don’t know off hand but the handle field may be used for custom names of anonymous users.

---

I'd suggest to have NULL on the handle, since the handle could change, and only keep the userid. The handle can - as you say - be set in case it's an anonymous user stating his name (plus userid NULL, of course).