| Table Name: | prtnum_kp |
| Table Number: | 17 |
| Group: | Diagnosis Eng |
| Description: | Part number keyphrase which is used as a truth condition for problem diagnosis. 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 | ||
| last_mod_time | CLK_TIME | datetime | Date and time of last modification | |||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (7) | ||
| show_info | ARRAY | 1 | 0 | DIRECT, BINARY | Associated binary array object | Search (7) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| prtnum_kp_prnt2keyphrase | MTO | keyphrase | keyphrase2prtnum_kp | Reserved; not used | Search (2) | ||
| prtnum_kp_chld2keyphrase | MTM | keyphrase | keyphrasechild2prtnum_kp | Keyphrases related to the part number keyphrase. Reserved; not used | mtm_keyphrase4_ prtnum_kp1 | Search (3) | |
| prtnum_kp2prtkp_cat | MTO | prtkp_cat | prtkp_cat2prtnum_kp | The part keyphrase category for the part number keyphrase. Reserved; not used | Search (2) | ||
| prtnum_kp2prtnum_cat | MTO | prtnum_cat | prtnum_cat2prtnum_kp | The part number category for the part number keyphrase. Reserved; not used | Search (2) | ||
| child2prtnum_kp | OTM | prtnum_kp | parent2prtnum_kp | Reserved; not used | |||
| parent2prtnum_kp | MTO | prtnum_kp | child2prtnum_kp | Reserved; not used | Search (2) |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_prtnum_kp2prtnum_cat | prtnum_kp2prtnum_cat | 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 |
| 101 | showip2psfi | gb_kp, keyphrase, prtnum_kp |
| 102 | shwipsfi2shwi | gb_kp, keyphrase, prtnum_kp |
| 103 | shwgpsfi2shwi | prtkp_cat, prtnum_cat, prtnum_kp |
| 110 | head_shwitm | prtkp_cat, prtnum_cat, prtnum_kp |
| 346 | subc_show2psfi | gb_kp, keyphrase, prtkp_subc, prtnum_kp |
| prtnum_kp | |||