Intakes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId Intakes_Points_ForeignKey C
IntakeId uniqueidentifier 16 null
PumpingTests.IntakeId PumpingTests_Intakes_ForeignKey C
qryIntakes.IntakeId Implied Constraint R
qryPumpingTests.IntakeId Implied Constraint R
qryWaterLevelMps.IntakeId Implied Constraint R
qryWaterLevels.IntakeId Implied Constraint R
WaterLevelMPs.IntakeId WaterLevelMPs_Intakes_ForeignKey C
WaterLevels.IntakeId WaterLevels_Intakes_ForeignKey C
Intake nvarchar 40 null
IntakeNo int 4 null
ScreenNo int 4 null
StringNo int 4 null
Description nvarchar 510 null
Diameter nvarchar 100 null
Diametermm real 4 null
Top real 4 null
Bottom real 4 null
IntakeDistance real 4 null
IntakeLength real 4 null
IntakeWidth real 4 null
Material nvarchar 40 null
Depth1 real 4 null
Depth2 real 4 null
ScreenDiameter nvarchar 100 null
ScreenDiametermm real 4 null
LayerId uniqueidentifier 16 null
Layers.LayerId Intakes_Layers_ForeignKey R
LayerIdList nvarchar 510 null
TValue float 8 null
SValue float 8 null
Aquifertype int 4 null
SpecificCapacity real 4 null
Efficiency real 4 null
BarometicEfficiency real 4 null
Reference nvarchar 100 null
ReferenceLevel real 4 null
Correction real 4 null
Correction2 real 4 null
TriggerLevel real 4 null
AmberLevel real 4 null
VerticalRefId nvarchar 100 null
VerticalRefs.VerticalRefId Implied Constraint R
StartDate datetime 16 null
EndDate datetime 16 null
WaterSounding bit 1 null
FRefCom nvarchar 100 null
FRefJob nvarchar 100 null
FRefBor nvarchar 100 null

Table contained 77 rows

Indexes

Constraint Name Type Sort Column(s)
Intakes_PrimaryKey Primary key Asc IntakeId
Intakes_FRefBor_Index Performance Asc FRefBor
Intakes_FRefCom_Index Performance Asc FRefCom
Intakes_FRefJob_Index Performance Asc FRefJob
Intakes_Intake_Index Performance Asc Intake
Intakes_IntakeId_Index Performance Asc IntakeId
Intakes_IntakeNo_Index Performance Asc IntakeNo
Intakes_LayerId_Index Performance Asc LayerId
Intakes_PointId_Index Performance Asc PointId
Intakes_PointId_Intake_UniqueKey Must be unique Asc/Asc PointId + Intake

Relationships