海馬汽車(chē)經(jīng)銷商管理系統(tǒng)表

1、(1)數(shù)據(jù)庫(kù)表匯總表名功能說(shuō)明表類型(基礎(chǔ)表？業(yè)務(wù)表？)BM_V_Contact車(chē)輛聯(lián)系人，車(chē)輛聯(lián)系人與車(chē)輛綁定基礎(chǔ)表BM_V_Users Data車(chē)輛使用人資料，當(dāng)前使用車(chē)的使用人基礎(chǔ)表BM_VehicleInfo車(chē)輛信息，關(guān)于車(chē)輛的信息基礎(chǔ)表BM_Addition Item附加項(xiàng)目，如外拖車(chē)費(fèi)、外烤漆費(fèi)等基礎(chǔ)表BM_Trace Operation跟蹤操作基礎(chǔ)表BM _StaffQualification員工學(xué)歷基礎(chǔ)表BM_WorkGroup班組，值班的工作小組基礎(chǔ)表BM_Work Hours Projec工時(shí)項(xiàng)目，包括工時(shí)單價(jià)，折扣等一些關(guān)于 工時(shí)的項(xiàng)目基礎(chǔ)表BM_MP_Selection

2、保養(yǎng)項(xiàng)目選擇基礎(chǔ)表BM_Standard Materia標(biāo)準(zhǔn)資料基礎(chǔ)表BM_SM Property標(biāo)準(zhǔn)資料屬性基礎(chǔ)表BM_Department部門(mén)基礎(chǔ)表BM_Menu菜單基礎(chǔ)表BM_Storage倉(cāng)庫(kù)基礎(chǔ)表AttributeCollect屬性集合表基礎(chǔ)表AttributeDetail屬性明細(xì)表基礎(chǔ)表BM_branchStore支店表基礎(chǔ)表BM_CBirthAlert顧客生日提醒基礎(chǔ)表BM_claimMainPro理賠維修項(xiàng)目基礎(chǔ)表BM_claimResultOrd理賠結(jié)果單基礎(chǔ)表BM_comHardware公司硬件表基礎(chǔ)表BM_CompanyInfo公司資料基礎(chǔ)表BM_JobType工種基礎(chǔ)表

3、BM_maintainRVFD維修回訪反饋表基礎(chǔ)表BM_maintainRVCon維修回訪內(nèi)容表基礎(chǔ)表BM_maintainTech維修技師表基礎(chǔ)表BM_preserveAlert保養(yǎng)提醒基礎(chǔ)表BM_O_Iinformation車(chē)主信息基礎(chǔ)表BM_PackagePro套餐項(xiàng)目表基礎(chǔ)表BM_packgePart套餐配件表基礎(chǔ)表BM_part配件表基礎(chǔ)表BM_sendOld寄出舊件表基礎(chǔ)表BM_SExpressionRe員工表現(xiàn)記錄基礎(chǔ)表BM_SP_BackupBusiness系統(tǒng)參數(shù)備份業(yè)務(wù)表基礎(chǔ)表BM_SP_maintainSer系統(tǒng)參數(shù)維修服務(wù)表基礎(chǔ)表BM_SP_sysManage系統(tǒng)參數(shù)系

4、統(tǒng)管理表基礎(chǔ)表BM_SP_VehicleSales系統(tǒng)參數(shù)整車(chē)銷售表基礎(chǔ)表BM_staffBaseData員工基本資料基礎(chǔ)表BM_staffRecord員工檔案表基礎(chǔ)表BM_staffRelation員工家屬表基礎(chǔ)表BM_staffwelfare員工福利表基礎(chǔ)表BM_Store庫(kù)存表基礎(chǔ)表BM_user用戶表基礎(chǔ)表BM_V_Properties車(chē)輛屬性表基礎(chǔ)表BM_VR_Remind車(chē)輛續(xù)保提醒表基礎(chǔ)表BM_WH_ Project Detail工時(shí)項(xiàng)目明細(xì)表基礎(chǔ)表BM_Work Station工位表基礎(chǔ)表BM_staffworkExper員工工作經(jīng)歷表基礎(chǔ)表BM_yearAlert年審提醒表基

