workflow.WorkflowStep_ForUpdate - V
type: V ( view ), modify_date: 2021-08-17 20:31:40
RepoObject_guid: A0BCD983-91FA-EB11-850E-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_WorkflowStep_ForUpdate__2
-
IndexSemanticGroup: no_group
-
[column-Workflow_id]; int
-
[column-Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_WorkflowStep_ForUpdate__3
-
IndexSemanticGroup: no_group
-
[column-Workflow_id]; int
-
-
PK, Unique, Real: 0, 0, 0
idx_WorkflowStep_ForUpdate__4
-
IndexSemanticGroup: no_group
-
[column-Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
sql_modules_definition
workflow.WorkflowStep_ForUpdate - V script
CREATE View workflow.WorkflowStep_ForUpdate
As
Select
ws.id
, ws.Workflow_id
, ws.Procedure_RepoObject_guid
, ws.is_active
, ws.is_PossibleReferenced
, Workflow_Name = w.Name
, ro.RepoObject_fullname
From
workflow.WorkflowStep As ws
Inner Join
workflow.Workflow As w
On
ws.Workflow_id = w.id
Inner Join
repo.RepoObject As ro
On
ws.Procedure_RepoObject_guid = ro.RepoObject_guid