PumpingTests


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IntakeId uniqueidentifier 16 null
Intakes.IntakeId PumpingTests_Intakes_ForeignKey C
TestId uniqueidentifier 16 null
TestNo int 4 null
Startdate datetime 16 null
Stopdate datetime 16 null
Duration real 4 null
NaturalDepth real 4 null
DrawDown real 4 null
SValue float 8 null
TValue float 8 null
LFactor float 8 null
Efficiency real 4 null
SpCapacity float 8 null
Sflow float 8 null
Rflow float 8 null
PumpType nvarchar 100 null
TestTypeId int 4 null
PumpingTestTypes.TestTypeId PumpingTests_PumpingTestTypes_ForeignKey R
InterpretationTypeId int 4 null
PumpingInterpTypes.InterpretationTypeId PumpingTests_PumpingInterpTypes_ForeignKey R
Description nvarchar 510 null

Table contained 1 rows

Indexes

Constraint Name Type Sort Column(s)
PumpingTests_PrimaryKey Primary key Asc TestId
PumpingTests_IntakeId_Index Performance Asc IntakeId
PumpingTests_TestId_Index Performance Asc TestId

Relationships