Table structure

Hello,

I want to create a user table to store user information, e.g. First name, Last name, Logon ID (a uniquely generated ID for each user), Phone, etc.

Is there anything wrong with creating the primary key on the Logon ID? The Logon ID will be a VARCHAR2 of eight long.

I'm not sure if creating the primary key index on a string is a good idea. From what I've seen, it's standard to create a "USER_ID" column, of NUMBER(6) which is a uniquely generated number (from a sequence), leaving the Login ID as is.

Any ideas?

-== A.G. Mueller ==- Received on Sun Sep 29 2002 - 23:03:35 CDT