車(chē)隊(duì)管理系統(tǒng)_數(shù)據(jù)庫(kù)設(shè)計(jì)說(shuō)明書(shū)

1、1 邏輯設(shè)計(jì)1.1 數(shù)據(jù)表設(shè)計(jì)中文名稱(chēng)表名所屬表空間說(shuō)明用戶信息表USERINFO圖表5數(shù)據(jù)庫(kù)表清單1.1.1 用戶信息表S_USERINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注USER_ID用戶編號(hào)INT11NOPKUSER_CODE用戶代碼VARCHAR20NOUSER_NAME用戶名稱(chēng)VARCHAR45NOUSER_AGE用戶年齡INTUSER_SEX用戶性別CHAR1M：男N：女MOTORCADE_ID車(chē)隊(duì)代碼INT11COMPANY_ID公司代碼INT11NOREMARK備注VARCHAR200USER_PWD密碼VARCHAR20NOMOBILE手機(jī)VARCHAR20P

2、HONE電話VARCHAR20EMAIL郵箱VARCHAR20HOME_ADDR家庭住址VARCHAR50ADDRESS住址VARCHAR50IDCARD_NO身份證號(hào)碼VARCHAR20BIRTH_DAY出生日期VARCHAR10START_JOB_DATE入職日期VARCHAR20END_JOB_DATE離職日期VARCHAR20END_JOB_PERSON離職原因VARCHAR50CHANGE_PASSWORD_DATE修改密碼日期VARCHAR20CHANGE_PASSWORD_FLAG修改密碼標(biāo)志VARCHAR1NODEFAULT NY：需要修改密碼N：不需要修改密碼ACCOUNT_

3、STATUS賬戶狀態(tài)VARCHAR1NOF：已凍結(jié)C：已關(guān)閉O：已開(kāi)啟USER_TYPE類(lèi)型VARCHAR1NOG：一般員工D：司機(jī)BIND_EMPLOYEE_FLAG綁定員工標(biāo)志VARCHAR1NOY：是N：否USER_ JOB職務(wù)VARCHAR45PERSONDIVSION_FLAG人事局登記標(biāo)志CHAR1Y：是N：否USER_STATUS員工狀態(tài)CHAR1A：在冊(cè)B：離職中C：已離職1.1.2 用戶組信息表S_GROUPINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注GROUP_ID編號(hào)INT11NOPKGROUP_NAME用戶組名稱(chēng)VARCHAR20REMARK備注VARCHA

4、R501.1.3 角色信息表S_ROLEINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注ROLE_ID角色代碼INT11NOPKROLE_NAME角色名稱(chēng)VARCHAR20NOREMARK備注VARCHAR501.1.4 權(quán)限表S_MENUINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注MENU_ID菜單編號(hào)INT11NOPKMENU_NAME菜單名稱(chēng)VARCHAR20NOMENU_LEVEL菜單級(jí)別INT1NOMENU_URL菜單訪問(wèn)路徑VARCHAR100SUPER_MEUN_ID上級(jí)菜單編號(hào)INT11NOREMARK備注VARCHAR501.1.5 用戶組用戶關(guān)系表S_U

5、SERGROUPRELA英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注ID編號(hào)INT11NOPKGROUP_ID編號(hào)INT11NOUSER_ID用戶編號(hào)INT11NO1.1.6 用戶組角色關(guān)系表S_GROUPROLERELA英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注ID編號(hào)INT11NOPKUSERGROUP_ID編號(hào)INT11NOROLE_ID角色編號(hào)INT11NO 1.1.7 角色權(quán)限關(guān)系表S_ROLEMENURELA英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注ID編號(hào)INT11NOPKROLE_ID角色編號(hào)INT11NO MENU_ID菜單編號(hào)INT11NO1.1.8 公司信

6、息表COMPANYINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注COMPANY_ID公司代碼INT11NOPKCOMPANY_NAME公司名稱(chēng)VARCHAR50NOCOMPANY_DES描述VARCHAR100HEADER機(jī)構(gòu)負(fù)責(zé)人VARCHAR20HEADER_PHONE負(fù)責(zé)人電話VARCHAR20REMARK備注VARCHAR50SALARY_CAL_METHOD司機(jī)工資計(jì)算方式VARCHAR1NOA：倒扣方式B：累計(jì)方式START_SALARY倒扣起始薪資DOUBLE12,2SALARY_MODEL_ID工資模板INT11NOACCOUNT_NO賬號(hào)VARCHAR50OPENA

