| Table Name: | eda_attr |
| Table Number: | 5928 |
| Group: | Analytics |
| Description: | Contains the attributes of the eda (original or discreted) |
| 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 | ALLOW_NULL | Category or business area e.g. billing | Search (3) | ||
| current_attr_name | CHAR | varchar | 32 | Holds the attributes (original or new) names of the EDA | Search (4) | |||
| description | CHAR | varchar | 255 | ALLOW_NULL | Description of EDA attributes | Search (3) | ||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| is_used | LONG | tinyint | 0 | DIRECT | Indicates whether used for EDA graphs; 1=Yes, 0=No; default=0. | Search (4) | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (4) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| attr_x2correlation | OTM | correlation | corr_x2eda_attr | Correlation's X-axis | |||
| attr_y2correlation | OTM | correlation | corr_y2eda_attr | Correlation's Y-axis | |||
| eda_attr2eda | MTO | eda | eda2eda_attr | All the attributes of the EDA | Search (3) | ||
| graph_x2eda_graph | OTM | eda_graph | graph_x2eda_attr | Axis-X attributes | |||
| graph_y2eda_graph | OTM | eda_graph | graph_y2eda_attr | Axis-Y attributes | |||
| graph_z2eda_graph | OTM | eda_graph | graph_z2eda_attr | Axis-Z attributes | |||
| measure2eda_graph | OTM | eda_graph | measure2eda_attr | Graph's measure | |||
| eda_attr2eda_stats | OTOF | eda_stats | eda_stats2eda_attr | Statistics for an attribute | |||
| eda_attr2gbst_elm | MTO | gbst_elm | attr_type2eda_attr | The attribute type | Search (3) | ||
| attr2struct_lst | MTO | struct_lst | struct_lst2eda_attr | Original structure list's attributes | Search (1) |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| c5928 | category | nonclustered located on PRIMARY |
| can5928 | current_attr_name | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5997 | eda_dsc_vls_view | eda, eda_attr, eda_dsc_vls, eda_stats |
| 5998 | eda_attr_cont_view | eda, eda_attr, eda_stats, eda_sts_cnt, gbst_elm |
| 5999 | eda_attr_disc_view | eda, eda_attr, gbst_elm |
| 6001 | correlation_view | correlation, eda, eda_attr |
| 6056 | eda_attr_discrzed_vw | eda, eda_attr, gbst_elm |
| 6067 | columns_eda_stt_dsc_temp | eda, eda_attr, eda_dsc_vls, model, struct_lst, subset |
| eda_attr | |||