/*
 Navicat Premium Data Transfer

 Source Server         : 118.178.224.202-SqlServer
 Source Server Type    : SQL Server
 Source Server Version : 10501600
 Source Host           : 118.178.224.202:1433
 Source Catalog        : Nbcqb2
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 10501600
 File Encoding         : 65001

 Date: 26/09/2021 16:43:56
*/


-- ----------------------------
-- Table structure for PushZlb
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[PushZlb]') AND type IN ('U'))
	DROP TABLE [dbo].[PushZlb]
GO

CREATE TABLE [dbo].[PushZlb] (
  [ID] nvarchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [PrjId] varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [IsNowDo] int NOT NULL,
  [IsAutoDo] int NOT NULL,
  [AutoDoTime] varchar(200) COLLATE Chinese_PRC_CI_AS NULL,
  [IsDeleted] int DEFAULT ((0)) NOT NULL,
  [CreateTime] datetime DEFAULT (getdate()) NOT NULL,
  [IsProcessed] int DEFAULT ((0)) NOT NULL,
  [LastProcessTime] datetime NULL,
  [ProcessCount] int NULL,
  [IsError] int NULL,
  [ErrorReason] varchar(500) COLLATE Chinese_PRC_CI_AS NULL
)
GO

ALTER TABLE [dbo].[PushZlb] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目ID',
'SCHEMA', N'dbo',
'TABLE', N'PushZlb',
'COLUMN', N'PrjId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否现在就做,1是0否',
'SCHEMA', N'dbo',
'TABLE', N'PushZlb',
'COLUMN', N'IsNowDo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否自动做,1是0否',
'SCHEMA', N'dbo',
'TABLE', N'PushZlb',
'COLUMN', N'IsAutoDo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'自动执行频率表达式',
'SCHEMA', N'dbo',
'TABLE', N'PushZlb',
'COLUMN', N'AutoDoTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否作废,1是0否',
'SCHEMA', N'dbo',
'TABLE', N'PushZlb',
'COLUMN', N'IsDeleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'PushZlb',
'COLUMN', N'CreateTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否已处理,1是0否',
'SCHEMA', N'dbo',
'TABLE', N'PushZlb',
'COLUMN', N'IsProcessed'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最后一次执行时间',
'SCHEMA', N'dbo',
'TABLE', N'PushZlb',
'COLUMN', N'LastProcessTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'到现在执行了几次',
'SCHEMA', N'dbo',
'TABLE', N'PushZlb',
'COLUMN', N'ProcessCount'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否出错, 1是0否',
'SCHEMA', N'dbo',
'TABLE', N'PushZlb',
'COLUMN', N'IsError'
GO

EXEC sp_addextendedproperty
'MS_Description', N'错误记录',
'SCHEMA', N'dbo',
'TABLE', N'PushZlb',
'COLUMN', N'ErrorReason'
GO


-- ----------------------------
-- Primary Key structure for table PushZlb
-- ----------------------------
ALTER TABLE [dbo].[PushZlb] ADD CONSTRAINT [PK__PushZlb__3214EC277BC631F6] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO