| Table Name: | keyphrase |
| Table Number: | 13 |
| Group: | Diagnosis Eng |
| Description: | Part keyphrase object. 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 |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| dim_info | ARRAY | 1 | 0 | DIRECT, BINARY | Associated binary array object | Search (10) | ||
| last_mod_time | CLK_TIME | datetime | Time and date of last modification | |||||
| logic_gate | ARRAY | 3 | 0 | DIRECT, BINARY | Associated binary array object | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (10) | ||
| rank | LONG | int | 9 | DIRECT | Presentation rank of the keyphrase; used for user interface | |||
| show_info | ARRAY | 2 | 0 | DIRECT, BINARY | Associated binary array object |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| keyphrase2case | MTM | case | case2keyphrase | The cases using the part keyphrase. Reserved; not used | mtm_case37_ keyphrase6 | ||
| keyphrase2gb_kp | MTO | gb_kp | gb_kp2keyphrase | Global keyphrase related to the part keyphrase. Reserved; not used | Search (7) | ||
| keyphrase2prog_logic | MTM | prog_logic | prog_logic2keyphrase | Logic objects associated with the part keyphrase. Reserved; not used | mtm_keyphrase5_ prog_logic2 | ||
| keyphrase2prtkp_cat | OTOF | prtkp_cat | prtkp_cat2keyphrase | The part keyphrase category that uses the part keyphrase as an index into the encoded logic for the category <a performance shortcut, enabling single calls to the DB for multiple combinations of keyphrase logic>. Reserved; not used | |||
| keyphrase2prtkp_subc | MTO | prtkp_subc | prtkp_subc2keyphrase | The part keyphrase sub-category that includes the part keyphrase. Reserved; not used | Search (3) | ||
| keyphrase2prtnum_kp | OTM | prtnum_kp | prtnum_kp_prnt2keyphrase | Reserved; not used | |||
| keyphrasechild2prtnum_kp | MTM | prtnum_kp | prtnum_kp_chld2keyphrase | Part num keyphrases applicable to the keyphrase. Reserved; not used | mtm_keyphrase4_ prtnum_kp1 |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_keyphrase2prtkp_subc | keyphrase2prtkp_subc | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 90 | down_show | keyphrase, prtnum_kp |
| 91 | show2psfi | gb_kp, keyphrase, prtnum_kp |
| 92 | psfl2psfi | gb_kp, gbkp_cat, keyphrase, prtkp_subc |
| 93 | show2psfg | gbkp_cat, keyphrase, prtkp_cat, prtnum_cat |
| 94 | psfi_view | gb_kp, keyphrase |
| 101 | showip2psfi | gb_kp, keyphrase, prtnum_kp |
| 102 | shwipsfi2shwi | gb_kp, keyphrase, prtnum_kp |
| 108 | psfg_view | gbkp_cat, keyphrase, prtkp_cat |
| 345 | prtcat2psfi | gb_kp, keyphrase, prtkp_cat, prtkp_subc |
| 346 | subc_show2psfi | gb_kp, keyphrase, prtkp_subc, prtnum_kp |
| keyphrase | |||