workflow.WorkflowStep_ForUpdate - V

type: V ( view ), modify_date: 2021-08-17 20:31:40

RepoObject_guid: A0BCD983-91FA-EB11-850E-A81E8446D5B0

Description

Examples

Entity Diagram

entity-workflow.workflowstep_forupdate

Columns

Table 1. Columns of workflow.WorkflowStep_ForUpdate - V
PK Column Name Data Type NULL? ID

id

int

NOT NULL

bit

NOT NULL

bit

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(261)

NOT NULL

int

NOT NULL

nvarchar(500)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-workflow.workflowstep_forupdate

References

Object Reference Diagram - 1 1

entity_1_1_objectref-workflow.workflowstep_forupdate

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-workflow.workflowstep_forupdate

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-workflow.workflowstep_forupdate

Column Reference Diagram

entity_1_1_colref-workflow.workflowstep_forupdate

Indexes

idx_WorkflowStep_ForUpdate__1

  • IndexSemanticGroup: no_group

  • PK, Unique, Real: 0, 0, 0

idx_WorkflowStep_ForUpdate__2

idx_WorkflowStep_ForUpdate__3

idx_WorkflowStep_ForUpdate__4

Column Details

_

id

id

int

NOT NULL

Referenced Columns

is_active

is_active

bit

NOT NULL

Referenced Columns

is_PossibleReferenced

is_PossibleReferenced

bit

NOT NULL

Procedure_RepoObject_guid

Procedure_RepoObject_guid

uniqueidentifier

NOT NULL

RepoObject_fullname

RepoObject_fullname

nvarchar(261)

NOT NULL

Description

(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))


Workflow_id

Workflow_id

int

NOT NULL

Workflow_Name

Workflow_Name

nvarchar(500)

NOT NULL

Referenced Columns

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