repo.IndexColumn_ssas_T - U

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

RepoObject_guid: F541F8C3-0F08-EC11-8515-A81E8446D5B0

InheritanceType: 13

Description

Examples

Entity Diagram

Columns

Table 1. Columns of repo.IndexColumn_ssas_T - U
PK	Column Name	Data Type	NULL?	ID
1	index_guid	`uniqueidentifier`	`NOT NULL`
2	index_column_id	`int`	`NOT NULL`
	ColumnName	`nvarchar(max)`	`NOT NULL`
	databasename	`nvarchar(128)`	`NOT NULL`
	RepoObjectColumn_guid	`uniqueidentifier`	`NOT NULL`
	TableName	`nvarchar(max)`	`NOT NULL`
	is_descending_key Definition `(CONVERT([bit],(0)))`	`bit`	`NULL`

Persistence, History Table

persistence source: repo.IndexColumn_ssas - V
is_persistence: 1
is_persistence_check_duplicate_per_pk: 0
is_persistence_check_for_empty_source: 0
is_persistence_delete_changed: 0
is_persistence_delete_missing: 1
is_persistence_insert: 1
is_persistence_truncate: 0
is_persistence_update_changed: 1
has_history: 0
has_history_columns: 0

Foreign Key Diagram

References

Referenced Objects

repo.IndexColumn_ssas - 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_IndexColumn_ssas_T

IndexSemanticGroup: no_group
- [column-index_guid]; uniqueidentifier
- [column-index_column_id]; int
PK, Unique, Real: 1, 1, 1

idx_IndexColumn_ssas_T__1

IndexSemanticGroup: no_group
- [column-index_guid]; uniqueidentifier
PK, Unique, Real: 0, 0, 0
FK_IndexColumn_ssas_T_Index_ssas_T
referenced: repo.Index_ssas_T - U, uq_Index_ssas_T

idx_IndexColumn_ssas_T__2

IndexSemanticGroup: no_group
- databasename; nvarchar(128)
PK, Unique, Real: 0, 0, 0

Column Details

_

index_guid

1

index_guid

uniqueidentifier

NOT NULL

Referenced Columns

repo.IndexColumn_ssas.index_guid

Referencing Columns

repo.IndexColumn_ssas_gross.index_guid

index_column_id

2

index_column_id

int

NOT NULL

Referenced Columns

repo.IndexColumn_ssas.index_column_id

Referencing Columns

repo.IndexColumn_ssas_gross.index_column_id

ColumnName

ColumnName

nvarchar(max)

NOT NULL

Referenced Columns

repo.IndexColumn_ssas.ColumnName

databasename

databasename

nvarchar(128)

NOT NULL

Referenced Columns

repo.IndexColumn_ssas.databasename

RepoObjectColumn_guid

RepoObjectColumn_guid

uniqueidentifier

NOT NULL

Referenced Columns

repo.IndexColumn_ssas.RepoObjectColumn_guid

Referencing Columns

repo.IndexColumn_ssas_gross.RepoObjectColumn_guid

TableName

TableName

nvarchar(max)

NOT NULL

Referenced Columns

repo.IndexColumn_ssas.TableName

is_descending_key

is_descending_key

Definition

(CONVERT([bit],(0)))

bit

NULL

Referencing Columns

repo.IndexColumn_ssas_gross.is_descending_key