| Table Name: | struct_lst |
| Table Number: | 5884 |
| Group: | Analytics |
| Description: | Represents all the attributes of the data set |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| is_calculated | LONG | tinyint | 0 | DIRECT | Indicates if it is a calculated attribute or an original attribute. 1=Yes (calculated), 0=No (original); default=0. | Search (4) | ||
| is_used | LONG | tinyint | 0 | DIRECT | Indicates whether user selected this attribute; 1=Yes, 0=No; Default=0. | Search (4) | ||
| is_value | LONG | tinyint | 0 | DIRECT | Indicates if the attribute is a value attribute; 1=Yes, 0=No; default=0. | 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 |
| 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 | ||||||||||
| list_value2data_set | OTOP | data_set | data_set2struct_lst | Data set values(if exists). | ||||||
| list2ds_calc_fld | MTO | ds_calc_fld | ds_calc_fld2struct_lst | Calculated columns in the data set | Search (2) | attr_defn_for | source_type | source_lowid | ||
| struct_lst2eda_attr | OTM | eda_attr | attr2struct_lst | Attributes of the EDA (Exploratory Data Analysis) can come from original structure list or to be discreted, based on an attribute from the structure list | ||||||
| struct_lst2md_lr_param | MTM | md_lr_param | md_lr_param2struct_lst | The active columns of the model | mtm_struct_lst5_ md_lr_param4 | |||||
| list2obj_column | MTO | obj_column | obj_column2struct_lst | Selected columns for the data set | Search (3) | attr_defn_for | source_type | source_lowid | ||
| struct_list2structure | MTO | structure | structure2struct_lst | Linking columns of data set to column list and teaching field | Search (5) | |||||
| struct_lst2tch_fld_inf | OTM | tch_fld_inf | tf_info2struct_lst | Teaching field for this list | ||||||
| ignore_list2tree_set | MTM | tree_set | tree_set2struct_lst | Ignored columns of a decision tree in a list. Each attribute can be ignored in a certain tree and un-ignored in another tree. | mtm_struct_lst4_ tree_set2 | |||||
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| objindex | objid | clustered, unique located on PRIMARY |
| sl5884 | 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 |
| 5976 | dt_attr_view | data_set, gbst_elm, obj_column, struct_lst, structure, tree_set |
| 5977 | dt_calc_attr_view | data_set, ds_calc_fld, gbst_elm, struct_lst, structure, tree_set |
| 5985 | ds_clc_attr_view | data_set, ds_calc_fld, gbst_elm, struct_lst, structure |
| 6067 | columns_eda_stt_dsc_temp | eda, eda_attr, eda_dsc_vls, model, struct_lst, subset |
| struct_lst | |||