Tables


SchemaSpy Analysis of GeoGIS2020Test.dbo

Generated on sø sep. 17 22:44 CEST 2017

XML Representation
Insertion Order Deletion Order

Database Properties

Database Type: Microsoft SQL Server - 12.00.2000

Tables

Table / View Children Parents Columns Rows Type Comments
Alignments 7 1 16 0 Table
AlignmentVertices 0 1 11 0 Table
AnalysisActions 5 0 3 4 Table
AnalysisAmberValues 0 4 8 0 Table
AnalysisAttachedParameters 1 3 5 826 Table
AnalysisAttributes 6 0 6 13 Table
AnalysisBottles 0 4 8 0 Table
AnalysisCauses 3 0 7 6 Table
AnalysisColors 2 0 9 24 Table
AnalysisEquipments 2 0 9 134 Table
AnalysisExtents 3 0 9 38 Table
AnalysisFiltrations 5 0 9 6 Table
AnalysisFractions 2 0 8 7 Table
AnalysisGroupParameters 0 10 15 731 Table
AnalysisGroups 6 5 8 41 Table
AnalysisLaboratories 7 0 12 500 Table
AnalysisLimits 5 0 5 8 Table
AnalysisLimitValues 0 4 9 2851 Table
AnalysisLooks 2 0 9 12 Table
AnalysisMedia 10 0 7 6 Table
AnalysisMethods 9 0 9 797 Table
AnalysisOdeurs 2 0 9 26 Table
AnalysisPackagings 3 0 9 16 Table
AnalysisParameters 14 3 20 2150 Table
AnalysisPreparations 4 0 9 17 Table
AnalysisPreservations 3 0 9 15 Table
AnalysisProgrammes 2 0 7 0 Table
AnalysisProjects 2 0 7 49 Table
AnalysisPurposes 4 1 10 38 Table
AnalysisQualities 2 0 7 15 Table
AnalysisRemarks 0 1 4 289 Table
AnalysisRetest 2 0 7 5 Table
AnalysisSampleLocations 2 0 7 86 Table
AnalysisSampleLocationTypes 2 0 7 26 Table
AnalysisSamples 3 22 72 688 Table
AnalysisSampleTypes 2 0 7 44 Table
AnalysisScopes 3 0 9 29 Table
AnalysisSites 4 0 9 4 Table
AnalysisTastes 2 0 9 16 Table
AnalysisTriggerValues 0 3 8 6044 Table
AnalysisUnitConversions 0 1 6 6 Table
AnalysisUnits 16 0 9 259 Table
AnalysisValues 0 14 40 4949 Table
AnalysisWaterTypes 2 0 7 15 Table
Areas 5 3 26 36 Table
AreaVertices 0 2 5 125 Table
BackFill 1 2 10 60 Table
BackFillMaterial 2 0 7 70 Table
BrazilianTests 0 1 12 0 Table
Casings 1 1 12 0 Table
ClassificationTests 2 3 102 173 Table
Codes 2 0 7 30 Table
CodeValues 0 3 11 284 Table
Companies 76 0 11 835 Table
ConsolidationTestCurves 0 1 13 0 Table
ConsolidationTests 1 2 37 0 Table
Constants 0 0 8 25 Table
CPTCones 2 0 14 0 Table
CPTData 0 3 77 0 Table
CPTGlobalSettings 0 1 59 1 Table
CPTInterpretationLayers 3 2 9 39 Table
CPTInterpretations 4 1 8 4 Table
CPTInterpretationValues 0 2 5 797 Table
CPTPush 2 2 17 0 Table
CPTSettings 0 3 60 0 Table
DBUpdates 0 1 8 20 Table
DocumentItems 1 1 4 0 Table
DocumentRevisions 1 1 10 0 Table
Documents 5 1 24 0 Table
DocumentTypes 0 0 6 36 Table
DPTData 0 2 12 0 Table
DrillingObservations 0 2 15 0 Table
DSSTests 1 1 18 0 Table
DSSTestValues 0 1 9 0 Table
EMMTestValues 0 1 11 0 Table
FieldLogs 0 2 8 0 Table
Fissures 0 2 8 0 Table
GLogDraw 0 2 185 0 Table
GLogs 2 2 64 0 Table
GLogTypes 1 0 13 77 Table
GLogValues 0 1 52 0 Table
GrainSizeClassifications 3 0 5 3 Table
GrainSizeClassificationValues 0 1 10 62 Table
GrainSizes 4 3 29 0 Table
GrainSizeTests 1 3 21 0 Table
GrainSizeValues 0 1 9 0 Table
Grouting 1 1 7 0 Table
History 2 4 11 0 Table
HistorySettings 2 0 1 0 Table
HistoryTransactions 3 2 6 0 Table
HistoryValues 0 1 4 0 Table
HoleDiameters 1 1 10 0 Table
Hydrometers 3 0 7 0 Table
Imports 0 1 9 1 Table
Inclinations 0 2 12 0 Table
Indurations 0 2 8 0 Table
Initials 0 1 4 0 Table
Injections 3 1 9 0 Table
InsituVaneTests 0 2 13 0 Table
Intakes 7 3 40 77 Table
Interpretations 4 0 4 27 Table
Jackups 3 2 5 0 Table
LabVaneTests 0 2 12 0 Table
Layers 61 3 35 617 Table
LayerSeries 9 1 6 13 Table
LegPenetrations 1 1 12 0 Table
MeasurementAggregations 3 0 4 10 Table
MeasurementData 0 1 6 0 Table
MeasurementDurations 2 0 5 4 Table
Measurements 3 7 13 0 Table
MeasurementTypes 2 0 4 679 Table
ModelCells 2 2 10 0 Table
ModelParameters 0 1 10 0 Table
ModelResults 0 1 12 0 Table
Models 3 2 25 0 Table
Municipalities 7 1 12 324 Table
Notifications 1 1 8 2 Table
Num 4 0 1 100 Table
Oedometers 2 0 6 0 Table
PenetrationTests 0 3 9 0 Table
PenetrationTestTypes 2 0 5 14 Table
PlasticityTestValues 0 1 9 0 Table
PointAbandonCauses 0 0 6 11 Table
PointCoordinateMethods 0 0 6 14 Table
PointCoordinateQualities 0 0 6 5 Table
PointDataOwners 0 0 6 8 Table
PointDataSources 0 0 6 11 Table
PointElevationMethods 0 0 6 14 Table
PointLoadTests 0 3 10 0 Table
PointMaterials 0 0 7 16 Table
PointMethods 0 0 8 21 Table
PointPurposes 0 0 8 36 Table
Points 85 9 89 115 Table
PointStatus 0 0 5 0 Table
PointSummary 0 3 39 0 Table
PointSynonyms 0 1 4 0 Table
PointTypes 0 0 11 51 Table
PointUses 0 0 8 29 Table
PostalCodes 4 0 2 1151 Table
PressuremeterTests 0 2 12 0 Table
ProctorTests 1 2 19 0 Table
ProctorTestValues 0 1 10 0 Table
Projections 1 1 14 3515 Table
ProjectPhases 58 2 12 32 Table
ProjectRights 1 2 7 0 Table
Projects 88 9 63 6 Table
ProjectSummary 0 3 41 0 Table
ProjectTypes 0 0 4 0 Table
PumpingInterpTypes 2 0 5 4 Table
PumpingTests 0 3 19 1 Table
PumpingTestTypes 2 0 4 5 Table
Pycnometers 3 0 30 0 Table
qryAlignments 0 3 21 0 View
qryAlignmentVertices 0 3 18 0 View
qryAnalysisAmberValues 0 6 27 0 View
qryAnalysisAttachedParameters 0 4 7 0 View
qryAnalysisGroupParameters 0 10 17 0 View
qryAnalysisLimitValues 0 5 14 0 View
qryAnalysisRemarks 0 3 14 0 View
qryAnalysisSamples 0 28 111 0 View
qryAnalysisValues 0 24 93 0 View
qryAreas 0 5 31 0 View
qryAreaVertices 0 4 12 0 View
qryBackFill 0 6 38 0 View
qryBrazilianTests 0 5 54 0 View
qryCasings 0 5 37 0 View
qryClassificationTestGrainSizes 0 6 162 0 View
qryClassificationTests 0 6 163 0 View
qryCodeValues 0 3 13 0 View
qryConsolidationTests 0 6 79 0 View
qryCPTData 0 6 112 0 View
qryCPTInterpretationLayers 0 3 12 0 View
qryCPTInterpretationValues 0 4 12 0 View
qryCPTPush 0 5 40 0 View
qryCPTSettings 0 3 65 0 View
qryDocumentItems 0 6 24 0 View
qryDocumentRevisions 0 6 24 0 View
qryDocuments 0 5 48 0 View
qryDPTData 0 5 42 0 View
qryDrillingObservations 0 5 42 0 View
qryDSSTests 0 5 60 0 View
qryEMMTestValues 0 4 24 0 View
qryFieldLogs 0 5 34 0 View
qryFissures 0 5 47 0 View
qryGrainSizes 0 7 70 0 View
qryGrainSizeTests 0 7 45 0 View
qryGrainSizeValues 0 7 36 0 View
qryGrouting 0 6 35 0 View
qryHistory 0 5 15 0 View
qryHistoryTransactions 0 3 9 0 View
qryHoleDiameters 0 5 36 0 View
qryInclinations 0 5 36 0 View
qryIndurations 0 5 47 0 View
qryInjections 0 5 32 0 View
qryInsituVaneTests 0 5 42 0 View
qryIntakes 0 7 68 0 View
qryJackups 0 6 28 0 View
qryLabVaneTests 0 5 54 0 View
qryLayers 0 4 37 0 View
qryLayerSeries 0 2 7 0 View
qryLegPenetrations 0 6 35 0 View
qryMeasurementData 0 7 18 0 View
qryMeasurements 0 10 33 0 View
qryModelCells 0 3 16 0 View
qryModels 0 4 29 0 View
qryPenetrationTests 0 6 35 0 View
qryPlasticityTestValues 0 4 22 0 View
qryPointLoadTests 0 6 52 0 View
qryPoints 0 12 101 0 View
qryPointSummary 0 6 51 0 View
qryPointSynonyms 0 4 27 0 View
qryPressuremeterTests 0 5 38 0 View
qryProctorTests 0 5 57 0 View
qryProctorTestValues 0 4 26 0 View
qryProjectPhases 0 3 23 0 View
qryProjectRights 0 4 13 0 View
qryProjects 0 9 64 0 View
qryProjectSummary 0 4 48 0 View
qryPumpingTests 0 7 46 0 View
qrySamples 0 5 68 0 View
qrySamples2 0 5 71 0 View
qrySectionPoints 0 6 52 0 View
qrySections 0 4 48 0 View
qrySelectionIds 0 2 4 0 View
qrySelectionPoints 0 3 8 0 View
qrySelectionProjects 0 2 6 0 View
qrySelections 0 3 12 0 View
qryShearBoxTests 0 5 53 0 View
qrySPTData 0 7 51 0 View
qryStrata 0 8 57 0 View
qrySurfaces 0 4 14 0 View
qrySwellTests 0 5 50 0 View
qrySyntaxDesignations 0 4 20 0 View
qrySyntaxElements 0 2 13 0 View
qrySyntaxSynonyms 0 2 10 0 View
qryTriaxialTests 0 6 76 0 View
qryUCTData 0 5 57 0 View
qryWaterLevelMps 0 7 40 0 View
qryWaterLevels 0 15 71 0 View
qryWaterStrikes 0 5 33 0 View
qryWaterVolumes 0 6 35 0 View
Regions 7 0 10 6 Table
Rigs 5 0 2 0 Table
Samples 14 2 36 393 Table
SampleTypes 0 0 7 28 Table
SectionPoints 1 3 18 63 Table
Sections 4 2 43 5 Table
SectionStrings 0 1 2 0 Table
SelectionIds 0 1 3 0 Table
Selections 7 1 7 0 Table
Setups 5 0 2 2 Table
ShearBoxTests 1 1 11 0 Table
ShearBoxTestValues 0 1 16 0 Table
SieveDiameters 0 1 3 47 Table
Sieves 4 0 3 3 Table
SoilTypes 11 0 3 0 Table
SPTData 0 4 25 0 Table
StandardDescriptions 0 2 5 0 Table
Strata 1 3 23 272 Table
Strings 1 1 5 0 Table
Surfaces 2 2 9 0 Table
SurfaceValues 0 2 7 0 Table
SwellTests 0 2 8 0 Table
SyntaxDesignations 2 2 17 507 Table
SyntaxElements 4 1 12 35 Table
Syntaxes 9 0 9 2 Table
SyntaxSynonyms 0 1 7 1019 Table
Tare 0 0 5 0 Table
TriaxialTestCurves 0 1 13 0 Table
TriaxialTests 1 3 34 0 Table
TriaxialTestStages 1 1 18 0 Table
TriaxialTestTypes 4 0 3 8 Table
UCTData 1 2 15 0 Table
UCTValues 0 2 8 0 Table
UserNotifications 0 2 6 38 Table
Users 9 0 7 1 Table
VaneCodes 0 0 6 27 Table
Vanes 0 0 6 6 Table
Version 29 0 5 1 Table
VerticalRefs 6 0 6 6 Table
WaterLevelCategories 2 0 6 14 Table
WaterLevelExtremes 2 0 6 5 Table
WaterLevelMethods 2 0 6 9 Table
WaterLevelMPs 1 2 10 0 Table
WaterLevelProjects 2 0 6 17 Table
WaterLevelQualities 2 0 6 3 Table
WaterLevelRounds 2 0 7 0 Table
WaterLevels 0 9 29 77 Table
WaterLevelSituations 2 0 6 2 Table
WaterStrikes 1 1 7 0 Table
WaterVolumes 0 3 12 0 Table