7、CCOUNT_NAME開(kāi)戶名稱(chēng)VARCHAR100BANK_NAME開(kāi)戶行名稱(chēng)VARCHAR100BANK_NO開(kāi)戶行號(hào)VARCHAR50OFFICE_ADDRESS辦公地址VARCHAR200NOCONTACT_PERSON聯(lián)系人VARCHAR20NOCONTACT_PERSON_PHONE聯(lián)系人電話VARCHAR20NO1.1.9 車(chē)隊(duì)信息表MOTORCADEINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注MOTORCADE _ID車(chē)隊(duì)代碼INT11NOPKMOTORCADE_NAME車(chē)隊(duì)名稱(chēng)VARCHAR45NOCOMPANY_ID公司代碼INT11NOMOTORCADE_DES

8、CRIBE描述VARCHAR100PROVINCE省份VARCHAR20NOCITY城市VARCHAR20NOLONGITUDE經(jīng)度DOUBLE12,6LATITUDE緯度DOUBLE12,6OFFICE_ADDRESS辦公地址VARCHAR200NOCONTACT_PERSON聯(lián)系人VARCHAR20NOCONTACT_PERSON_PHONE聯(lián)系人電話VARCHAR20NO1.1.10 系統(tǒng)參數(shù)表SYSPARAMINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注PARAMETERID參數(shù)編號(hào)INT11NOPKPARAM_CODE參數(shù)代碼VARCHAR40PARAM_TYPE參數(shù)類(lèi)型V

9、ARCHAR20repair_error：車(chē)輛故障字典com_sys_param：系統(tǒng)參數(shù)accident_car_fee事故車(chē)輛費(fèi)用accident_person_fee事故承擔(dān)費(fèi)用com_cust_param公司客戶費(fèi)用參數(shù)PARAMETERDESCRIBE參數(shù)描述VARCHAR50PARAMETERVALUE參數(shù)值VARCHAR20UNIT單位VARCHAR20MOTORCADEID車(chē)隊(duì)代碼INT11COMPANYID公司代碼INT11PARAM_LEVEL參數(shù)級(jí)別VARCHAR1P：平臺(tái)參數(shù)C：公司參數(shù)1.1.11 堆場(chǎng)信息表YARDINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵

10、備注YARDID堆場(chǎng)編號(hào)INT11NOPKYARDNAME堆場(chǎng)名稱(chēng)VARCHAR50NOYARDDESCRIBE堆場(chǎng)描述VARCHAR50PROVINCE_CODE省份代碼CHAR6PROVINCE_NAME省份名稱(chēng)VARCHAR30CITY_CODE城市代碼CHAR6CITY_NAME城市名稱(chēng)VARCHAR30AREA_CODE縣代碼CHAR6AREA_NAME縣名稱(chēng)VARCHAR30ADDRESS地址VARCHAR100NOCONTACTPERSON聯(lián)系人VARCHAR20NOPHONE電話VARCHAR20NOREMARK備注VARCHAR200LONGITUDE經(jīng)度DOUBLE12,6

11、LATITUDE緯度DOUBLE12,61.1.12 船公司信息表BOATCOMPANYINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注BOATCOMPANYID船公司編號(hào)INT11NOPKBOATCOMPANYNAME船公司名稱(chēng)VARCHAR50NOBOATCOMPANYDESCRIBE船公司描述VARCHAR100PROVINCE省份VARCHAR20CITY城市VARCHAR20ADDRESS地址VARCHAR100NOCONTACTPERSON聯(lián)系人VARCHAR20NOPHONE電話VARCHAR20NOREMARK備注VARCHAR50LONGITUDE經(jīng)度DOUBLE12

12、,6LATITUDE緯度DOUBLE12,61.1.13 船公司提箱費(fèi)用表BOATBOXFEE英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注BOATBOXFEE_ID船公司提箱費(fèi)用編號(hào)INT11NOPKBOATCOMPANY_ID船公司編號(hào)INT11BOX_SIZE箱子尺寸VARCHAR1A：大箱40B：小箱70C：特種箱130FEE_AMT費(fèi)用金額DOUBLE12,2BOX_OLD箱子新舊程度VARCHAR1N：新O：舊START_DATE開(kāi)始日期VARCHAR10END_DATE結(jié)束日期VARCHAR101.1.14 港區(qū)信息表PORTINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵

