sjbrande_ngl_db Database

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

DSSG

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

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

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

9

Table

Table for the general metadata of a consolidation test

COND

0

1

4

41846

Table

Consolidation test stage data

GMIM_COMP

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

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

6

48

Table

General information for consolidation test stages

password_resets

1

0

4

75

Table

Password Reset

phinxlog

0

5

9

Table

Version log

TXS

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

10

849

Table

General information for Cone Penetration Test (CPT)

LAB_PROGRAMP

0

2

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

3

668

Table

Site member information

GMIM_TYPE

0

2

118

Table

LAB

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

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

Tables

SchemaSpy Analysis of sjbrande_ngl_db

Database Properties

Tables