ColumnType

Enumeration defining database-specific column data types that map to the underlying database system's native data types. ColumnType provides the physical database type specification that complements the internal data type system for complete type management across different database platforms.

Enumeration Literals

VARCHAR - (0)

Variable-length character string type for text data, names, and descriptions in dimensional attributes.

NUMERIC - (1)

Exact numeric type with user-defined precision and scale for precise decimal calculations in measures.

DECIMAL - (2)

Fixed-point decimal type for financial data and precise numerical measures requiring exact decimal representation.

FLOAT - (3)

Single-precision floating-point type for approximate numeric data and scientific calculations.

REAL - (4)

Real number type for floating-point numerical data in measures and calculated values.

INTEGER - (5)

Whole number type for counts, identifiers, and integer-based dimensional keys.

SMALLINT - (6)

Small integer type for compact storage of ordinal values and small numeric identifiers.

DOUBLE - (7)

Double-precision floating-point type for high-precision numerical measures and statistical calculations.

OTHER - (8)

Fallback type for database-specific or custom data types not covered by standard type definitions.

BOOLEAN - (10)

Boolean type for true/false values, flags, and binary indicators in dimensional attributes.

DATE - (11)

Date type for calendar dates used in time dimensions and temporal analysis.

TIME - (12)

Time type for time-of-day values used in temporal dimensions and time-based analysis.

TIMESTAMP - (13)

Timestamp type combining date and time for precise temporal data and event tracking.

BIGINT - (14)

Large integer type for high-volume identifiers and big integer calculations.