13、備注PORTID港區(qū)編號(hào)INT11NOPKPORTNAME港區(qū)名稱(chēng)VARCHAR45NOPORTDESCRIBE港區(qū)描述VARCHAR100PROVINCE省份VARCHAR20CITY城市VARCHAR20ADDRESS地址VARCHAR100NOCONTACTPERSON聯(lián)系人VARCHAR20NOPHONE電話VARCHAR20NOREMARK備注VARCHAR200LONGITUDE經(jīng)度DOUBLE12,6LATITUDE緯度DOUBLE12,61.1.15 客戶信息表CUSTINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注CUSTOMER_ID客戶編號(hào)INT11NOPKCUS

14、TOMER_NAME客戶名稱(chēng)VARCHAR45NOCUSTOMER_STATE客戶狀態(tài)VARCHAR1NOA：未提交B：已提交未審核C：總經(jīng)理審核D：審核通過(guò)E：審核不通過(guò)COMPANY _ID公司代碼INT11CONTRACT_ID合同編號(hào)VARCHAR45NOATTACHMENT_PATH上傳附件路徑VARCHAR45NOCONTRACT_START_DATE簽約開(kāi)始日期VARCHAR10NOYYYY-MM-DDCONTRACT_END_DATE簽約結(jié)束日期VARCHAR10YYYY-MM-DDCONTRACT_COST_TYPE合同費(fèi)用類(lèi)型VARCHAR2NOKB：卡車(chē)按箱分段KM：卡車(chē)

15、按里程DM：噸車(chē)按里程DT：噸車(chē)按次數(shù)BOX_COUNT箱子數(shù)量INT11HIGH_SEGMENT_MONEY高段金額DOUBLELOW_PERIOD_MONEY低段金額DOUBLESTART_ADDRESS起始地VARCHAR45END_ADDRESS終止地VARCHAR45MILEAGE里程VARCHAR45MILEAGE_MONEY里程金額DOUBLE12,21.1.16 客戶門(mén)點(diǎn)信息CUSTSTOREINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注STORE_ID門(mén)點(diǎn)編號(hào)INT11NOPKCUSTOMER_ID客戶編號(hào)INT11NOSTORE_NAME門(mén)點(diǎn)名稱(chēng)VARCHAR45

16、NOPROVINCE省份VARCHAR20CITY城市VARCHAR20PACKING_ADDRESS裝箱地址VARCHAR200NOCONTACT_PERSON聯(lián)系人VARCHAR20NOMOBILE手機(jī)VARCHAR20PHONE電話VARCHAR20REQUIREMENT裝箱要求VARCHAR200ROAD_FEE路橋費(fèi)DOUBLE12,2NODEFAULT_FLAG默認(rèn)門(mén)點(diǎn)狀態(tài)VARCHAR1NOY：選中N：未選中LONGITUDE經(jīng)度DOUBLE12,6LATITUDE緯度DOUBLE12,6STORE_AREA門(mén)點(diǎn)區(qū)VARCHAR45CAR_STANDARD_LIMIT運(yùn)輸車(chē)輛的規(guī)

17、格型號(hào)限制VARCHAR50CAR_WEIGHT_LIMIT車(chē)輛載重限制VARCHAR50CAR_HEIGHT_LIMIT車(chē)輛高度限制VARCHAR501.1.17 加油站信息GASSTATIONINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注GAS_STATION_ID加油站編號(hào)INT11NOPKGAS_STATION_NAME加油站名稱(chēng)VARCHAR45NOPROVINCE省份VARCHAR20CITY城市VARCHAR20ADDRESS地址VARCHAR200NOCREATEDATE創(chuàng)建日期VARCHAR10NOYYYY-MM-DDREMARK備注VARCHAR50COMPANY

18、 _ID公司代碼INT11NOMOTORCADE _ID車(chē)隊(duì)代碼INT11LONGITUDE經(jīng)度DOUBLE12,6LATITUDE緯度DOUBLE12,61.1.18 油價(jià)信息表OILPRICEINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注OILPRICE_ID油價(jià)編號(hào)INT11NOPKDATE日期VARCHAR10NOYYYY-MM-DDCOST_PRICE成本價(jià)NUMERIC12,2NOSELL_PRICE零售價(jià)NUMERIC12,2NOCOMPANY _ID公司代碼INT11NO1.1.19 進(jìn)油信息表OILININFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注OIL_

