Table Name: | prtkp_cat |
Table Number: | 11 |
Group: | Diagnosis Eng |
Description: | Part keyphrase category. 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 the part keyphrase category was last modified | |||||
objid | LONG | int | 3 | DIRECT | Internal record number | Search (9) | ||
rank | LONG | int | 9 | DIRECT | Presentation rank of the category; used for user interface |
Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
---|---|---|---|---|---|---|---|
prtkp_cat2gbkp_cat | MTO | gbkp_cat | gbkp_cat2prtkp_cat | The global category of the part keyphrase category. Reserved; not used | Search (6) | ||
prtkp_cat2keyphrase | OTOP | keyphrase | keyphrase2prtkp_cat | The part keyphrase that is used to index into the encoded logic for the category. This is a performance shortcut, enabling single calls to the DB for multiple combinations of keyphrase logic. Reserved; not used | Search (2) | ||
prtkp_cat2prtkp_set | MTO | prtkp_set | prtkp_set2prtkp_cat | The set of part keyphrases in the category. Reserved; not used | Search (2) | ||
prtkp_cat2prtkp_subc | OTM | prtkp_subc | prtkp_subc2prtkp_cat | The children subcategories of the part keyphrase category. Reserved; not used | |||
prtkp_cat2prtnum_cat | MTM | prtnum_cat | prtnum_cat2prtkp_cat | The part number categories related to the part keyphrase category. Reserved; not used | mtm_prtkp_cat4_ prtnum_cat0 | ||
prtkp_cat2prtnum_kp | OTM | prtnum_kp | prtnum_kp2prtkp_cat | The part number keyphrases in the part keyphrase category. Reserved; not used |
Index Name | Fields | Flags |
---|
Index Name | Fields | Additional Information |
---|---|---|
ind_prtkp_cat2gbkp_cat | prtkp_cat2gbkp_cat | nonclustered located on PRIMARY |
ind_prtkp_cat2keyphrase | prtkp_cat2keyphrase | 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 |
108 | psfg_view | gbkp_cat, keyphrase, prtkp_cat |
110 | head_shwitm | prtkp_cat, prtnum_cat, prtnum_kp |
129 | psfg2psfs2pmh | part_class, prtkp_cat, prtkp_set |
153 | gsfg2psf2pfsg | gbkp_cat, prtkp_cat, prtkp_set |
345 | prtcat2psfi | gb_kp, keyphrase, prtkp_cat, prtkp_subc |
402 | prtcls2shwg2psfg | gbkp_cat, part_class, prtkp_cat, prtnum_cat |
prtkp_cat | |||