qryWaterLevels


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IntakeId uniqueidentifier 16 null
Intakes.IntakeId Implied Constraint R
ValueId uniqueidentifier 16 null
Time datetime 16 null
ExtremeId nvarchar 40 null
WaterLevelExtremes.ExtremeId Implied Constraint R
Depth real 4 null
Reading real 4 null
Temperature real 4 null
TemperatureAir real 4 null
Conductivity real 4 null
Salinity real 4 null
Reference nvarchar 100 null
ReferenceLevel real 4 null
Correction real 4 null
Correction2 real 4 null
VerticalRefId nvarchar 100 null
VerticalRefs.VerticalRefId Implied Constraint R
Fall real 4 null
Flow real 4 null
Pressure real 4 null
ProjectCode nvarchar 40 null
WaterLevelProjects.ProjectCode Implied Constraint R
RoundNo int 4 null
WaterLevelRounds.RoundNo Implied Constraint R
MethodId nvarchar 40 null
WaterLevelMethods.MethodId Implied Constraint R
SituationId nvarchar 40 null
WaterLevelSituations.SituationId Implied Constraint R
CategoryId nvarchar 40 null
WaterLevelCategories.CategoryId Implied Constraint R
QualityId nvarchar 40 null
WaterLevelQualities.QualityId Implied Constraint R
SouCompany nvarchar 100 null
SouInitials nvarchar 100 null
Description nvarchar 510 null
JupiterId int 4 null
DataOwner nvarchar 40 null
WLevel real 4 null
WDepth real 4 null
CompanyId uniqueidentifier 16 null
Companies.CompanyId Implied Constraint R
Company nvarchar 160 null
RegionNo int 4 null
Regions.RegionNo Implied Constraint R
MunicipalityNo int 4 null
Municipalities.MunicipalityNo Implied Constraint R
ProjectId uniqueidentifier 16 null
Projects.ProjectId Implied Constraint R
ProjectNo nvarchar 100 null
PointId uniqueidentifier 16 null
Points.PointId Implied Constraint R
PointNo nvarchar 160 null
PublicNo nvarchar 100 null
sPointId uniqueidentifier 16 null
sPointNo nvarchar 160 null
PhaseId uniqueidentifier 16 null
ProjectPhases.PhaseId Implied Constraint R
DateEnd datetime 16 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
Active bit 1 null
Locked bit 1 null
Level1 real 4 null
Level2 real 4 null
Layer nvarchar 100 null
Color int 4 null
Intake nvarchar 40 null
IntakeNo int 4 null
ScreenNo int 4 null
StringNo int 4 null
Top real 4 null
Bottom real 4 null
Depth1 real 4 null
Depth2 real 4 null
IntakeReferenceLevel real 4 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views