ModelingTable

Table definition in a model, contains table schema, name, columns, etc.

API Section: Objects

Type: Object

Properties

Name

Description

Required

Type

Format

tableId

The table's system ID

-

string

uuid

displayName

The table's display name

-

string

description

The tables's description

-

string

modelingColumns

Definition of a table column in the model.

-

ModelingColumn []

modelingMeasures

Definition of a measure in the model definition, contains column unique identifies, aggregation, etc.

-

ModelingMeasure []

modelingHierarchies

Hierarchy definition in the model. A hierarchy is defined by a list of levels, each defined by a column

-

ModelingHierarchy []

uniqueName

Unique identifier of this table

-

string

schemaName

Schema name in the source database

-

string

sourceTableName

Tables name in the source database

-

string

isVisible

Visible in the relationship diagram

-

boolean

primaryKeyColumnUniqueName

Unique identifier of the primary key column of this table

-

string

measureGroups

List of measure group ids

-

array

customQuery

If this tables is based on a query, instead of schema and table name

-

string

modelingTableType

Table type: regular database table (identified by schema and table name) or a custom query

-

ModelingTableType

modelAttributeType

-

ModelAttributeType