| Table Name: | gbkp_cat |
| Table Number: | 7 |
| Group: | Diagnosis Eng |
| Description: | Global keyphrase categories. 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 category was last modified | |||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (2) | ||
| rank | LONG | int | 9 | DIRECT | Presentation rank of the category; used for user interface | Search (3) | ||
| title | CHAR | varchar | 2 | 30 | Title of the keyphrase category | Search (5) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| gbkp_cat2gbkp_set | MTO | gbkp_set | gbkp_set2gbkp_cat | The set of global keyphrase categories in which the category is a member. Reserved; not used | Search (1) | ||
| gbkp_cat2gbkp_subc | OTM | gbkp_subc | gbkp_subc2gbkp_cat | The subcategories of the global keyphrase category; used for variations of a single kind of keyphrase-related situation. Reserved; not used | |||
| gbkp_cat2prtkp_cat | OTM | prtkp_cat | prtkp_cat2gbkp_cat | The global keyphrase category used as part keyphrase categories; i.e., uses of the category for particular product/parts. Reserved; not used |
| Index Name | Fields | Flags |
|---|---|---|
| title_index | title | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| objindex | objid | clustered, unique located on PRIMARY |
| title_index | title | nonclustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 92 | psfl2psfi | gb_kp, gbkp_cat, keyphrase, prtkp_subc |
| 93 | show2psfg | gbkp_cat, keyphrase, prtkp_cat, prtnum_cat |
| 100 | pml2shwg2psfg | gbkp_cat, mod_level, prtkp_cat, prtnum_cat |
| 108 | psfg_view | gbkp_cat, keyphrase, prtkp_cat |
| 151 | psfl2gsfi | gb_kp, gbkp_cat, gbkp_subc, prtkp_subc |
| 152 | pmh2psf2gsfg | gbkp_cat, gbkp_set, part_class, prtkp_set |
| 153 | gsfg2psf2pfsg | gbkp_cat, prtkp_cat, prtkp_set |
| 402 | prtcls2shwg2psfg | gbkp_cat, part_class, prtkp_cat, prtnum_cat |
| gbkp_cat | |||