Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Storing/referencing users

Storing/referencing users

From: Dave <dave_at_gmailNOSPAM.com>
Date: Sat, 03 Jun 2006 13:33:09 GMT
Message-ID: <pcggg.3717$qD.1325@newsfe1-gui.ntli.net>


Is it best practise to:

  1. Store users in a User table, with a numeric UserID as primary key, and reference these users in other tables using that UserID as a foreign key? Also, this would require an additional username field.

or

2) Store users in a User table, with a text Username as primary key, and reference these users in other tables using the Username as a foreign key?

TIA. Received on Sat Jun 03 2006 - 08:33:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US