Construction of workflow project

Asked

Viewed 79 times

1

I’m building a system where I need to record drives and display them to certain users as well as the progress of the process. Follow an example:

Dep- Departamento.
Equipe- pertence ao departamento.
  1. Dep1 - registration request
  2. Dep2 - Performs request
    • Equipe1 - executes request(step1, step2, step3)

At another time another team receives another parercida request but performs more steps:

  1. Dep1 - registration request
  2. Dep2 - Performs request
    • Equipe2 - executes request(step1,Etapa2...Etapa5)

I have built demand, user, demand, and I was in doubt of stage and demand. I’m in doubt how to build this process.

1 answer

1


I believe you can apply the following modeling:

//Cadastro dos departamentos
departamento
  - id (pk)
  - nome
  ...

//Cadastro das demandas, com o id do departamento que solicitou e o id que será preenchido com o id do departamento que irá executar.
demanda (solicitação)
  - id (pk)
  - dep_id_solicita (fk)
  - dep_id_realiza (fk)
  - descricao
  ...

//Etapas da demanda, com o id da demanda e chave extranjeria para a pessoa da equipe que a executará
demanda_etapa
  - id (pk)
  - demanda_id (fk)
  - equipe_id (fk) (equipe_pessoa)
  - pessoa_id (fk) (equipe_pessoa
  - numero

//Cadastro das pessoas, que fazem parte das equipes
pessoa (usuário)
  - id (pk)
  - nome
  ...

//Cadastro da equipe
equipe
  - id (pk)
  - apelido
  ...

//Cadastro das pessoas que fazem parte da equipe.
equipe_pessoa
  - equipe_id (fk)
  - pessoa_id (fk)
  - primary key(equipe_id, pessoa_id)
  • I just didn’t quite understand the part

  • Dear Thalles, the "stage demand" is a structure where the steps to meet the demand will be stored. They can be predefined steps or it can be fed on-demand, it depends a lot on the business.

  • Thanks @Fábio had actually built but was not firm the thought on this path, and now with the clarification I will leave open and limiting stages by teams on the frontend. In the bank I can not limit pq in a similar demand can occur more or less steps. Thanks for the clarification helped me a lot.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.