config.Parameter - U

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

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

Description

Examples

Entity Diagram

entity-config.parameter

Columns

Table 1. Columns of config.Parameter - U
PK Column Name Data Type NULL? ID

1

varchar(100)

NOT NULL

2

Default: DFParametersub_P__18B6AB08
('')

nvarchar(128)

NOT NULL

nvarchar(max)

NULL

nvarchar(1000)

NULL

nvarchar(max)

NULL

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

nvarchar(max)

NULL

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

date

NULL

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

datetime

NULL

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

int

NULL

Foreign Key Diagram

entity_1_1_fk-config.parameter

Indexes

PK_Parameter

Column Details

_

Parameter_name

1

Parameter_name

varchar(100)

NOT NULL

sub_Parameter

2

sub_Parameter

Default: DFParametersub_P__18B6AB08
('')

nvarchar(128)

NOT NULL

Parameter_desciption

Parameter_desciption

nvarchar(1000)

NULL

Parameter_value_result_date

Parameter_value_result_date

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

date

NULL

Description

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


Parameter_value_result_datetime

Parameter_value_result_datetime

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

datetime

NULL

Description

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


Parameter_value_result_int

Parameter_value_result_int

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

int

NULL

Description

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