AnalysisSamples


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId AnalysisSamples_Points_ForeignKey C
SampleId uniqueidentifier 16 null
AnalysisBottles.SampleId AnalysisBottles_AnalysisSamples_ForeignKey C
AnalysisRemarks.SampleId AnalysisRemarks_AnalysisSamples_ForeignKey C
AnalysisValues.SampleId AnalysisValues_AnalysisSamples_ForeignKey C
SampleNo nvarchar 40 null
sSampleId uniqueidentifier 16 null
MediumId int 4 null
AnalysisMedia.MediumId AnalysisSamples_AnalysisMedia_ForeignKey R
IntakeNo int 4 null
IntakeDescription nvarchar 510 null
Depth1 real 4 null
Depth2 real 4 null
SampleLocationTypeId int 4 null
AnalysisSampleLocationTypes.SampleLocationTypeId Implied Constraint R
SampleLocationId int 4 null
AnalysisSampleLocations.SampleLocationId Implied Constraint R
SampleLocationNo nvarchar 100 null
SampleLocationDescription nvarchar 510 null
MeasuringstationId int 4 null
Volume real 4 null
SampleDate datetime 16 null
StartDate datetime 16 null
StopDate datetime 16 null
ReceivedDate datetime 16 null
AnalysisDate datetime 16 null
SampleFrozen bit 1 null
OrderedById uniqueidentifier 16 null
OrderedBy nvarchar 510 null
SamplingOrgId uniqueidentifier 16 null
SampledBy nvarchar 100 null
SampleChecked bit 1 null
SampleCheckedBy nvarchar 510 null
SampleApproved bit 1 null
SampleApprovedBy nvarchar 510 null
ProgrammeId int 4 null
AnalysisProgrammes.ProgrammeId Implied Constraint R
ProjectCode int 4 null
AnalysisProjects.ProjectCode Implied Constraint R
LaboratoryId int 4 null
AnalysisLaboratories.LaboratoryId Implied Constraint R
SampleTypeId int 4 null
AnalysisSampleTypes.SampleTypeId Implied Constraint R
EquipmentId int 4 null
AnalysisEquipments.EquipmentId Implied Constraint R
GroupId uniqueidentifier 16 null
AnalysisGroups.GroupId Implied Constraint R
ReportNo nvarchar 240 null
ReportDate datetime 16 null
Description nvarchar 2147483647 null
CauseId nvarchar 20 null
AnalysisCauses.CauseId Implied Constraint R
ExtentId nvarchar 20 null
AnalysisExtents.ExtentId Implied Constraint R
PurposeId int 4 null
AnalysisPurposes.PurposeId Implied Constraint R
ScopeId int 4 null
AnalysisScopes.ScopeId Implied Constraint R
ReTestId int 4 null
AnalysisRetest.RetestId Implied Constraint R
Action int 4 null
AnalysisActions.Action Implied Constraint R
Active bit 1 null
Remark nvarchar 2147483647 null
WaterClass nvarchar 40 null
WaterTypeId nvarchar 20 null
AnalysisWaterTypes.WaterTypeId Implied Constraint R
OdeurId int 4 null
AnalysisOdeurs.OdeurId Implied Constraint R
TasteId int 4 null
AnalysisTastes.TasteId Implied Constraint R
LookId int 4 null
AnalysisLooks.LookId Implied Constraint R
ColorId int 4 null
AnalysisColors.ColorId Implied Constraint R
Filename nvarchar 510 null
PhaseId uniqueidentifier 16 null
ProjectPhases.PhaseId Implied Constraint R
Points int 4 null
Rainfall real 4 null
WindDirection int 4 null
WindVelocity real 4 null
WindHeight real 4 null
Temperature real 4 null
TemperatureGradient real 4 null
TemperatureHeight real 4 null
AtmPressure int 4 null
SelfMonitoring bit 1 null
JupiterId int 4 null
DataOwner nvarchar 40 null
FRef nvarchar 510 null
FRefCom nvarchar 100 null
FRefJob nvarchar 100 null
FRefBor nvarchar 100 null
FRefLoc nvarchar 100 null
FRefNo nvarchar 100 null

Table contained 688 rows

Indexes

Constraint Name Type Sort Column(s)
AnalysisSamples_PrimaryKey Primary key Asc SampleId
AnalysisSamples_Action_Index Performance Asc Action
AnalysisSamples_CauseId_Index Performance Asc CauseId
AnalysisSamples_ColorId_Index Performance Asc ColorId
AnalysisSamples_EquipmentId_Index Performance Asc EquipmentId
AnalysisSamples_ExtentId_Index Performance Asc ExtentId
AnalysisSamples_FRef_Index Performance Asc FRef
AnalysisSamples_FRefBor_Index Performance Asc FRefBor
AnalysisSamples_FRefCom_Index Performance Asc FRefCom
AnalysisSamples_FRefJob_Index Performance Asc FRefJob
AnalysisSamples_FRefLoc_Index Performance Asc FRefLoc
AnalysisSamples_FRefNo_Index Performance Asc FRefNo
AnalysisSamples_LaboratoryId_Index Performance Asc LaboratoryId
AnalysisSamples_LookId_Index Performance Asc LookId
AnalysisSamples_MediumId_Index Performance Asc MediumId
AnalysisSamples_OdeurId_Index Performance Asc OdeurId
AnalysisSamples_OrderedById_Index Performance Asc OrderedById
AnalysisSamples_PointId_Index Performance Asc PointId
AnalysisSamples_ProgrammeId_Index Performance Asc ProgrammeId
AnalysisSamples_ProjectCode_Index Performance Asc ProjectCode
AnalysisSamples_PurposeId_Index Performance Asc PurposeId
AnalysisSamples_ReTestId_Index Performance Asc ReTestId
AnalysisSamples_SampleId_Index Performance Asc SampleId
AnalysisSamples_SampleLocationId_Index Performance Asc SampleLocationId
AnalysisSamples_SampleLocationTypeId_Index Performance Asc SampleLocationTypeId
AnalysisSamples_SampleTypeId_Index Performance Asc SampleTypeId
AnalysisSamples_ScopeId_Index Performance Asc ScopeId
AnalysisSamples_TasteId_Index Performance Asc TasteId
AnalysisSamples_WaterTypeId_Index Performance Asc WaterTypeId

Relationships