科目三数据库结构

1、CarOfCarType Carsys Code Info Code Type DAY Examine TIME Employee ExamineExamineBak ExamineImage ExamineTempTable FeeTable FileImageTable FileTable GPSTempTable ImageTempTable JXHGLTable MiscarriageTable NightExamine NightExamineBak OperationRecord Preasign PrintExamine SFTable SiteTable SysParTable

2、 TableMemo TJUserGrant DrvZWTable DrvZPTable YYPreasignTable YYRSTable JMQTable KSSFTable数据库Re中表说明;/车型参数表/测试车载参数表代码信息国家代码/扣分代码/代码类别/ 白天检查时间？人员表治理员/测试信息/考生信息备份插入、更新前、更新后/考生照片/考生临时表/收费表文件图片表文件列表与升级有关/GPS临时表/图片临时表驾校合格率考生人数？/误判表/夜考/夜考备份对程序的操作日志/考生预约表/打印考生/收费表/场地列表/中央地址与公安网信息/表名称/统计内容/软件登陆用户分组/指纹表/照片表/预约

3、设计表/预约人数表/解码器表/测试收费表1. CarOfCarTypejfe 结构；厅p列名数据类型长度说明1.KCIDInt4考车ID2.FkscxidInt4:测试车型ID3.Fkscxvarchar2测试车型4.KSCXSMvarchar20测试车型说明2. Carsys表结构；厅P列名数据类型长度说明1.KCIDInt4考车ID2.Fkcdmvarchar10考车代码3.KCHPvarchar20考车号牌4.CarAddressint4车辆硬件地址；5.DevicelPVarchar20车载硬盘录像机IP6.SampleComInt4车载采集板com 口7.GPSComInt4GPSf

4、f块 com 口8.TrafficLightComInt4仁号灯灯屏com 口9.AccelerometerComInt4加速传感器com 口10.IsBigCarbit1是否大车11.SpHolesInt4标定脉冲个数12.DiameterInt4标定距离MM13.PerDistancefloat814.EngineDistancefloat8发动机跑离发动机转速？15.LeftUpLevelInt4左上方标注档位16.LeftDownLevelInt4左卜方标注档位17.UpLevelInt4上标注档位18.DownLevelInt4下标注档位19.RightUpLevelInt4右上标注

5、档位20.RightDownLevelInt4右下标注档位21.FkcztBit1考车状态22.KSYvarchar30测试员23.VideoServerIPvarchar20硬盘录像机IP地址时间？24.LastUpDateTimedatetime8视频上的时间译25.GCRSInt4跟车人数26.CarIPvarchar20车载计算机IP地址27.VideolPvarchar20测试中央视频解码器？28.VideoPortInt4视频端口厅P列名数据类型长度说明1.idInt4编号2.：DMLBInt4;代码类别3.PdmVarchar10代码/扣分代码4.DMSM1varchar50国家

6、名称/驾校名称5.；DMSM2varchar50;扣分类别6.DMSM3varchar50空7.DMSM4varchar50空8.:DMSM5varchar50空9.IsUseBit11未使用,空使用4. CodeType 表结构；厅P列名数据类型长度说明1.DMLBInt4代码标号2.FdmsmVarchar50代码说明3.UserChangechar1变更5. DAY_Examine_TIME表结构：厅P列名数据类型长度说明1.KSRQdatetime8测试日期2.FycslInt4:3.LJKSSLInt46. Employee 表结构；厅P列名数据类型长度说明1.EMPLOYEEIDv

7、archar10员工ID2.I KCDMvarchar10考场代码3.GroupIDInt4分组ID4.GroupNamevarchar15分组名称5.emp_nameVarchar20 1员工名称6.EMP WORKVarchar107.PassWordStrVarchar30加密后的密码8.IsFinger1Int49.Fingertpl1image16指纹图片10.Finger1image16指纹11.IsFinger2Int4 1是否指纹12.Fingertpl2image1613.Finger2image1614.IsFinger3Int415.Fingertpl3image1616

8、.Finger3image16 117.UserDefaultMenuvarchar200用户权限7. Examine 表结构：厅P列名数据类型长度说明1.KSLSHvarchar15测试流水号2.KCDMvarchar10考场代码3.LSHvarchar15流水号4.SFZMHMchar18身份证号5.SFZMMCchar1身份证实名称6.XMvarchar30姓名7.XBchar1性别8.CSRQdatetime8出生日期9.GJchar310.DJZSXZQHvarchar1011.DJZSXXDZvarchar12812.DJZSYZBMvarchar613.LXZSXZQHvarch

