uspgenerator.GeneratorUspParameter - U

type: U ( user table ), modify_date: 2022-09-05 18:18:09

RepoObject_guid: 4E90291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-uspgenerator.generatoruspparameter

Columns

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

1

id

int

NOT NULL

(1,1)

nvarchar(max)

NULL

nvarchar(4000)

NULL

Default: DF_GeneratorUspParameter_has_DefaultValue
((0))

tinyint

NOT NULL

Default: DF_GeneratorUspParameter_is_inactive
((0))

tinyint

NOT NULL

Default: DF_GeneratorUspParameter_is_out
((0))

tinyint

NOT NULL

nvarchar(128)

NOT NULL

int

NOT NULL

nvarchar(128)

NOT NULL

int

NOT NULL

Foreign Key Diagram

entity_1_1_fk-uspgenerator.generatoruspparameter

References

Object Reference Diagram - 1 1

entity_1_1_objectref-uspgenerator.generatoruspparameter

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-uspgenerator.generatoruspparameter

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-uspgenerator.generatoruspparameter

Column Reference Diagram

entity_1_1_colref-uspgenerator.generatoruspparameter

Indexes

PK_GeneratorUspParameter

  • IndexSemanticGroup: no_group

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

UK_GeneratorUspParameter_name

UK_GeneratorUspParameter_Number

idx_GeneratorUspParameter__1

Column Details

_

id

1

id

int

NOT NULL

(1,1)

DefaultValue

DefaultValue

nvarchar(max)

NULL

Description

Description

nvarchar(4000)

NULL

has_DefaultValue

has_DefaultValue

Default: DF_GeneratorUspParameter_has_DefaultValue
((0))

tinyint

NOT NULL

is_inactive

is_inactive

Default: DF_GeneratorUspParameter_is_inactive
((0))

tinyint

NOT NULL

is_out

is_out

Default: DF_GeneratorUspParameter_is_out
((0))

tinyint

NOT NULL

Name

Name

nvarchar(128)

NOT NULL

Number

Number

int

NOT NULL

UserTypeFullname

UserTypeFullname

nvarchar(128)

NOT NULL

usp_id

usp_id

int

NOT NULL