View= localhost, mysqli, bmi_r3_data, column_info, rows=85
PrimaryKeyFieldType
ceden|org_idorg_idvarchar(20)
ceden|prog_idprog_idvarchar(20)
ceden|user_iduser_idvarchar(20)
ceden|proj_idproj_idvarchar(40)
ceden|SiteTagSiteTagvarchar(16)
ceden|LatitudeLatitudedouble
ceden|LongitudeLongitudedouble
ceden|CollectionDepthCollectionDepthdouble
ceden|UnitCollectionDepthUnitCollectionDepthvarchar(10)
ceden|SampleDateSampleDatedatetime
ceden|SampleTimeSampleTimedatetime
ceden|SampleReplicateSampleReplicateint(11)
ceden|Sampler_NameSampler_Namevarchar(40)
ceden|AnalyteNameAnalyteNamevarchar(255)
ceden|MethodNameMethodNamevarchar(100)
ceden|ccampidccampidvarchar(40)
ceden|ResultResultvarchar(100)
ceden|Result_valResult_valdouble
ceden|ResultQualCodeResultQualCodevarchar(20)
ceden|ResultUnitResultUnitvarchar(100)
ceden|MDLMDLdouble
ceden|RLRLdouble
ceden|QACodeQACodevarchar(60)
ceden|QAcommentsQAcommentsvarchar(255)
ceden|MatrixNameMatrixNamevarchar(100)
ceden|SampleIDSampleIDvarchar(70)
ceden|LabSampleIDLabSampleIDvarchar(70)
ceden|LabLabvarchar(40)
ceden|AnalysisDateAnalysisDatedatetime
ceden|LabReplicateLabReplicateint(2)
ceden|AnalystAnalystvarchar(50)
ceden|LabBatchLabBatchvarchar(70)
ceden|LabResultCommentsLabResultCommentsvarchar(255)
ceden|SampleCommentsSampleCommentsvarchar(1000)
ceden|Trash_commentsTrash_commentsvarchar(1000)
ceden|OccupationMethodOccupationMethodvarchar(40)
ceden|LocationCodeLocationCodevarchar(100)
ceden|SourcefilenameSourcefilenamevarchar(255)
ceden|BasisBasisvarchar(10)
ceden|SampleTypeCodeSampleTypeCodevarchar(40)
ceden|CollectionMethodCodeCollectionMethodCodevarchar(100)
ceden|FractionNameFractionNamevarchar(100)
ceden|CollectionDeviceNameCollectionDeviceNamevarchar(100)
ceden|PreparationPreservationPreparationPreservationvarchar(100)
ceden|PreparationPreservationDatePreparationPreservationDatedatetime
ceden|DigestExtractDateDigestExtractDatedatetime
ceden|DigestExtractMethodDigestExtractMethodvarchar(100)
ceden|DilFactorDilFactordouble
ceden|Spike_AmountSpike_Amountdouble
ceden|Expected_ResultExpected_Resultdouble
ceden|CollectionTypeCollectionTypevarchar(40)
ceden|REC_RPDREC_RPDvarchar(40)
ceden|FailureReasonFailureReasonvarchar(100)
ceden|EventCodeEventCodevarchar(40)
ceden|ProtocolCodeProtocolCodevarchar(40)
ceden|SamplePurposeSamplePurposevarchar(100)
ceden|CriteriaCriteriavarchar(255)
ceden|SeasonSeasonvarchar(20)
ceden|ExceedanceExceedancedouble
ceden|StatStatvarchar(100)
ceden|p_valuep_valuedouble
ceden|Stat_commentsStat_commentsvarchar(255)
ceden|Control_IdControl_Idvarchar(40)
ceden|Calc_MethodCalc_Methodvarchar(255)
ceden|Huc8Huc8varchar(8)
ceden|Huc12Huc12varchar(12)
ceden|FieldCollectionReplicateFieldCollectionReplicateint(2)
ceden|RBUASPWRBUASPWvarchar(40)
ceden|AgencyCodeAgencyCodevarchar(40)
ceden|Chr_Sub_GroupChr_Sub_Groupvarchar(40)
ceden|Chr_groupChr_groupvarchar(40)
ceden|CalDateTime_preCalDateTime_predatetime
ceden|CalDateTime_postCalDateTime_postdatetime
ceden|HUHUvarchar(4)
ceden|comidcomidint(16)
ceden|FlagsFlagsvarchar(255)
ceden|WaterbodyWaterbodyvarchar(255)
ceden|DispositionDispositionvarchar(40)
ceden|Disp_CommentsDisp_Commentsvarchar(255)
ceden|activity_typeactivity_typevarchar(50)
ceden|created_dtcreated_dtdatetime
ceden|modified_dtmodified_dtdatetime
ceden|key_1key_1varchar(255)
ceden|id_keyid_keyint(11)
ceden|ActiveActivevarchar(2)