M6 — DB 연동 학습 (조회 / 변경)

13:00–17:00 · PLC/MES → SQLite → AAS Property · GET/PUT 양방향
M6
PLC → DB → AAS → 대시보드 전체 데이터 파이프라인
🏭PLC / MES조립 셀 S513 실시간CTkpi · OEE · 품질5분 주기기록🗄️SQLite DBequipment_propertyequipment_state_logDB 조회DB 쓰기⚙️ Demo Server.NET 8 · Port 5080BaSyx REST v3Base64Url ID 인코딩PUT / GETJSON 응답📋 AAS SubmodelSeqSimSm · SeqMaintSmOEEkpi=0.852CTkpi=18.5s3초 폴링/snapshot🖥️모니터링 대시보드/dashboard.htmlOEE · CT · 품질 표시⟳ PUT → GET 라운드트립 검증
GET / PUT 학습 흐름도
학습자 학습Demo ServerSQLite DB── GET (조회) ──GET /api/v3.0/shells200 OK [14 shells]GET /submodels/{smId}SeqSimSm JSON (OEEkpi=0.852)── PUT (변경) ──PUT /submodels/{smId} (Nameplate JSON)DB 쓰기204 No Content ✓GET /submodels/{smId} (검증)변경된 값 일치 확인 ✓⟳ PUT → GET → 대시보드 3초 후 반영 = 라운드트립 완성
DB 필드 ↔ AAS Property 매핑
🗄 equipment_property📋 AAS PropertyoeeREAL↔OEEkpixs:double = 0.852cycle_timeREAL↔CTkpixs:double = 18.5sthroughputREAL↔TPkpixs:double = 142.3/hquality_score_avgREAL↔quality_score_avg= 98.7%availabilityREAL↔RUkpi= 0.921maintenance_dateTEXT↔NextMaintenanceDateSeqMaintSmOEE 검증 공식Availability × Performance × Quality = OEEkpi0.921 × 0.937 × 0.987 = 0.852