Description
The table stores release details from all the projects.
Columns
The table contains the following columns:
Id : int, primary key, allows null: no, default: auto generated
The unique numeric identifier of the item.
ParentId : int, allows null: yes
The ID of the item’s parent release or iteration.
ProjId : int, allows null: no, default: auto filled
The ID of the project that contains the item.
ReleaseId : int, allows null: yes
The ID of the top level release in the hierarchy.
AssigneeUserId : int, allows null: yes
The ID of the user to whom the item is assigned.
CreateUserId : int, allows null: yes
The ID of the user who created the item.
Custom1..Custom10 : nvarchar (max), allows null: yes
The values of custom fields 1 - 10.
These columns correspond to fields that can be available for rich editing.
DateCreated : datetime, allows null: no
The date and time the item 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, default: Current date and time
The date and time the item was last updated.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
Description : nvarchar (max), allows null: yes
The description of the item.
This column corresponds to a field that can be available for rich editing.
EstFinishDate : datetime, allows null: yes
The date the work on the item is estimated to complete.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
EstStartDate : datetime, allows null: yes
The date the work on the item is estimated to start.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
FolderId : int, allows null: yes, default: auto filled
The ID of the folder where the item is located.
ImportId : int, allows null: yes
The ID of the imported batch in which the item was imported.
IsActive : nvarchar (max 1 char, or 4 bytes), allows null: no
Indicates whether the item is active.
IsAutoAdjustEstDates : nvarchar (max 1 char, or 4 bytes), allows null: no
Indicates whether the estimated start and finish dates are adjusted automatically.
OwnerUserId : int, allows null: yes
The ID of the user who created the item.
ReleaseType : nvarchar (max 100 chars, or 202 bytes), allows null: no
The type of the item (Release, Iteration, or Build).
SeqNum : int, allows null: no, default: 0
The ordinal number of the item among its siblings.
StatusCode : nvarchar (max 100 chars, or 202 bytes), allows null: no
The status of the item based on the choice list. The values of the choice list are stored in the Validation table. They correspond to the items whose values equal ReleaseStatus in the ValidationType column.
Title : nvarchar (max 255 chars, or 512 bytes), allows null: no
The title of the release.
UpdateUserId : int, allows null: yes
The ID of the user who last updated the item.