147 reputation
16
bio website escodeigniter.com
location Allende, Mexico
age 29
visits member for 2 years, 8 months
seen Jun 26 at 3:36

A developer wanna be.

Father, js padawan just for fun (since I can't do anymore in my current position.)

@el_allende


Jul
17
awarded  Notable Question
Oct
10
awarded  Popular Question
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