Re: using UID in DB

On Tue, Mar 30, 2010 at 01:36:27PM -0700, Tommy Pham wrote: > Hi, > > I'm just wondering if anyone on this list using some type of > UID/UUID/GUID in any of the DB? If so, what DBMS/RDBMS are you using > and how many rows do you have for the table(s) using it? What data > type are you using for that column? If I understand you correctly, I use a single table, "users". Either MySQL or PostgreSQL (depending on the application). There is one record per user, and that record contains a serial/sequential ID, set by the system, a user ID which is varchar(8), email address which is varchar(255), username which is varchar(50) and a password which is varchar(32) and stored encrypted. There are other related tables I use to record which URLs require security and which users have access to those URLs. Paul -- Paul M. Foster