19、IN_ID進(jìn)油編號(hào)INT11NOPKOIL_IN _DATE進(jìn)油日期VARCHAR10NOYYYY-MM-DDCAR_NO車(chē)輛編號(hào)VARCHAR45NOCAR_TIMES車(chē)次INT11NOTOTAL_WEIGHT總重DOUBLE12,2NO車(chē)加油TARE_WEIGHT皮重DOUBLE12,2NO車(chē)重NET_WEIGHT凈重DOUBLE12,2NO油重WEIGHING_DIFFERENCE過(guò)磅差數(shù)DOUBLE12,2NOL_NUMBER公升數(shù)DOUBLE12,2NOOIL_MACHINE_DIFFERENTIAL油機(jī)差數(shù)DOUBLE12,2NOREMARK備注VARCHAR200GAS_STAT

20、ION_ID加油站編號(hào)INT11NOCOMPANY _ID公司代碼INT11NOMOTORCADE _ID車(chē)隊(duì)代碼INT11HANDLER經(jīng)手人VARCHAR20PRICE單價(jià)DOUBLE12,2NO1.1.20 內(nèi)部車(chē)輛加油信息表OILOUTINTERCARINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注OILOUT_ID加油編號(hào)INT11NOPKCAR_ID車(chē)輛編號(hào)INT11NOHANDLER經(jīng)手人VARCHAR20GAS_STATION_ID加油站編號(hào)INT11NOOILOUT _DATE加油日期VARCHAR10NOYYYY-MM-DDDRIVER_ID司機(jī)編號(hào)INT11NOO

21、IL_COUNT油量DOUBLE12,2NOREMARK備注VARCHAR50JOB_ID作業(yè)單編號(hào)INT11NOPRICE單價(jià)DOUBLE12,2NOTOTAL_PRICE總額DOUBLE12,2NO1.1.21 外部車(chē)輛加油信息表OILOUTOUTERCARINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注OILOUT_ID加油編號(hào)INT11NOPKGASSTATION_ID加油站編號(hào)INT11NOPLCOME_DATE加油日期VARCHAR10NOOIL_COUNT油量DOUBLE12,2NOPRICE單價(jià)DOUBLE12,2NOTOTAL_PRICE總額DOUBLE12,2NOR

22、EMARK備注VARCHAR45COMPANY _ID公司代碼INT11NO1.1.22 耗油統(tǒng)計(jì)表OIL_STATISTIC英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注OIL_STATISTIC_ID編號(hào)INT11NOPKSTATISTIC_DATE統(tǒng)計(jì)日期VARCHAR10NOYYYY-MM-DDOIL_IN入庫(kù)DOUBLE12,2NOOIL_OUT出庫(kù)DOUBLE12,2NOBALANCE結(jié)存DOUBLE12,2NOOILDEPOT_NUMBER油庫(kù)數(shù)DOUBLE12,2NODIESEL_PRICES柴油價(jià)DOUBLE12,2NOREMARK備注VARCHAR50COMPANY _I

23、D公司代碼INT11NO1.1.23 司機(jī)油耗明細(xì)表DRIVEROIL英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注DRIVEROIL_ID司機(jī)油耗編號(hào)INT11NOPKMODELS車(chē)型VARCHAR20CAR_NO車(chē)牌號(hào)碼VARCHAR45COMPANY _ID公司代碼INT11NOMOTORCADE _ID車(chē)隊(duì)代碼INT11EMPLOYEE_ID員工編號(hào)INT11NAMES姓名VARCHAR20WORK_NUMBER工號(hào)VARCHAR20LABOR_ATTRIBUTE勞務(wù)屬性VARCHAR1STORE_NAME門(mén)點(diǎn)名稱(chēng)VARCHAR45ACTUAL_KILOMETER實(shí)際公里DOUBLE

