AnalysisValues


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SampleId uniqueidentifier 16 null
AnalysisSamples.SampleId AnalysisValues_AnalysisSamples_ForeignKey C
AnalysisId uniqueidentifier 16 null
Distance real 4 null
ParameterId int 4 null
AnalysisParameters.ParameterId AnalysisValues_AnalysisParameters_ForeignKey R
MethodId int 4 null
AnalysisMethods.MethodId AnalysisValues_AnalysisMethods_ForeignKey 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 AnalysisValues_AnalysisUnits_ForeignKey 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
AggregationCount int 4 null

Table contained 4949 rows

Indexes

Constraint Name Type Sort Column(s)
AnalysisValues_PrimaryKey Primary key Asc AnalysisId
AnalysisValues_AnalysisId_Index Performance Asc AnalysisId
AnalysisValues_Attribute_Index Performance Asc Attribute
AnalysisValues_FiltrationId_Index Performance Asc FiltrationId
AnalysisValues_FractionId_Index Performance Asc FractionId
AnalysisValues_FRef_Index Performance Asc FRef
AnalysisValues_FRefBor_Index Performance Asc FRefBor
AnalysisValues_FRefCom_Index Performance Asc FRefCom
AnalysisValues_FRefJob_Index Performance Asc FRefJob
AnalysisValues_FRefLoc_Index Performance Asc FRefLoc
AnalysisValues_FRefNo_Index Performance Asc FRefNo
AnalysisValues_FRefWSa_Index Performance Asc FRefWSa
AnalysisValues_LaboratoryId_Index Performance Asc LaboratoryId
AnalysisValues_MethodId_Index Performance Asc MethodId
AnalysisValues_PackagingId_Index Performance Asc PackagingId
AnalysisValues_ParameterId_Index Performance Asc ParameterId
AnalysisValues_PreparationId_Index Performance Asc PreparationId
AnalysisValues_PreservationId_Index Performance Asc PreservationId
AnalysisValues_QualityId_Index Performance Asc QualityId
AnalysisValues_SampleId_Index Performance Asc SampleId
AnalysisValues_SiteId_Index Performance Asc SiteId
AnalysisValues_UnitId_Index Performance Asc UnitId

Relationships