MV
Tables (5)
DEFECT_ID
- defect_ID (결함코드) — Primary key — NOT NULL
IMG
- IMG_ID (방향+ROI+순번) — VARCHAR(10) — Primary key — NOT NULL
- projection (촬영방향) — Foreign key → PROJECTION_ID.projection — NOT NULL
- ROI (ROI2) — Foreign key → ROI_ID.ROI — NOT NULL
- part (1~4) — NUMBER(2,0)
- recordtime (촬영시간) — DATE
- filename — VARCHAR(2)
- filepath — VARCHAR(2)
- IMG_width (width) — NUMBER
- IMG_height (height) — NUMBER
- IMG_Channel (1 or 3) — NUMBER
- Segmented (0 or 1) — NUMBER
- worker (촬영자) — VARCHAR(2)
OBJECT
- IMG_ID (방향+ROI+순번) — VARCHAR(10) — Foreign key → IMG.IMG_ID — NOT NULL
- defect_ID (결함코드) — Foreign key → DEFECT_ID.defect_ID — NOT NULL
- Name (결함 이름) — VARCHAR(2)
- Pose (Unspecified) — VARCHAR(2)
- truncated (0 or 1) — NUMBER
- difficult (01) — NUIMBER(2,0)
- xmin — NUMBER
- ymin — NUMBER
- xmax — NUMBER
- ymax — NUMBER
PROJECTION_ID
- projection — VARCHAR(4) — Primary key — NOT NULL
- projection_ID — VARCHAR(4)
ROI_ID
- ROI — VARCHAR(4) — Primary key — NOT NULL
- ROI_ID — VARCHAR(4)