Table Name:NWS_TreeFolders
Table Number:5514
Group:Configuration
Description:Describes folder structure within a tree that is displayed in Workshop.
Flags: 
Baseline/Custom:Baseline
select * from table_NWS_TreeFolders
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_ModificationDateCLK_TIMEdatetime   ALLOW_NULL Date and time when the information was last modified  
N_NameCHARvarchar 255 ALLOW_NULL The name that appears in the category tree  
N_SequenceNumberLONGint   DIRECT, ALLOW_NULL Used to establish order of the category relative to others under the same parent node  
objidLONGint3  DIRECT Internal record number  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
n_folders2NWS_FolderMembersOTMNWS_FolderMembersn_fldrmems2NWS_TreeFoldersThe members of the folder    
n_child2NWS_TreeFoldersMTONWS_TreeFoldersn_parent2NWS_TreeFoldersThe folder's parent folder    
n_parent2NWS_TreeFoldersOTMNWS_TreeFoldersn_child2NWS_TreeFoldersThe folder's subfolders    
n_folders2NWS_TreesMTONWS_Treesnws_trees2NWS_TreeFoldersThe folder's parent tree    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
I5514N_Name:n_child2NWS_TreeFolders:n_folders2NWS_TreesUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
I5514N_Name, n_child2NWS_TreeFolders, n_folders2NWS_Treesnonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
My Recent Objects
NWS_TreeFolders      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user