9、ar1014.LXZSXXDZvarchar12815.LXZSYZBMvarchar616.LXDHvarchar20联系 17.ZZZMvarchar1818.ZZSXZQHvarchar1019.ZZSXXDZvarchar12820.ZZSYZBMvarchar621.ZZFZJGvarchar3022.ZZFZRQdatetime823.ZKZMBHvarchar12准考证实编号24.JBRvarchar3025.DLRvarchar64代理人26.GLBMvarchar3027.KSYYchar1测试原因28.KSCXvarchar2测试车型29.YKRQdatetime8约考日期

10、30.GFZXHvarchar1131.GFZKCHPvarchar1532.GFZKSYvarchar30测试员33.GFZKSY2varchar30测试员234.CKRQdatetime8考场日期35.ZXRQdatetime8最新日期36.KSCSint4测试次数37.UpDateTimedatetime8更新日期时间38.ZPJvarchar1总评价39.IsMonibit1是/否模拟40.YCKSSJdatetime8一次开始时间41.YCJSSJdatetime8一次结束时间42.YCKCHPvarchar15一次考车号牌43.YCItemFlagvarchar25一次工程上传44

11、.YCComplex100varchar30100分工程45.YCComplex20varchar3046.YCComplex10varchar30十分工程47.YCOnTheirCarvarchar30上车准备48.YCStartCarvarchar30起步49.YCAddSubDangvarchar20加减档操作50.YCThroughTheLeftInterse ctionvarchar20左转51.YCThroughTheRightInter sectionvarchar20右转52.YCStraightDrivingvarchar30直线行驶53.YCChangeDrivevarch

12、ar30变更车道54.YCThroughTheIntersectio nvarchar30通过路口55.YCThroughTheCrosswalk Linevarchar30通过人行横道56.YCBySchoolDistrictvarchar30通过学校区域57.YCThroughTheBusStationvarchar30通过公共汽车站58.YCTheCarWillvarchar30会车59.YCOvertakevarchar30超车60.YCPullOvervarchar30靠边停车61.YCTurnRoundvarchar30掉头62.YCNightDrivingvarchar30夜考6

13、3.YCComplex100Valueint4100分值64.YCComplex20Valueint465.YCComplex10Valueint410分值66.YCOnTheirCarValueint4一次上车准备值67.YCStartCarValueint4一次起步值68.YCAddSubDangValueint4一次加减档值69.YCThroughTheLeftInterseint4一次左转值ctionValue70.YCThroughTheRightInter sectionValueint4一次右转值71.YCStraightDrivingValueint4一次直线行驶值72.YCC

14、hangeDriveValueint4一次变更车道值73.YCThroughTheIntersectio nValueint4一次通过路口值74.YCThroughTheCrosswalk LineValueint4一次通过人行横道值75.YCBySchoolDistrictValueint4一次通过学校区域值76.YCThroughTheBusStationValueint4一次通过公共车站值77.YCTheCarWillValueint4一次会车值78.YCOvertakeValueint4一次超车值79.YCPullOverValueint4一次靠边停车值80.YCTurnRoundVa

15、lueint4一次掉头值81.YCNightDrivingValueint4一次夜考值82.YCKFDMvarchar250一次扣分代码83.YCGPSCountint4一次GPS数84.YCExamineKilomint4一次测试公里数85.YCMaxSpeedfloat8一次取大速度86.YCZKFint4一次总扣分87.YCKSPJvarchar1一次测试评价88.ECKSSJdatetime8二次测试时间89.ECJSSJdatetime8一次结束时间90.ECKCHPvarchar15二次考车号牌91.ECItemFlagvarchar25二次工程上传92.ECComplex100v

16、archar30二次扣100分93.ECComplex20varchar3094.ECComplex10varchar30二次扣10分95.ECOnTheirCarvarchar30二次上车准备96.ECStartCarvarchar30二次起步97.ECAddSubDangvarchar20二次加减档操作98.ECThroughTheLeftInters ectionvarchar20二次左转99.ECThroughTheRightInter sectionvarchar20二次右转100.ECStraightDrivingvarchar30二次直线行驶101.ECChangeDriveva

