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 |