Anomalies


Things that might not be 'quite right' about your database and schema

Columns whose name and type imply a relationship to another table's primary key

Child Column Implied Parent Column
AnalysisBottles.[FiltrationId] AnalysisFiltrations.[FiltrationId]
AnalysisBottles.[PackagingId] AnalysisPackagings.[PackagingId]
AnalysisBottles.[PreservationId] AnalysisPreservations.[PreservationId]
AnalysisGroupParameters.[Attribute] AnalysisAttributes.[Attribute]
AnalysisGroupParameters.[Sequence] Version.[Sequence]
AnalysisGroups.[LaboratoryId] AnalysisLaboratories.[LaboratoryId]
AnalysisLimitValues.[MediumId] AnalysisMedia.[MediumId]
AnalysisLimitValues.[UnitId] AnalysisUnits.[UnitId]
AnalysisParameters.[AggregationId] MeasurementAggregations.[AggregationId]
AnalysisParameters.[GroupId] AnalysisGroups.[GroupId]
AnalysisParameters.[UnitId] AnalysisUnits.[UnitId]
AnalysisSamples.[Action] AnalysisActions.[Action]
AnalysisSamples.[CauseId] AnalysisCauses.[CauseId]
AnalysisSamples.[ColorId] AnalysisColors.[ColorId]
AnalysisSamples.[EquipmentId] AnalysisEquipments.[EquipmentId]
AnalysisSamples.[ExtentId] AnalysisExtents.[ExtentId]
AnalysisSamples.[GroupId] AnalysisGroups.[GroupId]
AnalysisSamples.[LaboratoryId] AnalysisLaboratories.[LaboratoryId]
AnalysisSamples.[LookId] AnalysisLooks.[LookId]
AnalysisSamples.[OdeurId] AnalysisOdeurs.[OdeurId]
AnalysisSamples.[PhaseId] ProjectPhases.[PhaseId]
AnalysisSamples.[ProgrammeId] AnalysisProgrammes.[ProgrammeId]
AnalysisSamples.[ProjectCode] AnalysisProjects.[ProjectCode]
AnalysisSamples.[PurposeId] AnalysisPurposes.[PurposeId]
AnalysisSamples.[ReTestId] AnalysisRetest.[RetestId]
AnalysisSamples.[SampleLocationId] AnalysisSampleLocations.[SampleLocationId]
AnalysisSamples.[SampleLocationTypeId] AnalysisSampleLocationTypes.[SampleLocationTypeId]
AnalysisSamples.[SampleTypeId] AnalysisSampleTypes.[SampleTypeId]
AnalysisSamples.[ScopeId] AnalysisScopes.[ScopeId]
AnalysisSamples.[TasteId] AnalysisTastes.[TasteId]
AnalysisSamples.[WaterTypeId] AnalysisWaterTypes.[WaterTypeId]
AnalysisValues.[Attribute] AnalysisAttributes.[Attribute]
AnalysisValues.[FiltrationId] AnalysisFiltrations.[FiltrationId]
AnalysisValues.[FractionId] AnalysisFractions.[FractionId]
AnalysisValues.[LaboratoryId] AnalysisLaboratories.[LaboratoryId]
AnalysisValues.[PackagingId] AnalysisPackagings.[PackagingId]
AnalysisValues.[PreparationId] AnalysisPreparations.[PreparationId]
AnalysisValues.[PreservationId] AnalysisPreservations.[PreservationId]
AnalysisValues.[QualityId] AnalysisQualities.[QualityId]
AnalysisValues.[Sequence] Version.[Sequence]
AnalysisValues.[SiteId] AnalysisSites.[SiteId]
Areas.[PhaseId] ProjectPhases.[PhaseId]
Areas.[SelectionId] Selections.[SelectionId]
AreaVertices.[Sequence] Version.[Sequence]
ClassificationTests.[Pycnometer] Pycnometers.[Pycnometer]
CodeValues.[Sequence] Version.[Sequence]
CodeValues.[Setup] Setups.[Setup]
ConsolidationTests.[Oedometer] Oedometers.[Oedometer]
CPTData.[SoilTypeId] SoilTypes.[SoilTypeId]
CPTGlobalSettings.[SoilTypeId] SoilTypes.[SoilTypeId]
CPTInterpretationValues.[Sequence] Version.[Sequence]
CPTSettings.[SoilTypeId] SoilTypes.[SoilTypeId]
DBUpdates.[Sequence] Version.[Sequence]
DPTData.[LayerId] Layers.[LayerId]
DrillingObservations.[LayerId] Layers.[LayerId]
FieldLogs.[Sequence] Version.[Sequence]
GLogDraw.[LogId] GLogs.[LogId]
GLogDraw.[Sequence] Version.[Sequence]
GLogs.[LogType] GLogTypes.[LogType]
History.[Action] AnalysisActions.[Action]
History.[Sequence] Version.[Sequence]
History.[UserId] Users.[UserId]
HistoryTransactions.[HistoryOn] HistorySettings.[HistoryOn]
HistoryTransactions.[UserId] Users.[UserId]
Imports.[UserId] Users.[UserId]
Inclinations.[Sequence] Version.[Sequence]
Intakes.[VerticalRefId] VerticalRefs.[VerticalRefId]
Jackups.[Rig] Rigs.[Rig]
Layers.[Sequence] Version.[Sequence]
Notifications.[UserId] Users.[UserId]
PenetrationTests.[TestType] TriaxialTestTypes.[TestType]
PointLoadTests.[N] Num.[n]
Points.[AlignmentId] Alignments.[AlignmentId]
Points.[AreaId] Areas.[AreaId]
Points.[MunicipalityNo] Municipalities.[MunicipalityNo]
Points.[PhaseId] ProjectPhases.[PhaseId]
Points.[Postalcode] PostalCodes.[PostalCode]
Points.[Rig] Rigs.[Rig]
Points.[Sequence] Version.[Sequence]
PointSummary.[SoilTypeId] SoilTypes.[SoilTypeId]
Projections.[Sequence] Version.[Sequence]
ProjectRights.[UserId] Users.[UserId]
Projects.[MunicipalityNo] Municipalities.[MunicipalityNo]
Projects.[Postalcode] PostalCodes.[PostalCode]
Projects.[RegionNo] Regions.[RegionNo]
Projects.[Setup] Setups.[Setup]
ProjectSummary.[LayerId] Layers.[LayerId]
ProjectSummary.[SoilTypeId] SoilTypes.[SoilTypeId]
SectionPoints.[PointId] Points.[PointId]
SectionPoints.[Sequence] Version.[Sequence]
Selections.[ProjectId] Projects.[ProjectId]
SPTData.[N] Num.[n]
SPTData.[TestType] PenetrationTestTypes.[TestType]
StandardDescriptions.[Sequence] Version.[Sequence]
Surfaces.[LayerId] Layers.[LayerId]
SyntaxDesignations.[Sequence] Version.[Sequence]
TriaxialTests.[TestType] TriaxialTestTypes.[TestType]
UCTValues.[Sequence] Version.[Sequence]
WaterLevels.[CategoryId] WaterLevelCategories.[CategoryId]
WaterLevels.[ExtremeId] WaterLevelExtremes.[ExtremeId]
WaterLevels.[MethodId] WaterLevelMethods.[MethodId]
WaterLevels.[ProjectCode] WaterLevelProjects.[ProjectCode]
WaterLevels.[QualityId] WaterLevelQualities.[QualityId]
WaterLevels.[RoundNo] WaterLevelRounds.[RoundNo]
WaterLevels.[SituationId] WaterLevelSituations.[SituationId]
WaterLevels.[VerticalRefId] VerticalRefs.[VerticalRefId]
WaterVolumes.[Attribute] AnalysisAttributes.[Attribute]
WaterVolumes.[MethodId] AnalysisMethods.[MethodId]

Tables without indexes

Table Rows
Anomaly not detected

Tables that contain a single column

Table Column
HistorySettings
Num

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected