Tables [dbo].[Task]
PropertyValue
Row Count (~)0
Created1:20:03 AM Thursday, March 21, 2019
Last Modified1:20:08 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_Task_TaskID: TaskIDTaskIDint4
False
1 - 1
TaskTypeint4
False
StartDatedatetime8
False
(getdate())
StartModeint4
False
((0))
IntervalTypeint4
False
((0))
IntervalCountint4
False
((0))
NrRunsint4
False
((0))
LastRundatetime8
True
LastRunStatusint4
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_Task_TaskID: TaskIDPK_Task_TaskIDTaskID
True
CREATE TABLE [dbo].[Task]
(
[TaskID] [int] NOT NULL IDENTITY(1, 1),
[TaskType] [int] NOT NULL,
[StartDate] [datetime] NOT NULL CONSTRAINT [DF_Task_StartDate] DEFAULT (getdate()),
[StartMode] [int] NOT NULL CONSTRAINT [DF_Task_StartMode] DEFAULT ((0)),
[IntervalType] [int] NOT NULL CONSTRAINT [DF_Task_IntervalType] DEFAULT ((0)),
[IntervalCount] [int] NOT NULL CONSTRAINT [DF_Task_IntervalCount] DEFAULT ((0)),
[NrRuns] [int] NOT NULL CONSTRAINT [DF_Task_NrRuns] DEFAULT ((0)),
[LastRun] [datetime] NULL,
[LastRunStatus] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Task] ADD CONSTRAINT [PK_Task_TaskID] PRIMARY KEY CLUSTERED  ([TaskID]) ON [PRIMARY]
GO