repo.RepoSchema - U :: DataHandwerk Docs

Description

Examples

Entity Diagram

Columns

Table 1. Columns of repo.RepoSchema - U
PK	Column Name	Data Type	NULL?
1	RepoSchema_guid Default: DF_RepoSchema_RepoSchema_guid `(newsequentialid())` sql	`uniqueidentifier`	`NOT NULL`
	is_ssas Default: DF_RepoSchema_is_ssas `((0))` sql	`bit`	`NOT NULL`
	is_SysSchema_missing	`bit`	`NULL`
	MeasuresRepoObjekt_guid Default: DF_RepoSchema_RepoSchema_guid1 `(newsequentialid())` sql	`uniqueidentifier`	`NOT NULL`
	RepoSchema_description	`nvarchar(4000)`	`NULL`
	RepoSchema_name Default: DF_RepoSchema_RepoSchema_name `(newid())` sql	`nvarchar(128)`	`NOT NULL`
	SysSchema_id	`int`	`NULL`
	SysSchema_name Default: DF_RepoSchema_SysSchema_name `(newid())` sql	`nvarchar(128)`	`NOT NULL`
	has_different_sys_names Definition `(CONVERT([bit],case when [RepoSchema_name]<>[SysSchema_name] then (1) else (0) end))` sql	`bit`	`NULL`
	is_RepoSchema_name_uniqueidentifier Definition (PERSISTED) `(case when TRY_CAST([RepoSchema_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)` sql	`int`	`NOT NULL`
	is_SysSchema_name_uniqueidentifier Definition (PERSISTED) `(case when TRY_CAST([SysSchema_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)` sql	`int`	`NOT NULL`
	MeasuresRepoObjekt_name Definition (PERSISTED) `('_measures')` sql	`varchar(9)`	`NOT NULL`

Foreign Key Diagram

References

Referenced Objects

repo.RepoSchema_ssas_tgt - 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_RepoSchema

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

UK_RepoSchema

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

Column Details

_

RepoSchema_guid

1

RepoSchema_guid

Default: DF_RepoSchema_RepoSchema_guid

(newsequentialid())

sql

uniqueidentifier

NOT NULL

Referencing Columns

is_ssas

Default: DF_RepoSchema_is_ssas

((0))

sql

bit

NOT NULL

Referencing Columns

is_SysSchema_missing

bit

NULL

Referencing Columns

MeasuresRepoObjekt_guid

Default: DF_RepoSchema_RepoSchema_guid1

(newsequentialid())

sql

uniqueidentifier

NOT NULL

Referencing Columns

repo.Measure.MeasuresRepoObjekt_guid

RepoSchema_description

nvarchar(4000)

NULL

Referencing Columns

RepoSchema_name

Default: DF_RepoSchema_RepoSchema_name

(newid())

sql

nvarchar(128)

NOT NULL

Referencing Columns

SysSchema_id

int

NULL

Referencing Columns

SysSchema_name

Default: DF_RepoSchema_SysSchema_name

(newid())

sql

nvarchar(128)

NOT NULL

Referencing Columns

has_different_sys_names

Definition

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

sql

bit

NULL

Description

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

Referenced Columns

repo.RepoSchema.SysSchema_name
repo.RepoSchema.RepoSchema_name

Referencing Columns

repo.RepoSchema_ssas_tgt.has_different_sys_names

is_RepoSchema_name_uniqueidentifier

Definition (PERSISTED)

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

sql

int

NOT NULL

Description

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

Referenced Columns

repo.RepoSchema.RepoSchema_name

Referencing Columns

is_SysSchema_name_uniqueidentifier

Definition (PERSISTED)

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

sql

int

NOT NULL

Description

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

Referenced Columns

repo.RepoSchema.SysSchema_name

Referencing Columns

MeasuresRepoObjekt_name

Definition (PERSISTED)

('_measures')

sql

varchar(9)

NOT NULL

Referencing Columns

repo.Measure.MeasuresRepoObjekt_name