logs.ExecutionLog_puml_Sequence_start_stop - V

type: V ( view ), modify_date: 2022-06-30 19:08:33

RepoObject_guid: BF90291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-logs.executionlog_puml_sequence_start_stop

Columns

Table 1. Columns of logs.ExecutionLog_puml_Sequence_start_stop - V
PK Column Name Data Type NULL? ID

datetime

NULL

uniqueidentifier

NOT NULL

id

bigint

NOT NULL

nvarchar(517)

NULL

nvarchar(517)

NOT NULL

nvarchar(1574)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-logs.executionlog_puml_sequence_start_stop

References

Object Reference Diagram - 1 1

entity_1_1_objectref-logs.executionlog_puml_sequence_start_stop

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-logs.executionlog_puml_sequence_start_stop

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-logs.executionlog_puml_sequence_start_stop

Column Reference Diagram

entity_1_1_colref-logs.executionlog_puml_sequence_start_stop

Indexes

idx_ExecutionLog_puml_Sequence_start_stop__1

  • IndexSemanticGroup: no_group

    • id; bigint

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

Column Details

_

created_dt

created_dt

datetime

NULL

Referenced Columns

execution_instance_guid

execution_instance_guid

uniqueidentifier

NOT NULL

id

id

bigint

NOT NULL

Referenced Columns

parent_proc_fullname

parent_proc_fullname

nvarchar(517)

NULL

Description

(concat(quotename([proc_schema_name]),'.',quotename([proc_name])))


proc_fullname

proc_fullname

nvarchar(517)

NOT NULL

Description

(concat(quotename([proc_schema_name]),'.',quotename([proc_name])))


puml_Sequence_start_stop

puml_Sequence_start_stop

nvarchar(1574)

NOT NULL

sql_modules_definition

logs.ExecutionLog_puml_Sequence_start_stop - V script
CREATE View [logs].[ExecutionLog_puml_Sequence_start_stop]
As
Select
    T1.id
  , T1.execution_instance_guid
  , puml_Sequence_start_stop =
  --
  Concat (   Case
                 When parent.parent_proc_fullname <> ''
                     Then
                     Concat ( '"', parent.parent_proc_fullname, '"' )
             --ELSE CONCAT('"' , [T1].[execution_instance_guid] , '"')
             End
           , Case T1.step_name
                 When 'start'
                     Then
                     ' -> '
                 When 'end'
                     Then
                     ' <- '
             End
           , '"'
           , concat(quotename(T1.[proc_schema_name]),'.',quotename(T1.[proc_name])) -- T1.proc_fullname
           , '"'
           , Char ( 13 ) + Char ( 10 )
           , Case T1.step_name
                 When 'start'
                     Then
                     'activate '
                 When 'end'
                     Then
                     'deactivate '
             End
           , '"'
           , concat(quotename(T1.[proc_schema_name]),'.',quotename(T1.[proc_name])) -- T1.proc_fullname
           , '"'
         )
  , proc_fullname = Concat(quotename(T1.[proc_schema_name]),'.',quotename(T1.[proc_name])) -- T1.proc_fullname
  , parent.parent_proc_fullname
  , T1.created_dt
From
    logs.ExecutionLog            As T1
    Left Join
        logs.ExecutionLog_parent As parent
            On
            parent.id = T1.id
Where
    T1.step_name In
    ( 'start', 'end' )