View= localhost, mysqli, toxsummary_mpsl, column_info, rows=61
PrimaryKeyFieldType
ceden|LabSampleIDLabSampleIDvarchar(70)
ceden|SourcefilenameSourcefilenamevarchar(255)
ceden|StationCodeStationCodevarchar(18)
ceden|EventCodeEventCodevarchar(40)
ceden|ProtocolCodeProtocolCodevarchar(40)
ceden|LocationCodeLocationCodevarchar(100)
ceden|SampleDateSampleDatedatetime
ceden|CollectionTimeCollectionTimedatetime
ceden|CollectionMethodCodeCollectionMethodCodevarchar(100)
ceden|SampleTypeCodeSampleTypeCodevarchar(40)
ceden|ReplicateReplicateint(11)
ceden|CollectionDepthCollectionDepthdouble
ceden|UnitCollectionDepthUnitCollectionDepthvarchar(10)
ceden|ProjectCodeProjectCodevarchar(20)
ceden|AgencyCodeAgencyCodevarchar(20)
ceden|LabCollectionCommentsLabCollectionCommentsvarchar(255)
ceden|SampleIDSampleIDvarchar(70)
ceden|DWC_TT_MatrixNameDWC_TT_MatrixNamevarchar(50)
ceden|DWC_TT_MethodNameDWC_TT_MethodNamevarchar(100)
ceden|ToxTestDurNameToxTestDurNamevarchar(255)
ceden|FinalIDFinalIDvarchar(40)
ceden|TestExposureTypeTestExposureTypevarchar(255)
ceden|ToxBatchToxBatchvarchar(50)
ceden|ToxTestCommentsToxTestCommentsvarchar(255)
ceden|TreatmentTreatmentvarchar(255)
ceden|ConcentrationConcentrationdouble
ceden|UnitTreatmentUnitTreatmentvarchar(50)
ceden|DilutionDilutiondouble
ceden|ToxPointMethodToxPointMethodvarchar(50)
ceden|DWC_TP_AnalyteNameDWC_TP_AnalyteNamevarchar(255)
ceden|FractionNameFractionNamevarchar(100)
ceden|WQSourceWQSourcevarchar(50)
ceden|TimePointNameTimePointNamevarchar(50)
ceden|UnitAnalyteUnitAnalytevarchar(50)
ceden|RepCountRepCountint(11)
ceden|MeanMeandouble
ceden|StdDevStdDevdouble
ceden|StatisticalMethodStatisticalMethodvarchar(40)
ceden|AlphaLevelAlphaLeveldouble
ceden|bValuebValuevarchar(255)
ceden|CalcValueTypeCalcValueTypevarchar(255)
ceden|CalculatedValueCalculatedValuedouble
ceden|CritcalValueCritcalValuedouble
ceden|PercentEffectPercentEffectdouble
ceden|CALC_PercentControlCALC_PercentControldouble
ceden|EvalThresholdEvalThresholddouble
ceden|SigEffectCodeSigEffectCodevarchar(3)
ceden|ToxPointSummaryCommentsToxPointSummaryCommentsvarchar(255)
ceden|TestQACodeTestQACodevarchar(50)
ceden|SubmittingAgencySubmittingAgencyvarchar(255)
ceden|DWC_TT_AgencyCodeDWC_TT_AgencyCodevarchar(20)
ceden|ToxBatchCommentsToxBatchCommentsvarchar(255)
ceden|LabSubmissionCodeLabSubmissionCodevarchar(10)
ceden|BatchVerificationCodeBatchVerificationCodevarchar(40)
ceden|DWC_DatabaseSourceDWC_DatabaseSourcevarchar(255)
ceden|TargetLatitudeTargetLatitudedouble
ceden|TargetLongitudeTargetLongitudedouble
ceden|YearYeardatetime
ceden|ToxPointSummaryRowIDToxPointSummaryRowIDvarchar(255)
ceden|id_keyid_keyint(11)
ceden|ActiveActivevarchar(2)