Table Name: | gb_kp |
Table Number: | 9 |
Group: | Diagnosis Eng |
Description: | Global keyphrase. 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 global keyphrase was last modified | |||||
objid | LONG | int | 3 | DIRECT | Internal record number | Search (1) | ||
rank | LONG | int | 9 | DIRECT | Presentation rank of the keyphrase used for user interface | Search (2) | ||
title | CHAR | varchar | 2 | 255 | Title of the global keyphrase | Search (8) | ||
unique_title | CHAR | varchar | 255 | Unique title of global keyphrase, a combination of the keyphrase and its category/subcategory |
Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
---|---|---|---|---|---|---|---|
gb_kp2gbkp_subc | MTO | gbkp_subc | gbkp_subc2gb_kp | Subcategory to which the global keyphrase belongs. Reserved; not used | Search (1) | ||
gb_kp2keyphrase | OTM | keyphrase | keyphrase2gb_kp | The global keyphrase used as part keyphrases; i.e., uses of the keyphrase for particular product/parts. Reserved; not used |
Index Name | Fields | Flags |
---|---|---|
title_index | unique_title | UNIQUE |
Index Name | Fields | Additional Information |
---|---|---|
objindex | objid | clustered, unique located on PRIMARY |
title_index | unique_title | nonclustered, unique located on PRIMARY |
View ID | View Name | Tables |
---|---|---|
91 | show2psfi | gb_kp, keyphrase, prtnum_kp |
92 | psfl2psfi | gb_kp, gbkp_cat, keyphrase, prtkp_subc |
94 | psfi_view | gb_kp, keyphrase |
101 | showip2psfi | gb_kp, keyphrase, prtnum_kp |
102 | shwipsfi2shwi | gb_kp, keyphrase, prtnum_kp |
151 | psfl2gsfi | gb_kp, gbkp_cat, gbkp_subc, prtkp_subc |
345 | prtcat2psfi | gb_kp, keyphrase, prtkp_cat, prtkp_subc |
346 | subc_show2psfi | gb_kp, keyphrase, prtkp_subc, prtnum_kp |
gb_kp | |||