repo.RepoObjectColumn - U

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

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

Description

Examples

Entity Diagram

Columns

Table 1. Columns of repo.RepoObjectColumn - U
PK	Column Name	Data Type	NULL?
1	RepoObjectColumn_guid Default: DF_RepoObjectColumn_RepoObjectColumn_guid `(newsequentialid())` sql	`uniqueidentifier`	`NOT NULL`
	Inheritance_StringAggSeparatorSql	`nvarchar(4000)`	`NULL`
	InheritanceDefinition	`nvarchar(4000)`	`NULL`
	InheritanceType	`tinyint`	`NULL`
	is_persistence_Ignore	`bit`	`NULL`
	is_persistence_NoCompareButUpdate	`bit`	`NULL`
	is_persistence_NoCompareNoUpdate	`bit`	`NULL`
	is_persistence_NoInsert	`bit`	`NULL`
	is_query_plan_expression	`bit`	`NULL`
	is_required_ColumnMerge	`bit`	`NULL`
	is_SysObjectColumn_missing	`bit`	`NULL`
	persistence_source_RepoObjectColumn_guid	`uniqueidentifier`	`NULL`
	Referencing_Count	`int`	`NULL`
	Repo_default_definition	`nvarchar(max)`	`NULL`
	Repo_default_is_system_named	`bit`	`NULL`
	Repo_default_name	`nvarchar(128)`	`NULL`
	Repo_definition	`nvarchar(max)`	`NULL`
	Repo_generated_always_type Default: DF_RepoObjectColumn_Repo_generated_always_type `((0))` sql	`tinyint`	`NOT NULL`
	Repo_graph_type	`int`	`NULL`
	Repo_increment_value	`sql_variant`	`NULL`
	Repo_is_computed Default: DF_RepoObjectColumn_Repo_is_computed `((0))` sql	`bit`	`NOT NULL`
	Repo_is_identity Default: DF_RepoObjectColumn_Repo_is_identity `((0))` sql	`bit`	`NOT NULL`
	Repo_is_nullable	`bit`	`NULL`
	Repo_is_persisted	`bit`	`NULL`
	Repo_seed_value	`sql_variant`	`NULL`
	Repo_user_type_fullname	`nvarchar(128)`	`NULL`
	Repo_user_type_name	`nvarchar(128)`	`NULL`
	Repo_uses_database_collation	`bit`	`NULL`
	RepoObject_guid	`uniqueidentifier`	`NOT NULL`
	RepoObjectColumn_column_id	`int`	`NULL`
	RepoObjectColumn_name Default: DF_RepoObjectColumn_RepoObjectColumn_name `(newid())` sql	`nvarchar(128)`	`NOT NULL`
	SysObjectColumn_column_id	`int`	`NULL`
	SysObjectColumn_name Default: DF_RepoObjectColumn_SysObjectColumn_name `(newid())` sql	`nvarchar(128)`	`NOT NULL`
	Column_name Definition (PERSISTED) `(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then [RepoObjectColumn_name] else [SysObjectColumn_name] end)` sql	`nvarchar(128)`	`NOT NULL`
	has_different_sys_names Definition `(CONVERT([bit],case when [RepoObjectColumn_name]<>[SysObjectColumn_name] then (1) else (0) end,(0)))` sql	`bit`	`NULL`
	is_RepoObjectColumn_name_uniqueidentifier Definition (PERSISTED) `(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)` sql	`int`	`NOT NULL`
	is_SysObjectColumn_name_uniqueidentifier Definition (PERSISTED) `(case when TRY_CAST([SysObjectColumn_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)` sql	`int`	`NOT NULL`

Foreign Key Diagram

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

PK_RepoObjectColumn

IndexSemanticGroup: no_group
- [column-RepoObjectColumn_guid]; uniqueidentifier
PK, Unique, Real: 1, 1, 1

UK_RepoObjectColumn__RepoNames

IndexSemanticGroup: no_group
- [column-RepoObject_guid]; uniqueidentifier
- [column-RepoObjectColumn_name]; nvarchar(128)
PK, Unique, Real: 0, 1, 1

UK_RepoObjectColumn__SysNames

IndexSemanticGroup: no_group
- [column-RepoObjectColumn_guid]; uniqueidentifier
- [column-SysObjectColumn_name]; nvarchar(128)
PK, Unique, Real: 0, 1, 1

idx_RepoObjectColumn__1

IndexSemanticGroup: no_group
- [column-RepoObject_guid]; uniqueidentifier
PK, Unique, Real: 0, 0, 0
FK_RepoObjectColumn_RepoObject
referenced: repo.RepoObject - U, PK_RepoObject
is disabled

