repo.RepoObject - U

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

RepoObject_guid: EB8F291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.repoobject

Columns

Table 1. Columns of repo.RepoObject - U
PK Column Name Data Type NULL? ID

1

Default: DF_RepoObject_RepoObject_guid
(newsequentialid())

uniqueidentifier

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

bit

NULL

bit

NULL

tinyint

NULL

nvarchar(261)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

tinyint

NULL

Default: DF_RepoObject_is_ExcludeFromDocs
((0))

bit

NOT NULL

Default: DF_RepoObject_is_external
((0))

bit

NOT NULL

bit

NULL

bit

NULL

Default: DF_RepoObject_is_ssas
((0))

bit

NOT NULL

bit

NULL

Default: DF_RepoObject_modify_dt
(getdate())

datetime

NOT NULL

uniqueidentifier

NULL

nvarchar(4000)

NULL

uniqueidentifier

NULL

tinyint

NULL

Default: DF_RepoObject_RepoObject_name
(newid())

nvarchar(128)

NOT NULL

int

NULL

nvarchar(128)

NOT NULL

char(2)

NOT NULL

int

NULL

datetime

NULL

Default: DF_RepoObject_SysObject_name
(newid())

nvarchar(128)

NOT NULL

Default: DF_RepoObject_SysObject_parent_object_id
((0))

int

NOT NULL

nvarchar(128)

NOT NULL

char(2)

NULL

Definition
(CONVERT([bit],case when [RepoObject_schema_name]<>[SysObject_schema_name] OR [RepoObject_name]<>[SysObject_name] then (1) else (0) end))

bit

NULL

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

int

NOT NULL

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

int

NOT NULL

Definition
(CONVERT([bigint],[SysObject_id])*(10000))

bigint

NULL

Definition (PERSISTED)
(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))

nvarchar(261)

NOT NULL

Definition (PERSISTED)
(concat([RepoObject_schema_name],'.',[RepoObject_name]))

nvarchar(257)

NOT NULL

Definition (PERSISTED)
(concat('[',[SysObject_schema_name],'].[',[SysObject_name],']'))

nvarchar(261)

NOT NULL

Definition (PERSISTED)
(concat([SysObject_schema_name],'.',[SysObject_name]))

nvarchar(257)

NOT NULL

Definition
(concat('SELECT * FROM [',[config].[fs_dwh_database_name](),'].[',[SysObject_schema_name],'].[',[SysObject_name],']'))

nvarchar(406)

NOT NULL

Definition
(concat('[',[RepoObject_schema_name],'].[','usp_PERSIST_',[RepoObject_name],']'))

nvarchar(273)

NOT NULL

Definition (PERSISTED)
(concat([RepoObject_schema_name],'.','usp_PERSIST_',[RepoObject_name]))

nvarchar(269)

NOT NULL

Definition (PERSISTED)
('usp_PERSIST_'+[RepoObject_name])

nvarchar(140)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-repo.repoobject

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.repoobject

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.repoobject

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.repoobject

Column Reference Diagram

entity_1_1_colref-repo.repoobject

Indexes

PK_RepoObject

UK_RepoObject__RepoNames

UK_RepoObject__SysNames

idx_RepoObject__1

Column Details

_

RepoObject_guid

1

RepoObject_guid

Default: DF_RepoObject_RepoObject_guid
(newsequentialid())

uniqueidentifier

NOT NULL

Referencing Columns

indent_sql_modules_definition

indent_sql_modules_definition

tinyint

NULL

Inheritance_Source_fullname

Inheritance_Source_fullname

nvarchar(261)

NULL

is_DocsExclude

is_DocsExclude

Default: DF_RepoObject_is_ExcludeFromDocs
((0))

bit

NOT NULL

RepoObject_schema_name

RepoObject_schema_name

nvarchar(128)

NOT NULL

SysObject_name

SysObject_name

Default: DF_RepoObject_SysObject_name
(newid())

nvarchar(128)

NOT NULL

Referencing Columns

SysObject_schema_name

SysObject_schema_name

nvarchar(128)

NOT NULL

Referencing Columns

has_different_sys_names

has_different_sys_names

Definition
(CONVERT([bit],case when [RepoObject_schema_name]<>[SysObject_schema_name] OR [RepoObject_name]<>[SysObject_name] then (1) else (0) end))

bit

NULL

Description

(CONVERT([bit],case when [RepoObject_schema_name]<>[SysObject_schema_name] OR [RepoObject_name]<>[SysObject_name] OR [RepoObject_type]<>[SysObject_type] then (1) else (0) end))


is_RepoObject_name_uniqueidentifier

is_RepoObject_name_uniqueidentifier

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

int

NOT NULL

Description

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


Referenced Columns

is_SysObject_name_uniqueidentifier

is_SysObject_name_uniqueidentifier

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

int

NOT NULL

Description

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


Referenced Columns

RepoObject_fullname

RepoObject_fullname

Definition (PERSISTED)
(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))

nvarchar(261)

NOT NULL

Description

(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))


Referencing Columns

SysObject_fullname

SysObject_fullname

Definition (PERSISTED)
(concat('[',[SysObject_schema_name],'].[',[SysObject_name],']'))

nvarchar(261)

NOT NULL

Description

(concat('[',[SysObject_schema_name],'].[',[SysObject_name],']'))


SysObject_query_sql

SysObject_query_sql

Definition
(concat('SELECT * FROM [',[config].[fs_dwh_database_name](),'].[',[SysObject_schema_name],'].[',[SysObject_name],']'))

nvarchar(406)

NOT NULL

Description

(concat('SELECT * FROM [',[config].[fs_dwh_database_name](),'].[',[SysObject_schema_name],'].[',[SysObject_name],']'))


usp_persistence_fullname

usp_persistence_fullname

Definition
(concat('[',[RepoObject_schema_name],'].[','usp_PERSIST_',[RepoObject_name],']'))

nvarchar(273)

NOT NULL

Description

(concat('[',[RepoObject_schema_name],'].[','usp_PERSIST_',[RepoObject_name],']'))


usp_persistence_fullname2

usp_persistence_fullname2

Definition (PERSISTED)
(concat([RepoObject_schema_name],'.','usp_PERSIST_',[RepoObject_name]))

nvarchar(269)

NOT NULL

Description

(concat([RepoObject_schema_name],'.','usp_PERSIST_',[RepoObject_name]))


usp_persistence_name

usp_persistence_name

Definition (PERSISTED)
('usp_PERSIST_'+[RepoObject_name])

nvarchar(140)

NOT NULL

Description

('usp_PERSIST_'+[RepoObject_name])


Referenced Columns