Can I add a foreign key to aspnet_Users table?
<p>I'm writing a website similar to Amazon. Each user can open a shop.</p>

<p>Thus the database has a <code>Shop</code> table, whose primary key is id. Each user can open at most one shop. </p>

<p>I know I can use <code>Profile Provider</code>. I have been already using it to save the user's address, telephones, and that sort of information. But I think saving shop id to Profile is not a good idea, because I can not use SQL to find out the shop owner's name of a given shop, which makes that I can not use the off-the-shelf data controls without code-behind to complete my function on the shop page.</p>

<p>So can I modify <code>aspnet_Users</code> table adding a <code>shop</code> field which is a foreign key to <code>Shop</code> table? Will it cause problems?</p>

<p>Or I built another <code>User</code> table and put <code>shop</code> field in it?</p>

<p>Or do you have any best practice of doing that sort of things?</p>
