meta user
network profile
| bio | website | |
|---|---|---|
| location | Charlotte, NC | |
| age | 25 | |
| visits | member for | 1 year, 4 months |
| seen | Feb 13 at 5:15 | |
| stats | profile views | 2 |
My twin brother and I have a CD; you can check it out on
- iTunes,
- Amazon MP3,
- Google Play, and
- CDBaby.com.
Let us know what you think about it on our Facebook page!
I find very few things in life serious enough to take all that seriously =)
I have an Amazon wishlist.
|
Mar 30 |
comment |
Do I need a separate Id column for this “mapping” table? @ypercube Thanks for clarifying that. I can see how that would be more clear. And, as Aaron said, it would be consistent across all tables (which is nice). |
|
Mar 30 |
awarded | Scholar |
|
Mar 30 |
accepted | Do I need a separate Id column for this “mapping” table? |
|
Mar 30 |
comment |
Do I need a separate Id column for this “mapping” table? +1, thanks! Question regarding your last paragraph: I thought it was bad practice to include the name of the table before the column name (Products.ProductId, rather than just using Products.Id). Am I wrong (or perhaps confused) about that? |
|
Mar 30 |
comment |
Do I need a separate Id column for this “mapping” table? "you wouldn't need to have an additional key, as the combination of ProductId/ProducerId would ultimately be unique" - Ah, that makes sense! Exactly what I was wondering about. |
|
Mar 30 |
awarded | Editor |
|
Mar 30 |
revised |
Do I need a separate Id column for this “mapping” table? Clarified the many-to-many confusion I created. |
|
Mar 30 |
comment |
Do I need a separate Id column for this “mapping” table? Ah, I did not make that clear. Yes, there is the relationship would be (I think) many to many. A product could be produced by more than one producer, and a producer and can carry multiple products. |
|
Mar 30 |
awarded | Student |
|
Mar 30 |
asked | Do I need a separate Id column for this “mapping” table? |
|
Mar 8 |
awarded | Supporter |
|
Jan 25 |
comment |
Could Stack Overflow run on SQL Server Web Edition? Possibly check out this SO podcast which discusses some of their scaling problems. |
|
Jan 25 |
awarded | Autobiographer |
