config.Parameter - U :: DataHandwerk Docs

Description

default parameter values are defined (hard coded) in configT.Parameter_default - V and available in config.Parameter.Parameter_default_value
default parameter values can be overwritten by project specific content using config.Parameter.Parameter_value
resulting content is available in

Examples

Entity Diagram

Columns

Table 1. Columns of config.Parameter - U
PK	Column Name	Data Type	NULL?
1	Parameter_name	`varchar(100)`	`NOT NULL`
2	sub_Parameter Default: DFParametersub_P__18B6AB08 `('')` sql	`nvarchar(128)`	`NOT NULL`
	Parameter_default_value	`nvarchar(max)`	`NULL`
	Parameter_desciption	`nvarchar(1000)`	`NULL`
	Parameter_value	`nvarchar(max)`	`NULL`
	Parameter_value_result Definition `(coalesce([Parameter_value],[Parameter_default_value]))` sql	`nvarchar(max)`	`NULL`
	Parameter_value_result_date Definition `(TRY_CAST(left(coalesce([Parameter_value],[Parameter_default_value]),(4000)) AS [date]))` sql	`date`	`NULL`
	Parameter_value_result_datetime Definition `(TRY_CAST(left(coalesce([Parameter_value],[Parameter_default_value]),(4000)) AS [datetime]))` sql	`datetime`	`NULL`
	Parameter_value_result_int Definition `(TRY_CAST(left(coalesce([Parameter_value],[Parameter_default_value]),(4000)) AS [int]))` sql	`int`	`NULL`

Foreign Key Diagram

References

Referenced Objects

configT.Parameter_default - V

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

PK_Parameter

IndexSemanticGroup: no_group
- [column-Parameter_name]; varchar(100)
- [column-sub_Parameter]; nvarchar(128)
PK, Unique, Real: 1, 1, 1

Column Details

_

Parameter_name

1

Parameter_name

varchar(100)

NOT NULL

sub_Parameter

2

sub_Parameter

Default: DFParametersub_P__18B6AB08

('')

sql

nvarchar(128)

NOT NULL

Parameter_default_value

nvarchar(max)

NULL

Referenced Columns

configT.Parameter_default.Parameter_default_value

Referencing Columns

config.Parameter.Parameter_value_result
config.Parameter.Parameter_value_result_int
config.Parameter.Parameter_value_result_date
config.Parameter.Parameter_value_result_datetime

Parameter_desciption

nvarchar(1000)

NULL

Parameter_value

nvarchar(max)

NULL

Referencing Columns

config.Parameter.Parameter_value_result
config.Parameter.Parameter_value_result_int
config.Parameter.Parameter_value_result_date
config.Parameter.Parameter_value_result_datetime

Parameter_value_result

Definition

(coalesce([Parameter_value],[Parameter_default_value]))

sql

nvarchar(max)

NULL

Description

(coalesce([Parameter_value],[Parameter_default_value]))

Referenced Columns

config.Parameter.Parameter_value
config.Parameter.Parameter_default_value

Referencing Columns

Parameter_value_result_date

Definition

(TRY_CAST(left(coalesce([Parameter_value],[Parameter_default_value]),(4000)) AS [date]))

sql

date

NULL

Description

(TRY_CAST(left(coalesce([Parameter_value],[Parameter_default_value]),(4000)) AS [date]))

Referenced Columns

config.Parameter.Parameter_default_value
config.Parameter.Parameter_value

Parameter_value_result_datetime

Definition

(TRY_CAST(left(coalesce([Parameter_value],[Parameter_default_value]),(4000)) AS [datetime]))

sql

datetime

NULL

Description

(TRY_CAST(left(coalesce([Parameter_value],[Parameter_default_value]),(4000)) AS [datetime]))

Referenced Columns

config.Parameter.Parameter_default_value
config.Parameter.Parameter_value

Parameter_value_result_int

Definition

(TRY_CAST(left(coalesce([Parameter_value],[Parameter_default_value]),(4000)) AS [int]))

sql

int

NULL

Description

(TRY_CAST(left(coalesce([Parameter_value],[Parameter_default_value]),(4000)) AS [int]))

Referenced Columns

config.Parameter.Parameter_value
config.Parameter.Parameter_default_value

Referencing Columns