Column
Abstract base class for database columns that define data structure and metadata for OLAP mappings. Column provides common attributes for data type, size, and constraints used in dimensional modeling and measure definitions.
Extends
- AbstractElement 🔗
Attributes
| Name | Id | Type | Lower | Upper |
|---|---|---|---|---|
| type | false | ColumnType🔗 | 0 | 1 |
| Data type of the column specifying the kind of data stored. Column type determines how data is processed in OLAP operations and dimensional mappings. Defaults to Varchar. | ||||
| columnSize | false | EIntegerObject | 0 | 1 |
| Maximum size or length of data that can be stored in this column. For character types, specifies maximum character count; for numeric types, specifies precision. | ||||
| decimalDigits | false | EIntegerObject | 0 | 1 |
| Number of digits to the right of the decimal point for numeric columns. Specifies the scale for decimal and numeric data types used in measure calculations. | ||||
| charOctetLength | false | EIntegerObject | 0 | 1 |
| Maximum length in bytes for character data types. Specifies the storage space required for variable-length character columns in the database. | ||||
| numPrecRadix | false | EIntegerObject | 0 | 1 |
| Radix for numeric precision, typically 10 for decimal or 2 for binary numeric types. Defines the base for interpreting the precision value of numeric columns. | ||||
| nullable | false | EBooleanObject | 0 | 1 |
| Boolean flag indicating whether the column can contain null values. Critical for OLAP operations as null handling affects aggregation calculations and dimensional member processing. | ||||
References
| Name | Type | Lower | Upper | Containment |
|---|---|---|---|---|
| table | Table🔗 | 0 | 1 | false |
| Reference to the parent table that contains this column. Establishes the table-column relationship for proper database structure organization. | ||||
| primaryLinks | Link🔗 | 0 | ∞ | false |
| Collection of links where this column serves as the primary key. These links define relationships where this column is the target of foreign key references from other tables. | ||||
| foreignLinks | Link🔗 | 0 | ∞ | false |
| Collection of links where this column acts as a foreign key referencing primary keys in other tables. These links establish dimensional relationships in OLAP schemas. | ||||
Used by
- CustomMeasure🔗 → columns
- ColumnBaseMeasure🔗 → column
- DimensionConnector🔗 → foreignKey
- Hierarchy🔗 → primaryKey
- Level🔗 → captionColumn
- Level🔗 → column
- Level🔗 → nameColumn
- Level🔗 → ordinalColumn
- ParentChildHierarchy🔗 → parentColumn
- MemberProperty🔗 → column
- ParentChildLink🔗 → childColumn
- ParentChildLink🔗 → parentColumn
- JoinedQueryElement🔗 → key
- WritebackAttribute🔗 → column
- WritebackMeasure🔗 → column
- AggregationForeignKey🔗 → aggregationColumn
- AggregationForeignKey🔗 → factColumn
- AggregationLevel🔗 → captionColumn
- AggregationLevel🔗 → column
- AggregationLevel🔗 → nameColumn
- AggregationLevel🔗 → ordinalColumn
- AggregationLevelProperty🔗 → column
- AggregationMeasure🔗 → column
- AggregationMeasureFactCount🔗 → column
- AggregationMeasureFactCount🔗 → factColumn
- AggregationColumnName🔗 → column
- AccessColumnGrant🔗 → column
- Table🔗 → columns
- OrderedColumn🔗 → column
- Link🔗 → primaryKey
- Link🔗 → foreignKey
- RowValue🔗 → column