| Table Name: | prtnum_cat |
| Table Number: | 98 |
| Group: | Diagnosis Eng |
| Description: | A grouping of keyphrases defined either for a part revision or for a part class. 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) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| prtnum_cat2part_info | OTOP | mod_level | part_info2prtnum_cat | The part revision for these keyphrases. Reserved; not used | Search (3) | ||
| prtnum_cat2part_class | OTOP | part_class | part_class2prtnum_cat | The keyphrase category for a part_class. Reserved; not used | Search (1) | ||
| prtnum_cat2prtkp_cat | MTM | prtkp_cat | prtkp_cat2prtnum_cat | The part keyphrase category related to the part number category. Reserved; not used | mtm_prtkp_cat4_ prtnum_cat0 | Search (3) | |
| prtnum_cat2prtnum_kp | OTM | prtnum_kp | prtnum_kp2prtnum_cat | The part number keyphrases in the part number category. Reserved; not used |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_prtnum_cat2part_info | prtnum_cat2part_info | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 93 | show2psfg | gbkp_cat, keyphrase, prtkp_cat, prtnum_cat |
| 100 | pml2shwg2psfg | gbkp_cat, mod_level, prtkp_cat, prtnum_cat |
| 103 | shwgpsfi2shwi | prtkp_cat, prtnum_cat, prtnum_kp |
| 105 | pinst2pml2shwgrp | mod_level, prtnum_cat, site_part |
| 110 | head_shwitm | prtkp_cat, prtnum_cat, prtnum_kp |
| 343 | prtnum2mod2shwgrp | mod_level, part_num, prtnum_cat |
| 402 | prtcls2shwg2psfg | gbkp_cat, part_class, prtkp_cat, prtnum_cat |
| prtnum_cat | |||