Timeline for alternative to trigger. Cascade
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 7, 2014 at 19:56 | comment | added | ricardo | Thanks. A user can have multiples stock; A stock belong to only one user; The stock can have multiple sectors; The user choose whish sectors their stock belong; When I delete a users, all the stock of this user(user_id of the stock table) are deleted; Your question help me with one thing: if a stock belong to only 1 user. I do not need the user_id on the sector table. So I can add a CONSTRAINT in the table like I put in the stock table. | |
| Sep 6, 2014 at 19:37 | comment | added | Lennart - Slava Ukraini | One additional question, in stock there is an attribute user_id, does it mean that a stock can no be owned by more than one user? | |
| Sep 6, 2014 at 19:30 | comment | added | Lennart - Slava Ukraini | I don't understand the stock_sector_a table, can a stock belong to different sectors for different users? Should that not be split into two tables, say stock_sector and user_stock? | |
| Sep 6, 2014 at 19:22 | comment | added | Lennart - Slava Ukraini | Thanks for the edit, the ddl makes it much easier to understand what it is you are trying to do. I'll update my answer according to this new info | |
| S Sep 6, 2014 at 18:30 | history | edited | ricardo | CC BY-SA 3.0 |
corrected grammar and more info
|
| S Sep 6, 2014 at 18:30 | history | suggested | Shanky | CC BY-SA 3.0 |
corrected grammar
|
| Sep 6, 2014 at 17:27 | review | Suggested edits | |||
| S Sep 6, 2014 at 18:30 | |||||
| Sep 6, 2014 at 17:24 | answer | added | Lennart - Slava Ukraini | timeline score: 1 | |
| Sep 6, 2014 at 16:40 | review | First posts | |||
| Sep 6, 2014 at 17:27 | |||||
| Sep 6, 2014 at 16:40 | history | asked | ricardo | CC BY-SA 3.0 |