property.RepoSchemaProperty - U

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

RepoObject_guid: B20747EC-8CA3-EB11-84FA-A81E8446D5B0

Description

Examples

Entity Diagram

entity-property.reposchemaproperty

Columns

Table 1. Columns of property.RepoSchemaProperty - U
PK Column Name Data Type NULL? ID

1

uniqueidentifier

NOT NULL

2

nvarchar(128)

NOT NULL

tinyint

NULL

nvarchar(max)

NULL

int

NOT NULL

(1,1)

Definition
(TRY_CAST(left([property_value],(4000)) AS [bigint]))

bigint

NULL

Definition
(TRY_CAST(left([property_value],(4000)) AS [float]))

float

NULL

Definition
(TRY_CAST(left([property_value],(4000)) AS [int]))

int

NULL

Definition
(TRY_CAST(left([property_value],(4000)) AS [money]))

money

NULL

Definition
(TRY_CAST(left([property_value],(4000)) AS [real]))

real

NULL

Foreign Key Diagram

entity_1_1_fk-property.reposchemaproperty

References

Object Reference Diagram - 1 1

entity_1_1_objectref-property.reposchemaproperty

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.reposchemaproperty

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.reposchemaproperty

Column Reference Diagram

entity_1_1_colref-property.reposchemaproperty

Indexes

PK_RepoSchemaProperty

UK_RepoSchemaProperty

idx_RepoSchemaProperty__1

Column Details

_

RepoSchema_guid

1

RepoSchema_guid

uniqueidentifier

NOT NULL

property_name

2

property_name

nvarchar(128)

NOT NULL

inheritance

inheritance

tinyint

NULL

RepoSchemaProperty_id

RepoSchemaProperty_id

int

NOT NULL

(1,1)

property_bigint

property_bigint

Definition
(TRY_CAST(left([property_value],(4000)) AS [bigint]))

bigint

NULL

Description

(TRY_CAST(left([property_value],(4000)) AS [bigint]))


property_float

property_float

Definition
(TRY_CAST(left([property_value],(4000)) AS [float]))

float

NULL

Description

(TRY_CAST(left([property_value],(4000)) AS [float]))


property_int

property_int

Definition
(TRY_CAST(left([property_value],(4000)) AS [int]))

int

NULL

Description

(TRY_CAST(left([property_value],(4000)) AS [int]))


property_money

property_money

Definition
(TRY_CAST(left([property_value],(4000)) AS [money]))

money

NULL

Description

(TRY_CAST(left([property_value],(4000)) AS [money]))


property_real

property_real

Definition
(TRY_CAST(left([property_value],(4000)) AS [real]))

real

NULL

Description

(TRY_CAST(left([property_value],(4000)) AS [real]))