| Table Name: | prog_logic |
| Table Number: | 18 |
| Group: | Diagnosis Eng |
| Description: | Linking device which links cases, diagnostic elements, and their related solutions to one another. Reserved; not used |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| creation_time | CLK_TIME | datetime | 1 | The date and time the path was created | ||||
| description | CHAR | varchar | 23 | 255 | Description of the path | Search (2) | ||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| id_number | CHAR | varchar | 4 | 32 | Unique ID number for the path; consists of solution-# | Search (2) | ||
| is_cmn | LONG | int | DIRECT | Reserved; future | Search (1) | |||
| modify_time | CLK_TIME | datetime | The date and time the logic was modified | |||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (4) | ||
| prog_array | ARRAY | 1 | 0 | DIRECT, BINARY | Associated binary array object | Search (4) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| prog_logic2case | OTM | case | case_logic2prog_logic | The cases using the logic. Reserved; not used | |||
| prog_logic2hint_inst | OTM | hint_inst | hint_logic2prog_logic | Diagnostic hint instances related to the logic. Reserved; not used | |||
| prog_logic2keyphrase | MTM | keyphrase | keyphrase2prog_logic | Keyphrases related to the logic. Reserved; not used | mtm_keyphrase5_ prog_logic2 | ||
| prog_logic2part_info | MTO | mod_level | part_info2prog_logic | Part revisions on which the logic was defined. Reserved; not used | Search (1) | ||
| prog_logic2part_class | MTO | part_class | part_class2prog_logic | Part class, generic part, related to the logic. Reserved; not used | Search (2) | ||
| prog_logic2probdesc | MTO | probdesc | probdesc2prog_logic | Solution applicable to the logic. Reserved; not used | Search (2) |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_prog_logic2part_class | prog_logic2part_class | nonclustered located on PRIMARY |
| ind_prog_logic2probdesc | prog_logic2probdesc | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 185 | rating | probdesc, prog_logic |
| 313 | diag_hint_inst | diag_hint, hint_inst, prog_logic |
| 344 | lgc2mod2prt | mod_level, part_class, part_num, prog_logic |
| 373 | lgc2pd2class | part_class, probdesc, prog_logic |
| prog_logic | |||