Description
Contains detailed information on folders.
Dependencies
Columns
DateCreated : datetime, allows null: no
Date and time when the folder was created.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateUpdated : datetime, allows null: no
Date and time when the folder was last updated.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DeptId : int, allows null: yes
The ID of the department that owns the folder.
Description : varchar (max 1000 chars), allows null: yes
The description of the folder.
This column corresponds to a field that can be available for Rich Text Feature.
EntityCode : varchar (max 100 chars), allows null: no
The module where the folder is located.
Correspondences between entity code values and related modules and features you can find in Table of Entity Code Values.
FolderId : int, allows null: no
The unique numeric identifier of the folder.
FolderName : varchar (max 255 chars), allows null: no
The name of the folder.
FullFolderName : varchar (max 511 chars), allows null: yes
A combination of the parent folder’s name and the name of the folder itself.
IsActive : char (max 1 char), allows null: no, default: Y
Shows if the folder is active.
IsCompanyWide : varchar (max 1 char), allows null: no
Indicates whether the folder is available in all the projects.
IsPublic : char (max 1 char), allows null: no
The column is reserved for system use only.
IsVersion : char (max 1 char), allows null: no, default: N
The column is reserved for system use only.
NotesDescription : varchar (max), allows null: yes
An alias for the LatestNotes column of the ExtendedAttributes table.
A description of the latest note attached to the associated item.
OwnerUserId : int, allows null: no
The ID of the user who created the item.
OwnerUserName : varchar (max 78 chars), allows null: yes
The name of the user who created the folder.
ParentId : int, allows null: no
The ID of the parent folder.
ParentName : varchar (max 255 chars), allows null: yes, default:
The name of the folder’s parent. Otherwise it is NULL.
ProjId : int, allows null: no
The ID of the project that contains the folder.
UpdateUserId : int, allows null: no
The ID of the user who last updated the item.
UserName : varchar (max 78 chars), allows null: yes
The name of the user who last updated the folder.