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

来源：用户分享时间：2025/5/18 7:06:35 本文由

loading 分享下载这篇文档手机版

说明：文章内容仅供预览，部分内容可能不全，需要完整文档或者需要复制内容，请下载word后使用。下载word有问题请添加微信号:xxxxxxx或QQ：xxxxxx 处理（尽可能给您提供完整文档），感谢您的支持与谅解。

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

搜索更多关于：数据库设计说明书 - 完整版的文档

数据库设计说明书 - 完整版.doc 将本文的Word文档下载到电脑，方便复制、编辑、收藏和打印

下载这篇word文档

本文链接：https://www.diyifanwen.net/c0zoae44w897e16h2fbzu_12.html（转载请注明文章来源）