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

1、（1）數(shù)據(jù)庫(kù)表匯總表名功能說明表類型（基礎(chǔ)表？業(yè)務(wù)表？）BM_V_Contact車輛聯(lián)系人，車輛聯(lián)系人與車輛綁定基礎(chǔ)表BM_V_Users Data車輛使用人資料，當(dāng)前使用車的使用人基礎(chǔ)表BM_VehicleInfo車輛信息，關(guān)于車輛的信息基礎(chǔ)表BM_Addition Item附加項(xiàng)目，如外拖車費(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_

2、Selection保養(yǎng)項(xiàng)目選擇基礎(chǔ)表BM_Standard Materia標(biāo)準(zhǔn)資料基礎(chǔ)表BM_SM Property標(biāo)準(zhǔn)資料屬性基礎(chǔ)表BM_Department部門基礎(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ǔ)表B

3、M_JobType工種基礎(chǔ)表BM_maintainRVFD維修回訪反饋表基礎(chǔ)表BM_maintainRVCon維修回訪內(nèi)容表基礎(chǔ)表BM_maintainTech維修技師表基礎(chǔ)表BM_preserveAlert保養(yǎng)提醒基礎(chǔ)表BM_O_Iinformation車主信息基礎(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_S

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

5、BM_yearAlert年審提醒表基礎(chǔ)表BM_yearGoal年度目標(biāo)表基礎(chǔ)表BM_packgeDet套餐明細(xì)表基礎(chǔ)表BM_vehicleBrand汽車品牌表基礎(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理賠圖片

6、信息表業(yè)務(wù)表PW_DebtSettle欠款結(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維修需求配件表業(yè)務(wù)表PW_maintainItems維修項(xiàng)目表業(yè)務(wù)表PW_MaintenOrder維修工單表業(yè)務(wù)表PW_maintainRVInfo維修回訪信息表業(yè)務(wù)表PW_Maint

7、enOrdDetail維修工單明細(xì)表業(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_wareho

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

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

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

11、bit5字符、數(shù)字YESUser Management用戶管理bit5字符、數(shù)字YES表名：BM_OwnerInfo（車主信息表）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值OwnerInfoID標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NoOwner Code車主代碼nchar20字符、數(shù)字YESOwner Name車主姓名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ù)字Y

12、ESArea Code電話區(qū)號(hào)nchar20字符、數(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 Status屬性明細(xì)ID_婚姻狀況int8整數(shù)范圍

13、YESID Card No身份證號(hào)碼nchar30字符、數(shù)字YESBirthday生日datetime20日期YESEducation Background學(xué)歷nchar20字符、數(shù)字YESHobby愛好nchar100字符、數(shù)字YESChange Address變更地址nchar100字符、數(shù)字YESPostcode郵編nchar20字符、數(shù)字YESNationality國(guó)籍nchar50字符、數(shù)字YESEmailEmailnchar50字符、數(shù)字YESC_Return time方便回訪時(shí)間datetime20日期YESOwner Photo車主照片n

14、char100字符、數(shù)字YES表名：PW_MaintenOrder維修工單表字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值MaintenOrdID標(biāo)識(shí)字段int5整數(shù)范圍NomaintenItemsID維修項(xiàng)目IDint8整數(shù)范圍YEStypeWorkID工種IDint8整數(shù)范圍YESworkStateID工位IDint8整數(shù)范圍YESteamID班組IDint8整數(shù)范圍YESmaintenTechID_maintenanceTech1維修技師ID_維修技師1int8整數(shù)范圍YESmaintenTechID_maintenanceTech2維修技師ID_維修技師2int8整數(shù)范圍YESWor

15、kingHoursProID_againPro工時(shí)項(xiàng)目ID_增修項(xiàng)目int8整數(shù)范圍YESHMTimesAmend第幾次增修D(zhuǎn)ecimal(18,2)18小數(shù)YESWHoursProID_ReworkPro工時(shí)項(xiàng)目ID_返修項(xiàng)目int8整數(shù)范圍YESQualityInspectResults質(zhì)檢結(jié)果nchar20字符、數(shù)字YESNumRework返工次數(shù)Decimal(18,2)18小數(shù)YESreworkTime返工時(shí)間datetime20日期YESAttributeDetID_accountClass屬性明細(xì)ID_帳類int8整數(shù)范圍YES表名：PW_MaintainOrdDet 維修工單明

16、細(xì)表字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值MaintainOrdDetID標(biāo)識(shí)字段int5整數(shù)范圍NojobNum工單號(hào)nchar(20)20字符、數(shù)字YESBookLisID預(yù)約單IDint5整數(shù)范圍YESvehicleInfoID車輛信息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字符

17、、數(shù)字YESadvReceive預(yù)收款decimal(18, 2)20字符、數(shù)字YESexpDealCar預(yù)計(jì)交車datetime20字符、數(shù)字YESlastinFac上次進(jìn)廠datetime20字符、數(shù)字YESReserNum預(yù)約單號(hào)nchar(20)20字符、數(shù)字YESMemType會(huì)員類別nchar(20)20字符、數(shù)字YESInsuranceCom保險(xiǎn)公司nchar(20)20字符、數(shù)字YESAttributeDetID_vehicleState屬性明細(xì)ID_車輛狀態(tài)int5整數(shù)范圍YESApno預(yù)修否bit20字符、數(shù)字YESApState預(yù)修狀態(tài)nchar(20)20字符、數(shù)字YE

18、SCarwashno洗車服務(wù)否bit20字符、數(shù)字YESoldDeal舊件處理nchar(20)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ù)顧問nchar(10)10字符、數(shù)字YESMaintenOrdID維修工單IDint5整數(shù)范圍YES表名：PW_BookList（預(yù)

19、約單表）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值 BookListID 標(biāo)識(shí)字段自動(dòng)增長(zhǎng)8整數(shù)范圍NoBookListNum 預(yù)約單號(hào)nchar20字符、數(shù)字YESVehicleInfoID車輛信息IDint8整數(shù)范圍YESBookTime預(yù)約時(shí)間datetime20日期YESAttributeDetID_BookWay屬性明細(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失敗原因nchar

20、100字符、數(shù)字YESStaffID_Accept員工ID_受理人int8字符、數(shù)字YESStaffID_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ù)字YESexpDealCar預(yù)約交車時(shí)間datetime20字符、數(shù)字YESBookalertTime預(yù)約提醒時(shí)

21、間datetime20字符、數(shù)字YESexpArrivalTime預(yù)計(jì)到貨時(shí)間datetime20字符、數(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備注nchar100YESres

22、Releaseno資源釋放否bit1YESeffectiveno有效否bit1YES表名：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 Category屬性明細(xì)ID_項(xiàng)目類別int5整數(shù)范圍YESWork Group ID班組IDint5整數(shù)范圍YESPrice價(jià)格decimal(18,2)字符、數(shù)字YES

23、Discount折扣decimal(18,2)字符、數(shù)字YES表名：BM_WorkGroup（班組表）字段名中文描述數(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車型nc

24、har20字符、數(shù)字YESGA_Working Hours客帳工時(shí)decimal(18,2)18小數(shù)YESIGA_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à)bit1boolYESDis

25、count折扣decimal(18,2)18小數(shù)YESImdiscount Symbol不折扣標(biāo)志bit1boolYESDiscount Begin Date折扣開始日期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ì)

26、表（車輛狀態(tài)）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值A(chǔ)ttributeDetPubID標(biāo)識(shí)字段自動(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_ma

27、intainTech（維修技師表）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值maintainTechID標(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ù)范圍YESQualityRes質(zhì)檢結(jié)果nchar20字符、數(shù)字YESreworkReson返工原因nchar100字符

28、、數(shù)字YES表名：PW_BookMaintenPro(預(yù)約維修項(xiàng)目表）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(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(18,2)18小數(shù)YESKZWHours客帳工時(shí)Decimal(18,2)18小數(shù)YESBZWHours標(biāo)準(zhǔn)工時(shí)Decimal(18,2)18小數(shù)YESExpWHoursSum預(yù)計(jì)工時(shí)金額Dec

29、imal(18,2)18小數(shù)YES表名：PW_BookParts (預(yù)約配件表）字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值BookPartsID標(biāo)識(shí)字段自動(dòng)增長(zhǎng)5整數(shù)范圍NoBookLisID預(yù)約單IDint8整數(shù)范圍YESPartsID配件IDint8整數(shù)范圍YESAttributeDetPubID_ZL屬性明細(xì)ID_帳類int8整數(shù)范圍YESReservedNum預(yù)留數(shù)量Decimal(18,2)18小數(shù)YESDemandNum需求數(shù)量Decimal(18,2)18小數(shù)YEStransitNum在途數(shù)量Decimal(18,2)18小數(shù)YESsellNum可售數(shù)量Decimal(18

30、,2)18小數(shù)YESprice單價(jià)Decimal(18,2)18小數(shù)YESsum金額Decimal(18,2)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ù)字Y

31、ESWHoursPrice工時(shí)單價(jià)decimal(18, 2)20字符、數(shù)字YESremarks備注nchar(100)100字符、數(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(18, 2)20小數(shù)YESDiscSum優(yōu)惠總金額decimal(18, 2)18小數(shù)YESADiscSum

32、優(yōu)惠后工時(shí)金額decimal(18, 2)18小數(shù)YESAmaterialsSum優(yōu)惠后材料金額decimal(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ù)范圍YESFollowConte

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

34、adviceno建議否bit20字符、數(shù)字YEScomplainno抱怨否bit20字符、數(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ì)ID_意向方式int5整數(shù)范圍YESAttributeDetID_FR屬性明細(xì)ID_失敗原因int5整數(shù)范圍YES表

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

36、aintainItems 維修項(xiàng)目表字段名中文描述數(shù)據(jù)類型長(zhǎng)度輸入范圍是否為空默認(rèn)值maintainItemID標(biāo)識(shí)字段int5整數(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折扣

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