Data Dictionary Data Model

DATA_FORMAT

string(60)

Data Format

☐

Data format.

DATABASE_DATA_TYPE

string

Database Data Type

Data type in the database.

DEFAULT_VALUE

string

Default Value

☐

Default value.

DOCUMENTATION

string

Documentation

Documentation.

DOTNET_DATA_TYPE

string

.NET Data Type

Data type for .NET.

ID

int32

ID

Unique ID of the column.

NAME

string

Name

Name of the column.

PRESENCE_REQUIRED

boolean

Presence Required

Whether the presence of a value is required.

PROVIDER_DATA_CONTAINER_ALIAS

string(4000)

Data Container Alias

☐

Data container alias.

PROVIDER_DATA_CONTAINER_ID

string(4000)

Data Container ID

☐

Data container ID.

PROVIDER_DESCRIPTION

string(16000)

Provider Description

☑

Provider description.

PROVIDER_NAME

string(240)

Provider Name

☑

Name of the provider.

PROVIDER_SHORT_NAME

string(240)

Provider Short Name

☑

Provider short name.

SORTING_ORDER

int32

Sort Order

Sorting order of the parameter within the table function.

TABLE_CATALOG_NAME

string

Table Catalog

Catalog where the tables are contained in.

TABLE_FULL_QUALIFIED_NAME

string(240)

Table Full Qualified Name

Full qualified name.

TABLE_NAME

string

Table Name

Name of the table or view.

TABLE_SCHEMA_NAME

string

Table Schema

Schema within the catalog where the table is contained in.

TABLE_TYPE

string

Table Type

Type, can be either 'view' or 'table'.