Vision DB

Tables (7)

Camera (CAMERA)

  • CameraName (Key2) — Primary key — NOT NULL
  • CameraSerialNumber (Field8)
  • PixelSize (Field2)
  • ExposureTime (Field)
  • Gain (Field3)
  • RecipeID (Key3) — Foreign key → Recipe.RecipeID — NOT NULL

Light (LIGHT)

  • LightID (Key) — Primary key — NOT NULL
  • RingR (Field)
  • RingG (Field2)
  • RingB (Field3)
  • CoaxR (Field4)
  • CoaxG (Field5)
  • CoaxB (Field6)
  • RecipeID (Key2) — Foreign key → Recipe.RecipeID — NOT NULL

Mark (MARK)

  • MarkID (Key) — Primary key — NOT NULL
  • MarkType (Field2)
  • MarkSubType (Field3)
  • MarkTargetPoint (Field4)
  • MarkTemplatePath (Field5)
  • SortType (Field6)
  • ThresholdType (Field7)
  • MatchScore (Field8)
  • ImageScale (Field9)
  • ResultMaxCount (Field10)
  • RansacThreshold (Field11)
  • EdgeGradientThreshold (Field12)
  • Angle (Field13)
  • AngleTolerance (Field14)
  • MinRadius1 (Field15)
  • MaxRadius1 (Field16)
  • MinRadius2 (Field17)
  • MaxRadius2 (Field18)
  • BlobColor (Field19)
  • MorphologyType (Field20)
  • LineWidth (Field21)
  • InvertFill (Field22)
  • UnsharpMask (Field23)
  • Binarization (Field24)
  • BiggestBlob (Field25)
  • RecipeID (Key2) — Foreign key → Recipe.RecipeID — NOT NULL

ROI

  • ROIID (Key) — Primary key — NOT NULL
  • ROIType (Field)
  • ROISize (Field2)
  • RecipeID (Key2) — Foreign key → Recipe.RecipeID — NOT NULL

Recipe (RECIPE)

  • RecipeID (Key) — Primary key — NOT NULL
  • RecipeName (Field)
  • CameraSerialNumber (Field2)
  • ROIID (Field3)
  • LightID (Field4)
  • MarkID (Field5)
  • RecipeGroupID (Key2) — Foreign key → RecipeGroup.RecipeGroupID — NOT NULL

RecipeGroup (RECIPE_GROUP)

  • RecipeGroupID (Key) — Primary key — NOT NULL
  • RecipeGroupName (Field2)
  • RecipeGroupDate (Field)
  • RecipeID (Field3)

RecipeGroups (RECIPE_GROUPS)

  • RecipeGroupName (Key) — Primary key — NOT NULL
  • RecipeGroupPath (Field)
  • RecipeGroupID (Key2) — Foreign key → RecipeGroup.RecipeGroupID — NOT NULL