5、礎(chǔ)表BM_yearGoal年度目標(biāo)表基礎(chǔ)表BM_packgeDet套餐明細(xì)表基礎(chǔ)表BM_vehicleBrand汽車(chē)品牌表基礎(chǔ)表LA_module模塊表基礎(chǔ)表LA_opType操作類型表基礎(chǔ)表LA_perGroup權(quán)限組表基礎(chǔ)表LA_perModule保養(yǎng)單表基礎(chǔ)表PW_AdiMainPro建議維修項(xiàng)目表業(yè)務(wù)表PW_BookList預(yù)約單表業(yè)務(wù)表PW_BookMaintenPro預(yù)約維修項(xiàng)目表業(yè)務(wù)表PW_BookParts預(yù)約配件表業(yè)務(wù)表PW_claimNum理賠單表業(yè)務(wù)表PW_claimPart理賠配件表業(yè)務(wù)表PW_claimPictureInfo理賠圖片信息表業(yè)務(wù)表PW_DebtSettl

6、e欠款結(jié)算表業(yè)務(wù)表PW_debtSettleDet欠款結(jié)算明細(xì)表業(yè)務(wù)表PW_demandPartDet需求配件明細(xì)表業(yè)務(wù)表PW_DiagnosRecords診斷記錄表業(yè)務(wù)表PW_DInsurance代辦保險(xiǎn)表業(yè)務(wù)表PW_DInsuranceDet代辦保險(xiǎn)明細(xì)單表業(yè)務(wù)表PW_DispatchList派工單表業(yè)務(wù)表PW_FinanCash財(cái)務(wù)收銀單表業(yè)務(wù)表PW_maintainDP維修需求配件表1業(yè)務(wù)表PW_maintainItems維修項(xiàng)目表業(yè)務(wù)表PW_MaintenOrder維修工單表業(yè)務(wù)表PW_maintainRVInfo維修回訪信息表業(yè)務(wù)表PW_MaintenOrdDetail維修工單明細(xì)

7、表業(yè)務(wù)表PW_maintainOrder需求配件明細(xì)表業(yè)務(wù)表PW_demandPart需求配件表業(yè)務(wù)表PW_MRVFollow維修回訪跟進(jìn)表業(yè)務(wù)表PW_OutgoingList出庫(kù)單表業(yè)務(wù)表PW partBook配件訂單表業(yè)務(wù)表PW_preservePlan保養(yǎng)計(jì)劃表業(yè)務(wù)表PW_RVfeedback回訪反饋表業(yè)務(wù)表PW_settleAccounts結(jié)算單業(yè)務(wù)表PW_sueDealRec投訴處理記錄表業(yè)務(wù)表PW_sueNum投訴單表業(yè)務(wù)表PW_unqualifiedMPro不合格維修項(xiàng)目表業(yè)務(wù)表PW_RVisitIntent維修回訪意向表業(yè)務(wù)表PW_warehouseAllocat倉(cāng)庫(kù)調(diào)撥單表業(yè)

8、務(wù)表BM_V_Iinformation車(chē)輛信息業(yè)務(wù)表PW_preserveOrd保養(yǎng)單表業(yè)務(wù)表Standard Material標(biāo)準(zhǔn)資料表業(yè)務(wù)表BM_Department部門(mén)表業(yè)務(wù)表(3)表結(jié)構(gòu)表名：BM_VehicleInfo (車(chē)輛信息表)字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值VehicleInfo id標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NoOwnerInfoID車(chē)主信息IDint5整數(shù)范圍YESFile Number檔案號(hào)nchar20字符、數(shù)字YESLicensePlateNumber車(chē)牌號(hào)nchar20字符、數(shù)字YESModel Code車(chē)型代碼nchar20字符、數(shù)字YESVIN

