View= localhost, mysqli, socalibiscores_01, column_info, rows=53
PrimaryKeyFieldType
ceden|IBIGroupNameIBIGroupNamevarchar(100)
ceden|EcoregionLevelEcoregionLevelvarchar(100)
ceden|OriginalEcoregionCodeOriginalEcoregionCodevarchar(50)
ceden|EcoregionCodeEcoregionCodeint(11)
ceden|WithinIBIBoundaryWithinIBIBoundaryvarchar(2)
ceden|UpstreamAreaUpstreamAreadouble
ceden|UpstreamAreaRecordedUpstreamAreaRecordedvarchar(2)
ceden|ProtocolCodeProtocolCodevarchar(40)
ceden|ProjectCodeProjectCodevarchar(20)
ceden|ProjectNameProjectNamevarchar(255)
ceden|SampleAgencyCodeSampleAgencyCodevarchar(32)
ceden|StationCodeStationCodevarchar(18)
ceden|StationNameStationNamevarchar(100)
ceden|TargetLatitudeTargetLatitudedouble
ceden|TargetLongitudeTargetLongitudedouble
ceden|DatumDatumvarchar(12)
ceden|SampleDateSampleDatedatetime
ceden|LocationCodeLocationCodevarchar(100)
ceden|CollectionTimeCollectionTimedatetime
ceden|CollectionMethodCodeCollectionMethodCodevarchar(100)
ceden|SampleTypeCodeSampleTypeCodevarchar(40)
ceden|CollectionDeviceDescrCollectionDeviceDescrvarchar(255)
ceden|CollectionDepthCollectionDepthdouble
ceden|UnitCollectionDepthUnitCollectionDepthvarchar(10)
ceden|SieveSizeSieveSizevarchar(255)
ceden|ReplicateReplicateint(11)
ceden|MinimumSampleSizeMinimumSampleSizeint(11)
ceden|SubSampleCountSubSampleCountint(10)
ceden|OriginalSumIndividualsOriginalSumIndividualsint(11)
ceden|FlagFlagvarchar(50)
ceden|NumberIndividualsIncludedNumberIndividualsIncludedint(11)
ceden|IterationsIterationsint(11)
ceden|IterationIterationint(11)
ceden|LabSampleIDLabSampleIDvarchar(70)
ceden|IBI_ScoreIBI_Scoredouble
ceden|EPT_TaxaEPT_Taxaint(11)
ceden|EPT_Taxa_ScoreEPT_Taxa_Scoredouble
ceden|Number_Coleoptera_TaxaNumber_Coleoptera_Taxaint(11)
ceden|Number_Coleoptera_Taxa_ScoreNumber_Coleoptera_Taxa_Scoreint(4)
ceden|Number_Predator_TaxaNumber_Predator_Taxaint(11)
ceden|Number_Predator_Taxa_ScoreNumber_Predator_Taxa_Scoreint(4)
ceden|Percent_CFCG_IndividualsPercent_CFCG_Individualsdouble
ceden|Percent_CFCG_Individuals_ScorePercent_CFCG_Individuals_Scoredouble
ceden|Percent_IntolerantPercent_Intolerantdouble
ceden|Percent_Intolerant_ScorePercent_Intolerant_Scoredouble
ceden|Percent_Non_Insecta_TaxaPercent_Non_Insecta_Taxadouble
ceden|Percent_Non_Insecta_Taxa_ScorePercent_Non_Insecta_Taxa_Scoredouble
ceden|Percent_Tolerant_TaxaPercent_Tolerant_Taxadouble
ceden|Percent_Tolerant_Taxa_ScorePercent_Tolerant_Taxa_Scoredouble
ceden|utilutilvarchar(20)
ceden|id_keyid_keyint(11)
ceden|ActiveActivevarchar(2)
ceden|SourcefilenameSourcefilenamevarchar(255)