logs.ExecutionLog_parent - V

type: V ( view ), modify_date: 2022-06-30 18:23:13

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

Description

Examples

Entity Diagram

entity-logs.executionlog_parent

Columns

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

id

bigint

NOT NULL

datetime

NULL

uniqueidentifier

NULL

bigint

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(517)

NOT NULL

int

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

int

NULL

nvarchar(1000)

NULL

Foreign Key Diagram

entity_1_1_fk-logs.executionlog_parent

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-logs.executionlog_parent

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-logs.executionlog_parent

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-logs.executionlog_parent

Column Reference Diagram

entity_1_1_colref-logs.executionlog_parent

Indexes

idx_ExecutionLog_parent__1

  • IndexSemanticGroup: no_group

    • id; bigint

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

Column Details

_

id

id

bigint

NOT NULL

Referenced Columns

parent_created_dt

parent_created_dt

datetime

NULL

Referenced Columns

parent_current_execution_guid

parent_current_execution_guid

uniqueidentifier

NULL

parent_execution_log_id

parent_execution_log_id

bigint

NULL

parent_parameter_01

parent_parameter_01

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_02

parent_parameter_02

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_03

parent_parameter_03

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_04

parent_parameter_04

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_05

parent_parameter_05

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_06

parent_parameter_06

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_07

parent_parameter_07

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_08

parent_parameter_08

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_09

parent_parameter_09

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_10

parent_parameter_10

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_11

parent_parameter_11

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_12

parent_parameter_12

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_13

parent_parameter_13

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_14

parent_parameter_14

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_15

parent_parameter_15

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_16

parent_parameter_16

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_17

parent_parameter_17

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_18

parent_parameter_18

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_19

parent_parameter_19

nvarchar(4000)

NULL

Referenced Columns

parent_parameter_20

parent_parameter_20

nvarchar(4000)

NULL

Referenced Columns

parent_proc_fullname

parent_proc_fullname

nvarchar(517)

NOT NULL

Description

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


parent_proc_id

parent_proc_id

int

NULL

Referenced Columns

parent_proc_name

parent_proc_name

nvarchar(128)

NULL

Referenced Columns

parent_proc_schema_name

parent_proc_schema_name

nvarchar(128)

NULL

parent_step_id

parent_step_id

int

NULL

Referenced Columns

parent_step_name

parent_step_name

nvarchar(1000)

NULL

Referenced Columns

sql_modules_definition

logs.ExecutionLog_parent - V script
CREATE View [logs].[ExecutionLog_parent]
As
Select
    T1.id
  , T1.parent_execution_log_id
  , parent_current_execution_guid = parent.current_execution_guid
  , parent_proc_id                = parent.proc_id
  , parent_proc_schema_name       = parent.proc_schema_name
  , parent_proc_name              = parent.proc_name
  , parent_step_id                = parent.step_id
  , parent_step_name              = parent.step_name
  , parent_created_dt             = parent.created_dt
  , parent_parameter_01           = parent.parameter_01
  , parent_parameter_02           = parent.parameter_02
  , parent_parameter_03           = parent.parameter_03
  , parent_parameter_04           = parent.parameter_04
  , parent_parameter_05           = parent.parameter_05
  , parent_parameter_06           = parent.parameter_06
  , parent_parameter_07           = parent.parameter_07
  , parent_parameter_08           = parent.parameter_08
  , parent_parameter_09           = parent.parameter_09
  , parent_parameter_10           = parent.parameter_10
  , parent_parameter_11           = parent.parameter_11
  , parent_parameter_12           = parent.parameter_12
  , parent_parameter_13           = parent.parameter_13
  , parent_parameter_14           = parent.parameter_14
  , parent_parameter_15           = parent.parameter_15
  , parent_parameter_16           = parent.parameter_16
  , parent_parameter_17           = parent.parameter_17
  , parent_parameter_18           = parent.parameter_18
  , parent_parameter_19           = parent.parameter_19
  , parent_parameter_20           = parent.parameter_20
  , parent_proc_fullname          = Concat(QuoteName(parent.[proc_schema_name]),'.',QuoteName(parent.[proc_name])) --proc_fullname
From
    logs.ExecutionLog     As T1
    Left Join
        logs.ExecutionLog As parent
            On
            parent.id = T1.parent_execution_log_id
Where
    Not parent.id Is Null