【正文】 ](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_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] [int] IDENTITY(1,1) NOT NULL, [AffTypeName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [AffTypeID] [int] NULL, CONSTRAINT [PK_AffTypeInfo] PRIMARY KEY CLUSTERED ( [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, 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] [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 ( [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] [int] IDENTITY(1,1) NOT NULL, [CommTypeName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [CommTypeID] [int] NULL, CONSTRAINT [PK_CommTypeInfo] PRIMARY KEY CLUSTERED ( [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, [CommTypeID] [int] NULL, [CommClient] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [IsDelete] [int] NULL CONSTRAINT [DF_CommunicateInfo_IsDelete] DEFAULT (0), [ReMark] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_CommunicateInfo] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GO/*** 對象: Table [dbo].[Company_Project] 腳本日期: 07/02/2009 21:15:32 ***/CREATE TABLE [dbo].[Company_Project]( [ID] [int] IDENTITY(1,1) NOT NULL, [ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [IsDelete] [int] NULL CONSTRAINT [DF_Company_Project_IsDelete] DEFAULT (0), [CompanyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [ProjectName] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_Company_Project] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GO/** 對象: Table [dbo].[Company_Pro_Type] 腳本日期: 07/02/2009 21:18:23 ***/CREATE TABLE [dbo].[Company_Project_Type]( [ID] [int] IDENTITY(1,1) NOT NULL, [ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [IsDelete] [int] NULL CONSTRAINT [DF_Company_Project_Type_IsDelete] DEFAULT (0), [ProjectCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [ProjectType] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_Company_Project_Type] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GO/**** 對象: Table [dbo].[Company_User] 腳本日期: 07/02/2009 21:18:59 ****/CREATE TABLE [dbo].[Company_User]( [ID] [int] IDENTITY(1,1) NOT NULL, [ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [CompanyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [UserCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [IsLook] [int] NULL CONSTRAINT [DF_Company_User_IsLook] DEFAULT (0), [IsEdit] [int] NULL CONSTRAINT [DF_Company_User_IsEdit] DEFAULT (0), [IsDelete] [int] NULL CONSTRAINT [DF_Company_User_IsDelete] DEFAULT (0), CONSTRAINT [PK_Company_User] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GO/** 對象: Table [dbo].[CompanyInfo] 腳本日期: 07/02/2009 21:19:34 ****/CREATE TABLE [dbo].[CompanyInfo]( [ID] [int] IDENTITY(1,1) NOT NULL, [ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [CorpName] [varchar](500) COLLATE Chinese_PRC_CI_AS NOT NULL, [CorpAddress] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, [CorpTel] [varchar](300) COLLATE Chinese_PRC_CI_AS NULL, [CorpFax] [varchar](300) COLLATE Chinese_PRC_CI_AS NULL, [CorpEmail] [varchar](300) COLLATE Chinese_PRC_CI_AS NULL, [CorpPrincipal] [varchar](300) COLLATE Chinese_PRC_CI_AS NULL, [CorpAddTime] [smalldatetime] NULL, [CorpUserID] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [CorpLinkMan] [varchar](300) COLLATE Chine