If you would like to manually run a report/query on the database on a ticket (e.g. with Crystal Reports) and need to get the User from the "Assigned To", this does not directly correlate to "ID" in the USERS table.
See attached screenshot from Crystal Reports to join the appropriate Tables and Columns
TICKET table ASSIGNEDTO column-> USERROLEGROUPS table ID column
USERROLEGROUPS table USERROLEID column -> USERROLE table ID column
USERROLE table USERID column -> USERS table ID column
This information can also be found in our database schema