sqlparse.RepoObject_SqlModules_41_from_T - U

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

RepoObject_guid: 4E4CB4D0-4762-EB11-84DC-A81E8446D5B0

InheritanceType: 13

Description

Examples

Entity Diagram

entity-sqlparse.repoobject_sqlmodules_41_from_t

Columns

Table 1. Columns of sqlparse.RepoObject_SqlModules_41_from_T - U
PK Column Name Data Type NULL? ID

nvarchar(max)

NULL

nvarchar(500)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

int

NOT NULL

bit

NULL

int

NOT NULL

bit

NULL

bit

NULL

varchar(16)

NULL

nvarchar(4000)

NOT NULL

bigint

NULL

bigint

NULL

bigint

NULL

nvarchar(max)

NULL

bigint

NULL

nvarchar(max)

NULL

bigint

NULL

uniqueidentifier

NOT NULL

bigint

NULL

nvarchar(261)

NULL

Persistence, History Table

  • persistence source: sqlparse.RepoObject_SqlModules_41_from - 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

entity_1_1_fk-sqlparse.repoobject_sqlmodules_41_from_t

References

Object Reference Diagram - 1 1

entity_1_1_objectref-sqlparse.repoobject_sqlmodules_41_from_t

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-sqlparse.repoobject_sqlmodules_41_from_t

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-sqlparse.repoobject_sqlmodules_41_from_t

Column Reference Diagram

entity_1_1_colref-sqlparse.repoobject_sqlmodules_41_from_t

Indexes

idx_RepoObject_SqlModules_41_from_T__1

idx_RepoObject_SqlModules_41_from_T__2

idx_RepoObject_SqlModules_41_from_T__3

Column Details

_

children

children

nvarchar(max)

NULL

class

class

nvarchar(500)

NULL

identifier_alias

identifier_alias

nvarchar(max)

NULL

identifier_name

identifier_name

nvarchar(max)

NULL

is_from

is_from

int

NOT NULL

is_group

is_group

bit

NULL

is_join

is_join

int

NOT NULL

is_keyword

is_keyword

bit

NULL

is_whitespace

is_whitespace

bit

NULL

join_type

join_type

varchar(16)

NULL

json_key

json_key

nvarchar(4000)

NOT NULL

Min_RowNumber_From

Min_RowNumber_From

bigint

NULL

Min_RowNumber_GroupBy

Min_RowNumber_GroupBy

bigint

NULL

Min_RowNumber_Where

Min_RowNumber_Where

bigint

NULL

normalized

normalized

nvarchar(max)

NULL

normalized_PatIndex_Select

normalized_PatIndex_Select

bigint

NULL

normalized_wo_nolock

normalized_wo_nolock

nvarchar(max)

NULL

patindex_nolock

patindex_nolock

bigint

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

RowNumber_per_Object

RowNumber_per_Object

bigint

NULL

SysObject_fullname

SysObject_fullname

nvarchar(261)

NULL

Description

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