/****** 对象: 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]