AnalysisGroupParameters


Columns

Column Type Size Nulls Auto Default Children Parents Comments
GroupId uniqueidentifier 16 null
AnalysisGroups.GroupId AnalysisGroupParameters_AnalysisGroups_ForeignKey C
AnalysisId uniqueidentifier 16 null
ParameterId int 4 null
AnalysisParameters.ParameterId AnalysisGroupParameters_AnalysisParameters_ForeignKey R
MethodId int 4 null
AnalysisMethods.MethodId AnalysisGroupParameters_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
DetectionLimit float 8 null
Uncertainty float 8 null
UnitId int 4 null
AnalysisUnits.UnitId AnalysisGroupParameters_AnalysisUnits_ForeignKey R
LaboratoryId int 4 null
AnalysisLaboratories.LaboratoryId AnalysisGroupParameters_AnalysisLaboratories_ForeignKey R
SiteId int 4 null
AnalysisSites.SiteId AnalysisGroupParameters_AnalysisSites_ForeignKey R
PreparationId int 4 null
AnalysisPreparations.PreparationId AnalysisGroupParameters_AnalysisPreparations_ForeignKey R
FiltrationId int 4 null
AnalysisFiltrations.FiltrationId AnalysisGroupParameters_AnalysisFiltrations_ForeignKey R
Accredited bit 1 null

Table contained 731 rows

Indexes

Constraint Name Type Sort Column(s)
AnalysisGroupParameters_PrimaryKey Primary key Asc AnalysisId
AnalysisGroupParameters_AnalysisId_Index Performance Asc AnalysisId
AnalysisGroupParameters_AnalysisId_UniqueKey Must be unique Asc AnalysisId
AnalysisGroupParameters_Attribute_Index Performance Asc Attribute
AnalysisGroupParameters_FiltrationId_Index Performance Asc FiltrationId
AnalysisGroupParameters_GroupId_Index Performance Asc GroupId
AnalysisGroupParameters_LaboratoryId_Index Performance Asc LaboratoryId
AnalysisGroupParameters_MethodId_Index Performance Asc MethodId
AnalysisGroupParameters_ParameterId_Index Performance Asc ParameterId
AnalysisGroupParameters_PreparationId_Index Performance Asc PreparationId
AnalysisGroupParameters_SiteId_Index Performance Asc SiteId
AnalysisGroupParameters_UnitId_Index Performance Asc UnitId

Relationships