Article(id=1217470429502034326, tenantId=1146029695717560320, journalId=1189873562199433220, issueId=1217470424573727039, articleNumber=null, orderNo=null, doi=10.19710/J.cnki.1003-8817.20220386, pmid=null, cstr=null, oa=null, hot=null, price=null, onlineType=0, articleFormat=0, articleType=null, articleTypeStr=research-article, receivedDate=null, receivedDateStr=null, revisedDate=null, revisedDateStr=null, acceptedDate=null, acceptedDateStr=null, onlineDate=1768197169900, onlineDateStr=2026-01-12, pubDate=1689782400000, pubDateStr=2023-07-20, doiRegisterDate=null, doiRegisterDateStr=null, onlineIssueDate=1768197169900, onlineIssueDateStr=2026-01-12, onlineJustAcceptDate=null, onlineJustAcceptDateStr=null, onlineFirstDate=null, onlineFirstDateStr=null, sourceXml=null, magXml=null, createTime=1768197169900, creator=13701087609, updateTime=1768197169900, updator=13701087609, issue=Issue{id=1217470424573727039, tenantId=1146029695717560320, journalId=1189873562199433220, year='2023', volume='', issue='7', pageStart='1', pageEnd='72', issueExtLink='null', onlineDate='null', pubDate='null', beforeIssueId=null, nextIssueId=null, price=null, status=1, issueComplete=1, articleOrder=1, issueType=-1, specialIssue=null, createTime=1768197168725, creator=13701087609, updateTime=1768198089128, updator=13701087609, preIssue=null, nextIssue=null, ext={EN=IssueExt(id=1217474285078233609, tenantId=1146029695717560320, journalId=1189873562199433220, issueId=1217470424573727039, language=EN, specialIssueTitle=, coverIllustrator=null, specialIssueEditor=, specialIssueAbout=), CN=IssueExt(id=1217474285078233610, tenantId=1146029695717560320, journalId=1189873562199433220, issueId=1217470424573727039, language=CN, specialIssueTitle=, coverIllustrator=null, specialIssueEditor=, specialIssueAbout=)}, issueFiles=null}, startPage=68, endPage=72, ext={EN=ArticleExt(id=1217470429799829925, articleId=1217470429502034326, tenantId=1146029695717560320, journalId=1189873562199433220, language=EN, title=The Detection System of Automobile Manufacturing Parts Based on Machine Vision Technology, columnId=null, journalTitle=Automobile Technology & Material, columnName=null, runingTitle=null, highlight=null, articleAbstract=
A complete visual inspection system based on YOLOv5 combining with PLC, RFID, Python, OpenCV and DingTalk, was designed to replace manual inspection and recognition of the installation status of automotive parts. Accuracy and recall rate of the sample models trained in this system are both above 98%. From actual operation observation, the probability of identifying and accurately reminding is above 99%, and it meets the requirements of production takt, superior to the actual results of current manual detection, with low cost and good economic promotion.
, correspAuthors=null, authorNote=null, correspAuthorsNote=null, copyrightStatement=null, copyrightOwner=null, extLink=null, articleAbsUrl=null, sourceXml=null, magXml=null, pdfUrl=null, pdf=null, pdfFileSize=null, pdfExtLink=null, richHtmlUrl=null, mobilePdfUrl=null, reviewReport=null, pdfFirstPage=null, abstractGraph=null, abstractGraphContent=null, abstractVideo=null, citation=null, cebUrl=null, magXmlContent=null, mapNumber=null, authorCompany=null, fund=null, authors=null, authorsList=Jincheng Wang, Xing Liu), CN=ArticleExt(id=1217470430647079373, articleId=1217470429502034326, tenantId=1146029695717560320, journalId=1189873562199433220, language=CN, title=基于机器视觉技术的汽车制造零件检测系统, columnId=1192072540240626067, journalTitle=汽车工艺与材料, columnName=生产装备, runingTitle=null, highlight=null, articleAbstract=
为代替人工完成汽车零件安装状态的检测识别,基于YOLOv5算法并结合PLC、RFID、Python、OpenCV、钉钉即时移动通讯软件设计形成一套完整的视觉检测系统。该系统种所训练得到的样本模型准确率和召回率均在98%以上,从实际运行观察,其识别并准确提醒的概率在99%以上,并且可满足生产节拍需求,优于目前人工检测的实际效果,成本较低具备良好的经济推广性。
, correspAuthors=null, authorNote=null, correspAuthorsNote=null, copyrightStatement=null, copyrightOwner=null, extLink=null, articleAbsUrl=null, sourceXml=qIJgI76lL+zs4kY6BCMdPw==, magXml=xzoDQZ47obzZtrQ6Xo1/uA==, pdfUrl=null, pdf=dz6qG0SRtfT1fk5sclYZyg==, pdfFileSize=1248653, pdfExtLink=null, richHtmlUrl=null, mobilePdfUrl=null, reviewReport=null, pdfFirstPage=null, abstractGraph=zgRT+LQUGm6uq+qnKDgjTg==, abstractGraphContent=null, abstractVideo=null, citation=null, cebUrl=null, magXmlContent=tF83WPf9WUH35OaXt1op1w==, mapNumber=null, authorCompany=null, fund=null, authors=
王金成(1982—),男,工程师,硕士学位,研究方向为智能制造和工厂数智化。
, authorsList=王金成, 刘兴)}, authors=[Author(id=1217498606706278617, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, orderNo=0, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=null, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1217498606811136226, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, authorId=1217498606706278617, language=EN, stringName=Jincheng Wang, firstName=Jincheng, middleName=null, lastName=Wang, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=FAW Volkswagen Co., Ltd, Foshan Branch, Foshan 528000, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null), CN=AuthorExt(id=1217498606895022311, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, authorId=1217498606706278617, language=CN, stringName=王金成, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=一汽-大众汽车有限公司佛山分公司,佛山 528000, bio={"content":"
王金成(1982—),男,工程师,硕士学位,研究方向为智能制造和工厂数智化。
"}, bioImg=null, bioContent=
王金成(1982—),男,工程师,硕士学位,研究方向为智能制造和工厂数智化。
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1217498606614003921, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, xref=null, ext=[AuthorCompanyExt(id=1217498606618198226, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, companyId=1217498606614003921, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=FAW Volkswagen Co., Ltd, Foshan Branch, Foshan 528000), AuthorCompanyExt(id=1217498606626586834, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, companyId=1217498606614003921, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=一汽-大众汽车有限公司佛山分公司,佛山 528000)])]), Author(id=1217498606995685612, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, orderNo=1, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=null, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1217498607117320436, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, authorId=1217498606995685612, language=EN, stringName=Xing Liu, firstName=Xing, middleName=null, lastName=Liu, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=FAW Volkswagen Co., Ltd, Foshan Branch, Foshan 528000, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null), CN=AuthorExt(id=1217498607268315385, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, authorId=1217498606995685612, language=CN, stringName=刘兴, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=一汽-大众汽车有限公司佛山分公司,佛山 528000, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1217498606614003921, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, xref=null, ext=[AuthorCompanyExt(id=1217498606618198226, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, companyId=1217498606614003921, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=FAW Volkswagen Co., Ltd, Foshan Branch, Foshan 528000), AuthorCompanyExt(id=1217498606626586834, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, companyId=1217498606614003921, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=一汽-大众汽车有限公司佛山分公司,佛山 528000)])])], keywords=[Keyword(id=1217498608660824324, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=EN, orderNo=1, keyword=Vehicle production), Keyword(id=1217498608753099017, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=EN, orderNo=2, keyword=YOLOv5), Keyword(id=1217498608832790799, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=EN, orderNo=3, keyword=Python), Keyword(id=1217498608916676882, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=EN, orderNo=4, keyword=Testing), Keyword(id=1217498609067671829, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=CN, orderNo=1, keyword=整车生产), Keyword(id=1217498609138975002, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=CN, orderNo=2, keyword=YOLOv5), Keyword(id=1217498609302552864, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=CN, orderNo=3, keyword=Python), Keyword(id=1217498609390633254, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=CN, orderNo=4, keyword=检测)], refs=[Reference(id=1217498610397266270, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, doi=null, pmid=null, pmcid=null, year=2021, volume=null, issue=1, pageStart=115, pageEnd=116, url=null, language=null, rfNumber=[1], rfOrder=0, authorNames=许有健, 吴涛, 梁玉环, journalName=制造与工艺, refType=null, unstructuredReference=许有健, 吴涛, 梁玉环. 质量信息管理系统在汽车制造质量控制中的应用[J].
制造与工艺,
2021(1): 115-116., articleTitle=质量信息管理系统在汽车制造质量控制中的应用, refAbstract=null), Reference(id=1217498610481152355, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, doi=null, pmid=null, pmcid=null, year=2021, volume=null, issue=2, pageStart=103, pageEnd=106, url=null, language=null, rfNumber=[2], rfOrder=1, authorNames=唐艳, 胡桐, journalName=企业管理, refType=null, unstructuredReference=唐艳, 胡桐. 美的数智化"探索[J].
企业管理 2021(2):103-106., articleTitle=美的数智化"探索, refAbstract=null), Reference(id=1217498610552455525, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, doi=null, pmid=null, pmcid=null, year=2020, volume=null, issue=10, pageStart=66, pageEnd=68, url=null, language=null, rfNumber=[3], rfOrder=2, authorNames=陈莉, journalName=电器, refType=null, unstructuredReference=陈莉. 美的"数智四剑客"亮相工博会, 美云智数"立腕"最懂制造业的数字规划师[J].
电器,
2020(10): 66-68., articleTitle=美的"数智四剑客"亮相工博会, 美云智数"立腕"最懂制造业的数字规划师, refAbstract=null), Reference(id=1217498610653118828, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, doi=null, pmid=null, pmcid=null, year=2020, volume=null, issue=6, pageStart=150, pageEnd=153, url=null, language=null, rfNumber=[4], rfOrder=3, authorNames=张丽秀, 田甜, 邵萌, journalName=组合机床与自动化加工技术, refType=null, unstructuredReference=张丽秀, 田甜, 邵萌. 基于改进的YOLO V3算法汽车零件配置辨识[J].
组合机床与自动化加工技术,
2020(6): 150-153., articleTitle=基于改进的YOLO V3算法汽车零件配置辨识, refAbstract=null), Reference(id=1217498610749587823, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, doi=null, pmid=null, pmcid=null, year=2022, volume=null, issue=4, pageStart=1292, pageEnd=1300, url=null, language=null, rfNumber=[5], rfOrder=4, authorNames=张锦, 屈佩琪, 孙程, journalName=计算机应用, refType=null, unstructuredReference=张锦, 屈佩琪, 孙程, 等. 基于改进YOLOv5的安全帽佩戴检测算法[J].
计算机应用,
2022(4): 1292-1300., articleTitle=基于改进YOLOv5的安全帽佩戴检测算法, refAbstract=null), Reference(id=1217498610862834036, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=65, pageEnd=67, url=null, language=null, rfNumber=[6], rfOrder=5, authorNames=王莉茹, journalName=西藏科技, refType=null, unstructuredReference=王莉茹. 基于YOLOv5s 的口罩佩带检测[J].
西藏科技: 65-67., articleTitle=基于YOLOv5s 的口罩佩带检测, refAbstract=null), Reference(id=1217498610959303031, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, doi=null, pmid=null, pmcid=null, year=2019, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=[7], rfOrder=6, authorNames=李立宗, journalName=OpenCV轻松入门面向Python, refType=null, unstructuredReference=李立宗.
OpenCV轻松入门面向Python[M]. 北京: 电子工业出版社,
2019., articleTitle=null, refAbstract=null), Reference(id=1217498611064160639, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, doi=null, pmid=null, pmcid=null, year=2020, volume=39, issue=5, pageStart=6, pageEnd=11, url=null, language=null, rfNumber=[8], rfOrder=7, authorNames=田佳鹭, 邓立国, journalName=信息技术与网络安全, refType=null, unstructuredReference=田佳鹭, 邓立国. 基于改进VGG16的猴子图像分类方法[J].
信息技术与网络安全,
2020,
39(5): 6-11., articleTitle=基于改进VGG16的猴子图像分类方法, refAbstract=null), Reference(id=1217498611169018244, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, doi=null, pmid=null, pmcid=null, year=2021, volume=29, issue=3, pageStart=30, pageEnd=33, url=null, language=null, rfNumber=[9], rfOrder=8, authorNames=徐晓, journalName=电脑与信息技术, refType=null, unstructuredReference=徐晓. 基于C和OpenCV相结合的猫脸识别研究[J].
电脑与信息技术,
2021,
29(3): 30-33., articleTitle=基于C和OpenCV相结合的猫脸识别研究, refAbstract=null), Reference(id=1217498611257098633, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, doi=null, pmid=null, pmcid=null, year=2022, volume=null, issue=3, pageStart=180, pageEnd=186, url=null, language=null, rfNumber=[10], rfOrder=9, authorNames=杨雪珂, 熊先青, journalName=林业工程学报, refType=null, unstructuredReference=杨雪珂, 熊先青. 家具生产线射频识别技术的信息采集与应用[J].
林业工程学报,
2022(3): 180-186., articleTitle=家具生产线射频识别技术的信息采集与应用, refAbstract=null), Reference(id=1217498611340984716, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, doi=null, pmid=null, pmcid=null, year=2019, volume=null, issue=4, pageStart=39, pageEnd=42, url=null, language=null, rfNumber=[11], rfOrder=10, authorNames=郭佳琛, journalName=中国信息安全, refType=null, unstructuredReference=郭佳琛. 网络摄像头的安全威胁技术分析[J].
中国信息安全,
2019(4): 39-42., articleTitle=网络摄像头的安全威胁技术分析, refAbstract=null), Reference(id=1217498611433259409, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, doi=null, pmid=null, pmcid=null, year=2020, volume=null, issue=8, pageStart=900, pageEnd=903, url=null, language=null, rfNumber=[12], rfOrder=11, authorNames=李红永, journalName=中国有线电视, refType=null, unstructuredReference=李红永. Python监听服务器业务并利用钉钉机器人实现报警[J].
中国有线电视,
2020(8): 900-903., articleTitle=Python监听服务器业务并利用钉钉机器人实现报警, refAbstract=null)], funds=null, companyList=[AuthorCompany(id=1217498606614003921, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, xref=null, ext=[AuthorCompanyExt(id=1217498606618198226, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, companyId=1217498606614003921, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=FAW Volkswagen Co., Ltd, Foshan Branch, Foshan 528000), AuthorCompanyExt(id=1217498606626586834, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, companyId=1217498606614003921, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=一汽-大众汽车有限公司佛山分公司,佛山 528000)])], figs=[ArticleFig(id=1217498609587765554, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=EN, label=null, caption=null, figureFileSmall=QBa/GUVuigEd5oJ8bhH4wQ==, figureFileBig=m8/FgpTe6sLxqKO99R7kxg==, tableContent=null), ArticleFig(id=1217498609663263032, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=CN, label=图1, caption=
系统网络拓扑结构, figureFileSmall=QBa/GUVuigEd5oJ8bhH4wQ==, figureFileBig=m8/FgpTe6sLxqKO99R7kxg==, tableContent=null), ArticleFig(id=1217498609751343422, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=EN, label=null, caption=null, figureFileSmall=0kj3hxrIwcthDgdA/IcGLg==, figureFileBig=Y2J9Rq/IIHfrjqHg6Xpwnw==, tableContent=null), ArticleFig(id=1217498609835229508, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=CN, label=图2, caption=
语音屏报警逻辑流程, figureFileSmall=0kj3hxrIwcthDgdA/IcGLg==, figureFileBig=Y2J9Rq/IIHfrjqHg6Xpwnw==, tableContent=null), ArticleFig(id=1217498609919115592, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=EN, label=null, caption=null, figureFileSmall=null, figureFileBig=null, tableContent=
| 零件 | 分类 数量/个 | Train图片数/张 | Test图片数/张 | 精确率 |
| 门槛亮条 | 9 | 3 722 | 712 | 0.989 17 |
| 侧标 | 6 | 3 120 | 652 | 0.988 21 |
| 车顶天线 | 2 | 696 | 93 | 0.999 77 |
| 尾标logo | 2 | 420 | 152 | 0.997 28 |
| 尾标 | 8 | 3 600 | 730 | 0.988 22 |
| 酒精罐插头 | 2 | 1 314 | 307 | 0.999 57 |
| 后杠固定条 | 2 | 282 | 33 | 0.998 64 |
| 左侧裙 | 3 | 2 210 | 512 | 0.991 12 |
| 右侧裙 | 3 | 2 210 | 512 | 0.992 09 |
| 左胶堵 | 2 | 1 960 | 435 | 0.993 08 |
| 右胶堵 | 2 | 1 381 | 306 | 0.999 09 |
), ArticleFig(id=1217498609998807371, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=CN, label=表1, caption=
各零件模型训练信息
, figureFileSmall=null, figureFileBig=null, tableContent=
| 零件 | 分类 数量/个 | Train图片数/张 | Test图片数/张 | 精确率 |
| 门槛亮条 | 9 | 3 722 | 712 | 0.989 17 |
| 侧标 | 6 | 3 120 | 652 | 0.988 21 |
| 车顶天线 | 2 | 696 | 93 | 0.999 77 |
| 尾标logo | 2 | 420 | 152 | 0.997 28 |
| 尾标 | 8 | 3 600 | 730 | 0.988 22 |
| 酒精罐插头 | 2 | 1 314 | 307 | 0.999 57 |
| 后杠固定条 | 2 | 282 | 33 | 0.998 64 |
| 左侧裙 | 3 | 2 210 | 512 | 0.991 12 |
| 右侧裙 | 3 | 2 210 | 512 | 0.992 09 |
| 左胶堵 | 2 | 1 960 | 435 | 0.993 08 |
| 右胶堵 | 2 | 1 381 | 306 | 0.999 09 |
), ArticleFig(id=1217498610124636498, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=EN, label=null, caption=null, figureFileSmall=null, figureFileBig=null, tableContent=
| 序号 | 数据表名 | 数据表简要描述 |
| 1 | A402_qrk1_visual_realtime | 楼上QRK1实时更新表格用于更新结果 |
| 2 | A403_qrk1_visual_history | QRK1历史记录表格 |
| 3 | A405_qrk1_visual_dispose | 楼上QRK1视觉识别图片配置表格 |
| 4 | A406_qrk1_visual_photo_disopse | 楼上图片拍照配置表格 |
| 5 | A408_qrk1_visual_plc | 实时获取吊具号和KEN号 |
| 6 | A410_qrk1_visual_realtime | 车辆实时数据 |
| 7 | A420_qrk1_visual_real_time | 更新结果及判断数据新旧使用 |
| 8 | A422_qrk1_visual_real_time | 4040工位实时数据使用 |
| 9 | A423_qrk1_visual_history | 4040工位历史数据使用 |
| 10 | A425_qrk1_visual_dispose | Yolov5识别图片参数使用 |
| 11 | A428_qrk1_visual_plc | 4040工位获取吊具和ken号 |
| 12 | A430_qrk1_image | 楼上识别视觉图片结果 |
| 13 | A431_qrk1_image_history | 4040工位图片存储位置 |
), ArticleFig(id=1217498610200133973, tenantId=1146029695717560320, journalId=1189873562199433220, articleId=1217470429502034326, language=CN, label=表2, caption=
系统数据库结构简要说明
, figureFileSmall=null, figureFileBig=null, tableContent=
| 序号 | 数据表名 | 数据表简要描述 |
| 1 | A402_qrk1_visual_realtime | 楼上QRK1实时更新表格用于更新结果 |
| 2 | A403_qrk1_visual_history | QRK1历史记录表格 |
| 3 | A405_qrk1_visual_dispose | 楼上QRK1视觉识别图片配置表格 |
| 4 | A406_qrk1_visual_photo_disopse | 楼上图片拍照配置表格 |
| 5 | A408_qrk1_visual_plc | 实时获取吊具号和KEN号 |
| 6 | A410_qrk1_visual_realtime | 车辆实时数据 |
| 7 | A420_qrk1_visual_real_time | 更新结果及判断数据新旧使用 |
| 8 | A422_qrk1_visual_real_time | 4040工位实时数据使用 |
| 9 | A423_qrk1_visual_history | 4040工位历史数据使用 |
| 10 | A425_qrk1_visual_dispose | Yolov5识别图片参数使用 |
| 11 | A428_qrk1_visual_plc | 4040工位获取吊具和ken号 |
| 12 | A430_qrk1_image | 楼上识别视觉图片结果 |
| 13 | A431_qrk1_image_history | 4040工位图片存储位置 |
)], attaches=null, journal=Journal(id=1149695537990905873, delFlag=0, nameCn=汽车工艺与材料, nameEn=Automobile Technology & Material, nameHistory1=null, nameHistory2=null, issn=1003-8817, eissn=null, cn=22-1187/U, coden=null, periodic=Monthly, language=CN, oaType=null, ccby=null, superviseOffice=null, ownerOffice=null, pubOffice=null, editorOffice=null, officeType=null, aims=null, clcCode=null, officeProv=null, officeCity=null, officeAddr=null, officeZip=null, officeEmail=null, officePhone=null, editDirector=null, officeDirector=null, officeDirectorPhone=null, officeStaffNum=null, officeEmpNum=null, coverPicUrl=EBkYJ12CSpR8ZrXZjv/pYQ==, journalPrice=null, startedYear=null, abbrevIsoEn=null, journalRemark=null, publicationField=null, createdTime=1752038376569, updatedTime=1761735695609, createdBy=18614031015, updatedBy=13701087609, firstLetterCn=A, firstLetterEn=A, subjectCode=Engineering, subjectName=Engineering, subjectCodeEn=Engineering, subjectNameEn=null, picCn=EBkYJ12CSpR8ZrXZjv/pYQ==, picEn=ZHRsuN+WSBmI0ZKvacWZGg==, jcr=null, cjcr=null, exts=[JournalExt(id=1190369042188832930, language=CN, name=汽车工艺与材料, nameHistory1=null, nameHistory2=null, managedBy=, sponsoredBy=, publishedBy=, editorOffice=, officeProv=null, officeCity=null, officeAddr=, officeZip=, editDirector=, officeDirector=null, officePhone=null, coverPicUrl=null, journalRemark=, submitArticleUrl=null, websiteUrl=, createdTime=1761735695645, updatedTime=1761735695645, createdBy=13701087609, updatedBy=13701087609, submissionGuidelinesUrl=, submissionAuthorUrl=https://qcgy.cbpt.cnki.net/EditorEN/index.aspx?t=1, submissionEditorUrl=https://qcgy.cbpt.cnki.net/EditorEN/index.aspx?t=3, submissionReviewUrl=https://qcgy.cbpt.cnki.net/EditorEN/index.aspx?t=2, submissionCeEditorUrl=, submissionAeEditorUrl=, option={"copyright":""}), JournalExt(id=1190369042272719011, language=EN, name=Automobile Technology & Material, nameHistory1=null, nameHistory2=null, managedBy=, sponsoredBy=, publishedBy=, editorOffice=, officeProv=null, officeCity=null, officeAddr=, officeZip=, editDirector=, officeDirector=null, officePhone=null, coverPicUrl=null, journalRemark=, submitArticleUrl=null, websiteUrl=, createdTime=1761735695665, updatedTime=1761735695665, createdBy=13701087609, updatedBy=13701087609, submissionGuidelinesUrl=, submissionAuthorUrl=https://qcgy.cbpt.cnki.net/EditorEN/index.aspx?t=1, submissionEditorUrl=https://qcgy.cbpt.cnki.net/EditorEN/index.aspx?t=3, submissionReviewUrl=https://qcgy.cbpt.cnki.net/EditorEN/index.aspx?t=2, submissionCeEditorUrl=, submissionAeEditorUrl=, option={"copyright":""})], databaseList=null, tenantJournalId=1189873562199433220, websiteList=[Website(id=1189873845868761153, webName=null, webTitle=null, webDomain=null, webCopyrigh=null, webIpcNo=null, seoTitle=null, seoKeywords=null, seoDescription=null, tenantJournalId=null, journalId=1189873562199433220, journalNameCn=null, journalNameEn=null, grayFlag=null, tenantId=1146029695717560320, platformId=null, journalGroupId=null, journalGroupNameCn=null, journalGroupNameEn=null, type=1, domain=https://castjournals.cast.org.cn/joweb/qcgyycl/CN, language=CN, createTime=1761617631642, createBy=18614031015, updateTime=1761617686759, updateBy=18614031015, name=汽车工艺与材料-中文, tplId=1146099689490845704, title=汽车工艺与材料, delFlag=0, indexPage=/home, props=[WebsiteProps(id=1189875402131698022, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873845868761153, code=articleTextType, value=kx, createTime=1761618002684, updateTime=1761618002684, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875402098143587, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873845868761153, code=banner, value=null, createTime=1761618002676, updateTime=1761618002676, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875402186223977, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873845868761153, code=grayFlag, value=0, createTime=1761618002697, updateTime=1761618002697, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875402081366370, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873845868761153, code=logo, value=https://castjournals.cast.org.cn/joweb/qcgyycl/CN/file/pic?fileId=E4N6Gi2LAZXbROJyHI+u1g==, createTime=1761618002672, updateTime=1761618002672, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875402203001195, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873845868761153, code=minRunFlag, value=0, createTime=1761618002701, updateTime=1761618002701, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875402123309413, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873845868761153, code=picServerUrl, value=https://castjournals.cast.org.cn/joweb/qcgyycl/CN/file/pic, createTime=1761618002682, updateTime=1761618002682, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875402194612586, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873845868761153, code=silenceFlag, value=0, createTime=1761618002699, updateTime=1761618002699, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875402110726500, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873845868761153, code=staticResourcePath, value=https://castjournals.cast.org.cn/joweb/cast_kjdb_cn_619/, createTime=1761618002679, updateTime=1761618002679, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875402144280935, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873845868761153, code=themeColor, value=null, createTime=1761618002687, updateTime=1761618002687, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875402169446760, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873845868761153, code=themeStyle, value=null, createTime=1761618002694, updateTime=1761618002694, creator=18614031015, updator=18614031015)]), Website(id=1189873846040727621, webName=null, webTitle=null, webDomain=null, webCopyrigh=null, webIpcNo=null, seoTitle=null, seoKeywords=null, seoDescription=null, tenantJournalId=null, journalId=1189873562199433220, journalNameCn=null, journalNameEn=null, grayFlag=null, tenantId=1146029695717560320, platformId=null, journalGroupId=null, journalGroupNameCn=null, journalGroupNameEn=null, type=1, domain=https://castjournals.cast.org.cn/joweb/qcgyycl/EN, language=EN, createTime=1761617631683, createBy=18614031015, updateTime=1761617707358, updateBy=18614031015, name=汽车工艺与材料-英文, tplId=1146101810881728533, title=Automobile Technology & Material, delFlag=0, indexPage=/home, props=[WebsiteProps(id=1189875426081181783, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873846040727621, code=articleTextType, value=kx, createTime=1761618008394, updateTime=1761618008394, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875426056015956, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873846040727621, code=banner, value=null, createTime=1761618008388, updateTime=1761618008388, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875426102153306, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873846040727621, code=grayFlag, value=0, createTime=1761618008399, updateTime=1761618008399, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875426047627347, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873846040727621, code=logo, value=https://castjournals.cast.org.cn/joweb/qcgyycl/EN/file/pic?fileId=E4N6Gi2LAZXbROJyHI+u1g==, createTime=1761618008386, updateTime=1761618008386, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875426114736220, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873846040727621, code=minRunFlag, value=0, createTime=1761618008402, updateTime=1761618008402, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875426072793174, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873846040727621, code=picServerUrl, value=https://castjournals.cast.org.cn/joweb/qcgyycl/EN/file/pic, createTime=1761618008392, updateTime=1761618008392, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875426110541915, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873846040727621, code=silenceFlag, value=0, createTime=1761618008401, updateTime=1761618008401, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875426064404565, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873846040727621, code=staticResourcePath, value=https://castjournals.cast.org.cn/joweb/cast_kjdb_en_623/, createTime=1761618008390, updateTime=1761618008390, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875426089570392, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873846040727621, code=themeColor, value=null, createTime=1761618008396, updateTime=1761618008396, creator=18614031015, updator=18614031015), WebsiteProps(id=1189875426093764697, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1189873846040727621, code=themeStyle, value=null, createTime=1761618008397, updateTime=1761618008397, creator=18614031015, updator=18614031015)])], journalTitle=汽车工艺与材料, weixinUrl=null, journalUrl=https://qcgyycl.cbpt.cnki.net/, iacademicId=null, status=1, seqNo=null, journalTitleEn=Automobile Technology & Material, journalPhotoCn=EBkYJ12CSpR8ZrXZjv/pYQ==, journalPhotoEn=ZHRsuN+WSBmI0ZKvacWZGg==, journalFirstLetter=A, journalRecommend=null, journalNew=null, journalCollection=null, jcrJf=null, cjcrJf=null, jcrJfStr=null, cjcrJfStr=null, submissionFirstDecision=null, sciSubjectClassification=null, casSubjectClassification=null, citeScore=null, totalCitationFrequency=null, icpCode=null, psCode=null, advertisingLicenseCode=null, copyrightInformation=null, country=null, option=, provinceCode=null, provinceName=null, collectFlag=false), detailUrlCn=https://castjournals.cast.org.cn/joweb/qcgyycl/CN/10.19710/J.cnki.1003-8817.20220386, detailUrlEn=https://castjournals.cast.org.cn/joweb/qcgyycl/EN/10.19710/J.cnki.1003-8817.20220386, pdfUrlCn=https://castjournals.cast.org.cn/joweb/qcgyycl/CN/PDF/10.19710/J.cnki.1003-8817.20220386, pdfUrlEn=https://castjournals.cast.org.cn/joweb/qcgyycl/EN/PDF/10.19710/J.cnki.1003-8817.20220386, aliStartDate=null, aliEndDate=null, collectionFlag=false, citedCount=null, citedUrl=null, reference=null)