24、12,2VERIFY_KILOMETER核定公里DOUBLE12,2OIL_DAY_USED當(dāng)日耗油量DOUBLE12,2STANDARD_DAY_USED標(biāo)準(zhǔn)耗油量DOUBLE12,2VERYFY_HUND_KM核定百公里DOUBLE12,2ACTUAL_HUND_KM實(shí)際百公里DOUBLE12,2ALLOW_KM補(bǔ)貼公里DOUBLE12,2手工錄入VERIFY_KILOMETER_SUM合計(jì)核定油量DOUBLE12,2手工錄入FUELSAVING_LITERS節(jié)油超標(biāo)升數(shù)DOUBLE12,2合計(jì)核定油量-標(biāo)準(zhǔn)耗油量ALLOW_OILLITERS補(bǔ)貼油量DOUBLE12,2手工錄入FUELS

25、AVING_LITERS_SUM合計(jì)節(jié)油超標(biāo)升數(shù)DOUBLE12,2=合計(jì)核定油量OIL_USED_TOTAL合計(jì)油耗獎(jiǎng)扣DOUBLE12,2手工錄入STATISTIC_DAY日期VARCHAR10MOTORCADE _NAME車(chē)隊(duì)名稱(chēng)VARCHAR45START_MILEOMETER起始路碼表數(shù)DOUBLE12,2END_MILEOMETER結(jié)束路碼表數(shù)DOUBLE12,2JOB_ID作業(yè)編號(hào)INT111.1.24 司機(jī)信息表EMPLOYEEINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注EMPLOYEE_ID員工編號(hào)INT11NOPKADRIVERS_LICENSE駕駛證號(hào)VARC

26、HAR45NOFIRST_IDCARD_DATE初次領(lǐng)證日期VARCHAR20DRIVER_CAR_TYPE準(zhǔn)駕車(chē)型VARCHAR10A1,A2,A3,B1,B2,B3DRIVER_IDCARD_NO駕駛證檔案號(hào)VARCHAR20DRIVE_MANAGE_ADDR駕駛管轄地VARCHAR20ENABLE_DATE正證有效開(kāi)始日期VARCHAR20DISABLE_DATE正證有效結(jié)束日期VARCHAR20CHECK_DATE審驗(yàn)日期VARCHAR20COMPANY_ID公司代碼INT11NOMOTORCADE _ID車(chē)隊(duì)代碼INT11NOJOB_IDCARD_NO從業(yè)證號(hào)VARCHAR20JOB

27、_MANAGE_ADDR從業(yè)管轄地VARCHAR20JOB_ENABLE_DATE從業(yè)有效開(kāi)始日期VARCHAR20JOB_DISABLE_DATE從業(yè)有效結(jié)束日期VARCHAR20DANGER_APTITUDE危險(xiǎn)品資質(zhì)VARCHAR20ESCORT_IDCARD_NO押運(yùn)證證號(hào)VARCHAR20ESCORT_ APTITUDE押運(yùn)資質(zhì)VARCHAR20DANGER_AGREE_NO危險(xiǎn)品準(zhǔn)運(yùn)證號(hào)VARCHAR20HIGH_TOXIC_NO劇毒品證號(hào)VARCHAR20BASE_SALARY基本工資DOUBLE12,2WORK_NUMBER工號(hào)VARCHAR50WORKYEARS_SALARY

28、工齡工資DOUBLE12,2NOWORKYEARS工齡INT11NOLABOR_BASE_AMT勞務(wù)基金DOUBLE12,2LABOR_ATTRIBUTE勞務(wù)屬性VARCHAR1NOO：合同A：加盟SETTLEMENT_WAY結(jié)算方式VARCHAR1NOM：工資D：日結(jié)USER_ID用戶編號(hào)INT11STATE狀態(tài)VARCHAR1NOU：未綁定B：已綁定USER_SUPERVISION_NO海關(guān)注冊(cè)號(hào)VARCHAR50DREVER_CAR_NO默認(rèn)駕駛車(chē)號(hào)INT11DRIVER_METER行駛公里DOUBLE10,2SAFE_DRIVER_METER安全行駛公里DOUBLE10,2EMERGE

29、_CONTACT緊急聯(lián)系人VARCHAR20EMERGE_CONTACT_TEL通訊方式VARCHAR20EMERGE_RELA關(guān)系VARCHAR10REMARK備注VARCHAR201.1.25 司機(jī)考勤信息表VACATIONINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注VACATION_ID考勤編號(hào)INT11NOPKVACATION_DATE日期VARCHAR20NOYYYY-MM-DDUSER_ID用戶編號(hào)INT11NOSIGNIN_TIME簽到時(shí)間TIMESTAMPSIGNOUT_TIME簽退時(shí)間TIMESTAMPHOLIDAY_FLAG休假標(biāo)志VARCHAR1NOY：是N：

