qryAnalysisSamples


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId Implied Constraint R
SampleId uniqueidentifier 16 null
SampleNo nvarchar 40 null
sSampleId uniqueidentifier 16 null
MediumId int 4 null
AnalysisMedia.MediumId Implied Constraint 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
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
PointNo nvarchar 160 null
PublicNo nvarchar 100 null
PointSequence int 4 null
PointType nvarchar 40 null
sPointId uniqueidentifier 16 null
sPointNo nvarchar 160 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
PointActive bit 1 null
Locked bit 1 null
Intake nvarchar 40 null
ScreenNo int 4 null
StringNo int 4 null
Intakelayerdepth1 real 4 null
Intakelayerdepth2 real 4 null
IntakeLayerId uniqueidentifier 16 null
IntakeLayer nvarchar 100 null
IntakeColor int 4 null
Medium nvarchar 510 null
LimitId uniqueidentifier 16 null
AnalysisLimits.LimitId Implied Constraint R
LayerId uniqueidentifier 16 null
Layers.LayerId Implied Constraint R
Layer nvarchar 100 null
Color int 4 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views