Ylbtech-kefuyunwei (Service operation and Maintenance inspection system)-Database design

Ylbtech-databasedesgin:ylbtech-kefuyunwei (Service operation and Maintenance inspection system)-Database design

Databasename:kefuyunwei

Model:admin User background Management data design

Type: Management software

Url:

1.A, Database diagram (db Diagram) back to top

1.B, database design script back to top

 UseMasterGo-- =============================================--Customer service operation and maintenance services examination and record system--author:ylb--pubdate:14:03 2013-03-18-- =============================================IF EXISTS(SELECT *         fromMaster.. sysdatabasesWHEREName=N'Kefuyunwei')    DROP DATABASEKefuyunweiGOCREATE DATABASEKefuyunweiGO UseKefuyunwei-- =============================================--1, Service log--author:ylb--pubdate:14:03 2013-03-18-- =============================================Create TableServerlog (Logidint Primary Key Identity(1,1), CustomerNamevarchar( $),--Customer NameCompanyvarchar( $),--Affiliated UnitsContactvarchar( -),--Contact Phone number (or QQ)Introvarchar( -),--Problem Description--, 6Productvarchar( -),--Affiliated ProductsAddressvarchar( -),--Customer LocationSolutionvarchar( -),--Solution SolutionsStatevarchar( -),--status (Resolved, unresolved, follow up)Typesolutionvarchar( -),--solution (on-site, phone, remote, phone, and remote)--, Onepubdatedatetime default(getdate()),--Resolution TimeRemarkvarchar( $)--Notes)Go--AddInsert  intoServerlog ()Values()--Update--SelectSelectLogid,customername,company,contact,intro, product,address,solution,state,typesolution, Pubdate,remark fromServerlogOrder  byLogiddesc--DeleteServerlogwhereLogid=0--

View Code

1.C, functional implementation code (function implementation codes) back to top

Ylbtech Source: http://ylbtech.cnblogs.com/ This article is copyright to the author and the blog Park, Welcome to reprint, but without the consent of the author must retain this paragraph, and in the article page obvious location to the original link, otherwise reserves the right to pursue legal responsibility.

Ylbtech-kefuyunwei (Service operation and Maintenance inspection system)-Database design