Welcome Guest, Not a member yet? Register   Sign In
Table Structure
#7

[eluser]Bartolo![/eluser]
Can add this question to this topic?

Which naming method (example) do you prefer? Or maybe different?

example One:
(without prefix)

Code:
users
--------
id(pk)
name
email


messages
--------
id(pk)  
message
date
users.id(fk)

example Two:
(with prefix)

Code:
users
--------
user_id(pk)
user_name
user_email


messages
--------
message_id(pk)
message_message
message_date
users_id(fk)


Messages In This Thread
Table Structure - by El Forum - 11-22-2010, 06:59 PM
Table Structure - by El Forum - 11-22-2010, 08:30 PM
Table Structure - by El Forum - 11-22-2010, 09:10 PM
Table Structure - by El Forum - 11-22-2010, 09:17 PM
Table Structure - by El Forum - 11-22-2010, 10:11 PM
Table Structure - by El Forum - 11-22-2010, 11:39 PM
Table Structure - by El Forum - 11-23-2010, 02:23 AM
Table Structure - by El Forum - 11-23-2010, 05:32 AM
Table Structure - by El Forum - 11-23-2010, 05:41 AM
Table Structure - by El Forum - 11-23-2010, 05:51 AM
Table Structure - by El Forum - 11-23-2010, 06:22 AM



Theme © iAndrew 2016 - Forum software by © MyBB