Description
For any item that has scheduled events, the ScheduledEvents table contains a cross reference between a task (appointment, agile task, or to do list item) and a specific item, such as defect or requirement.
An item can have several scheduled events.
Columns
The table contains the following columns:
ScheduledEventId : int, primary key, allows null: no, default: auto-generated
The identifier of the scheduled event.
DateCreated : datetime, allows null: no, default: Current date and time
The date and time when 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 when 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.
EntityCode : varchar (max 100 chars), allows null: no
The module where the scheduled item is located.
You can find correspondences between entity code values and related modules in Table of Entity Code Values.
FKId : int, allows null: no
The unique identifier of the associated item, such as BugId, FunctionalSpecId, and so on.
TaskId : int, allows null: no
The identifier of the associated task.
UpdateUserId : int, allows null: no
The ID of the user who last updated the item.