logs.ExecutionLog - U

type: U ( user table ), modify_date: 2022-06-30 17:24:34

RepoObject_guid: 1C90291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

Columns

Table 1. Columns of logs.ExecutionLog - U
PK	Column Name	Data Type	NULL?	ID
1	id	`bigint`	`NOT NULL`	`(1,1)`
	created_dt	`datetime`	`NULL`
	current_execution_guid	`uniqueidentifier`	`NULL`
	deleted	`int`	`NULL`
	event_info	`nvarchar(max)`	`NULL`
	execution_instance_guid	`uniqueidentifier`	`NOT NULL`
	info_01	`nvarchar(4000)`	`NULL`
	info_02	`nvarchar(4000)`	`NULL`
	info_03	`nvarchar(4000)`	`NULL`
	info_04	`nvarchar(4000)`	`NULL`
	info_05	`nvarchar(4000)`	`NULL`
	info_06	`nvarchar(4000)`	`NULL`
	info_07	`nvarchar(4000)`	`NULL`
	info_08	`nvarchar(4000)`	`NULL`
	info_09	`nvarchar(4000)`	`NULL`
	inserted	`int`	`NULL`
	parameter_01	`nvarchar(4000)`	`NULL`
	parameter_02	`nvarchar(4000)`	`NULL`
	parameter_03	`nvarchar(4000)`	`NULL`
	parameter_04	`nvarchar(4000)`	`NULL`
	parameter_05	`nvarchar(4000)`	`NULL`
	parameter_06	`nvarchar(4000)`	`NULL`
	parameter_07	`nvarchar(4000)`	`NULL`
	parameter_08	`nvarchar(4000)`	`NULL`
	parameter_09	`nvarchar(4000)`	`NULL`
	parameter_10	`nvarchar(4000)`	`NULL`
	parameter_11	`nvarchar(4000)`	`NULL`
	parameter_12	`nvarchar(4000)`	`NULL`
	parameter_13	`nvarchar(4000)`	`NULL`
	parameter_14	`nvarchar(4000)`	`NULL`
	parameter_15	`nvarchar(4000)`	`NULL`
	parameter_16	`nvarchar(4000)`	`NULL`
	parameter_17	`nvarchar(4000)`	`NULL`
	parameter_18	`nvarchar(4000)`	`NULL`
	parameter_19	`nvarchar(4000)`	`NULL`
	parameter_20	`nvarchar(4000)`	`NULL`
	parent_execution_log_id	`bigint`	`NULL`
	proc_id	`int`	`NULL`
	proc_name	`nvarchar(128)`	`NULL`
	proc_schema_name	`nvarchar(128)`	`NULL`
	source_object	`nvarchar(261)`	`NULL`
	ssis_execution_id	`bigint`	`NULL`
	step_id	`int`	`NULL`
	step_name	`nvarchar(1000)`	`NULL`
	sub_execution_id	`int`	`NULL`
	target_object	`nvarchar(261)`	`NULL`
	updated	`int`	`NULL`

Foreign Key Diagram

References

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

PK_ExecutionLog

IndexSemanticGroup: no_group
- id; bigint
PK, Unique, Real: 1, 1, 1

Column Details

_

id

bigint

NOT NULL

(1,1)

Referencing Columns

created_dt

datetime

NULL

Referencing Columns

current_execution_guid

uniqueidentifier

NULL

Referencing Columns

deleted

int

NULL

Referencing Columns

logs.ExecutionLog_gross.deleted

event_info

nvarchar(max)

NULL

Referencing Columns

logs.ExecutionLog_gross.event_info

execution_instance_guid

uniqueidentifier

NOT NULL

Referencing Columns

info_01

nvarchar(4000)

NULL

Referencing Columns

logs.ExecutionLog_gross.info_01

info_02

nvarchar(4000)

NULL

Referencing Columns

logs.ExecutionLog_gross.info_02

info_03

nvarchar(4000)

NULL

Referencing Columns

logs.ExecutionLog_gross.info_03

info_04

nvarchar(4000)

NULL

Referencing Columns

logs.ExecutionLog_gross.info_04

info_05

nvarchar(4000)

NULL

Referencing Columns

logs.ExecutionLog_gross.info_05

info_06

nvarchar(4000)

NULL

Referencing Columns

logs.ExecutionLog_gross.info_06

info_07

nvarchar(4000)

NULL

Referencing Columns

logs.ExecutionLog_gross.info_07

info_08

nvarchar(4000)

NULL

Referencing Columns

logs.ExecutionLog_gross.info_08

info_09

nvarchar(4000)

NULL

Referencing Columns

logs.ExecutionLog_gross.info_09

inserted

int

NULL

Referencing Columns

logs.ExecutionLog_gross.inserted

parameter_01

nvarchar(4000)

NULL

Referencing Columns

parameter_02

nvarchar(4000)

NULL

Referencing Columns

parameter_03

nvarchar(4000)

NULL

Referencing Columns

parameter_04

nvarchar(4000)

NULL

Referencing Columns

parameter_05

nvarchar(4000)

NULL

Referencing Columns

parameter_06

nvarchar(4000)

NULL

Referencing Columns

parameter_07

nvarchar(4000)

NULL

Referencing Columns

parameter_08

nvarchar(4000)

NULL

Referencing Columns

parameter_09

nvarchar(4000)

NULL

Referencing Columns

parameter_10

nvarchar(4000)

NULL

Referencing Columns

parameter_11

nvarchar(4000)

NULL

Referencing Columns

parameter_12

nvarchar(4000)

NULL

Referencing Columns

parameter_13

nvarchar(4000)

NULL

Referencing Columns

parameter_14

nvarchar(4000)

NULL

Referencing Columns

parameter_15

nvarchar(4000)

NULL

Referencing Columns

parameter_16

nvarchar(4000)

NULL

Referencing Columns

parameter_17

nvarchar(4000)

NULL

Referencing Columns

parameter_18

nvarchar(4000)

NULL

Referencing Columns

parameter_19

nvarchar(4000)

NULL

Referencing Columns

parameter_20

nvarchar(4000)

NULL

Referencing Columns

parent_execution_log_id

bigint

NULL

Referencing Columns

proc_id

int

NULL

Referencing Columns

proc_name

nvarchar(128)

NULL

Referencing Columns

proc_schema_name

nvarchar(128)

NULL

Referencing Columns

source_object

nvarchar(261)

NULL

Referencing Columns

logs.ExecutionLog_gross.source_object

ssis_execution_id

bigint

NULL

Referencing Columns

logs.ExecutionLog_gross.ssis_execution_id

step_id

int

NULL

Referencing Columns

step_name

nvarchar(1000)

NULL

Referencing Columns

sub_execution_id

int

NULL

Referencing Columns

logs.ExecutionLog_gross.sub_execution_id

target_object

nvarchar(261)

NULL

Referencing Columns

logs.ExecutionLog_gross.target_object

updated

int

NULL

Referencing Columns

logs.ExecutionLog_gross.updated