uspgenerator.GeneratorUspStep - U

type: U ( user table ), modify_date: 2022-06-30 17:32:52

RepoObject_guid: 5690291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-uspgenerator.generatoruspstep

Columns

Table 1. Columns of uspgenerator.GeneratorUspStep - U
PK Column Name Data Type NULL? ID

1

id

int

NOT NULL

(1,1)

nvarchar(4000)

NULL

Default: DF_GeneratorUspStep_has_logging
((1))

tinyint

NOT NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

Default: DF_GeneratorUspStep_is_condition
((0))

tinyint

NOT NULL

Default: DF_GeneratorUspStep_is_inactive
((0))

tinyint

NOT NULL

Default: DF_GeneratorUspStep_is_SubProcedure
((0))

tinyint

NOT NULL

char(1)

NULL

nvarchar(261)

NULL

nvarchar(261)

NULL

nvarchar(1000)

NULL

int

NOT NULL

int

NULL

nvarchar(max)

NULL

int

NOT NULL

Foreign Key Diagram

entity_1_1_fk-uspgenerator.generatoruspstep

References

Object Reference Diagram - 1 1

entity_1_1_objectref-uspgenerator.generatoruspstep

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-uspgenerator.generatoruspstep

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-uspgenerator.generatoruspstep

Column Reference Diagram

entity_1_1_colref-uspgenerator.generatoruspstep

Indexes

PK_GeneratorUspStep

  • IndexSemanticGroup: no_group

  • PK, Unique, Real: 1, 1, 1

UK_GeneratorUspStep_Number

idx_GeneratorUspStep__1

Column Details

_

id

1

id

int

NOT NULL

(1,1)

Description

Description

nvarchar(4000)

NULL

has_logging

has_logging

Default: DF_GeneratorUspStep_has_logging
((1))

tinyint

NOT NULL

info_01

info_01

nvarchar(max)

NULL

info_02

info_02

nvarchar(max)

NULL

info_03

info_03

nvarchar(max)

NULL

info_04

info_04

nvarchar(max)

NULL

info_05

info_05

nvarchar(max)

NULL

info_06

info_06

nvarchar(max)

NULL

info_07

info_07

nvarchar(max)

NULL

info_08

info_08

nvarchar(max)

NULL

info_09

info_09

nvarchar(max)

NULL

is_condition

is_condition

Default: DF_GeneratorUspStep_is_condition
((0))

tinyint

NOT NULL

is_inactive

is_inactive

Default: DF_GeneratorUspStep_is_inactive
((0))

tinyint

NOT NULL

is_SubProcedure

is_SubProcedure

Default: DF_GeneratorUspStep_is_SubProcedure
((0))

tinyint

NOT NULL

log_flag_InsertUpdateDelete

log_flag_InsertUpdateDelete

char(1)

NULL

log_source_object

log_source_object

nvarchar(261)

NULL

log_target_object

log_target_object

nvarchar(261)

NULL

Name

Name

nvarchar(1000)

NULL

Number

Number

int

NOT NULL

Parent_Number

Parent_Number

int

NULL

Statement

Statement

nvarchar(max)

NULL

usp_id

usp_id

int

NOT NULL