Table Name:prtkp_cat
Table Number:11
Group:Diagnosis Eng
Description:Part keyphrase category. Reserved; not used
Flags: 
Baseline/Custom:Baseline
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
devLONGint151 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
last_mod_timeCLK_TIMEdatetime    Date and time the part keyphrase category was last modified  
objidLONGint3  DIRECT Internal record number Search (9)
rankLONGint9  DIRECT Presentation rank of the category; used for user interface  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
prtkp_cat2gbkp_catMTOgbkp_catgbkp_cat2prtkp_catThe global category of the part keyphrase category. Reserved; not used   Search (6)
prtkp_cat2keyphraseOTOPkeyphrasekeyphrase2prtkp_catThe 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_setMTOprtkp_setprtkp_set2prtkp_catThe set of part keyphrases in the category. Reserved; not used   Search (2)
prtkp_cat2prtkp_subcOTMprtkp_subcprtkp_subc2prtkp_catThe children subcategories of the part keyphrase category. Reserved; not used    
prtkp_cat2prtnum_catMTMprtnum_catprtnum_cat2prtkp_catThe part number categories related to the part keyphrase category. Reserved; not used  mtm_prtkp_cat4_
prtnum_cat0
 
prtkp_cat2prtnum_kpOTMprtnum_kpprtnum_kp2prtkp_catThe part number keyphrases in the part keyphrase category. Reserved; not used    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
Indexes (Defined in Database):
Index NameFieldsAdditional Information
ind_prtkp_cat2gbkp_catprtkp_cat2gbkp_catnonclustered located on PRIMARY
ind_prtkp_cat2keyphraseprtkp_cat2keyphrasenonclustered located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
My Recent Objects
prtkp_cat