CHL_Enterprise_Database_Schema.pdf

TABLE 1

ENTERPRISE DATABASE SCHEMA

CHICKAMAUGA LOCK EXCAVATION DATA MANAGEMENT SYSTEM

DMP_T1_tblDocumentation Rev 1.xlsx Page 1 of 5 2/1/2017

Object Type Object Field Keys Description Table tblAnchorData -- Primary storage of anchor construction details Field tblAnchorData AlignmentLoad Alignment Load (kips) Field tblAnchorData AnchorID PK Object Identifier Field tblAnchorData AnchorInstalledPhase Installation Phase Field tblAnchorData AnchorType Bar/Strand Field tblAnchorData Azimuth Direction of inclination (Degrees) Field tblAnchorData BarDiameter Diameter of Bar (inches) Field tblAnchorData BarStrandLength Strand Length (feet) Field tblAnchorData BatterOfHole Direction of dip from horizontal (Degrees) Field tblAnchorData BearingPlateThickness Thickness of Bearing Plate (inches) Field tblAnchorData BondLength Length of bond (feet) Field tblAnchorData BondZoneGroutTest Qualitative description of bond test results Field tblAnchorData BottomHoleElevation Bottom hole elevation (feet NAVD88) Field tblAnchorData CementBagsInjected_Backfill Number of bags of cement injected during backfill testing Field tblAnchorData CementBagsInjected_WaterTightness Number of bags of cement injected during watertightness testing Field tblAnchorData DateInstalled Date of anchor installation Field tblAnchorData DesignLoad Design Load (kips) Field tblAnchorData DiameterDrilledHole Drilled hole diameter (inches) Field tblAnchorData ElevBot_Dsgn Design bottom elevation (feet NAVD88) Field tblAnchorData GroutDateTime_Backfill Date and time of grouting during backfill testing Field tblAnchorData GroutDateTime_WaterTightness Date and time of grouting during watertightness testing Field tblAnchorData GroutMix_Backfill Grout mix design used in backfill testing (see shop drawings for mix design details) Field tblAnchorData GroutMix_WaterTightness Grout mix design used in watertightness testing (see shop drawings for mix design details) Field tblAnchorData GroutPressure_Backfill Grouting pressure in backfill testing (psi) Field tblAnchorData GroutPressure_WaterTightness Grouting pressure in watertightness testing (psi) Field tblAnchorData GroutRefusal Qualitative description of refusal depth and details Field tblAnchorData LockOffLoad Lock Off Load (kips) Field tblAnchorData NoOfStrands Strand count Field tblAnchorData Offset Offset (feet) Field tblAnchorData SheathedLength Grease and Sheath Length (feet) Field tblAnchorData Station Stationing (feet) Field tblAnchorData SteelArea Area of Steel (square inches) Field tblAnchorData StressingLength Length (feet) Field tblAnchorData TendonBondLength Length of tendon bond (feet) Field tblAnchorData TestLoad Test Load (kips) Field tblAnchorData TopHoleElevation Top hole elevation (feet NAVD88) Field tblAnchorData TopRockElevation Top of rock elevation (feet NAVD88) Field tblAnchorData TotalLength Total Fabricated Anchor Length (Feet) Table tblBlastHoles -- Primary storage of data collected from blast holes associated with blast shots Field tblBlastHoles Depth Depth to bottom of hole (feet) Field tblBlastHoles Easting Surveyed location of hole (NAD83 Tennessee State Plane Feet) Field tblBlastHoles GeologicalFeaturesEncountered List of features in blasting hole Field tblBlastHoles HoleID PK Hole identifier Field tblBlastHoles Northing Surveyed location of hole (NAD83 Tennessee State Plane Feet)

CHICKAMAUGA LOCK EXCAVATION DATA MANAGEMENT SYSTEM

DMP_T1_tblDocumentation Rev 1.xlsx Page 2 of 5 2/1/2017

