qryAnalysisValues


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SampleId uniqueidentifier 16 null
AnalysisId uniqueidentifier 16 null
Distance real 4 null
ParameterId int 4 null
AnalysisParameters.ParameterId Implied Constraint R
MethodId int 4 null
AnalysisMethods.MethodId Implied Constraint R
Sequence int 4 null
Version.Sequence Implied Constraint R
Attribute nvarchar 20 null
AnalysisAttributes.Attribute Implied Constraint R
Value float 8 null
ValueText nvarchar 240 null
DetectionLimit float 8 null
Uncertainty float 8 null
UncertaintyPct real 4 null
UnitId int 4 null
AnalysisUnits.UnitId Implied Constraint R
OrgValue float 8 null
OrgDetectionLimit float 8 null
OrgUncertainty float 8 null
OrgUnitId int 4 null
Remark nvarchar 510 null
AnalysisDate datetime 16 null
SiteId int 4 null
AnalysisSites.SiteId Implied Constraint R
LaboratoryId int 4 null
AnalysisLaboratories.LaboratoryId Implied Constraint R
PreparationId int 4 null
AnalysisPreparations.PreparationId Implied Constraint R
PreservationId int 4 null
AnalysisPreservations.PreservationId Implied Constraint R
PackagingId int 4 null
AnalysisPackagings.PackagingId Implied Constraint R
FiltrationId int 4 null
AnalysisFiltrations.FiltrationId Implied Constraint R
FractionId int 4 null
AnalysisFractions.FractionId Implied Constraint R
QualityId int 4 null
AnalysisQualities.QualityId Implied Constraint R
Accredited bit 1 null
Approved bit 1 null
Retest bit 1 null
JupiterId int 4 null
JupiterId2 uniqueidentifier 16 null
FRef nvarchar 240 null
FRefCom nvarchar 100 null
FRefJob nvarchar 100 null
FRefBor nvarchar 100 null
FRefLoc nvarchar 100 null
FRefNo nvarchar 100 null
FRefWSa nvarchar 100 null
GroupName nvarchar 756 null
CompanyId uniqueidentifier 16 null
Companies.CompanyId Implied Constraint R
Company nvarchar 160 null
ProjectId uniqueidentifier 16 null
Projects.ProjectId Implied Constraint R
ProjectNo nvarchar 100 null
RegionNo int 4 null
Regions.RegionNo Implied Constraint R
MunicipalityNo int 4 null
Municipalities.MunicipalityNo Implied Constraint R
PointId uniqueidentifier 16 null
Points.PointId Implied Constraint R
PointNo nvarchar 160 null
PublicNo nvarchar 100 null
PointSequence int 4 null
PointType nvarchar 40 null
MediumId int 4 null
AnalysisMedia.MediumId Implied Constraint R
IntakeNo int 4 null
sPointId uniqueidentifier 16 null
sPointNo nvarchar 160 null
SampleNo nvarchar 40 null
SampleDate datetime 16 null
ReportNo nvarchar 240 null
PurposeId int 4 null
AnalysisPurposes.PurposeId Implied Constraint R
Action int 4 null
AnalysisActions.Action Implied Constraint R
Active bit 1 null
Projection1 int 4 null
X1 float 8 null
Y1 float 8 null
VerticalRefId1 nvarchar 100 null
Z1 real 4 null
Projection2 int 4 null
X2 float 8 null
Y2 float 8 null
VerticalRefId2 nvarchar 100 null
Z2 real 4 null
Depth1 real 4 null
Depth2 real 4 null
Depth real 4 null
Level real 4 null
Intakelayerdepth1 real 4 null
Intakelayerdepth2 real 4 null
IntakeLayerId uniqueidentifier 16 null
IntakeLayer nvarchar 100 null
IntakeColor int 4 null
LayerId uniqueidentifier 16 null
Layers.LayerId Implied Constraint R
Layer nvarchar 100 null
Color int 4 null
PhaseId uniqueidentifier 16 null
ProjectPhases.PhaseId Implied Constraint R
LimitId uniqueidentifier 16 null
AnalysisLimits.LimitId Implied Constraint R
Medium nvarchar 510 null
Parameter nvarchar 160 null
Method nvarchar 510 null
Unit nvarchar 510 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null
PointActive bit 1 null
Locked bit 1 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views