@startuml
left to right direction
'top to bottom direction
hide circle
'avoide "." issues:
set namespaceSeparator none


skinparam class {
  BackgroundColor White
  BackgroundColor<<FN>> Yellow
  BackgroundColor<<FS>> Yellow
  BackgroundColor<<FT>> LightGray
  BackgroundColor<<IF>> Yellow
  BackgroundColor<<IS>> Yellow
  BackgroundColor<<P>> Aqua
  BackgroundColor<<PC>> Aqua
  BackgroundColor<<SN>> Yellow
  BackgroundColor<<SO>> SlateBlue
  BackgroundColor<<TF>> LightGray
  BackgroundColor<<TR>> Tomato
  BackgroundColor<<U>> White
  BackgroundColor<<V>> WhiteSmoke
  BackgroundColor<<X>> Aqua
  BackgroundColor<<external>> AliceBlue
}


entity "puml-link:dhw:sqldb:workflow.proceduredependency.adoc[]" as workflow.ProcedureDependency << U >> {
  - **id** : (int)
  Description : (nvarchar(4000))
  - is_active : (bit)
  - is_PersistenceDependency : (bit)
  - referenced_Procedure_RepoObject_guid : (uniqueidentifier)
  referenced_RepoObject_guid : (uniqueidentifier)
  - referencing_Procedure_RepoObject_guid : (uniqueidentifier)
  referencing_RepoObject_guid : (uniqueidentifier)
  --
}

entity "puml-link:dhw:sqldb:workflow.usp_persist_workflow_proceduredependency_t.adoc[]" as workflow.usp_PERSIST_Workflow_ProcedureDependency_T << P >> {
  --
}

entity "puml-link:dhw:sqldb:workflow.workflow.adoc[]" as workflow.Workflow << U >> {
  - **id** : (int)
  Description : (nvarchar(4000))
  - is_active : (bit)
  - Name : (nvarchar(500))
  Package_Biml : (nvarchar(max))
  --
}

entity "puml-link:dhw:sqldb:workflow.workflow_proceduredependency.adoc[]" as workflow.Workflow_ProcedureDependency << V >> {
  - referenced_Procedure_RepoObject_guid : (uniqueidentifier)
  - referencing_Procedure_RepoObject_guid : (uniqueidentifier)
  - Workflow_id : (int)
  --
}

entity "puml-link:dhw:sqldb:workflow.workflow_proceduredependency_t.adoc[]" as workflow.Workflow_ProcedureDependency_T << U >> {
  - **Workflow_id** : (int)
  - **referenced_Procedure_RepoObject_guid** : (uniqueidentifier)
  - **referencing_Procedure_RepoObject_guid** : (uniqueidentifier)
  - is_redundant : (bit)
  --
}

entity "puml-link:dhw:sqldb:workflow.workflowstep_active.adoc[]" as workflow.WorkflowStep_active << V >> {
  - is_PossibleReferenced : (bit)
  - Procedure_RepoObject_guid : (uniqueidentifier)
  - Workflow_id : (int)
  - Workflow_Name : (nvarchar(500))
  --
}

workflow.ProcedureDependency <.. workflow.Workflow_ProcedureDependency
workflow.Workflow <.. workflow.Workflow_ProcedureDependency
workflow.Workflow_ProcedureDependency <.. workflow.Workflow_ProcedureDependency_T
workflow.Workflow_ProcedureDependency <.. workflow.usp_PERSIST_Workflow_ProcedureDependency_T
workflow.WorkflowStep_active <.. workflow.Workflow_ProcedureDependency
"workflow.ProcedureDependency::referenced_Procedure_RepoObject_guid" <-- "workflow.Workflow_ProcedureDependency::referenced_Procedure_RepoObject_guid"
"workflow.ProcedureDependency::referencing_Procedure_RepoObject_guid" <-- "workflow.Workflow_ProcedureDependency::referencing_Procedure_RepoObject_guid"
"workflow.Workflow::id" <-- "workflow.Workflow_ProcedureDependency::Workflow_id"
"workflow.Workflow_ProcedureDependency::referenced_Procedure_RepoObject_guid" <-- "workflow.Workflow_ProcedureDependency_T::referenced_Procedure_RepoObject_guid"
"workflow.Workflow_ProcedureDependency::referencing_Procedure_RepoObject_guid" <-- "workflow.Workflow_ProcedureDependency_T::referencing_Procedure_RepoObject_guid"
"workflow.Workflow_ProcedureDependency::Workflow_id" <-- "workflow.Workflow_ProcedureDependency_T::Workflow_id"footer The diagram is interactive and contains links.
@enduml