Object Type Object Field Keys Description Field tblBlastHoles ShotNumber PK Blast location associated with holes Field tblBlastHoles TopElevation Surveyed top elevation (feet NAVD88) Field tblBlastHoles VibrationResponse Response observed in hole Table tblBlasting -- Primary storage of drilling and blasting locations and associated data Field tblBlasting BlastPlan Hyperlink to document Field tblBlasting Delay Delay, units TBD Field tblBlasting Easting Blast Location (NAD83 Tennessee State Plane Feet) Field tblBlasting ExplosivesAmount Mass of explosives (lbs) Field tblBlasting ExplosivesBrand Brand name of explosives (with model number if applicable) Field tblBlasting ExplosivesDepth Depth to explosives (feet) Field tblBlasting ExplosivesDiameter Dimater of explosives, units TBD Field tblBlasting ExplosivesLength Length of explosives, units TBD Field tblBlasting ExplosivesMassPerDay Maximum mass of explosives per day (lbs) Field tblBlasting ExplosivesStemming Stemming of explosives, units TBD Field tblBlasting ExplosivesType Description of explosives type Field tblBlasting NearestStructure Name of nearest structure Field tblBlasting Northing Blast Location (NAD83 Tennessee State Plane Feet) Field tblBlasting NumberOfHoles Number of Blast Holes Field tblBlasting PostShotRecord Hyperlink to document Field tblBlasting PowderFactor Powder Factor Field tblBlasting PPV_Predicted Predicted peak particle velocity (mm/s) Field tblBlasting PPV_Actual Actual measured peak particle velocity (mm/s) Field tblBlasting PreShotPlan Hyperlink to document Field tblBlasting ScaledDistance Scaled distance (feet) Field tblBlasting SeismographEasting Seismograph Location (NAD83 Tennessee State Plane Feet) Field tblBlasting SeismographNorthing Seismograph Location (NAD83 Tennessee State Plane Feet) Field tblBlasting ShotDateTime Date and time of blast Field tblBlasting ShotNumber PK Primary identification of Blast Location Field tblBlasting VolumeOfRockInShot Volume of rock in shot (cubic yards) Table tblConcreteBatch -- Concrete Batch Table Field tblConcreteBatch Air_Content Air Content (%) Field tblConcreteBatch Ambient_Temperature Ambient temperature (degrees Fahrenheit) Field tblConcreteBatch Batch_ID PK Batch identifier Field tblConcreteBatch Batch_Location Batch location Field tblConcreteBatch BatchDate Date and Time water enters the mixture, as reported on the batch ticket (dd/mm/yyyy hh:mm) Field tblConcreteBatch Cast_Quantity Number of samples cast per batch Field tblConcreteBatch Cast_Time Date and Time concrete cylinders were made (dd/mm/yyyy hh:mm) Field tblConcreteBatch Concrete_Temperature Concrete temperature (degrees Fahrenheit) Field tblConcreteBatch Lift_ID Lift identifier Field tblConcreteBatch Mix_ID Mix identifier Field tblConcreteBatch Mix_Type Type of mix used Field tblConcreteBatch Slump Slump (inches) Field tblConcreteBatch Teschnician_Name Name of technician/personnel performing the concrete testing Field tblConcreteBatch Test_Time Date and Time fresh concrete properties were measured (dd/mm/yyyy hh:mm)

CHICKAMAUGA LOCK EXCAVATION DATA MANAGEMENT SYSTEM

DMP_T1_tblDocumentation Rev 1.xlsx Page 3 of 5 2/1/2017

