/****** Object:  Table [dbo].[CoreCmsCheckBeforeAddOrder]    Script Date: 2022/6/30 23:43:39 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[CoreCmsCheckBeforeAddOrder](
	[id] [INT] IDENTITY(1,1) NOT NULL,
	[orderId] [NVARCHAR](50) NOT NULL,
	[requireOrder] [INT] NOT NULL,
	[requiredFundType] [INT] NOT NULL,
	[traceId] [NVARCHAR](50) NULL,
	[createTime] [DATETIME] NOT NULL,
 CONSTRAINT [PK_CoreCmsCheckBeforeAddOrder] PRIMARY KEY CLUSTERED 
(
	[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

ALTER TABLE [dbo].[CoreCmsCheckBeforeAddOrder] ADD  CONSTRAINT [DF_CoreCmsCheckBeforeAddOrder_requireOrder]  DEFAULT ((0)) FOR [requireOrder]
GO

ALTER TABLE [dbo].[CoreCmsCheckBeforeAddOrder] ADD  CONSTRAINT [DF_CoreCmsCheckBeforeAddOrder_requiredFundType]  DEFAULT ((2)) FOR [requiredFundType]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÐòÁÐ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsCheckBeforeAddOrder', @level2type=N'COLUMN',@level2name=N'id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¶©µ¥±àºÅ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsCheckBeforeAddOrder', @level2type=N'COLUMN',@level2name=N'orderId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÊÇ·ñÐèÒªÍƵ¥' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsCheckBeforeAddOrder', @level2type=N'COLUMN',@level2name=N'requireOrder'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÉÌ»§¶©µ¥ÀàÐÍ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsCheckBeforeAddOrder', @level2type=N'COLUMN',@level2name=N'requiredFundType'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¸ú×ÙID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsCheckBeforeAddOrder', @level2type=N'COLUMN',@level2name=N'traceId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'´´½¨Ê±¼ä' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsCheckBeforeAddOrder', @level2type=N'COLUMN',@level2name=N'createTime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'΢ÐŽ»Ò××é¼þϵ¥Ç°Öüì²é' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsCheckBeforeAddOrder'
GO