Timeline for Implementing a one to zero or one relationship
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 14, 2014 at 15:23 | vote | accept | Bart Calixto | ||
| Apr 12, 2014 at 22:45 | history | edited | Rob Farley | CC BY-SA 3.0 |
added 400 characters in body
|
| Apr 12, 2014 at 13:08 | comment | added | ypercubeᵀᴹ |
@Bart, now in scenario 1, product_price_id is a useless column (as scenario 2 shows, you can use the product_id instead.) Plus, the combination NULL UNIQUE constraints will fail miserably in SQL-Server.
|
|
| Apr 12, 2014 at 6:36 | comment | added | Bart Calixto | good catch! I added a unique constrain to the product table. Mind commenting again ? :D | |
| Apr 12, 2014 at 6:04 | history | answered | Rob Farley | CC BY-SA 3.0 |