9、 CodeVIN碼nchar20字符、數(shù)字YESEngine Number發(fā)動(dòng)機(jī)號(hào)nchar20字符、數(shù)字YESTheGearboxNumber變速箱號(hào)碼nchar20字符、數(shù)字YESVS_Car Models變速車(chē)廂型號(hào)nchar20字符、數(shù)字YESKey Number鑰匙號(hào)nchar20字符、數(shù)字YESShift Way換擋方式nchar20字符、數(shù)字YESCar Model車(chē)型年款nchar20字符、數(shù)字YESDelivery Capacity排量nchar20字符、數(shù)字YESEquipped Code裝備代碼nchar20字符、數(shù)字YESCar Color車(chē)身顏色nchar10字符、數(shù)

10、字YESDate of Production出廠日期datetime20字符、數(shù)字YESFuel Type燃料種類nchar20字符、數(shù)字YESPurchase Date購(gòu)車(chē)日期datetime20字符、數(shù)字YESCar Mileage購(gòu)車(chē)?yán)锍蘢ecimal(18,3 )字符、數(shù)字YESUse用途nchar20字符、數(shù)字YESSales Unit銷售單位nchar20字符、數(shù)字YESV_Brand車(chē)輛品牌nchar20字符、數(shù)字YESModel Brief-Code車(chē)型簡(jiǎn)碼nchar20字符、數(shù)字YESIn Warranty Period在保修期內(nèi)bit5字符、數(shù)字YESUser Manage

11、ment用戶管理bit5字符、數(shù)字YES表名：BM_OwnerInfo （車(chē)主信息表）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn) 值OwnerInfo ID標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NoOwner Code車(chē)主代碼nchar20字符、數(shù)字YESOwner Name車(chē)主姓名nchar20字符、數(shù)字YESAD_ID_CType One屬性明細(xì)ID_客戶類型一int8整數(shù)范圍YESAD_ID_CType Two屬性明細(xì)ID_客戶類型二int8整數(shù)范圍YESAD ID_Sex屬性明細(xì)ID_性別int8整數(shù)范圍YESAddress地址nchar20字符、數(shù)字YESArea Code電話區(qū)號(hào)nchar

12、20字符、數(shù)字YESMobile Phone移動(dòng)電話nchar20字符、數(shù)字YESHome Tel住宅電話nchar20字符、數(shù)字YESOffice Tel辦公電話nchar20字符、數(shù)字YESAddress Post Code住址郵編nchar20字符、數(shù)字YESSubordinate City所屬縣市nchar50字符、數(shù)字YESWork Unit工作單位nchar50字符、數(shù)字YESPosition職務(wù)nchar50字符、數(shù)字YESAD_ID_Marital Stat us屬性明細(xì)ID_婚姻狀況int8整數(shù)范圍YESID Card No身份證號(hào)碼nchar30字符、數(shù)字YESBirthd

13、ay生日datetime20日期YESEducation Backgrou nd學(xué)歷nchar20字符、數(shù)字YESHobby愛(ài)好nchar100字符、數(shù)字YESChange Address艾更地址nchar100字符、數(shù)字YESPostcode郵編nchar20字符、數(shù)字YESNationality國(guó)籍nchar50字符、數(shù)字YESEmailEmailnchar50字符、數(shù)字YESC_Return time方便回訪時(shí)間datetime20日期YESOwner Photo車(chē)主照片nchar100字符、數(shù)字YES表名：PW_MaintenOrder 維修工單表字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否

14、為空默認(rèn)值MaintenOrdID標(biāo)識(shí)字段int5整數(shù)范圍NomaintenItemsID維修項(xiàng)目IDint8整數(shù)范圍YEStypeWorkID工種IDint8整數(shù)范圍YESworkStatelD工位IDint8整數(shù)范圍YESteamID班組IDint8整數(shù)范圍YESmaintenTechID_ maintenanceTech 1維修技師ID維 修技師1int8整數(shù)范圍YESmaintenTechID_ maintenanceTech 2維修技師ID維 修技師2int8整數(shù)范圍YESWorkingHoursPro ID_againPro工時(shí)項(xiàng)目2_增 修項(xiàng)目int8整數(shù)范圍YESHMTimes