Object Type Object Field Keys Description Field tblConcreteBatch Vebe Vebe (seconds) Field tblConcreteBatch Weather_Clouds Pick from a list Field tblConcreteBatch Weather_Precipitation Pick from a list Field tblConcreteBatch Weather_Winds Pick from a list Table tblConcreteCylinder -- Concrete Cylinder Table Field tblConcreteCylinder Age_Sample Age of specimen in whole number Field tblConcreteCylinder Batch_ID Batch identifier Field tblConcreteCylinder Casting_Date Date and time specimen was cast Field tblConcreteCylinder Casting_Name Name of personnel casting sample; Last name and 1st initial Field tblConcreteCylinder Compressive_Name Name of personnel testing sample; Last name and 1st initial Field tblConcreteCylinder Compressive_Strength Compressive strength (psi) Field tblConcreteCylinder Specimen_ID PK Specimen identifier Field tblConcreteCylinder Specimen_Test_Date Date and Time sample was tested (dd/mm/yyyy hh:mm) Field tblConcreteCylinder Specimen_Type Type of specimen Table tblgINT_Atterberg -- FK: tblgINT_Point.PointID Atterberg limits from gINT import Field tblgINT_Atterberg PointID PK Atterberg limits from gINT import Table tblgINT_LabSpecimen -- FK: tblgINT_Point.PointID Lab specimen from gINT import Field tblgINT_LabSpecimen PointID PK Lab specimen from gINT import Table tblgINT_Lithology -- FK: tblgINT_Point.PointID General lithological information Field tblgINT_Lithology PointID PK General lithological information Table tblgINT_LithologyRock -- FK: tblgINT_Point.PointID Rock lithology from gINT import Field tblgINT_LithologyRock PointID PK Rock lithology from gINT import Table tblgINT_LithologySoil -- FK: tblgINT_Point.PointID Soil lithology from gINT import Field tblgINT_LithologySoil PointID PK Soil lithology from gINT import Table tblgINT_Point -- FK: tblgINT_Point.PointID Primary storage of information for holes in gINT database (from gINT import) Field tblgINT_Point PointID PK Primary storage of information for holes in gINT database (from gINT import) Table tblgINT_Remarks -- FK: tblgINT_Point.PointID gINT hole comments from gINT import Field tblgINT_Remarks PointID PK gINT hole comments from gINT import Table tblgINT_RockCoreData -- FK: tblgINT_Point.PointID Rock core data from gINT import Field tblgINT_RockCoreData PointID PK Rock core data from gINT import Table tblgINT_Sample -- FK: tblgINT_Point.PointID Primary storage of geological sample information from gINT import Field tblgINT_Sample PointID PK Primary storage of geological sample information from gINT import Table tblgINT_Sieve -- FK: tblgINT_Point.PointID Sieve data from gINT import Field tblgINT_Sieve PointID PK Sieve data from gINT import Table tblgINT_StrataDetails -- FK: tblgINT_Point.PointID Stratigraphy details from gINT import Field tblgINT_StrataDetails PointID PK Stratigraphy details from gINT import Table tblgINT_SVReadings -- FK: tblgINT_Point.PointID SV Readings from gINT import Field tblgINT_SVReadings PointID PK SV Readings from gINT import Table tblgINT_WaterLevels -- FK: tblgINT_Point.PointID Water levels from gINT import Field tblgINT_WaterLevels PointID PK Water levels from gINT import Table tblgINT_Weathering -- FK: tblgINT_Point.PointID Bedrock from gINT import Field tblgINT_Weathering PointID PK Bedrock from gINT import Table tblInstrument -- Primary storage of instrument location and installation details..

Field tblInstrument ADASUnit Unit ID

CHICKAMAUGA LOCK EXCAVATION DATA MANAGEMENT SYSTEM

DMP_T1_tblDocumentation Rev 1.xlsx Page 4 of 5 2/1/2017

Object Type Object Field Keys Description Field tblInstrument Boring Boring ID Field tblInstrument CompletionDate Date of instrument completion Field tblInstrument CompletionType Completion type Field tblInstrument DateInstalled Installation date Field tblInstrument DepthToPZTipElevation Depth to piezometer tip (feet) Field tblInstrument Easting Instrument location (NAD83 Tennessee State Plane Feet) Field tblInstrument InstrumentID PK Primary Instrument ID Field tblInstrument InstrumentType Type (piezometer, etc.)

