完整的开发文档数据库设计说明书

第四章 运用设计

4.1 数据字典设计

无说明。

4.2 安全保密设计

通过区分不同的访问者、不同的访问类型和不同的数据对象，进行分别对待而获得的数据库安全保密设计考虑。对数据库设计中涉及到的各种项目，如数据项、记录、系、文卷、模式、子模式等一般要建立起数据保护措施，以说明它的标识符、同义名及有关信息。数据库由专门数据库管理用员对数据库操作，需要注意以下几项安全问题：

访问安全 、网络安全 、传输安全 、备份安全 、数据安全

4.3 数据库实施

4.3.1 创建数据库

/****** 对象: Database [DB_OA] 脚本日期: 07/02/2009 20:45:31 ******/ CREATE DATABASE DB_OA

4.3.2 创建表

USE [BBSDataTest] GO

/****** 对象: Table [dbo].[User] 脚本日期: 07/02/2009 20:48:01 ******/ CREATE TABLE [dbo].[User](

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

[ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [LoginName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [Name] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [PassWord] [char](50) COLLATE Chinese_PRC_CI_AS NULL,

[CompanyEmail] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL, [Email] [varchar](2000) COLLATE Chinese_PRC_CI_AS NULL, [MSN] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, [QQ] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [Skype] [varchar](1000) COLLATE Chinese_PRC_CI_AS NULL,

(

[Mobile] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, [Tel] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, [SmallTel] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [DeptID] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,

[PositionScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [IsDelete] [int] NULL CONSTRAINT [DF_User_IsDelete] DEFAULT (0),

CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED

[ID] ASC

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

/****** 对象: Table [dbo].[Position] 脚本日期: 07/02/2009 20:51:09 ******/ CREATE TABLE [dbo].[Position]( (

[ID] ASC

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

/****** 对象: Table [dbo].[Degree] 脚本日期: 07/02/2009 20:52:01 ******/ CREATE TABLE [dbo].[Degree]( (

[ID] ASC

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

/****** 对象: Table [dbo].[Temp_Dept] 脚本日期: 07/02/2009 20:53:22 ******/ REATE TABLE [dbo].[Temp_Dept]( (

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

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

[ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [DegName] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL, [ID] [int] IDENTITY(1,1) NOT NULL,

[ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [PosName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,

CONSTRAINT [PK_POSITION] PRIMARY KEY CLUSTERED

CONSTRAINT [PK_DEGREE] PRIMARY KEY CLUSTERED

CONSTRAINT [PK_Temp_Dept] PRIMARY KEY CLUSTERED

[ID] ASC

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

/****** 对象: Table [dbo].[Feedback] 脚本日期: 07/02/2009 20:56:27 ******/ CREATE TABLE [dbo].[Feedback]( (

[ID] ASC

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

/****** 对象: Table [dbo].[ReNew] 脚本日期: 07/02/2009 20:55:13 ******/ CREATE TABLE [dbo].[ReNew]( (

[ID] ASC

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

/****** 对象: Table [dbo].[CallBoard] 脚本日期: 07/02/2009 21:00:15 ******/ CREATE TABLE [dbo].[RetchTemp_CallBoard](

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

[Title] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, [Content] [text] COLLATE Chinese_PRC_CI_AS NULL,

[SendID] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [SendTime] [smalldatetime] NULL,

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

[ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [IsDelete] [int] NULL,

[Title] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL, [SubmitTime] [smalldatetime] NULL, [SysTime] [datetime] NULL,

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

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

[IsDelete] [int] NULL CONSTRAINT [DF_Feedback_IsDelete] DEFAULT ((0)), [Feedbacker] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [SysTime] [datetime] NULL,

[Content] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL, [Photo] [image] NULL,

CONSTRAINT [PK_Feedback] PRIMARY KEY CLUSTERED

PRIMARY KEY CLUSTERED

(

[IsDelete] [bit] NULL,

CONSTRAINT [PK_RetchTemp_CallBoard] PRIMARY KEY CLUSTERED

[ID] ASC

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

/****** 对象: Table [dbo].[CallState] 脚本日期: 07/02/2009 21:01:46 ******/ CREATE TABLE [dbo].[RetchTemp_CallState]( (

[ID] ASC

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

/****** 对象: Table [dbo].[Affair] 脚本日期: 07/02/2009 21:08:41 ******/ CREATE TABLE [dbo].[AffairDealInfo]( (

[ID] ASC

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

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

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

[IsDelete] [int] NULL CONSTRAINT [DF_AffairDealInfo_IsDelete] DEFAULT [AffairID] [int] NULL,

[AffairApplyID] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [AffairDealID] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [StartTime] [datetime] NULL, [EndTime] [datetime] NULL,

[AffairInputTime] [datetime] NULL,

[AffairTypeID] [int] NULL CONSTRAINT [DF_AffairDealInfo_AffairTypeID] [Cause] [text] COLLATE Chinese_PRC_CI_AS NULL,

[ReMark] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, [ID] [int] IDENTITY(1,1) NOT NULL,

[ClassID] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [ClassName] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,

CONSTRAINT [PK_RetchTemp_CallState] PRIMARY KEY CLUSTERED

(0),

DEFAULT (0),

CONSTRAINT [PK_AffairDealInfo] PRIMARY KEY CLUSTERED