15、Amend第幾次增修D(zhuǎn)ecimal。8,2)18小數(shù)YESWHoursProID_R eworkPro工時(shí)項(xiàng)目2_返 修項(xiàng)目int8整數(shù)范圍YESQualityInspectRes ults質(zhì)檢結(jié)果nchar20字符、數(shù)字YESNumRework返工次數(shù)Decimal。8,2)18小數(shù)YESreworkTime返工時(shí)間datetime20日期YESAttributeDetID_a ccountClass屬性明細(xì)2_帳 類int8整數(shù)范圍YES表名：PW_MaintainOrdDet維修工單明細(xì)表字段名中文描述數(shù)據(jù)類型長(zhǎng) 度輸入范圍是否為空默認(rèn)值MaintainOrdDetID標(biāo)識(shí)字段int5整

16、數(shù)范圍NojobNum工單號(hào)nchar(20)20字符、數(shù)字YESBookLisID預(yù)約單IDint5整數(shù)范圍YESvehicleInfoID車(chē)輛信息IDint5整數(shù)范圍YESfacMiles進(jìn)廠里程decimal(18, 2)20字符、數(shù)字YESbusinessClass業(yè)務(wù)類別nchar(20)20字符、數(shù)字YESFacTime進(jìn)廠時(shí)間datetime20字符、數(shù)字YESsendMan送修人nchar(20)20字符、數(shù)字YESRemainoil剩余油量decimal(18, 2)20字符、數(shù)字YESadvReceive預(yù)收款decimal(18, 2)20字符、數(shù)字YESexpDealC

17、ar預(yù)計(jì)交車(chē)datetime20字符、數(shù)字YESlastinFac上次進(jìn)廠datetime20字符、數(shù)字YESReserNum預(yù)約單號(hào)nchar(20)20字符、數(shù)字YESMemType會(huì)員類別nchar(20)20字符、數(shù)字1YESInsuranceCom保險(xiǎn)公司nchar(20)20字符、數(shù)字YESAttributeDetID_vehi cleState屬性明細(xì)ID_ 車(chē)輛狀態(tài)int5整數(shù)范圍YESApno預(yù)修否bit20字符、數(shù)字YESApState預(yù)修狀態(tài)nchar(20)20字符、數(shù)字YESCarwashno洗車(chē)服務(wù)否bit20字符、數(shù)字YESoldDeal舊件處理nchar(20)

18、20字符、數(shù)字YESRingControlRecord環(huán)檢記錄nchar(100)100字符、數(shù)字YESCustomerStatement顧客陳述nchar(100)100字符、數(shù)字YESremarks備注nchar(100)100字符、數(shù)字YESbookingno預(yù)約否bit20字符、數(shù)字YESOweno欠款否bit20字符、數(shù)字YESserviceConsult服務(wù)顧問(wèn)nchar(10)10字符、數(shù)字YESMaintenOrdID維修工單IDint5整數(shù)范圍YES表名：PW_BookList （預(yù)約單表）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值BookListID標(biāo)識(shí)字段自動(dòng)增長(zhǎng)8

19、整數(shù)范圍NoBookListNum預(yù)約單號(hào)nchar20字符、數(shù)字YESVehicleInfoID車(chē)輛信息IDint8整數(shù)范圍YESBookTime預(yù)約時(shí)間datetime20日期YESAttributeDetID_Bo okWay屬性明細(xì) ID_預(yù)約方式int8整數(shù)范圍YESBookMail預(yù)約里程Decimal( 18,2)18小數(shù)YESBookState預(yù)約狀態(tài)nchar20字符、數(shù)字YESAllSum總計(jì)金額Decimal( 18,2)18小數(shù)YESFailureReasons失敗原因nchar100字符、數(shù)字YESStaffID_Accept員工ID_受理 人int8字符、數(shù)字YES

20、StaffID_receiver員工ID_接待 人int8字符、數(shù)字YESStaffID_Approve員工ID_核準(zhǔn) 人int8字符、數(shù)字YESApprovalTime核準(zhǔn)時(shí)間datetime20字符、數(shù)字YESLastInFac上次進(jìn)廠時(shí)間datetime20字符、數(shù)字YESBookSuccessno預(yù)約成功否bit1字符、數(shù)字YESStaffID change員工ID艾更int8字符、數(shù)字YES人expDealCar預(yù)約交車(chē)時(shí)間datetime20字符、數(shù)字YESBookalertTime預(yù)約提醒時(shí)間datetime20字符、數(shù)字YESexpArrivalTime預(yù)計(jì)到貨時(shí)間dateti