Column Details

_

RepoObjectColumn_guid

RepoObjectColumn_guid

Default: DF_RepoObjectColumn_RepoObjectColumn_guid

(newsequentialid())

sql

uniqueidentifier

NOT NULL

Referencing Columns

Inheritance_StringAggSeparatorSql

nvarchar(4000)

NULL

Referencing Columns

InheritanceDefinition

nvarchar(4000)

NULL

Referencing Columns

InheritanceType

tinyint

NULL

Referencing Columns

is_persistence_Ignore

bit

NULL

Referencing Columns

is_persistence_NoCompareButUpdate

bit

NULL

Referencing Columns

is_persistence_NoCompareNoUpdate

bit

NULL

Referencing Columns

is_persistence_NoInsert

bit

NULL

Referencing Columns

is_query_plan_expression

bit

NULL

Referencing Columns

is_required_ColumnMerge

bit

NULL

Referencing Columns

is_SysObjectColumn_missing

bit

NULL

Referencing Columns

persistence_source_RepoObjectColumn_guid

uniqueidentifier

NULL

Referencing Columns

Referencing_Count

int

NULL

Referencing Columns

Repo_default_definition

nvarchar(max)

NULL

Referencing Columns

Repo_default_is_system_named

bit

NULL

Referencing Columns

Repo_default_name

nvarchar(128)

NULL

Referencing Columns

Repo_definition

nvarchar(max)

NULL

Referencing Columns

Repo_generated_always_type

Default: DF_RepoObjectColumn_Repo_generated_always_type

((0))

sql

tinyint

NOT NULL

Referencing Columns

Repo_graph_type

int

NULL

Referencing Columns

Repo_increment_value

sql_variant

NULL

Referencing Columns

Repo_is_computed

Default: DF_RepoObjectColumn_Repo_is_computed

((0))

sql

bit

NOT NULL

Referencing Columns

Repo_is_identity

Default: DF_RepoObjectColumn_Repo_is_identity

((0))

sql

bit

NOT NULL

Referencing Columns

Repo_is_nullable

bit

NULL

Referencing Columns

Repo_is_persisted

bit

NULL

Referencing Columns

Repo_seed_value

sql_variant

NULL

Referencing Columns

Repo_user_type_fullname

nvarchar(128)

NULL

Referencing Columns

Repo_user_type_name

nvarchar(128)

NULL

Referencing Columns

Repo_uses_database_collation

bit

NULL

Referencing Columns

RepoObject_guid

uniqueidentifier

NOT NULL

Referencing Columns

RepoObjectColumn_column_id

int

NULL

Referencing Columns

RepoObjectColumn_name

Default: DF_RepoObjectColumn_RepoObjectColumn_name

(newid())

sql

nvarchar(128)

NOT NULL

Referencing Columns

SysObjectColumn_column_id

int

NULL

Referencing Columns

SysObjectColumn_name

Default: DF_RepoObjectColumn_SysObjectColumn_name

(newid())

sql

nvarchar(128)

NOT NULL

Referencing Columns

Column_name

Definition (PERSISTED)

(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then [RepoObjectColumn_name] else [SysObjectColumn_name] end)

sql

nvarchar(128)

NOT NULL

Description

(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then [RepoObjectColumn_name] else [SysObjectColumn_name] end)

Referenced Columns

repo.RepoObjectColumn.RepoObjectColumn_name
repo.RepoObjectColumn.SysObjectColumn_name

Referencing Columns

repo.RepoObjectColumn_gross.Column_name

has_different_sys_names

Definition

(CONVERT([bit],case when [RepoObjectColumn_name]<>[SysObjectColumn_name] then (1) else (0) end,(0)))

sql

bit

NULL

Description

(CONVERT([bit],case when [RepoObjectColumn_name]<>[SysObjectColumn_name] then (1) else (0) end))

Referenced Columns

repo.RepoObjectColumn.SysObjectColumn_name
repo.RepoObjectColumn.RepoObjectColumn_name

Referencing Columns

is_RepoObjectColumn_name_uniqueidentifier

Definition (PERSISTED)

(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)

sql

int

NOT NULL

Description

(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)

Referenced Columns

repo.RepoObjectColumn.RepoObjectColumn_name

Referencing Columns

is_SysObjectColumn_name_uniqueidentifier

Definition (PERSISTED)

(case when TRY_CAST([SysObjectColumn_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)

sql

int

NOT NULL

Description

(case when TRY_CAST([SysObjectColumn_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)

Referenced Columns

repo.RepoObjectColumn.SysObjectColumn_name

Referencing Columns