Description
Contains created folders across all the projects.
Columns
The table contains the following columns:
FolderId : int, primary key, allows null: no
The unique numeric identifier of the folder.
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 editing.
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.
FolderName : varchar (max 255 chars), allows null: no
The name of the folder.
IsActive : char (max 1 char), allows null: no, default: Y
Shows if the folder is active.
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.
OwnerUserId : int, allows null: no
The ID of the user who created the item.
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.