Tables


SchemaSpy Analysis of sjbrande_ngl_db

Generated on Mon Apr 18 19:28 CEST 2022

XML Representation
Insertion Order Deletion Order
TABLES 78
VIEWS 0
COLUMNS 590
Constraints 88
Anomalies 2
Routines 0

Database Properties

Database Type: MySQL - 5.6.41-84.1

Tables

Table / View Children Parents Columns Rows Type Comments
DSSG 1 1 7 65 Table

General information for direct simple shear test

OTHF 0 1 7 0 Table

Other Field Tests

OTHR 0 2 6 31 Table

Other Laboratory Tests

GINV 1 1 7 125 Table

General information for geophysical investigation

LAB_PROGRAM 3 1 3 9 Table

Lab program table

PLAS 0 1 6 1385 Table

Atterberg Limits

ISPT 0 1 9 7956 Table

Standard Penetration Test Results

DSSS 2 1 7 115 Table

Direct simple shear test stages

DSSD1D 0 1 7 1138830 Table

Direct simple shear test data in one dimension

TEPT 0 1 8 3 Table

Test Pit

EVNT 3 0 20 608 Table

General information for earthquake events

GSWD 0 1 4 11240 Table

Surface Wave Geophysical Test - Dispersion Curve

GSWG 2 1 7 38 Table

General information and configuration for surface wave geophysical test

SPEC 8 1 7 5553 Table

General information for specimens

SEGM 0 1 11 615 Table

Fault Segments (finite fault models)

TESI 0 1 3 0 Table
SAMP_TEST 0 2 3 8460 Table

Junction table between sample and test tables

TESF 0 2 4 1455 Table

General information of supplemental files associated with a test

IM 0 2 125 20790 Table

Recorded Intensity Measure

DETL 0 1 4 783 Table

Within-layer Description

TESC 0 2 5 166 Table

Test Comments

TESP 0 2 3 1330 Table

Junction table between citation and test

GMIM 0 1 10 1007 Table

Ground Motion Intensity Measure recorded or estimated at a site

TESM 1 2 3 2961 Table

Test member information

SWVG 1 1 4 39 Table

General Information for Surface Wave Geophysical Test

DSSD2D 0 1 9 0 Table

Direct simple shear test data in one dimension

SWVD 0 1 7 341 Table

Surface Wave Geophysical Test Data - Vs/Vp Profiles

TEST 15 1 9 1869 Table

General information for in-situ tests

TESR 0 2 3 296 Table

Test Reviewer

GIND 0 1 5 2972 Table

Invasive Geophysical Investigation - Data

CONG 1 1 9 9 Table

Table for the general metadata of a consolidation test

COND 0 1 4 41846 Table

Consolidation test stage data

GMIM_COMP 0 0 2 10 Table
CITATION 5 0 3 197 Table

Citation table

LAB_PROGRAM_USER 0 2 3 12 Table

Lab program and user junction table

CRET 0 1 2 2840 Table

Test creator

SAMF 0 2 4 0 Table

Associated Files for Laboratory Tests

TXD 0 1 9 881706 Table

Triaxial test data

CRES 0 1 2 597 Table

Site creator

TXG 1 1 9 63 Table

General information for triaxial test

CREO 0 1 2 821 Table

Observation creator

OBSC 0 2 5 172 Table

Observation Comment

OBSM 1 2 3 834 Table

Observation member information

CON_STGE 1 1 6 48 Table

General information for consolidation test stages

password_resets 1 0 4 75 Table

Password Reset

phinxlog 0 0 5 9 Table

Version log

TXS 1 1 7 191 Table

Triaxial test stages

PERM 0 1 5 290 Table

Permissions

OBSR 0 2 3 439 Table

Observation Reviewer

SAMP 5 0 10 11439 Table

General information for sample

INDX 0 1 9 4059 Table

Index Tests

BORH 0 1 11 847 Table

General information for boreholes

FILE_EXT 0 1 4 2 Table

Large file table (>16MB)

FILE 5 0 6 2432 Table

Table storing supplemental files

WATR 0 1 5 1085 Table

Ground water table information

SITE 6 0 8 333 Table

Site general information

SCPG 1 1 10 849 Table

General information for Cone Penetration Test (CPT)

LAB_PROGRAMP 0 2 3 3 Table
SITC 0 2 5 178 Table

Site Comments

FLDD 0 1 9 2912 Table

Displacement vectors

FLDF 0 2 6 580 Table

General information of supplemental files associated with an observation

LAB_PROGRAM_SAMP 0 2 3 106 Table

Lab program and sample junction table

SITM 1 1 3 668 Table

Site member information

GMIM_TYPE 0 0 2 118 Table
LAB 1 1 6 7 Table

Lab general information

USER 12 0 17 524 Table

User Information

SITF 0 2 4 547 Table

General information of supplemental files associated with a site

FLDM 0 1 12 3240 Table

Liquefaction manifestation

GRAG 1 1 4 4383 Table

General information for particle size distribution test

FLDO 8 2 6 527 Table

General information for field observation

FLDP 0 2 3 1236 Table

Junction table between citation and observation

SCPT 0 1 6 572044 Table

Cone Penetration Test (CPT) Data

STAT 1 0 15 4183 Table

Recording stations

SITR 0 2 3 341 Table

Site Reviewer

SITP 0 2 3 841 Table

Junction table between citation and site

STRA 0 1 7 5505 Table

Stratigraphic Layer Description

RDEN 0 1 6 77 Table

Relative Density

GRAT 0 1 4 21231 Table

Particle Size Distribution - Data