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

[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

/****** 对象: Table [dbo].[AffairInfo] 脚本日期: 07/02/2009 21:09:57 ******/ GO

CREATE TABLE [dbo].[AffairInfo](

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

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

[IsDelete] [int] NULL CONSTRAINT [DF_AffairInfo_IsDelete] DEFAULT (0), [CommCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [AffairName] [varchar](300) COLLATE Chinese_PRC_CI_AS NULL, [AffairContent] [nvarchar](2000) COLLATE Chinese_PRC_CI_AS NULL, [AffairInputTime] [datetime] NULL,

[State] [int] NULL CONSTRAINT [DF_AffairInfo_State] DEFAULT (1), [Important] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT

[DF_AffairInfo_CommID] DEFAULT (0),

[DF_AffairInfo_Import] DEFAULT (0),

CONSTRAINT [PK_AffairInfo] PRIMARY KEY CLUSTERED (

[ID] ASC

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

/****** 对象: Table [dbo].[AffType] 脚本日期: 07/02/2009 21:10:23 ******/ CREATE TABLE [dbo].[AffTypeInfo]( (

[ID] ASC

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

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

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

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

[IsDelete] [int] NULL CONSTRAINT [DF_BrowseRecord_IsDelete] DEFAULT (0), [FatherCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [OriginPagePath] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL, [PagePath] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL, [AccessTime] [datetime] NULL, [ExitTime] [datetime] NULL,

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

[AffTypeName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [AffTypeID] [int] NULL,

CONSTRAINT [PK_AffTypeInfo] PRIMARY KEY CLUSTERED

CONSTRAINT [PK_BrowseRecord] PRIMARY KEY CLUSTERED

(

[ID] ASC

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

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

[ID] ASC

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

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

[ID] ASC

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

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

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

[Scantycode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [CompanyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [CommName] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, [CommContent] [varchar](2000) COLLATE Chinese_PRC_CI_AS NULL, [CommTime] [smalldatetime] NULL,

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

[CommTypeName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [CommTypeID] [int] NULL,

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

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

[IsDelete] [int] NULL CONSTRAINT [DF_ClientRecord_IsDelete] DEFAULT (0), [IPAddr] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [LoginTime] [datetime] NULL, [ExitTime] [datetime] NULL,

[UserScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [IPArea] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,

CONSTRAINT [PK_ClientRecord] PRIMARY KEY CLUSTERED

CONSTRAINT [PK_CommTypeInfo] PRIMARY KEY CLUSTERED