GO
CREATE TABLE [dbo].[ZL_OrderBaseField](
[FieldID] [int] IDENTITY(1,1) NOT NULL,
[FieldName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[FieldAlias] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[FieldTips] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Description] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[IsNotNull] [bit] NULL CONSTRAINT [DF_ZL_OrderBaseField_IsNotNull]  DEFAULT (0),
[FieldType] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[OrderId] [int] NULL CONSTRAINT [DF_ZL_OrderBaseField_OrderId]  DEFAULT (1),
[ShowList] [bit] NULL,
[ShowWidth] [int] NULL CONSTRAINT [DF_ZL_OrderBaseField_ShowWidth]  DEFAULT (0),
[NoEdit] [int] NULL CONSTRAINT [DF_ZL_OrderBaseField_NoEdit]  DEFAULT (0),
[Type] [int] NULL,
CONSTRAINT [PK_ZL_OrderBaseField] PRIMARY KEY NONCLUSTERED
(
[FieldID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'字段名称' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_OrderBaseField', @level2type=N'COLUMN',@level2name=N'FieldName'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'字段别名' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_OrderBaseField', @level2type=N'COLUMN',@level2name=N'FieldAlias'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'字段说明' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_OrderBaseField', @level2type=N'COLUMN',@level2name=N'FieldTips'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'字段描述' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_OrderBaseField', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'字段允许空，1：允许，2：不允许' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_OrderBaseField', @level2type=N'COLUMN',@level2name=N'IsNotNull'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'字段类型' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_OrderBaseField', @level2type=N'COLUMN',@level2name=N'FieldType'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'字段内容' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_OrderBaseField', @level2type=N'COLUMN',@level2name=N'Content'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_OrderBaseField', @level2type=N'COLUMN',@level2name=N'OrderId'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'列表显示。1：显示，2不显示' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_OrderBaseField', @level2type=N'COLUMN',@level2name=N'ShowList'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'显示列宽度' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_OrderBaseField', @level2type=N'COLUMN',@level2name=N'ShowWidth'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'是否允许修改' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_OrderBaseField', @level2type=N'COLUMN',@level2name=N'NoEdit'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'模型类型：0为网站订单,1为店铺订单' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_OrderBaseField', @level2type=N'COLUMN',@level2name=N'Type'