workbenchrow

Table info.

Title Workbench Row
Description Workbench Row

Fields

Name Type Required Index Hidden On form Title Pick list Description
WorkbenchRowID int(11) PRI
BioGeomancerResults text Bio Geomancer Results The XML returned from Bio Geomancer
CardImageData mediumblob Card Image Data A single image attached to the row
CardImageFullPath varchar(255) Card Image Full Path The full path of the image
Lat1Text varchar(50) Lat1 Text lat1Text
Lat2Text varchar(50) Lat2 Text lat2Text
Long1Text varchar(50) Long1 Text long1Text
Long2Text varchar(50) Long2 Text long2Text
RowNumber smallint(6) MUL Row Number The row number
UploadStatus tinyint(4) Upload Status uploadStatus
WorkbenchID int(11) MUL
RecordID int(11) Record Id recordId
SGRStatus tinyint(4) Sgr Status sgrStatus
ErrorEstimate decimal(20,10) Error Estimate errorEstimate
ErrorPolygon text Error Polygon errorPolygon

Indexes

Name Fields Unique Nullable
FK486DDFBBBBCF9E96 WorkbenchID
PRIMARY WorkbenchRowID
RowNumberIDX RowNumber

One-to-many relationships

Name Field Related table Related field
FK2901E47CC66EB2D4 WorkbenchRowID workbenchdataitem WorkbenchRowID
FK6829C946C66EB2D4 WorkbenchRowID workbenchrowexportedrelationship WorkbenchRowID
FKC17A6680C66EB2D4 WorkbenchRowID workbenchrowimage WorkbenchRowID

Many-to-one relationships

Name Field Related table Related field
FK486DDFBBBBCF9E96 WorkbenchID workbench WorkbenchID