AnalysisGroups


Columns

Column Type Size Nulls Auto Default Children Parents Comments
GroupId uniqueidentifier 16 null
AnalysisGroupParameters.GroupId AnalysisGroupParameters_AnalysisGroups_ForeignKey C
AnalysisParameters.GroupId Implied Constraint R
AnalysisSamples.GroupId Implied Constraint R
qryAnalysisGroupParameters.GroupId Implied Constraint R
qryAnalysisLimitValues.GroupId Implied Constraint R
qryAnalysisSamples.GroupId Implied Constraint R
GroupName nvarchar 240 null
Description nvarchar 510 null
LaboratoryId int 4 null
AnalysisLaboratories.LaboratoryId Implied Constraint R
CauseId nvarchar 20 null
AnalysisCauses.CauseId AnalysisGroups_AnalysisCauses_ForeignKey R
ExtentId nvarchar 20 null
AnalysisExtents.ExtentId AnalysisGroups_AnalysisExtents_ForeignKey R
PurposeId int 4 null
AnalysisPurposes.PurposeId AnalysisGroups_AnalysisPurposes_ForeignKey R
ScopeId int 4 null
AnalysisScopes.ScopeId AnalysisGroups_AnalysisScopes_ForeignKey R

Table contained 41 rows

Indexes

Constraint Name Type Sort Column(s)
AnalysisGroups_PrimaryKey Primary key Asc GroupId
AnalysisGroups_CauseId_Index Performance Asc CauseId
AnalysisGroups_ExtentId_Index Performance Asc ExtentId
AnalysisGroups_GroupId_Index Performance Asc GroupId
AnalysisGroups_PurposeId_Index Performance Asc PurposeId
AnalysisGroups_ScopeId_Index Performance Asc ScopeId

Relationships