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

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

2、HONE電話VARCHAR20EMAIL郵箱VARCHAR20HOME_ADDR家庭住址VARCHAR50ADDRESS住址VARCHAR50IDCARD_NO身份證號碼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：已開啟USER_TYPE類型VARCHAR1NOG：一般員工D：司機(jī)BIND_EMPLOYEE_FLAG綁定員工標(biāo)志VARCHAR1NOY：是N：否USER_ JOB職務(wù)VARCHAR45PERSONDIVSION_FLAG人事局登記標(biāo)志CHAR1Y：是N：否USER_STATUS員工狀態(tài)CHAR1A：在冊B：離職中C：已離職1.1.2 用戶組信息表S_GROUPINFO英文名中文名數(shù)據(jù)類型長度ISNULL主/外鍵備注GROUP_ID編號INT11NOPKGROUP_NAME用戶組名稱VARCHAR20REMARK備注VARCHA

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

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

6、息表COMPANYINFO英文名中文名數(shù)據(jù)類型長度ISNULL主/外鍵備注COMPANY_ID公司代碼INT11NOPKCOMPANY_NAME公司名稱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賬號VARCHAR50OPENA

7、CCOUNT_NAME開戶名稱VARCHAR100BANK_NAME開戶行名稱VARCHAR100BANK_NO開戶行號VARCHAR50OFFICE_ADDRESS辦公地址VARCHAR200NOCONTACT_PERSON聯(lián)系人VARCHAR20NOCONTACT_PERSON_PHONE聯(lián)系人電話VARCHAR20NO1.1.9 車隊(duì)信息表MOTORCADEINFO英文名中文名數(shù)據(jù)類型長度ISNULL主/外鍵備注MOTORCADE _ID車隊(duì)代碼INT11NOPKMOTORCADE_NAME車隊(duì)名稱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ù)類型長度ISNULL主/外鍵備注PARAMETERID參數(shù)編號INT11NOPKPARAM_CODE參數(shù)代碼VARCHAR40PARAM_TYPE參數(shù)類型V

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

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

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

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

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

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

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

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

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

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

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

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

21、IL_COUNT油量DOUBLE12,2NOREMARK備注VARCHAR50JOB_ID作業(yè)單編號INT11NOPRICE單價(jià)DOUBLE12,2NOTOTAL_PRICE總額DOUBLE12,2NO1.1.21 外部車輛加油信息表OILOUTOUTERCARINFO英文名中文名數(shù)據(jù)類型長度ISNULL主/外鍵備注OILOUT_ID加油編號INT11NOPKGASSTATION_ID加油站編號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ù)類型長度ISNULL主/外鍵備注OIL_STATISTIC_ID編號INT11NOPKSTATISTIC_DATE統(tǒng)計(jì)日期VARCHAR10NOYYYY-MM-DDOIL_IN入庫DOUBLE12,2NOOIL_OUT出庫DOUBLE12,2NOBALANCE結(jié)存DOUBLE12,2NOOILDEPOT_NUMBER油庫數(shù)DOUBLE12,2NODIESEL_PRICES柴油價(jià)DOUBLE12,2NOREMARK備注VARCHAR50COMPANY _I

23、D公司代碼INT11NO1.1.23 司機(jī)油耗明細(xì)表DRIVEROIL英文名中文名數(shù)據(jù)類型長度ISNULL主/外鍵備注DRIVEROIL_ID司機(jī)油耗編號INT11NOPKMODELS車型VARCHAR20CAR_NO車牌號碼VARCHAR45COMPANY _ID公司代碼INT11NOMOTORCADE _ID車隊(duì)代碼INT11EMPLOYEE_ID員工編號INT11NAMES姓名VARCHAR20WORK_NUMBER工號VARCHAR20LABOR_ATTRIBUTE勞務(wù)屬性VARCHAR1STORE_NAME門點(diǎn)名稱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車隊(duì)名稱VARCHAR45START_MILEOMETER起始路碼表數(shù)DOUBLE12,2END_MILEOMETER結(jié)束路碼表數(shù)DOUBLE12,2JOB_ID作業(yè)編號INT111.1.24 司機(jī)信息表EMPLOYEEINFO英文名中文名數(shù)據(jù)類型長度ISNULL主/外鍵備注EMPLOYEE_ID員工編號INT11NOPKADRIVERS_LICENSE駕駛證號VARC

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

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

28、工齡工資DOUBLE12,2NOWORKYEARS工齡INT11NOLABOR_BASE_AMT勞務(wù)基金DOUBLE12,2LABOR_ATTRIBUTE勞務(wù)屬性VARCHAR1NOO：合同A：加盟SETTLEMENT_WAY結(jié)算方式VARCHAR1NOM：工資D：日結(jié)USER_ID用戶編號INT11STATE狀態(tài)VARCHAR1NOU：未綁定B：已綁定USER_SUPERVISION_NO海關(guān)注冊號VARCHAR50DREVER_CAR_NO默認(rèn)駕駛車號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ù)類型長度ISNULL主/外鍵備注VACATION_ID考勤編號INT11NOPKVACATION_DATE日期VARCHAR20NOYYYY-MM-DDUSER_ID用戶編號INT11NOSIGNIN_TIME簽到時(shí)間TIMESTAMPSIGNOUT_TIME簽退時(shí)間TIMESTAMPHOLIDAY_FLAG休假標(biāo)志VARCHAR1NOY：是N：

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

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

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

33、YELEMENT_ID工資要素編號INT111.1.30 司機(jī)工資信息表SALARYINFO英文名中文名數(shù)據(jù)類型長度ISNULL主/外鍵備注SALARY_ID工資編號INT11NOPKEMPLOYEE_ID司機(jī)編號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車隊(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車隊(duì)代碼INT11CREATE_DATE創(chuàng)建時(shí)間TIMESTAMP1.1.31 GPS設(shè)備信息表GPSINFO英文名中文名數(shù)據(jù)類型長度ISNULL主/外鍵備注GPS_EQUIP_ID編號INT11NOPKCOMPANY_ID公司代碼INT11NOMOTORCADE _ID車隊(duì)代碼INT11NOCAR_ID車輛車掛編號INT11NOBIND_EQUIPMENT_TYPE綁定設(shè)備類型V

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

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

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

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