repo.IndexColumn_union_T - U

type: U ( user table ), modify_date: 2022-06-30 17:40:44

RepoObject_guid: 00C6A3B8-1612-EC11-851A-A81E8446D5B0

InheritanceType: 13

Description

Examples

Entity Diagram

Columns

Table 1. Columns of repo.IndexColumn_union_T - U
PK	Column Name	Data Type	NULL?	ID
1	index_guid	`uniqueidentifier`	`NOT NULL`
2	index_column_id	`int`	`NOT NULL`
	ColumnsPerIndex	`int`	`NULL`
	index_name	`nvarchar(450)`	`NULL`
	is_descending_key	`bit`	`NULL`
	is_index_primary_key	`bit`	`NULL`
	is_index_real	`bit`	`NULL`
	is_index_unique	`bit`	`NULL`
	parent_RepoObject_guid	`uniqueidentifier`	`NULL`
	parent_schema_name	`nvarchar(128)`	`NULL`
	parent_SysObject_fullname	`nvarchar(261)`	`NULL`
	parent_SysObject_name	`nvarchar(128)`	`NULL`
	RepoObjectColumn_guid	`uniqueidentifier`	`NULL`
	SysObject_column_name	`nvarchar(128)`	`NULL`
	SysObject_column_user_type_fullname	`nvarchar(182)`	`NULL`

Persistence, History Table

persistence source: repo.IndexColumn_union - 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: 0
is_persistence_insert: 1
is_persistence_truncate: 1
is_persistence_update_changed: 0
has_history: 0
has_history_columns: 0

Foreign Key Diagram

References

Referenced Objects

repo.IndexColumn_union - 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_union_T

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

Column Details

_

index_guid

1

index_guid

uniqueidentifier

NOT NULL

Referenced Columns

repo.IndexColumn_union.index_guid

Referencing Columns

index_column_id

2

index_column_id

int

NOT NULL

Referenced Columns

repo.IndexColumn_union.index_column_id

Referencing Columns

ColumnsPerIndex

ColumnsPerIndex

int

NULL

Referenced Columns

repo.IndexColumn_union.ColumnsPerIndex

Referencing Columns

repo.IndexColumn_ReferencedReferencing_HasFullColumnsInReferencing.ColumnsPerIndex

index_name

index_name

nvarchar(450)

NULL

Referenced Columns

repo.IndexColumn_union.index_name

Referencing Columns

repo.RepoObjectColumn_gross2.index_name

is_descending_key

is_descending_key

bit

NULL

Referenced Columns

repo.IndexColumn_union.is_descending_key

Referencing Columns

repo.IndexColumn_ReferencedReferencing_HasFullColumnsInReferencing.is_descending_key

is_index_primary_key

is_index_primary_key

bit

NULL

Referenced Columns

repo.IndexColumn_union.is_index_primary_key

Referencing Columns

repo.RepoObjectColumn_gross2.is_index_primary_key

is_index_real

is_index_real

bit

NULL

Referenced Columns

repo.IndexColumn_union.is_index_real

is_index_unique

is_index_unique

bit

NULL

Referenced Columns

repo.IndexColumn_union.is_index_unique

parent_RepoObject_guid

parent_RepoObject_guid

uniqueidentifier

NULL

Referenced Columns

repo.IndexColumn_union.parent_RepoObject_guid

parent_schema_name

parent_schema_name

nvarchar(128)

NULL

Referenced Columns

repo.IndexColumn_union.parent_schema_name

parent_SysObject_fullname

parent_SysObject_fullname

nvarchar(261)

NULL

Referenced Columns

repo.IndexColumn_union.parent_SysObject_fullname

parent_SysObject_name

parent_SysObject_name

nvarchar(128)

NULL

Referenced Columns

repo.IndexColumn_union.parent_SysObject_name

RepoObjectColumn_guid

RepoObjectColumn_guid

uniqueidentifier

NULL

Referenced Columns

repo.IndexColumn_union.RepoObjectColumn_guid

SysObject_column_name

SysObject_column_name

nvarchar(128)

NULL

Referenced Columns

repo.IndexColumn_union.SysObject_column_name

SysObject_column_user_type_fullname

SysObject_column_user_type_fullname

nvarchar(182)

NULL

Referenced Columns

repo.IndexColumn_union.SysObject_column_user_type_fullname