数据库设计说明书 - 完整版

/****** 对象: Table [dbo].[Meeting] 脚本日期: 07/02/2009 21:24:27 ******/ CREATE TABLE [dbo].[Meeting]( (

[ID] ASC

)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO

/*** 对象: Table [dbo].[MeetingInfo] 脚本日期: 07/02/2009 21:25:12 ***/ CREATE TABLE [dbo].[MeetingInfo]( (

[ID] ASC

)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO

/****** 对象: Table [dbo].[Message] 脚本日期: 07/02/2009 21:26:02 ******/ CREATE TABLE [dbo].[Message](

[ID] [int] IDENTITY(1,1) NOT NULL,

[ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [SendID] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [GetID] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [Title] [varchar](1000) COLLATE Chinese_PRC_CI_AS NULL, [ID] [int] IDENTITY(1,1) NOT NULL,

[ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [MeetingTime] [datetime] NULL,

[MeetingNum] [nchar](50) COLLATE Chinese_PRC_CI_AS NULL,

[MeetingAddress] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [MeetingTitle] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL, [MeetingContain] [varchar](2000) COLLATE Chinese_PRC_CI_AS NULL, [MeetingReply] [int] NULL,

[MeetingUser] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [MeetingExcuse] [varchar](2000) COLLATE Chinese_PRC_CI_AS NULL, [MeetingUpdateTime] [smalldatetime] NULL,

[MeetingUpdateUser] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [ID] [int] IDENTITY(1,1) NOT NULL,

[ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [MeetingCompere] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [SendTime] [datetime] NULL,

[MeetingJionUser] [varchar](2000) COLLATE Chinese_PRC_CI_AS NULL, [Content] [varchar](5000) COLLATE Chinese_PRC_CI_AS NULL, [State] [int] NULL,

CONSTRAINT [PK_MEETING] PRIMARY KEY CLUSTERED

CONSTRAINT [PK_MEETINGINFO] PRIMARY KEY CLUSTERED

(

[Content] [text] COLLATE Chinese_PRC_CI_AS NULL, [SendTime] [datetime] NULL, [IsReply] [bit] NULL, [IsRead] [bit] NULL, [IsOpen] [bit] NULL,

[MessState] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,

[SendDelete] [int] NULL CONSTRAINT [DF_Message_SendDelete] DEFAULT (0), [GetDelete] [int] NULL CONSTRAINT [DF_Message_GetDelete] DEFAULT (0),

CONSTRAINT [PK_MESSAGE] PRIMARY KEY CLUSTERED

[ID] ASC

)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

/****** 对象: Table [dbo].[Plm_Goal] 脚本日期: 07/02/2009 21:26:40 ******/ CREATE TABLE [dbo].[Plm_Goal]( (

[ID] ASC

)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

/****** 对象: Table [dbo].[Plm_Plan] 脚本日期: 07/02/2009 21:27:58 ******/ CREATE TABLE [dbo].[Plm_Plan](

[ID] [int] IDENTITY(1,1) NOT NULL,

[IsDelete] [int] NULL CONSTRAINT [DF_Plm_Plan_IsDelete] DEFAULT (0), [ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [ID] [int] IDENTITY(1,1) NOT NULL,

[IsDelete] [int] NULL CONSTRAINT [DF_Plm_Goal_IsDelete] DEFAULT (0), [ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [GoalTitle] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL, [SetUser] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [ReceiveUser] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [BeginTime] [datetime] NULL, [EndTime] [datetime] NULL, [SysTime] [datetime] NULL,

[GoalContent] [text] COLLATE Chinese_PRC_CI_AS NULL,

[GoalLevel] [int] NULL CONSTRAINT [DF_Plm_Goal_GoalLevel] DEFAULT (0), [PlanCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [IsTemp] [int] NULL CONSTRAINT [DF_Plm_Goal_Temp] DEFAULT (0), [IsLook] [int] NULL CONSTRAINT [DF_Plm_Goal_IsLook] DEFAULT ((0)),

[DF_Plm_Goal_PlanCode] DEFAULT (0),

CONSTRAINT [PK_Plm_Goal] PRIMARY KEY CLUSTERED

(

[GoalCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [PlanUser] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [ReceiveUser] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [PlanTitle] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL, [BeginTime] [datetime] NULL, [EndTime] [datetime] NULL,

[PlanContent] [text] COLLATE Chinese_PRC_CI_AS NULL, [SysTime] [datetime] NULL,

[PlanState] [int] NULL CONSTRAINT [DF_Plm_Plan_PlanState] DEFAULT (0), [ApprovalState] [int] NULL CONSTRAINT [DF_Plm_Plan_ApprovalState] DEFAULT [PlanLevel] [int] NULL CONSTRAINT [DF_Plm_Plan_PlanLevel] DEFAULT (0), [IsTemp] [int] NULL CONSTRAINT [DF_Plm_Plan_Temp] DEFAULT (0), [Cause] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,

[Workload] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [IsLook] [int] NULL CONSTRAINT [DF_Plm_Plan_IsLook] DEFAULT ((0)),

(0),

[DF_Plm_Plan_Workload] DEFAULT (0),

CONSTRAINT [PK_Plm_Plan] PRIMARY KEY CLUSTERED

[ID] ASC

)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]