Herbarium Database Management System - Table definitions

Database: LabelsData.mdb (C:\HerbariumAccess\LabelsData.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: 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

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 Long Integer 4

LatitudeDirection Text 1

LongitudeDegree Long Integer 4

LongitudeMinutes Long Integer 4

LongitudeSeconds Long Integer 4

LongitudeDirection Text 1

Elevation 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
Table: Herbarium Label Footers Access 95 version

Columns

Name Type Size

FooterOne Text 50

FooterTwo Text 50

FooterNumber Long Integer 4
Table: Footers Access 97 version

Columns

Name Type Size

FooterOne Text 50

FooterTwo Text 50

FooterNumber Long Integer 4
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

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