表名：ZL_Mis












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是是 否  
2Titlenvarchar2550   是 标题
3Rateint40   是 完成比例(%)
4ComTimedatetime83   是 完成日期
5limitTimedatetime83   是 时限，倒数日期
6Typeint40   是 类型：0事业 ,1财富,2 家庭,3 休闲,4 学习
7Contentntext160   是 描述
8Statusint40   是 状态：0未启动 ,1进行中,2 已完成
9Joinernvarchar2550   是 参与人
10CreateTimedatetime83   是 创建时间
11ParentIDint40   是 父ID
12Inputernvarchar2550   是 创建人
13Picnvarchar2550   是 梦想图

简要说明：

用户日程安排

GO
CREATE TABLE [dbo].[ZL_Mis](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Title] [nvarchar](255) NULL,
[Rate] [int] NULL,
[ComTime] [datetime] NULL,
[limitTime] [datetime] NULL,
[Type] [int] NULL,
[Content] [ntext] NULL,
[Status] [int] NULL,
[Joiner] [nvarchar](255) NULL,
[CreateTime] [datetime] NULL,
[ParentID] [int] NULL,
[Inputer] [nvarchar](255) NULL,
[Pic] [nvarchar](255) NULL,
CONSTRAINT [PK_ZL_Mis] 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] TEXTIMAGE_ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'完成比例(%)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Mis', @level2type=N'COLUMN',@level2name=N'Rate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'完成日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Mis', @level2type=N'COLUMN',@level2name=N'ComTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'时限，倒数日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Mis', @level2type=N'COLUMN',@level2name=N'limitTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型：0事业 ,1财富,2 家庭,3 休闲,4 学习' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Mis', @level2type=N'COLUMN',@level2name=N'Type'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Mis', @level2type=N'COLUMN',@level2name=N'Content'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态：0未启动 ,1进行中,2 已完成' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Mis', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'参与人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Mis', @level2type=N'COLUMN',@level2name=N'Joiner'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Mis', @level2type=N'COLUMN',@level2name=N'ParentID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Mis', @level2type=N'COLUMN',@level2name=N'Inputer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'梦想图' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Mis', @level2type=N'COLUMN',@level2name=N'Pic'

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

detele from ZL_Mis

--注意：将删除整个表

drop table ZL_Mis

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

TRUNCATE table ZL_Mis