| Table Name: | obj_column |
| Table Number: | 5876 |
| Group: | Analytics |
| Description: | Information about the columns in the flat table |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| category | CHAR | varchar | 32 | Category or business area e.g. billing | Search (3) | |||
| description | CHAR | varchar | 255 | ALLOW_NULL | Column description | Search (3) | ||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| last_stats_dt | CLK_TIME | datetime | The last date when the statistics was updated | |||||
| name | CHAR | varchar | 32 | Name of the column | Search (4) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (5) | ||
| source_lowid | LONG | int | DIRECT | Internal record number of the object to be routed | ||||
| source_type | LONG | smallint | DIRECT, ALLOW_NULL | Type id of the object to be routed | Search (2) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views | Set Name | Type ID Stored in | Objid Stored In |
|---|---|---|---|---|---|---|---|---|---|---|
| Exclusive Set Relations | ||||||||||
| columns2anls_object | MTO | anls_object | anls_object2obj_column | Analysed object's column | Search (1) | |||||
| columns2att_cnt_stt | OTOP | att_cnt_stt | att_cnt_stt2obj_column | Continuous attribute values for column | Search (1) | stats_for | source_type | source_lowid | ||
| columns2att_dsc_stt | OTOP | att_dsc_stt | att_dsc_stt2obj_column | Discrete attribute values for column | Search (2) | stats_for | source_type | source_lowid | ||
| columns2dm_analysis | MTM | dm_analysis | analysis2obj_column | Analysis for the column | mtm_obj_column0_ dm_analysis3 | |||||
| col_lg_type2gbst_elm | MTO | gbst_elm | lg_type2obj_column | Logical type of the column | Search (2) | |||||
| obj_column2key_column | OTOF | key_column | key2obj_column | Key (primary or secondary) columns | ||||||
| obj_column2struct_lst | OTM | struct_lst | list2obj_column | Data sets columns | attr_defn_for | source_type | source_lowid | |||
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| c5876 | category | nonclustered located on PRIMARY |
| n5876 | name | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| sl5876 | source_lowid, source_type | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5958 | ds_attr_view | data_set, gbst_elm, obj_column, struct_lst, structure |
| 5959 | columns_stat_disc | att_dsc_vls, obj_column |
| 5960 | columns_stat_cont | att_cnt_vls, obj_column |
| 5962 | ds_create_tf_list | att_dsc_vls, data_set, obj_column |
| 5965 | ds_modeling_columns | anls_object, dm_analysis, obj_column, se_session |
| 5976 | dt_attr_view | data_set, gbst_elm, obj_column, struct_lst, structure, tree_set |
| obj_column | |||