12 messages in com.mysql.lists.eventum-usersCustomer ID
FromSent OnAttachments
Joakim Abel21 Apr 2005 05:56 
Joao Prado Maia21 Apr 2005 12:47 
Georger Araujo25 Apr 2005 05:11 
Georger Araujo28 Apr 2005 04:45 
Eric Frazier28 Apr 2005 08:20 
Joao Prado Maia28 Apr 2005 08:41 
Eric Frazier28 Apr 2005 08:59 
Eric Frazier28 Apr 2005 10:55 
Elan Ruusamäe29 Apr 2005 06:36 
Bryan Alsdorf02 May 2005 05:42 
Eric Frazier02 May 2005 07:14 
R P Herrold02 May 2005 13:03 
Subject:Customer ID
From:Eric Frazier (er@dmcontact.com)
Date:04/28/2005 10:55:58 AM
List:com.mysql.lists.eventum-users

Hi,

I just noticed that in the user table there is only the usr_id for uniqueness, but it seems to me this needs to be something more like usr_id,prj_id In our case we have more than one customer group that wants to use Eventum, and the way it is now, usr_ids could conflict between projects. It ends up being helpful for a usr_id in Eventum to correspond the customer id in other CS databases.

Just an observation..

Thanks,

Eric