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)