17、rchar30二次变更车道102.ECThroughTheIntersectio nvarchar30二次通过路口103.ECThroughTheCrosswalkLinevarchar30二次通过人行横道104.ECBySchoolDistrictvarchar30二次通过学校区域105.ECThroughTheBusStationvarchar30二次通过汽车站106.ECTheCarWillvarchar30二次会车107.ECOvertakevarchar30二次超车108.ECPullOvervarchar30二次靠边停车109.ECTurnRoundvarchar30二次掉头110

18、.ECNightDrivingvarchar30一次夜考111.ECComplex100Valueint4二次扣100分值112.ECComplex20Valueint4113.ECComplex10Valueint4二次扣10分值114.ECOnTheirCarValueint4二次上车准备值115.ECStartCarValueint4二次起步值116.ECAddSubDangValueint4同上117.ECThroughTheLeftInters ectionValueint4118.ECThroughTheRightInter sectionValueint4119.ECStraig

19、htDrivingValueint4120.ECChangeDriveValueint4121.ECThroughTheIntersectio nValueint4122.ECThroughTheCrosswalkLineValueint4123.ECBySchoolDistrictValueint4124.ECThroughTheBusStationValueint4125.ECTheCarWillValueint4126.ECOvertakeValueint4127.ECPullOverValueint4128.ECTurnRoundValueint4129.ECNightDrivingV

20、alueint4130.ECKFDMvarchar250二次扣分代码131.ECGPSCountint4二次GPS点132.ECExamineKilomint4二次测试公里数133.ECMaxSpeedfloat8二次最大速度134.ECZKFint4二次总扣分135.ECKSPJvarchar1二次测试评价136.YCUpFlagbit1一次上传137.ECUpFlagbit1二次上传138.SCBZvarchar10139.YCKFDMStrvarchar512一次扣分代码140.ECKFDMStrvarchar512二次扣分代码141.XYWvarchar208. ExamineBak

21、表结构；厅p列名数据类型长度说明1.OpertionTypevarchar20操作类型2.OpertionUservarchar20操作用户3.OpertionDateTimedatetime8操作时间4.KSLSHvarchar15测试流水号5.KCDMvarchar10考场代码6.LSHvarchar15流水号7.SFZMHMchar18身份证实号8.SFZMMCchar1身份证实名称9.XMvarchar30姓名10.XBchar1性别11.CSRQdatetime812.GJchar313.DJZSXZQHvarchar1014.DJZSXXDZvarchar12815.DJZSYZB

22、Mvarchar616.LXZSXZQHvarchar1017.LXZSXXDZvarchar12818.LXZSYZBMvarchar619.LXDHvarchar20联系 20.ZZZMvarchar1821.ZZSXZQHvarchar1022.ZZSXXDZvarchar12823.ZZSYZBMvarchar624.ZZFZJGvarchar3025.ZZFZRQdatetime826.ZKZMBHvarchar12准考证实编号27.JBRvarchar3028.DLRvarchar64代理人29.GLBMvarchar3030.KSYYchar131.KSCXvarchar2测试车

23、型32.YKRQdatetime8约考日期33.GFZXHvarchar1134.GFZKCHPvarchar1535.GFZKSYvarchar30测试员36.GFZKSY2varchar30测试员237.CKRQdatetime838.ZXRQdatetime8最新日期39.KSCSint4测试次数40.UpDateTimedatetime8更新时间41.ZPJvarchar1总评价42.IsMonibit1是否模拟43.YCKSSJdatetime8一次测试时间44.YCJSSJdatetime8一次结束时间45.YCKCHPvarchar15一次考车号牌46.YCItemFlagvar

24、char25一次工程上传47.YCComplex100varchar30一次扣100分48.YCComplex20varchar3049.YCComplex10varchar30一次扣10分50.YCOnTheirCarvarchar3051.YCStartCarvarchar3052.YCStraightDrivingvarchar3053.YCChangeDrivevarchar3054.YCThroughTheIntersectio nvarchar3055.YCThroughTheCrosswalkL inevarchar3056.YCBySchoolDistrictvarchar30

25、57.YCThroughTheBusStationvarchar3058.YCTheCarWillvarchar3059.YCOvertakevarchar3060.YCPullOvervarchar3061.YCTurnRoundvarchar3062.YCNightDrivingvarchar3063.YCComplex100Valueint464.YCComplex20Valueint465.YCComplex10Valueint466.YCOnTheirCarValueint467.YCStartCarValueint468.YCStraightDrivingValueint469.Y

