title: Relational database in phpmyadmin
body: <p>I have two tables set up in phpmyadmin- table userid and table data. The userid table has a single column <code>userid</code> which is the primary key. The table data has <code>id|name|src|</code> and a bunch of other information. The issue right now is that the column id which is a 16 character long string acts as a primary key in table userid and foreign key in table data. Now if the same user wants to upload more than one image then i am having to repeat the id in the table data and the table is becoming very large. Is there any other way to go about this(i am relatively new so im sorry if this sound rather stupid.). Finally is there actually any performance boost in this situation by indexing the id of the user in the other table as to me it seems like just a waste of space as im haveing to repeat the user id one more time in the table userid as compared to having a single table to hold both data and user id. </p>