基于c的企業(yè)客戶信息數(shù)據(jù)庫應用系統(tǒng)開發(fā)綜合實驗(編輯修改稿)
2025-07-16 12:32 本頁面
【文章內(nèi)容簡介】 ClientStaffer表：CREATE TABLE [dbo].[ClientStaffer]( [ClientStafferID] [char](10) NOT NULL, [ClientID] [char](10) NOT NULL, [ClientStafferName] [char](10) NOT NULL, [Sex] [char](10) NULL, [Birthday] [smalldatetime] NULL, [Nationality] [char](50) NULL, [Marriage] [char](50) NULL, [PartyFeature] [char](50) NULL, [EducationLevel] [char](50) NULL, [GraduateSchool] [char](50) NULL, [Telephone] [char](50) NULL, [Postcode] [char](50) NULL, [Mobile] [char](50) NULL, [MSN] [char](50) NULL, [Email] [char](50) NULL, [Department] [char](50) NULL, [Positions] [char](50) NULL, [Duty] [char](50) NULL, [Address] [char](50) NULL, [Favourit] [char](100) NULL, [Remark] [char](100) NULL, CONSTRAINT [PK_ClientStaffer] PRIMARY KEY CLUSTERED ( [ClientStafferID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]ContactHistory表：CREATE TABLE [dbo].[ContactHistory]( [ContactHistoryId] [char](10) NOT NULL, [ClientID] [char](10) NOT NULL, [contactDate] [smalldatetime] NOT NULL, [ourStaff] [char](10) NOT NULL, [clientStaff] [char](10) NOT NULL, [contactSubject] [char](50) NOT NULL, [contact] [char](100) NULL, [ClientSuggest] [char](100) NULL, [contactSummary] [char](100) NULL, [contactResult] [char](10) NULL, CONSTRAINT [PK_ContactHistory] PRIMARY KEY CLUSTERED ( [ContactHistoryId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]contractMag表：CREATE TABLE [dbo].[contractMag]( [contractID] [char](10) NOT NULL, [contractName] [char](50) NOT NULL, [formDate] [smalldatetime] NOT NULL, [Total] [money] NOT NULL, [ClientID] [char](10) NOT NULL, [clientStaffer] [char](10) NOT NULL, [ourStaffer] [char](10) NOT NULL, [thirdStaffer] [char](10) NOT NULL, [effectiveDate] [smalldatetime] NOT NULL, [endDate] [smalldatetime] NOT NULL, [remark] [char](100) NULL, CONSTRAINT [PK_contractMag] PRIMARY KEY CLUSTERED ( [contractID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]SystUser表：CREATE TABLE [dbo].[SystUser]( [UserID] [char](10) NOT NULL, [UserName] [char](10) NOT NULL, [Passward] [char](10) NOT NULL, [Userrole] [char](10) NOT NULL, CONSTRAINT [PK_SystUser] PRIMARY KEY CLUSTERED ( [UserID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]建立索引index_allfounds_desc：create index index_allfounds_desc on[dbo].[Client]([AllFunds] desc)插入測試數(shù)據(jù)：建立反映銷售人員的用戶視圖：CREATE VIEW [dbo].[USER_VIEW] ASSELECT * F
公司管理相關推薦
鄂ICP備17016276號-1