26、CChangeDriveValueint470.YCThroughTheIntersectio nValueint471.YCThroughTheCrosswalkL ineValueint472.YCBySchoolDistrictValueint473.YCThroughTheBusStationValueint474.YCTheCarWillValueint475.YCOvertakeValueint476.YCPullOverValueint477.YCTurnRoundValueint478.YCNightDrivingValueint479.YCKFDMvarchar25080.Y

27、CGPSCountint481.YCExamineKilomint482.YCMaxSpeedfloat883.YCZKFint484.YCKSPJvarchar185.ECKSSJdatetime886.ECJSSJdatetime887.ECKCHPvarchar1588.ECItemFlagvarchar2589.ECComplex100varchar3090.ECComplex20varchar3091.ECComplex10varchar3092.ECOnTheirCarvarchar3093.ECStartCarvarchar3094.ECStraightDrivingvarcha

28、r3095.ECChangeDrivevarchar3096.ECThroughTheIntersectio nvarchar3097.ECThroughTheCrosswalkL inevarchar30二次通过人行横道98.ECBySchoolDistrictvarchar3099.ECThroughTheBusStationvarchar30100.ECTheCarWillvarchar30101.ECOvertakevarchar30102.ECPullOvervarchar30103.ECTurnRoundvarchar30104.ECNightDrivingvarchar30105

29、.ECComplex100Valueint4106.ECComplex20Valueint4107.ECComplex10Valueint4108.ECOnTheirCarValueint4109.ECStartCarValueint4110.ECStraightDrivingValueint4111.ECChangeDriveValueint4112.ECThroughTheIntersectio nValueint4113.ECThroughTheCrosswalkL ineValueint4114.ECBySchoolDistrictValueint4115.ECThroughTheBu

30、sStationValueint4116.ECTheCarWillValueint4117.ECOvertakeValueint4118.ECPullOverValueint4同上119.ECTurnRoundValueint4120.ECNightDrivingValueint4121.ECKFDMvarchar250122.ECGPSCountint4123.ECExamineKilomint4二次测试公里数124.ECMaxSpeedfloat8二次最大时速125.ECZKFint4二次总扣分126.ECKSPJvarchar1二次测试评价127.YCUpFlagbit1一次上传128.

31、ECUpFlagbit1二次上传129.SCBZvarchar10130.XYWvarchar209. Examinelmage 结构；厅P列名数据类型长度说明1.KSLSHvarchar15测试流水号2.DAZPimage163.YCZPimage16一次照片4.ECZPimage16二次照片5.YCZWXX1image16一次指纹信息16.YCZWXX2image167.YCKSZP1image16一次测试照片18.YCKSZP2image169.YCKSZP3image1610.YCGPSimage16一次 GPS11.ECZWXX1image16二次指纹信息112.ECZWXX2ima

32、ge1613.ECKSZP1image16二次测试照片114.ECKSZP2image1615.ECKSZP3image1616.ECGPSimage16二次 GPS10. ExamineTempTable 表结构；厅P列名数据类型长度说明1.ZKZMBHvarchar15准考证实编号2.KCHPvarchar15考车号牌3.Complex100varchar304.Complex20varchar305.Complex10varchar306.OnTheirCarvarchar307.StartCarvarchar308.StraightDrivingvarchar309.ChangeDri

33、vevarchar3010.ThroughTheIntersectionvarchar30上向有11.ThroughTheCrosswalkLin evarchar3012.BySchoolDistrictvarchar3013.ThroughTheBusStationvarchar3014.TheCarWillvarchar3015.Overtakevarchar3016.PullOvervarchar3017.TurnRoundvarchar3018.NightDrivingvarchar3011. FeeTable 表结构；厅p列名数据类型长度说明1.FeeIDint42.XMvarch

34、ar30姓名3.SFZMHMvarchar20身份证名号4.DLRvarchar128代理人5.YKRQdatetime8约考日期6.FeeMoneyint47.ChargesWerevarchar308.FeeDateTimedatetime8日期9.Statusint4状态12. FilelmageTable 表结构：厅P列名数据类型长度说明1.FileImageIDint4文件图片ID2.FileIDint4文件ID3.FilePackIDint44.FileImageimage16文件图片5.FilePackLenint413. FileTable 表结构；厅P列名数据类型长度说明1.