30、否HOLIDAY_TYPE休假類(lèi)型VARCHAR1A：年假B：探親假C：病假D：事假E：曠工F：遲到G：早退H：婚假I(mǎi)：產(chǎn)假PUNISH_REWARD_AMT懲罰獎(jiǎng)勵(lì)金額DOUBLE12,2COMPANY _ID公司代碼INT11NOMOTORCADE _ID車(chē)隊(duì)代碼INT11VACATE_START請(qǐng)假開(kāi)始時(shí)間TIMESTAMPVACATE_END請(qǐng)假結(jié)束時(shí)間TIMESTAMPUSER_TYPE類(lèi)型CHAR1 NOG：一般員工D：司機(jī)LOCK_FLAG封存標(biāo)志CHAR1Y：已封存N：未封存1.1.26 工資計(jì)算要素表SALARYELEMENT英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注S

31、ALARYELEMENT_ID工資要素編號(hào)INT11NOPKELEMENT_NAME要素名稱(chēng)VARCHAR50ELEMENT_LABEL要素標(biāo)識(shí)VARCHAR201.1.27 工資計(jì)算模板信息表SALARYMODELINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注SALARYMODEL_ID工資模板編號(hào)INT11NOPKMODEL_NAME模板名稱(chēng)VARCHAR50SALARY_CAL_METHOD司機(jī)工資計(jì)算方式VARCHAR1NOA：倒扣方式B：累計(jì)方式START_SALARY倒扣起始薪資DOUBLE12,21.1.28 工資要素明細(xì)表SALARYELEMENTDETAIL(作廢)

32、英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注DETAIL_ID明細(xì)編號(hào)INT11NOPKELEMENT_LABEL要素標(biāo)識(shí)VARCHAR10EMPLOYEE_ID司機(jī)編號(hào)INT11NOELEMENT_AMT金額NUMERIC12,2CREATE_DATE創(chuàng)建日期VARCHAR10YYYY-MM-DDCOMPANY _ID公司代碼INT11NOMOTORCADE _ID車(chē)隊(duì)代碼INT111.1.29 模板要素關(guān)系表MODELELEMENTRELA英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注RELA_ID關(guān)系編號(hào)INT11NOPKSALARYMODEL_ID工資模板編號(hào)INT11SALAR

33、YELEMENT_ID工資要素編號(hào)INT111.1.30 司機(jī)工資信息表SALARYINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注SALARY_ID工資編號(hào)INT11NOPKEMPLOYEE_ID司機(jī)編號(hào)INT11NOSALARY_DATE月份VARCHAR10YYYY-MMSALARY_AMT金額NUMERIC12,2ANNUITY養(yǎng)老金NUMERIC12,2SOCIAL_FUND社保金NUMERIC12,2INCOME_TAX個(gè)人所得稅金NUMERIC12,2INTEREST利息DOUBLE12,2ATTENDANCE考勤工資DOUBLE12,2SENIORITY工齡補(bǔ)貼DOUB

34、LE12,2NIANXIU_AMT年休補(bǔ)貼DOUBLE12,2TONGXXUN_AMT通訊費(fèi)補(bǔ)貼DOUBLE12,2WEIXIAN_AMT運(yùn)輸危險(xiǎn)品補(bǔ)貼DOUBLE12,2JIJIAN_AMT計(jì)件工資DOUBLE12,2FADING_AMT法定加班工資DOUBLE12,2HOLIDAY_AMT法定節(jié)假日加班計(jì)件工資DOUBLE12,2JIDUAN_AMT季度安全獎(jiǎng)DOUBLE12,2JIDU_AMT季度獎(jiǎng)勵(lì)金DOUBLE12,2WEIJI_AMT車(chē)隊(duì)違章違紀(jì)DOUBLE12,2WEIJIAN_AMT安全違章違紀(jì)DOUBLE12,2JISUN_AMT機(jī)損DOUBLE12,2SHIGU_AMT事故

