Table Strucuture
Posted: Mon Jun 21, 2004 6:32 pm
My two examples are probably similar enough where it doesn't matter but I would like to know how you would do it.
I am creating a table for logging users in and storing user information. Is it best to use 1 table (Option A) or two tables (Option B) with a shared key? I see advantages and disadvantages with both.
User_Table
Option A: 1 table
Option B: 2 tables:
TABLE 1:
TABLE 2:
I am creating a table for logging users in and storing user information. Is it best to use 1 table (Option A) or two tables (Option B) with a shared key? I see advantages and disadvantages with both.
User_Table
Option A: 1 table
Code: Select all
| ID | USER_NAME | PASSWORD | FNAME | LNAME | PHONE | EMAIL | DTTM_LAST_LOGIN | STATUS | LOGIN_ATTEMPTS | DTTM_ADDED |TABLE 1:
Code: Select all
| ID | USER_NAME | PASSWORD | LOGIN_ATTEMPTS | DTTM_LAST_LOGIN | STATUS |Code: Select all
| ID | FNAME | LNAME | PHONE | EMAIL | DTTM_ADDED |