| Table Name: | log |
| Table Number: | 5946 |
| Group: | Analytics |
| Description: | Information about the log (creation and close dates) |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| close_dt | CLK_TIME | datetime | Close date | |||||
| creation_dt | CLK_TIME | datetime | Creation date | Search (6) | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (6) | ||
| source_lowid | LONG | int | DIRECT | Internal record number of the object to be routed | Search (6) | |||
| source_type | LONG | smallint | DIRECT, ALLOW_NULL | Type id of the object to be routed | Search (6) |
| 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 | ||||||||||
| log2data_set | OTOP | data_set | data_set2log | Data set messages in log | Search (1) | log_for | source_type | source_lowid | ||
| log2log_line | OTM | log_line | log_line2log | Line details for the log | ||||||
| log2model | OTOP | model | model2log | Model messages in log | Search (1) | log_for | source_type | source_lowid | ||
| log2rule_set | OTOP | rule_set | rule_set2log | Rule set messages in log | Search (1) | log_for | source_type | source_lowid | ||
| log_scoring2se_session | OTOP | se_session | se_session_score2log | Session messages in log | Search (1) | log_for | source_type | source_lowid | ||
| log2se_session | OTOP | se_session | se_session2log | Session for the log | Search (4) | |||||
| log2tree_set | OTOP | tree_set | tree_set2log | Tree set messages in log | Search (1) | log_for | source_type | source_lowid | ||
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| objindex | objid | clustered, unique located on PRIMARY |
| sl5946 | source_lowid, source_type | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5968 | log_view | gbst_elm, log, log_line |
| 6042 | se_scor_exec_log | gbst_elm, log, log_line, se_session |
| 6044 | ds_log_view | data_set, gbst_elm, log, log_line, se_session |
| 6045 | dt_log_view | gbst_elm, log, log_line, se_session, tree_set |
| 6046 | rs_log_view | gbst_elm, log, log_line, rule_set, se_session |
| 6047 | model_log_view | gbst_elm, log, log_line, model, se_session |
| log | |||