35、扣款DOUBLE12,2YOUHAO_AMT油耗獎(jiǎng)罰DOUBLE12,2TIAO_AMT調(diào)整項(xiàng)DOUBLE12,2STATUS狀態(tài)VARCHAR1COMPANY _ID公司代碼INT11NOMOTORCADE _ID車(chē)隊(duì)代碼INT11CREATE_DATE創(chuàng)建時(shí)間TIMESTAMP1.1.31 GPS設(shè)備信息表GPSINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注GPS_EQUIP_ID編號(hào)INT11NOPKCOMPANY_ID公司代碼INT11NOMOTORCADE _ID車(chē)隊(duì)代碼INT11NOCAR_ID車(chē)輛車(chē)掛編號(hào)INT11NOBIND_EQUIPMENT_TYPE綁定設(shè)備類(lèi)型V

36、ARCHAR1NOC：車(chē)輛G：車(chē)掛IMEI_NOIMEI號(hào)碼VARCHAR20NOCARD_NO卡號(hào)VARCHAR20NOPORT_NO端口號(hào)VARCHAR10NOEQUIP_GPS_STATUS設(shè)備狀態(tài)CHAR1NO(Y在線,N離線)SERVER_FLAG啟停服務(wù)標(biāo)志CHAR1NO(S啟動(dòng) T停止)1.1.32 車(chē)輛信息表CARINFO英文名中文名數(shù)據(jù)類(lèi)型長(zhǎng)度ISNULL主/外鍵備注CAR_ID車(chē)輛編號(hào)INT11NOPKEQUIP_NO設(shè)備號(hào)VARCHAR10CAR_NO車(chē)牌號(hào)碼VARCHAR45NOCAR_ TYPE車(chē)輛類(lèi)別CHAR1NOJ：集卡D：噸車(chē)CAR_MODEL車(chē)輛類(lèi)型CHAR1

37、A：重型半掛牽引車(chē)CAR_MODEL_NO車(chē)輛型號(hào)VARCHAR20A：陜汽牌SX4185TM351SIZE尺寸VARCHAR20NOSELF_WEIGHT自重INT8LOADWEIGHT載重INT8NOENGINE_ NO發(fā)動(dòng)機(jī)號(hào)VARCHAR50NOCHASSIS_NO底盤(pán)號(hào)VARCHAR50IMPORT_CAR_FLAG進(jìn)口車(chē)標(biāo)志CHAR1Y：是N：否ENABLE_DATE起用日期VARCHAR20DISABLE_DATE報(bào)廢日期VARCHAR20DANGER_IDCARD_NO危險(xiǎn)品準(zhǔn)運(yùn)證號(hào)VARCHAR50DANGER_BEGIN_DATE危品證獲證日期VARCHAR20ROUTE_

38、IDCARD_NO道路營(yíng)運(yùn)證號(hào)VARCHAR50CUSTOMHOUSE_LOAD_NO海關(guān)準(zhǔn)載證號(hào)VARCHAR50CUSTOMHOUSE_SET_FLAG海關(guān)監(jiān)控設(shè)備安裝標(biāo)志CHAR1Y：是N：否RFID_NORFID號(hào)VARCHAR50DRIVER_NO正司機(jī)編號(hào)INT11DRIVER_NAME正司機(jī)VARCHAR20DRIVER_SND_NO副司機(jī)編號(hào)INT11DRIVER_SND_NAME副司機(jī)VARCHAR20ESCORT_PERSON押運(yùn)員編號(hào)INT11ESCORT_PERSON_NAME押運(yùn)員VARCHAR20REGISTRATION_TIME上牌日期VARCHAR20NOPUR

39、CHASE_COST購(gòu)置費(fèi)用VARCHAR20TRANS_QUALIFICATION運(yùn)輸資質(zhì)VARCHAR45NODISCOUNT_AMT折舊金NUMERIC12,2WHITE_CARD白卡VARCHAR100COMPANY_ID公司代碼INT11NOMOTORCADE _ID車(chē)隊(duì)代碼INT11SHARE_EXCLUSIVE_SIGN共享獨(dú)占標(biāo)志VARCHAR1NOG：共享D：獨(dú)占OWN_RENTAL_TYPE自有租憑分類(lèi)VARCHAR1NOZ：自有P：租憑G：掛靠CAR_STATUS狀態(tài)VARCHAR1NOA：未分配B：作業(yè)中C：保養(yǎng)中D：維修中E：事故處置中MAINTAIN_METER保養(yǎng)周期公里DOUBLE10,2DRIVER_METER行駛公里DOU