SS
Tables (13)
DefectClasses
- ClassID — int — NOT NULL
- Name — varchar(252)
- HmiName — nvarchar(255)
- ModelType — int
- ModelID — int
- OutputID — int
- DisID — int
- ClassLevel — int
- Color — varchar(32)
- Status — char(1)
- Code — char(2)
- Process — varchar(10)
- MarginTop — float
- MarginTail — float
- MarginSide — float
- OrderSide — int
- MergeWidth0 — float
- MergeHeight0 — float
- MergeWidth01 — float
- MergeHeight01 — float
- SizeMin — float
- SizeMax — float
- WidthMin — float
- HeightMin — float
- RatioMin — float
- RatioMax — float
- MkFlag — char(1)
Defect_Class
- ClassID — int — Primary key — NOT NULL — pk index
- Name — varchar(255) — 변수명
- HmiName — varchar(255) — 결함 이름
- ModelType — int — 검출 모델 타입??
- ModelID — int
- OutputID — int
- DisID — int
- ClassLevel — int
- Color — varchar(32) — 화면 표시 컬러
- Status — char(1)
- Code — char(2)
- Process — varchar(10)
- MarginHead — float
- MarginTail — float
- MarginSide — float
- OrderSide — float
- MergeWidth0 — float
- MergeHeight0 — float
- MergeWidth1 — float
- MergeHeight1 — float
- SizeMin — float
- SizeMax — float
- WidthMin — float
- HeightMin — float
- RatioMin — float
- RatioMax — float
- MkFlag — char(1)
Defects
- SlabID — int — Primary key — NOT NULL — index
- ClassID — int — Foreign key → Defect_Class.ClassID — NOT NULL — pk index
- idx_d — numeric(18, 0) — pk index
- 1) — NOT — NOT NULL
- DefectID — int — NOT NULL — 검출 index
- Surface — int — NOT NULL — 측정면 상하좌우
- Side — int — 상하면 좌우 구분용
- Grade — int
- PositionCD — numeric(15, 4)
- PositionRCD — numeric(15, 4)
- PositinoMD — numeric(15, 4)
- SizeCD — numeric(15, 4)
- SizeMD — numeric(15, 4)
- ImgNo — int — 측정 이미지 번호
- DefectNo — int — ID와 중복??? xx
- MergeTo — int
- Confidence — int
- RoiX0 — int
- RoiX1 — int
- RoiY0 — int
- RoiY1 — int
- OriginalClass — int
- InternalStatus — int
- ProdClass — int
- SizeArea — numeric(15, 4)
- OrgArea — numeric(15, 4)
- MkFlag — char(1)
- MkMsos — bit — 통계용?
Machine
- m_idx — char(1) — Primary key — NOT NULL
- m_name — varchar(50)
Markings
- SlabID — int — Primary key — NOT NULL
- MarkingID — int — Primary key — NOT NULL
- Surface — int
- RoiX0 — int
- RoiX1 — int
- RoiY0 — int
- RoiY1 — int
Slabs_Result
- SlabID — int — Primary key — NOT NULL — index
- idx_sr — numeric(18, 0) — pk index
- 1) — NOT — NOT NULL
- Surface — int — NOT NULL — 측정면 상하좌우 (0, 1, 2, 3 or 1, 2, 3, 4)
- StartTime — datetime — 측정시작시간
- EndTime — datetime — 측정 종료 시간
- ImgPath — varchar(255) — 이미지 경로
- ScaleX — float — 화면 표시 X축 비율
- ScaleY — float — 화면 표시 Y축 비율
- EdgeHead — int — Head부 Edge
- EdgeTail — int — Tail부 Edge
- LastMarkingID — int — 마지막 마킹 ID
- LastDegectID — int — 마지막 검출 ID
- ImgCountLeft — int — 좌측 이미지 개수
- ImgCountRight — int — 우측 이미지 개수 (사이드 카메라이면 null)
- Status — char(1) — 측정 상태? (F : 검출 종료) ???
- PointZeroX — int — 원점 X좌표
- PointZeroY — int — 원점 Y좌표
TEST_CLASS
- cls_idx — int — Primary key — NOT NULL
- class — int
TEST_DB
- idx — int — Primary key — NOT NULL
- name — varchar(50)
TEST_DB_HMI
- idx — int — Primary key — NOT NULL
- name — varchar(50)
TEST_DETECT
- td_idx — int — Primary key — NOT NULL
- idx (idx2) — int — Foreign key → TEST_DB.idx — NOT NULL
- cls_idx — int — Foreign key → TEST_CLASS.cls_idx — NOT NULL
- level — int
- roi — int
TEST_DETECT_HMI
- tdh_idx — int — Primary key — NOT NULL
- idx (idx2) — int — Foreign key → TEST_DB_HMI.idx — NOT NULL
- cls_idx — int — Foreign key → TEST_CLASS.cls_idx — NOT NULL
- level — int
- roi — int
defects_bak
- idx — numeric(18, 0)
- SlabID — int — NOT NULL
- DefectID — int — NOT NULL
- Surface — int
- Side — int
- Class — int — NOT NULL
- Grade — int
- PositionCD — numeric(15, 4)
- PositionRCD — numeric(15, 4)
- PositionMD — numeric(15, 4)
- SizeCD — numeric(15, 4)
- SizeMD — numeric(15, 4)
- ImageNo — int
- DefectNo — int
- MergedTo — int
- Confidence — int
- RoiX0 — int
- RoiX1 — int
- RoiY0 — int
- RoiY1 — int
- OriginalClass — int
- InternalStatus — int
- ProdClass — int
- SizeArea — numeric(15, 4)
- OrgArea — numeric(15, 4)
- MkFlag — char(1)
- MkMsos — bit
slabs_bak
- SlabID — int — NOT NULL
- SlabName — varchar(24) — NOT NULL
- RecvTime — datetime — NOT NULL
- StartTime — datetime
- EndTime — datetime
- Surface — int
- Length — int
- Width — int
- Thickness — int
- Weight — int
- CastNo — int
- CastDefined — char(1)
- ChargeNo — int
- StandNo — int
- TargetQuality — int
- MachineNo — char(1)
- SteelGrade — varchar(14)
- TimeCutting — datetime
- Method — char(1)
- ScarfEndue — char(1)
- ScarfCause — char(1)
- ScarfTrim — varchar(2)
- Scarfed — char(1)
- UsedChamferMold — char(1)
- ImagePath — varchar(252)
- ScaleX — float
- ScaleY — float
- EdgeTop — int
- EdgeTail — int
- LastMarkingID — int
- LastDefectID — int
- ImageCountLeft — int
- ImageCountRight — int
- ImageCountLeftSide — int
- ImageCountRightSide — int
- MeasureCount — int
- InternalStatus — int
- Status — char(1)
- PointZeroX — int
- PointZeroY — int
- Temp — int
- Condition — char(1)
- strChargeNo — varchar(50)
- strStrandNo — varchar(50)
- strMcNo — varchar(50)