35、FileIDint42.FileFlagvarchar10文件上传3.FileNamevarchar50文件名4.FilePathvarchar50文件路线5.FileSizeint4文件大小6.FileDateTimedatetime8文件日期7.FilePackCountint48.FileMemovarchar100文件内容14. GPSTempTable表结构；厅P列名数据类型长度说明1.GPSIDint42.LSHvarchar20流水号3.GPSimage16GPS4.GPSCountint4GPS点5.UpDateTimedatetime8更新时间15. ImageTempTab

36、le 表结构；厅P列名数据类型长度说明1.IDint42.ZKZMBHvarchar15准考证实编号3.PhotoIDint4照片ID4.KCHPvarchar20考车号牌5.ExamImageimage16测试照片16. JXHGLTable厅P列名数据类型长度说明1.idint42.JXMCvarchar64驾校名称3.KSRSvarchar100测试人数4.HGRSvarchar100合格人数5.HGLvarchar100合格率6.A116PJCSvarchar1007.A116BFLvarchar10017. MiscarriageTable 表结构；厅P列名数据类型长度;说明1.Mi

37、scarriageIDint4误判ID号2.LSHvarchar18流水号3.KSLSHvarchar15测试流水号4.SFZMHMvarchar18身份证实号5.XMvarchar20姓名6.Reasonvarchar200原因7.Applicantvarchar30申请人8.ApplyDatedatetime8制#日期9.Approvedvarchar30获得文10.ApprovalDatedatetime8获得申请日期11.Treatmentvarchar3012.TreatmentDatedatetime813.Statusint4状态14.OldDataimage16老日期15.KS

38、CXvarchar10测试车型16.ZKZMBHvarchar15准考证实编号17.ZPJvarchar10总评价18. NightExamine 表结构；序号列名数据类型长度;说明1.KSLSHvarchar15测试流水号2.KCDMvarchar10考场代码3.LSHvarchar15流水号4.SFZMHMchar18身份证实号5.SFZMMCchar1身份证实名称6.XMvarchar30姓名7.XBchar1性别8.CSRQdatetime89.GJchar310.DJZSXZQHvarchar1011.DJZSXXDZvarchar12812.DJZSYZBMvarchar613.L

39、XZSXZQHvarchar1014.LXZSXXDZvarchar12815.LXZSYZBMvarchar616.LXDHvarchar2017.ZZZMvarchar1818.ZZSXZQHvarchar1019.ZZSXXDZvarchar12820.ZZSYZBMvarchar621.ZZFZJGvarchar3022.ZZFZRQdatetime823.ZKZMBHvarchar12准考证实编号24.JBRvarchar3025.DLRvarchar64代理人26.GLBMvarchar3027.KSYYchar1测试原因28.KSCXvarchar2测试车型29.YKRQdate

40、time8约考日期30.GFZXHvarchar1131.GFZKCHPvarchar1532.GFZKSYvarchar3033.GFZKSY2varchar3034.CKRQdatetime835.ZXRQdatetime8最新日期36.KSCSint4测试次数37.UpDateTimedatetime8更新时间38.ZPJvarchar1总评价39.IsMonibit1是否模拟40.YCKSSJdatetime8一次测试时间41.YCJSSJdatetime8一次结束时间42.YCKCHPvarchar15一次考车号牌43.YCItemFlagvarchar25一次工程上传44.YCCo

41、mplex100varchar30扣100分值45.YCComplex20varchar3046.YCComplex10varchar30扣10分值47.YCOnTheirCarvarchar30一次上车准备48.YCStartCarvarchar30一次起步49.YCStraightDrivingvarchar30一次直线行驶50.YCChangeDrivevarchar30一次变更车道51.YCThroughTheIntersectio nvarchar30一次通过路口52.YCThroughTheCrosswalkL inevarchar30一次通过人行横道53.YCBySchoolDi

42、strictvarchar30一次通过学校区域54.YCThroughTheBusStationvarchar30一次通过公共汽车站55.YCTheCarWillvarchar30一次会车56.YCOvertakevarchar30一次超车57.YCPullOvervarchar30一次靠边停车58.YCTurnRoundvarchar30一次掉头59.YCNightDrivingvarchar30一次夜考60.YCComplex100Valueint4一次扣100分值61.YCComplex20Valueint462.YCComplex10Valueint4一次扣10分值63.YCOnTheirCarValueint464.YCStartCarValueint465.YCStraightDrivingValueint466.YCChangeDrive