Field tblInstrument MeasuringPointElevation Elevation of measuring midpoint (feet NAVD88) Field tblInstrument Northing Instrument location (NAD83 Tennessee State Plane Feet) Field tblInstrument Offset Instrument location Field tblInstrument PZTipElevation Elevation of piezometer tip (feet NAVD88) Field tblInstrument Station Instrument location Field tblInstrument Status Current status Field tblInstrument TotalDepth Total instrument boring depth (feet) Table tblInstrument_Data -- Primary storage of data collected from instruments Field tblInstrument_Data InstrumentID PK, FK: tblInstrument.Instrume Instrument ID Field tblInstrument_Data MeasurementDate PK Date of measurement Field tblInstrument_Data Metric PK Measurement type Field tblInstrument_Data Result Measurement result Field tblInstrument_Data Units Measurement units Table tblPhotograph -- List of Contractor photographs and associated metadata Field tblPhotograph CameraType Camera make and model Field tblPhotograph Elevation Elevation, meters. Generally NULL for site photographs Field tblPhotograph Feature Description of photographed feature name where possible Field tblPhotograph FeatureType Description of photographed feature or activity where possible Field tblPhotograph Filename PK Photograph filename Field tblPhotograph GPSenabled TRUE if camera is GPS enabled Field tblPhotograph Latitude Latitude (decimal degrees) Field tblPhotograph Longitude Longitude (decimal degrees) Field tblPhotograph PhotoDate Photograph creation date Table tblRockBolt -- Primary storage of rock bolt locations Field tblRockBolt Depth Depth to bottom of rock bolt (feet) Field tblRockBolt Easting Location - raw data or calculated from station/offset (NAD83 Tennessee State Plane Feet) Field tblRockBolt Elevation Elevation of top of rock bolt (feet NAVD88) Field tblRockBolt InstallationDate Date/Time of completion of installation Field tblRockBolt Northing Location - raw data or calculated from station/offset (NAD83 Tennessee State Plane Feet) Field tblRockBolt RockBoltID PK Rock bolt Identifier Table tblSecantPiles -- Primary storage of secant pile locations and geometry

Field tblSecantPiles Object Type The lowest Concrete Condition Rating ("Good", "Conditional", "Poor", etc.) derived from Crosshole Sonic Logging data for the pile

Field tblSecantPiles CSLReport Filename of Crosshole Sonic Logging report Field tblSecantPiles Depth Pile depth to bottom (feet) Field tblSecantPiles DepthsToBentonite Depths (comma separated list) of depths at which bentonite seams were encountered

CHICKAMAUGA LOCK EXCAVATION DATA MANAGEMENT SYSTEM

DMP_T1_tblDocumentation Rev 1.xlsx Page 5 of 5 2/1/2017

Object Type Object Field Keys Description Field tblSecantPiles DepthsToCavities Depths (comma separated list) of depths at which cavities were encountered Field tblSecantPiles Diameter Pile diameter (inches) Field tblSecantPiles DrillRigID Drill Rig identifier (including manufacturer's make and model) Field tblSecantPiles Easting Location - raw data or calculated from station/offset (NAD83 Tennessee State Plane Feet) Field tblSecantPiles ExcavationEndDate Date and time of excavation end Field tblSecantPiles ExcavationStartDate Date and time of excavation start Field tblSecantPiles GeologicalClassification Geological classification of materials encountered during excavation Field tblSecantPiles GroundWaterObservations Qualitative description of water table (e.g., artesian) or depth to water observed Field tblSecantPiles MixID Concrete mix identifier Field tblSecantPiles Northing Location - raw data or calculated from station/offset (NAD83 Tennessee State Plane Feet) Field tblSecantPiles Offset Location - raw data or calculated from coordinates Field tblSecantPiles PileID PK Pile name Field tblSecantPiles PlacementEndDate Date and time of material placement end Field tblSecantPiles PlacementStartDate Date and time of material placement start Field tblSecantPiles Station Location - raw data or calculated from coordinates

PK - Primary Key FK - Foreign Key Utility tables and fields not shown Schema subject to change; field types to be determined when example data available