21、me20字符、數(shù)字YESMaintenOrderNum維修單號(hào)nchar20字符、數(shù)字YESNBookListNum新預(yù)約單號(hào)nchar20字符、數(shù)字YESOBookListNum原預(yù)約單號(hào)nchar20字符、數(shù)字YESdemandNum需求單號(hào)nchar20字符、數(shù)字YESChangeTime變更時(shí)間datetime20字符、數(shù)字YESChangeReson變更原因nchar100字符、數(shù)字YEScustomerDescript顧客描述nchar100YESremarks備注nchar100YESresReleaseno資源釋放否bit1YESeffectiveno后效否bit1YES表名：

22、BM_Addition Item （附加項(xiàng)目表）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值A(chǔ)ddition Item ID標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NoProject Code項(xiàng)目代碼nchar20字符、數(shù)字YESProject Name項(xiàng)目名稱nchar20字符、數(shù)字YESAD_ID_Project Ca tegory屬性明細(xì) ID_項(xiàng)目類別int5整數(shù)范圍YESWork Group ID班組IDint5整數(shù)范圍YESPrice價(jià)格decimal(18,2)字符、數(shù)字YESDiscount折扣decimal(18,2)字符、數(shù)字YES表名：BM_WorkGroup班組表）字段名中文描述

23、數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值Work Group ID標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NoJob Type ID工種IDint5整數(shù)范圍YESWork Group Name班組名稱nchar20字符、數(shù)字YES表名：BM_Work Hours Projec(工時(shí)項(xiàng)目表)字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為 空默認(rèn)值WH_Project ID標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NoWH_Project Detail ID工時(shí)項(xiàng)目明細(xì)IDint5整數(shù)范圍YESVehicle Type車(chē)型nchar20字符、數(shù)字YESGA_Working Hours客帳工時(shí)decimal(18,2)18小數(shù)YESIGA_

24、Working Hours內(nèi)部帳工時(shí)decimal(18,2)18小數(shù)YESStandard_Working Hours標(biāo)準(zhǔn)工時(shí)decimal(18,2)18小數(shù)YESIA_Working Hours保險(xiǎn)帳工時(shí)decimal(18,2)18小數(shù)YESWorking Hours Money工時(shí)金額decimal(18,2)18小數(shù)YESFactory Standard原廠標(biāo)準(zhǔn)nchar100字符、數(shù)字YESIf WH multiply UP是否取工時(shí)乘 單價(jià)bit1boolYESDiscount折扣decimal(18,2)18小數(shù)YESImdiscount Symbol不折扣標(biāo)志bit1boo

25、lYESDiscount Begin Date折扣開(kāi)始日期datetime20日期YESDiscount End Date折扣結(jié)束日期datetime20日期YESRemark備注nchar100字符、數(shù)字YES表名：AttributeCollect （屬性集合表）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值A(chǔ)ttributeColID標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NoAttributeColName屬性集合名稱char20字符、數(shù)字YES表名：AttributeDetail （屬性明細(xì)表（車(chē)輛狀態(tài)）字段名中文描述數(shù)據(jù)類型長(zhǎng) 度輸入范圍是否 為空默認(rèn)值A(chǔ)ttributeDetPubID標(biāo)識(shí)字段

26、自動(dòng)增長(zhǎng)5整數(shù)范圍NoAttributeDetPubFID屬性明細(xì)公共父IDint8整數(shù)范圍YESAttributeColID屬性集合IDint8整數(shù)范圍YESAttributeDetName屬性明細(xì)名稱char20字符、數(shù)字YESEffectiveno后效否bit1bolYES表名：BM_JobType （工種表）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值Job Type ID:標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NoJob Type Name工種名稱nchar20字符、數(shù)字YES表名：BM_maintainTech （維修技師表）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值maintain

