I plan to use User Logins and Roles etc in the next while and am currently seting up my Application Database tables. At this point, I am setting up the actual transaction tables (rather than the User login / roles tables etc.)

I need to know what type of fields to set up for the appication to hold the user ID. Typically I will be adding a 'Who Did what when' to my data files and need to know what type of field the 'Who' should be . What sort of field does SF expect a user to be      Integer ?  Character  ?   Varchar? etc.

Tia

Gerard