meta user
network profile
| bio | website | escodeigniter.com |
|---|---|---|
| location | Allende, Mexico | |
| age | 28 | |
| visits | member for | 1 year, 3 months |
| seen | Jan 29 at 17:38 | |
| stats | profile views | 7 |
A developer wanna be.
Nothing interesting about me.
|
Nov 26 |
revised |
How should I model a worflow of status/activities ? (rules like “if is 3 go to 4, if is 4 go to 5” etc) improved formatting |
|
Nov 26 |
comment |
How should I model a worflow of status/activities ? (rules like “if is 3 go to 4, if is 4 go to 5” etc) Thanks @Kevin, It seems to work (not tested yet in a "real" application) but you certainly solve most of my doubts. I'm going to try model my "real application" first, after that I'll be back to make a last update for my post/question. And yes, you're right, I didn't mention nothing about "state machine" because every time I read about it, I got lost and didn't find nothing about how to model to a database, I try to understan/use the "Workflow Foundation" but it looks too complicated, well it's time to go on my own :) My regards ! |
|
Nov 26 |
accepted | How should I model a worflow of status/activities ? (rules like “if is 3 go to 4, if is 4 go to 5” etc) |
|
Nov 26 |
revised |
How should I model a worflow of status/activities ? (rules like “if is 3 go to 4, if is 4 go to 5” etc) added 2 characters in body |
|
Nov 26 |
revised |
How should I model a worflow of status/activities ? (rules like “if is 3 go to 4, if is 4 go to 5” etc) Improve format |
|
Nov 26 |
comment |
How should I model a worflow of status/activities ? (rules like “if is 3 go to 4, if is 4 go to 5” etc) Hi again @Kevin-Feasel,could you please extend the "parent-child relationship with Activity" approach, I edit my question and add the constrains and more samples on the table Rules, you were right about "If you have multiple statuses, multiple activities, and there are multiple relationships between these". Thanks again |
|
Nov 26 |
revised |
How should I model a worflow of status/activities ? (rules like “if is 3 go to 4, if is 4 go to 5” etc) added 1399 characters in body |
|
Nov 26 |
comment |
How should I model a worflow of status/activities ? (rules like “if is 3 go to 4, if is 4 go to 5” etc) Thanks, I'm going to try to "digest" your whole answer,it looks totally right, but I need time to figure out what are you explaining, Once I get a new idea I'll update your answer as the correct one, thanks again. One more thing it seems to me that the "parent-child relationship with Activity" approach it's what I need, mainly because the requirements don't specify this (I'm assuming that can happen for example, go from State One to State Two, and also to State 3 (with diferent activities). |
|
Nov 26 |
revised |
How should I model a worflow of status/activities ? (rules like “if is 3 go to 4, if is 4 go to 5” etc) edited body |
|
Nov 26 |
revised |
How should I model a worflow of status/activities ? (rules like “if is 3 go to 4, if is 4 go to 5” etc) edited body |
|
Nov 26 |
revised |
How should I model a worflow of status/activities ? (rules like “if is 3 go to 4, if is 4 go to 5” etc) added 812 characters in body |
|
Nov 26 |
asked | How should I model a worflow of status/activities ? (rules like “if is 3 go to 4, if is 4 go to 5” etc) |
|
Sep 24 |
awarded | Supporter |
|
Sep 24 |
accepted | Alternative query to this (avoid DISTINCT) |
|
Sep 22 |
revised |
Alternative query to this (avoid DISTINCT) Follow the recomendations to improve the significante of the data |
|
Sep 21 |
asked | Alternative query to this (avoid DISTINCT) |
|
Jul 10 |
comment |
T-SQL, show a set of rows (specific column) as a field, for a better desc, please see the table relationship Thank you @DanSorensen |
|
Feb 8 |
comment |
T-SQL, show a set of rows (specific column) as a field, for a better desc, please see the table relationship Thanks @WT_W I'm gonna check ASAP to see If I can learn/understand them |
|
Feb 3 |
awarded | Student |
|
Feb 3 |
awarded | Scholar |
