WaterLevels


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IntakeId uniqueidentifier 16 null
Intakes.IntakeId WaterLevels_Intakes_ForeignKey C
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

Table contained 77 rows

Indexes

Constraint Name Type Sort Column(s)
WaterLevels_PrimaryKey Primary key Asc ValueId
WaterLevels_CategoryId_Index Performance Asc CategoryId
WaterLevels_ExtremeId_Index Performance Asc ExtremeId
WaterLevels_IntakeId_Index Performance Asc IntakeId
WaterLevels_MethodId_Index Performance Asc MethodId
WaterLevels_ProjectCode_Index Performance Asc ProjectCode
WaterLevels_QualityId_Index Performance Asc QualityId
WaterLevels_RoundNo_Index Performance Asc RoundNo
WaterLevels_SituationId_Index Performance Asc SituationId
WaterLevels_ValueId_Index Performance Asc ValueId
WaterLevels_ValueId_UniqueKey Must be unique Asc ValueId

Relationships