表名：ZL_UserBaseField












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1FieldIDint40是是 否 模型字段ID
2FieldNamenvarchar500   否 字段名称
3FieldAliasnvarchar500   否 字段别名
4FieldTipsnvarchar500   是 字段说明
5Descriptionnvarchar2550   是 字段描述
6IsNotNullbit10   是0字段允许空，1：允许，2：不允许
7FieldTypenvarchar500   否 字段类型
8Contentntext160   是 字段内容
9OrderIdint40   是1排序
10ShowListbit10   是 列表显示。1：显示，2不显示
11ShowWidthint40   是0显示列宽度
12NoEditint40   是0是否允许编辑
13IsCopyint40   是 是否是复制

简要说明：

用户模型字段表

GO
CREATE TABLE [dbo].[ZL_UserBaseField](
[FieldID] [int] IDENTITY(1,1) NOT NULL,
[FieldName] [nvarchar](50) NOT NULL,
[FieldAlias] [nvarchar](50) NOT NULL,
[FieldTips] [nvarchar](50) NULL,
[Description] [nvarchar](255) NULL,
[IsNotNull] [bit] NULL CONSTRAINT [DF_ZL_UserBaseField_IsNotNull]  DEFAULT (0),
[FieldType] [nvarchar](50) NOT NULL,
[Content] [ntext] NULL,
[OrderId] [int] NULL CONSTRAINT [DF_ZL_UserBaseField_OrderId]  DEFAULT (1),
[ShowList] [bit] NULL,
[ShowWidth] [int] NULL CONSTRAINT [DF_ZL_UserBaseField_ShowWidth]  DEFAULT (0),
[NoEdit] [int] NULL CONSTRAINT [DF_ZL_UserBaseField_NoEdit]  DEFAULT (0),
[IsCopy] [int] NULL,
CONSTRAINT [PK_ZL_UserBaseField] PRIMARY KEY NONCLUSTERED
([FieldID] ASC
)WITH (IGNORE_DUP_KEY = OFF) 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_UserBaseField', @level2type=N'COLUMN', @level2name=N'FieldName'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'字段别名' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_UserBaseField', @level2type=N'COLUMN', @level2name=N'FieldAlias'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'字段说明' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_UserBaseField', @level2type=N'COLUMN', @level2name=N'FieldTips'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'字段描述' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_UserBaseField', @level2type=N'COLUMN', @level2name=N'Description'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'字段允许空，1：允许，2：不允许' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_UserBaseField', @level2type=N'COLUMN', @level2name=N'IsNotNull'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'字段类型' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_UserBaseField', @level2type=N'COLUMN', @level2name=N'FieldType'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'字段内容' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_UserBaseField', @level2type=N'COLUMN', @level2name=N'Content'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_UserBaseField', @level2type=N'COLUMN', @level2name=N'OrderId'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'列表显示。1：显示，2不显示' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_UserBaseField', @level2type=N'COLUMN', @level2name=N'ShowList'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'显示列宽度' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_UserBaseField', @level2type=N'COLUMN', @level2name=N'ShowWidth'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'是否允许编辑' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_UserBaseField', @level2type=N'COLUMN', @level2name=N'NoEdit'

--注意：将清空全表数据

detele from ZL_UserBaseField

--注意：将删除整个表

drop table ZL_UserBaseField

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_UserBaseField