27、TechID標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NostaffID員工IDint8整數(shù)范圍YESmaintainTechName維修技師名稱nchar20字符、數(shù)字YES表名：PW_unqualifiedMPro（不合格維修項(xiàng)目表）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值unqualifiedMProID標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NomaintainProID維修項(xiàng)目IDint8整數(shù)范圍YESQualityResr質(zhì)檢結(jié)果nchar20字符、數(shù)字YESreworkReson返工原因nchar100字符、數(shù)字YES表名：PW_BookMaintenPro（ 預(yù)約維修項(xiàng)目表）字段名中文描述數(shù)據(jù)類型長(zhǎng)

28、度輸入范圍是否為空默認(rèn)值BookMaintenProID標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NoBookLisID預(yù)約單IDint8整數(shù)范圍YESWHoursProID工時(shí)項(xiàng)目IDint8整數(shù)范圍YESAttributeDetID_ZL屬性明細(xì)ID_帳類int8整數(shù)范圍YESWHoursPrice工時(shí)單價(jià)Decimal。8,2)18小數(shù)YESKZWHours客帳工時(shí)Decimal。8,2)18小數(shù)YESBZWHours標(biāo)準(zhǔn)工時(shí)Decimal。8,2)18小數(shù)YESExpWHoursSum預(yù)計(jì)工時(shí)Decimal(118小數(shù)YES8,2)金額表名：PW_BookParts （預(yù)約配件表）字段名中文描述數(shù)據(jù)類

29、型長(zhǎng)度輸入范圍是否為空默認(rèn)值BookPartsID:標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NoBookLisID預(yù)約單IDint8整數(shù)范圍YESPartsID配件IDint8整數(shù)范圍YESAttributeDetPubID_Z L屬性明細(xì)ID_帳類int8整數(shù)范圍YESReservedNum預(yù)留數(shù)量Decimal。8,2)18小數(shù)YESDemandNum需求數(shù)量Decimal。8,2)18小數(shù)YEStransitNum在途數(shù)量Decimal。8,2)18小數(shù)YESsellNum可售數(shù)量Decimal。8,2)18小數(shù)YESprice單價(jià)Decimal。8,2)18小數(shù)YESsum金額Decimal。8,2

30、)18小數(shù)YESresReleaseno資源釋放 否bit1boolYES表名：PW_suggestMainPro （建議維修項(xiàng)目）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值additionProID標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NomaintainDetID維修工單明細(xì)IDint5字符、數(shù)字YESWHoursProID工時(shí)項(xiàng)目IDint5字符、數(shù)字YESAttributeDetID_ZL屬性明細(xì)ID_帳類int5字符、數(shù)字YESWHours工時(shí)decimal(18, 2)20字符、數(shù)字YESWHoursPrice工時(shí)單價(jià)decimal(18, 2)20字符、數(shù)字YESremarks備注nc

31、har(100100字符、數(shù)字YES表名：PW_settleAccounts (結(jié)算單表)字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值settleAccountsID標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NostatementNum結(jié)算單號(hào)nchar(20)20字符、數(shù)字YESmaintainNumID維修工單IDint10字符、數(shù)字YESbeforeDiscSum優(yōu)惠前總金 額decimal。8, 2)20小數(shù)YESDiscSum優(yōu)惠總金額decimal。8, 2)18小數(shù)YESADiscSum優(yōu)惠后工時(shí) 金額decimal(18, 2)18小數(shù)YESAmaterialsSum優(yōu)惠后材料 金額dec

32、imal(18, 2)18小數(shù)YESAotherSum優(yōu)惠后其他 金額decimal(18, 2)18小數(shù)YESAsum優(yōu)惠后總金 額decimal(18, 2)18小數(shù)YES表名：PW_MRVFolloW維修回訪跟進(jìn)表）字段名中文描述數(shù)據(jù)類型長(zhǎng) 度輸入范圍是否為空默認(rèn)值FollowID標(biāo)識(shí)字段int5整數(shù)范圍NoMRVInfoID維修回訪信息IDint5整數(shù)范圍YESFollowTime跟進(jìn)時(shí)間datetime20字符、數(shù)字YESstaffID員工IDint5整數(shù)范圍YESFollowContent跟進(jìn)內(nèi)容nchar(100)100字符、數(shù)字YES表名：PW_maintainRVInfo （

