SYCW_API/文档/Sql/sql_20190429...

/****** Object:  Table [dbo].[T_Wo_WorkOrderItem_New]    Script Date: 04/29/2019 09:40:25 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[T_Wo_WorkOrderItem_New]') AND type in (N'U'))
DROP TABLE [dbo].[T_Wo_WorkOrderItem_New]
GO

/****** Object:  Table [dbo].[T_Wo_WorkOrderItem_New]    Script Date: 04/29/2019 09:40:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[T_Wo_WorkOrderItem_New](
	[F_ID] [bigint] IDENTITY(1,1) NOT NULL,
	[F_WoID] [bigint] NOT NULL, --工单id
	[F_WoState] [int] NULL,--工单状态
	[F_ItemType] [int] NULL,--记录类型
	[F_OptType] [int] NULL,--操作类型
	[F_OptContent] [nvarchar](max) NULL,--操作内容
	[F_NextUser] [varchar](50) NULL,--下一步操作人
	[F_NextDept] [int] NULL,--下一步操作部门
	[F_IsUsed] [int] NULL default(0),--是否已过期
	[F_CreateUser] [varchar](50) NULL,--处理人
	[F_CreateTime] [datetime] NULL,--处理时间
 CONSTRAINT [PK__T_Wo_WorkOrderItem_New] PRIMARY KEY CLUSTERED 
(
	[F_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工单记录ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_WorkOrderItem_New', @level2type=N'COLUMN',@level2name=N'F_ID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工单ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_WorkOrderItem_New', @level2type=N'COLUMN',@level2name=N'F_WoID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工单状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_WorkOrderItem_New', @level2type=N'COLUMN',@level2name=N'F_WoState'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录类型 1工单处理，2工单催办' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_WorkOrderItem_New', @level2type=N'COLUMN',@level2name=N'F_ItemType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_WorkOrderItem_New', @level2type=N'COLUMN',@level2name=N'F_OptType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_WorkOrderItem_New', @level2type=N'COLUMN',@level2name=N'F_OptContent'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下一步操作人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_WorkOrderItem_New', @level2type=N'COLUMN',@level2name=N'F_NextUser'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下一步操作部门' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_WorkOrderItem_New', @level2type=N'COLUMN',@level2name=N'F_NextDept'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否在用，0是 1否' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_WorkOrderItem_New', @level2type=N'COLUMN',@level2name=N'F_IsUsed'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_WorkOrderItem_New', @level2type=N'COLUMN',@level2name=N'F_CreateUser'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_WorkOrderItem_New', @level2type=N'COLUMN',@level2name=N'F_CreateTime'
GO