Herbarium Database Management System - Table definitions

Database: LabelsData2000.mdb (C:\HerbariumAccess\Herbarium2000.mdb)

Table: Annotation  

Columns

Name Type Size

AnnotationID Long Integer 4

AnnotationLink Long Integer 4

AGenus Text 20

ASpecificEpithet Text 20

AAuthority Text 40

ARank Text 10

AInfraspecificName Text 20

AInfraspecificAuthority Text 40

ADeterminedBy Text 28

ATypeStatus Text 12

AHeaderOne Text 40

AHeaderTwo Text 40

ADate Text 12

ANeedPrint Yes/No 1

AQuantity Long Integer 4
Table: Family  

Columns

Name Type Size

ID Long Integer 4

Family Text 20

FamilyAcronym Text 4

FamilyNumber Text 4

FamilySoundex Text 4
Table: Footers  

Columns

Name Type Size

FooterOne Text 50

FooterTwo Text 50

FooterNumber Long Integer 4
Table: Genera  

Columns

Name Type Size

Genus Text 20

Synonym Text 20

FamilyNumber Text 4

GenusNumber Long Integer 4

FamilyLink Long Integer 4

GenusSoundex Text 4
Table: Herbarium Labels  

Columns

Name Type Size

ID Long Integer 4

GeoPrimaryDivision Text 30

GeoSecondaryDivision Text 30

GeoTertiaryDivision Text 30

SpecificEpithet Text 20

Authority Text 40

Rank Text 10

InfraspecificName Text 20

InfraspecificAuthority Text 40

DeterminedBy Text 40

Prefix Text 5

CollectionNumber Text 6

Suffix Text 5

Collector Text 30

MoreCollectors Text 50

Date Text 15

Locality Memo -

Ecology Memo -

LatitudeDegree Long Integer 4

LatitudeMinutes Long Integer 4

LatitudeSeconds Single 4

LatitudeDirection Text 1

LatitudeDecimal Double 8

LongitudeDegree Long Integer 4

LongitudeMinutes Long Integer 4

LongitudeSeconds Single 4

LongitudeDirection Text 1

LongitudeDecimal Double 8

Elevation Long Integer 4

Elevation2 Long Integer 4

ElevationUnits Text 3

FamilySource Long Integer 4

GeneraSource Long Integer 4

Notes Memo -

FooterSource Long Integer 4

EntryDate Date/Time 8

TypeStatus Text 12

GeographicCode Text 15

Quantity Byte 1

NeedPrint Yes/No 1

USGSQuadrangle Text 35

USGSQuadrangleScale Text 8

TownshipAndRange Text 55

Accession Text 10

LabelPrefix Long Integer 4

Genus Text 20

hybridspp1 Text 20

hybridspp2 Text 20

HybridAuthor1 Text 40

HybridAuthor2 Text 40

HybridGenus Text 20

HeaderCheck Yes/No 1

HeaderOne Text 30

HeaderTwo Text 30

HeaderPrimary Byte 1

UTMprint Yes/No 1
Table: Preferences  

Columns

Name Type Size

ID Long Integer 4

HeaderPrefix Text 30

RankList Text 10

TypeList Text 12

UnitList Text 3

ShipperList Text 21
Table: tblUTM  

Columns

Name Type Size

ID Long Integer 4

Label_ID Long Integer 4

Datum Text 50

UTMZone Text 50

easting Long Integer 4

northing Long Integer 4

Click here to return to Herbarium Management System  |  Click here to return to UC Davis herbarium homepage