33、維修回訪信息表）字段名中文描述數(shù)據(jù)類型長(zhǎng) 度輸入范圍是否為空默認(rèn)值maintainRVInfoID標(biāo)識(shí)字段int5整數(shù)范圍NoRVintentID回訪意向IDint5整數(shù)范圍YESFeedback顧客意見(jiàn)nchar(100)100字符、數(shù)字YESfirstRVtime第一次回訪時(shí) 間datetime20字符、數(shù)字YESsecondRVtime第二次回訪時(shí) 間datetime20字符、數(shù)字YESthirdRVtime第三次回訪時(shí) 間datetime20字符、數(shù)字YESSueno投訴否bit20字符、數(shù)字YESadviceno建議否bit20字符、數(shù)字YEScomplainno抱怨否bit20字符

34、、數(shù)字YESPraise no表?yè)P(yáng)否bit20字符、數(shù)字YESsatisfyno滿總合bit20字符、數(shù)字YEScontactno聯(lián)系上否bit20字符、數(shù)字YESbookno預(yù)約否bit20字符、數(shù)字YESbookContent預(yù)約內(nèi)容nchar(100)100字符、數(shù)字YESsueContent投訴內(nèi)容nchar(100)100字符、數(shù)字YESAttributeDetID_IWay屬性明細(xì)2_意 何方式int5整數(shù)范圍YESAttributeDetID_F R屬性明細(xì)2_失 敗原因int5整數(shù)范圍YES表名：PW_RVisitIntent（維修回訪意向表）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍

35、是否為空默認(rèn)值RVisitIntentID標(biāo)識(shí)字段int5整數(shù)范圍NoMaintenOrdDetailID維修工單明細(xì)IDint5整數(shù)范圍YESbusinessType業(yè)務(wù)類別nchar(20)20字符、數(shù)字YESrecVisitno是否接受回 訪bit20字符、數(shù)字YESAttributeDetID_RV way屬性明細(xì)ID_ 回訪方式int5整數(shù)范圍YESRevisitTime回訪時(shí)間datetime20字符、數(shù)字YESoutFacMile出廠里程decimal(18, 2)20字符、數(shù)字YES字段名中文描述數(shù)據(jù)類型長(zhǎng) 度輸入范圍是否 為空默認(rèn) 值maintainItemID標(biāo)識(shí)字段int

36、5整數(shù)范圍NomaintainOrdDetID維修工單明細(xì)IDint5整數(shù)范圍YESWHProID工時(shí)項(xiàng)目IDint5整數(shù)范圍YESAttributeDetID_ZL屬性明細(xì) ID_帳類int5整數(shù)范圍YESWHours工時(shí)decimal(18, 2)20字符、數(shù)字YESWHoursPrices工時(shí)單價(jià)優(yōu)惠前 工時(shí)金額decimal(18, 2)20字符、數(shù)字YESbeforeDisWHSum優(yōu)惠前，時(shí)金額decimal(18, 2)20字符、數(shù)字YESdiscount折扣decimal(18, 2)20字符、數(shù)字YESafterDisWHSum優(yōu)惠后工時(shí)金額decimal(18, 2)20字

37、符、數(shù)字YESinsuranceRate保險(xiǎn)比例decimal(18, 2)20字符、數(shù)字YESProTypes項(xiàng)目類別nchar(20)20字符、數(shù)字YESAttributeDetID_pro Sta屬性明細(xì) ID_項(xiàng) 目狀態(tài)int5整數(shù)范圍YESfaultResonCode故障原因代碼nchar(20)20字符、數(shù)字YESResReleaseno釋放資源看bit20字符、數(shù)字YES表名：PW_maintainItems維修項(xiàng)目表表名：PW_maintainDP維修需求配件表字段名中文描述數(shù)據(jù)類型長(zhǎng) 度輸入范圍是否 為空默認(rèn)值maintainDPID標(biāo)識(shí)字段Int5整數(shù)范圍二NodemandPartDetID維