Table Name:NWS_Trees
Table Number:5516
Group:Configuration
Description:A tree structure comprised of folder nodes. Items can belong to one or more nodes in a tree.
Flags: 
Baseline/Custom:Baseline
select * from table_NWS_Trees
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
N_EffectiveDateCLK_TIMEdatetime   ALLOW_NULL The first date on which the information should be used  
N_ExpirationDateCLK_TIMEdatetime   ALLOW_NULL Last date when the information should be used  
N_ItemIdLONGint   DIRECT, ALLOW_NULL Row number of the item being assigned  
N_ItemTypeIdLONGint   DIRECT, ALLOW_NULL Identifies the ID number of the type of item being assigned  
N_ModificationDateCLK_TIMEdatetime   ALLOW_NULL Date and time when the information was last modified  
N_TreeNameCHARvarchar 255 ALLOW_NULL The name of the tree  
objidLONGint3  DIRECT Internal record number  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in ViewsSet NameType ID Stored inObjid Stored In
 Exclusive Set Relations
nws_trees2N_ItemTypesMTON_ItemTypesn_itmtyp2NWS_TreesFor a folder of type N_ItemType the N_ItemType    member_of N_ItemTypeId N_ItemId 
nws_trees2N_ItemTypesExMTON_ItemTypesExn_xitmtyp2NWS_TreesFor a folder of an N_ExtItemType the N_ExtItemType    member_of N_ItemTypeId N_ItemId 
nws_trees2NWS_TreeFoldersOTMNWS_TreeFoldersn_folders2NWS_TreesFolders belonging to the tree       
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
I5516N_TreeName:N_ItemTypeId:N_ItemIdUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
I5516N_TreeName, N_ItemTypeId, N_ItemIdnonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
My Recent Objects
NWS_Trees      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user