Skip to content

Specify Software Project

Personal tools
You are here: Home » What is Specify? » Data Dictionary

Specify Data Dictionary

Document Actions
The document contains a complete list of all Specify's data tables and fields. It is intended as a technical reference. It can also be helpful, however, in understanding the scope and usage of certain attributes. When you have a question like "where does this information fit in", reading the attribute description of related attributes may help.

This document is about 56 printed pages and was generated by the Diversity Model Documenter (v1.7) available under a GNU General Public License (v2) from Dr. Gregor Hagedorn, Federal Biological Research Center for Agriculture and Forestry, Berlin, Germany. We gratefully acknowledge the use of his software.

Index to Specify Data Tables

Accession, AccessionAgents, AccessionAuthorizations, Address, Agent, AgentAddress, Authors, BiologicalObjectAttributes, BiologicalObjectRelation, BiologicalObjectRelationType, Borrow, BorrowAgents, BorrowMaterial, BorrowReturnMaterial, BorrowShipments, CatalogSeries, CatalogSeriesDefinition, CollectingEvent, Collection, CollectionObject, CollectionObjectCatalog, CollectionObjectCitation, CollectionObjectType, CollectionTaxonomyTypes, Collectors, DATAVIEWS, Deaccession, DeaccessionAgents, DeaccessionCollectionObject, Determination, DeterminationCitation, ExchangeIn, ExchangeOut, Geography, GeologicTimeBoundary, GeologicTimePeriod, GroupPersons, Habitat, Image, ImageAgents, ImageCollectionObjects, ImageLocalities, Journal, Loan, LoanAgents, LoanPhysicalObject, LoanReturnPhysicalObject, Locality, LocalityCitation, Observation, OtherIdentifier, Permit, Preparation, Project, ProjectCollectionObjects, ReferenceWork, REPORTS, Shipment, Sound, SoundEventStorage, Stratigraphy, TaxonCitation, TaxonName, TaxonomicUnitType, TaxonomyType.

Accession

Information about a collection's accessions.

Attributes and indices of the entity 'Accession'
Name Type Description / Default value & validation Rqrd./Index
AccessionID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
CollectionID Long Collection making the accession. R I/I (UM)
Number Text (30) A user-visible identifier of the Accession. Typically an integer, but may include alphanumeric characters as prefix, suffix, and separators. R I
Status Text (30) Status of Accession, e.g. 'In process', 'Complete' ...
validation message: List.
- -
Type Text (30) Source of Accession, e.g. 'Collecting', 'Gift', 'Bequest' ...
validation message: List.
- -
VerbatimDate Text (50) accomodates historical accessions. - -
DateAccessioned Long Date of Accession. - I
DateReceived Long Date material was received. - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Text3 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
Remarks Memo Comments. - -
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - I
LastEditedBy Text (50) Login name of user who last edited the record. - I
StatusID Long Link to Lookup table for Status. - I
TypeID Long Link to Lookup table for Type. - I
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88AE3-69C6-11D2-A962-00...:  CollectionID (Duplicates OK)
CandidateKey:  CollectionID; Number (Unique values)
DateAccessioned:  DateAccessioned (Duplicates OK)
LastEditedBy:  LastEditedBy (Duplicates OK)
Number:  Number (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
PrimaryKey:  AccessionID (Primary key; Unique values)
StatusID:  StatusID (Duplicates OK)
TimestampModified:  TimestampModified (Duplicates OK)
TypeID:  TypeID (Duplicates OK)
Relation type:  Fields involved
Deletions cascade  Accession.AccessionID ? AccessionAgents.AccessionID
Deletions cascade  Accession.AccessionID ? AccessionAuthorizations.AccessionID
Referential integrity  Accession.AccessionID ? CollectionObjectCatalog.AccessionID
Referential integrity  Collection.CollectionID ? Accession.CollectionID

AccessionAgents

Associates agents with accessions.

Attributes and indices of the entity 'AccessionAgents'
Name Type Description / Default value & validation Rqrd./Index
AccessionAgentsID Autonumber Default value: GenUniqueID() - I (U)
AccessionID Long Accession in which the Agent played a role. R I/I (UM)
AgentAddressID Long AgentAdress of agent playing role in Accession. R I
Role Text (50) Role the agent played in the accession process.
validation message: List.
R -
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
RoleID Long Link to Lookup table for Role. - I
Index name:  Attributes & index properties
{32B88AB5-69C6-11D2-A962-00...:  AccessionID (Duplicates OK)
{32B88AB9-69C6-11D2-A962-00...:  AgentAddressID (Duplicates OK)
AccessionAgentsID:  AccessionAgentsID (Primary key; Unique values)
CandidateKey:  AccessionID; AgentAddressID; Role (Unique values)
RoleID:  RoleID (Duplicates OK)
Relation type:  Fields involved
Deletions cascade  Accession.AccessionID ? AccessionAgents.AccessionID
Referential integrity  AgentAddress.AgentAddressID ? AccessionAgents.AgentAddressID

AccessionAuthorizations

Associates permits with accessions.

Attributes and indices of the entity 'AccessionAuthorizations'
Name Type Description / Default value & validation Rqrd./Index
AccessionAuthorizationsID Autonumber Default value: GenUniqueID() - I (U)
AccessionID Long Accession authorized by permit. R I/I (UM)
PermitID Long Permit authorizing accession. R I
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88AB6-69C6-11D2-A962-00...:  AccessionID (Duplicates OK)
{32B88B19-69C6-11D2-A962-00...:  PermitID (Duplicates OK)
AccessionAuthorizationsID:  AccessionAuthorizationsID (Unique values)
PrimaryKey:  AccessionID; PermitID (Primary key; Unique values)
Relation type:  Fields involved
Deletions cascade  Accession.AccessionID ? AccessionAuthorizations.AccessionID
Referential integrity  Permit.PermitID ? AccessionAuthorizations.PermitID

Address

Addresses of persons and organizations.

Attributes and indices of the entity 'Address'
Name Type Description / Default value & validation Rqrd./Index
AddressID Autonumber PrimaryKey.
Default value: GenUniqueID()
- I (U)
Address Memo Address as it should appear on mailing labels. R -
City Text (32)   - -
State Text (32)   - -
Country Text (32)   - -
Postalcode Text (32)   - I
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
AddressID:  AddressID (Primary key; Unique values)
Postalcode:  Postalcode (Duplicates OK)
Relation type:  Fields involved
Referential integrity  Address.AddressID ? AgentAddress.AddressID

Agent

Information about people, groups, and organizations.

Attributes and indices of the entity 'Agent'
Name Type Description / Default value & validation Rqrd./Index
AgentID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
AgentType Byte Discriminator between Organization(0), Person(1),Other(2), and Group(3).
Default value: 1
R -
FirstName Text (50) of Person. - -
LastName Text (50) of Person. - I
MiddleInitial Text (1) of Person. - -
Title Text (50) of Person. - -
Interests Text (255) of Person or Organization. - -
Abbreviation Text (50) of organization. - I
Name Text (120) of organization/group/Folks (and maybe persons). - I
ParentOrganizationID Long of organization. - I
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() R I
TimestampCreated Date/Time Default value: Now() R -
LastEditedBy Text (50)   - I
Index name:  Attributes & index properties
{32B88AC3-69C6-11D2-A962-00...:  ParentOrganizationID (Duplicates OK)
Abbreviation:  Abbreviation (Duplicates OK)
AgentID:  AgentID (Primary key; Unique values)
LastEditedBy:  LastEditedBy (Duplicates OK)
LastName:  LastName (Duplicates OK)
Name:  Name (Duplicates OK)
TimestampModified:  TimestampModified (Duplicates OK)
Relation type:  Fields involved
Referential integrity  Agent.AgentID ? Agent.ParentOrganizationID
Deletions cascade  Agent.AgentID ? AgentAddress.AgentID
Referential integrity  Agent.AgentID ? AgentAddress.OrganizationID
Referential integrity  Agent.AgentID ? Authors.AgentID
Referential integrity  Agent.AgentID ? BorrowReturnMaterial.ReturnedByID
Referential integrity  Agent.AgentID ? Collection.OrganizationID
Referential integrity  Agent.AgentID ? Collectors.AgentID
Referential integrity  Agent.AgentID ? Determination.DeterminerID
Referential integrity  Agent.AgentID ? ExchangeIn.CatalogedByID
Referential integrity  Agent.AgentID ? ExchangeOut.CatalogedByID
Deletions cascade  Agent.AgentID ? GroupPersons.GroupID
Referential integrity  Agent.AgentID ? GroupPersons.MemberID
Referential integrity  Agent.AgentID ? CollectionObjectCatalog.CatalogerID
Referential integrity  Agent.AgentID ? Image.MadeByID
Referential integrity  Agent.AgentID ? Image.CopyrightOwnerID
Referential integrity  Agent.AgentID ? ImageAgents.AgentID
Referential integrity  Agent.AgentID ? LoanReturnPhysicalObject.ReceivedByID
Referential integrity  Agent.AgentID ? Preparation.PreparedByID
Referential integrity  Agent.AgentID ? Shipment.ShippedByID
Referential integrity  Agent.AgentID ? Sound.RecordedByID
Referential integrity  Agent.AgentID ? Project.ProjectAgentID

AgentAddress

Associates agents, addresses, and organizaions.

Attributes and indices of the entity 'AgentAddress'
Name Type Description / Default value & validation Rqrd./Index
AgentAddressID Autonumber PrimaryKey.
Default value: GenUniqueID()
- I (U)
TypeOfAgentAddressed Integer 0 for organization, 1 for person.
Default value: 1
- -
AddressID Long Associated record in Address table.
Default value: Null
- I
AgentID Long Associated record in Agent table.
Default value: Null
- I
OrganizationID Long Associates Agent identified by AgentID (type Person) as a member of Agent identified by OrganizationID (type Organization).
Default value: Null
- I
JobTitle Text (50) Agent's (person) job title at specified address and organization. - -
Phone1 Text (50)   - -
Phone2 Text (50)   - -
Fax Text (50)   - -
RoomOrBuilding Text (50)   - -
Email Text (50)   - -
URL Text (50)   - -
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
IsCurrent Integer   - -
Index name:  Attributes & index properties
{32B88AB8-69C6-11D2-A962-00...:  AddressID (Duplicates OK)
{32B88AC4-69C6-11D2-A962-00...:  AgentID (Duplicates OK)
{32B88AC5-69C6-11D2-A962-00...:  OrganizationID (Duplicates OK)
AgentAddressID:  AgentAddressID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  Address.AddressID ? AgentAddress.AddressID
Referential integrity  AgentAddress.AgentAddressID ? AccessionAgents.AgentAddressID
Referential integrity  AgentAddress.AgentAddressID ? BorrowAgents.AgentAddressID
Referential integrity  AgentAddress.AgentAddressID ? DeaccessionAgents.AgentAddressID
Referential integrity  AgentAddress.AgentAddressID ? ExchangeIn.ReceivedFromOrganizationID
Referential integrity  AgentAddress.AgentAddressID ? ExchangeOut.SentToOrganizationID
Referential integrity  AgentAddress.AgentAddressID ? LoanAgents.AgentAddressID
Referential integrity  AgentAddress.AgentAddressID ? Permit.IssuerID
Referential integrity  AgentAddress.AgentAddressID ? Permit.IssueeID
Referential integrity  AgentAddress.AgentAddressID ? Shipment.ShipperID
Referential integrity  AgentAddress.AgentAddressID ? Shipment.ShippedToID
Deletions cascade  Agent.AgentID ? AgentAddress.AgentID
Referential integrity  Agent.AgentID ? AgentAddress.OrganizationID

Authors

Associates agents with referenceworks.

Attributes and indices of the entity 'Authors'
Name Type Description / Default value & validation Rqrd./Index
AuthorsID Autonumber Default value: GenUniqueID() - I (U)
AgentID Long Agent record representing the Author. R I/I (UM)
ReferenceWorkID Long Reference record the Agent authored. R I/I (UM)
Order Integer the order of AgentID relative to other authors of reference. R -
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88AC6-69C6-11D2-A962-00...:  AgentID (Duplicates OK)
{32B88B1B-69C6-11D2-A962-00...:  ReferenceWorkID (Duplicates OK)
CandidateKey:  AgentID; ReferenceWorkID (Unique values)
CitationOrder:  ReferenceWorkID; Order (Unique values)
PrimaryKey:  AuthorsID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  Agent.AgentID ? Authors.AgentID
Deletions cascade  ReferenceWork.ReferenceWorkID ? Authors.ReferenceWorkID

BiologicalObjectAttributes

Measurements and other attributes of BiologicalObjects.

Attributes and indices of the entity 'BiologicalObjectAttributes'
Name Type Description / Default value & validation Rqrd./Index
BiologicalObjectAttributesID Long   R I (U)/I (U)
BiologicalObjectTypeID Long   R I
Sex Text (50) validation message: List*. - -
Age Text (50)   - -
Stage Text (50) validation message: List*. - -
Weight Single Default value: Null - -
Length Single Default value: Null - -
GosnerStage Byte Default value: Null - -
SnoutVentLength Single Default value: Null - -
Activity Text (50)   - -
LengthTail Single Default value: Null - -
ReproductiveCondition Text (50)   - -
Condition Text (50)   - -
LengthTarsus Single Default value: Null - -
LengthWing Single Default value: Null - -
LengthHead Single Default value: Null - -
LengthBody Single Default value: Null - -
LengthMiddleToe Single Default value: Null - -
LengthBill Single Default value: Null - -
TotalExposedCulmen Single Default value: Null - -
MaxLength Single Default value: Null - -
MinLength Single Default value: Null - -
LengthHindFoot Single Default value: Null - -
LengthForeArm Single Default value: Null - -
LengthTragus Single Default value: Null - -
LengthEar Single Default value: Null - -
EarFromNotch Single Default value: Null - -
Wingspan Single Default value: Null - -
LengthGonad Single Default value: Null - -
WidthGonad Single Default value: Null - -
LengthHeadBody Single Default value: Null - -
Width Single Default value: Null - -
HeightFinalWhorl Single Default value: Null - -
InsideHeightAperture Single Default value: Null - -
InsideWidthAperture Single Default value: Null - -
NumberWhorls Integer Default value: Null - I
OuterLipThickness Single Default value: Null - -
Mantle Single Default value: Null - -
Height Single Default value: Null - -
Diameter Single Default value: Null - -
BranchingAt Text (50)   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Text3 Text (50) User definable. - -
Text4 Text (50) User definable. - -
Text5 Text (50) User definable. - -
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
SexID Long Link to Lookup table for Sex. - I
StageID Long Link to Lookup table for Stage. - I
YesNo1 Integer   - -
YesNo2 Integer   - -
YesNo3 Integer   - -
Number1 Single   - -
Number2 Single   - -
Number3 Single   - -
Number4 Single   - -
Number5 Single   - -
Number6 Single   - -
Number7 Single   - -
Text6 Text (100)   - -
Text7 Text (100)   - -
YesNo4 Integer   - -
YesNo5 Integer   - -
YesNo6 Integer   - -
YesNo7 Integer   - -
Index name:  Attributes & index properties
{32B88AEA-69C6-11D2-A962-00...:  BiologicalObjectAttributesID (Unique values)
{32B88AF9-69C6-11D2-A962-00...:  BiologicalObjectTypeID (Duplicates OK)
BiologicalObjectID:  BiologicalObjectAttributesID (Primary key; Unique values)
NumberWhorls:  NumberWhorls (Duplicates OK)
SexID:  SexID (Duplicates OK)
StageID:  StageID (Duplicates OK)
Relation type:  Fields involved
Deletions cascade, one-to-one  CollectionObject.CollectionObjectID ? BiologicalObjectAttributes.BiologicalObjectAttributesID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? BiologicalObjectAttributes.BiologicalObjectTypeID

BiologicalObjectRelation

Information about relationships (Parent-Child, Host-Parasite, etc.) between BiologicalObjects.

Attributes and indices of the entity 'BiologicalObjectRelation'
Name Type Description / Default value & validation Rqrd./Index
BiologicalObjectRelationID Autonumber Default value: GenUniqueID() - I (U)
BiologicalObjectID Long   R I/I (UM)
RelatedBiologicalObjectID Long   R I
BiologicalObjectRelationTypeID Long   R I
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88AD8-69C6-11D2-A962-00...:  BiologicalObjectRelationTypeID (Duplicates OK)
{32B88AEB-69C6-11D2-A962-00...:  BiologicalObjectID (Duplicates OK)
{32B88AEC-69C6-11D2-A962-00...:  RelatedBiologicalObjectID (Duplicates OK)
BiologicalObjectRelationID:  BiologicalObjectRelationID (Primary key; Unique values)
CandidateKey:  BiologicalObjectID; RelatedBiologicalObjectID; BiologicalObjectRelationTypeID (Unique values)
Relation type:  Fields involved
Referential integrity  BiologicalObjectRelationType.BiologicalObjectRelationTypeID ? BiologicalObjectRelation.BiologicalObjectRelationTypeID
Referential integrity  CollectionObject.CollectionObjectID ? BiologicalObjectRelation.BiologicalObjectID
Referential integrity  CollectionObject.CollectionObjectID ? BiologicalObjectRelation.RelatedBiologicalObjectID

BiologicalObjectRelationType

Information about the valid types of relationships between BiologicalObjects. .

Attributes and indices of the entity 'BiologicalObjectRelationType'
Name Type Description / Default value & validation Rqrd./Index
BiologicalObjectRelationTypeID Autonumber Default value: GenUniqueID() - I (U)
RelationshipName Text (50)   - -
LeftSideRoleName Text (50)   - -
RightSideRoleName Text (50)   - -
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
IsReflexive Integer   - -
Index name:  Attributes & index properties
PrimaryKey:  BiologicalObjectRelationTypeID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  BiologicalObjectRelationType.BiologicalObjectRelationTypeID ? BiologicalObjectRelation.BiologicalObjectRelationTypeID

Borrow

Invoice information for borrowed (incoming) material.

Attributes and indices of the entity 'Borrow'
Name Type Description / Default value & validation Rqrd./Index
BorrowID Autonumber Primary key.
Default value: GenUniqueID()
- I/I (U)
CollectionID Long Department receiving the loan. R I (UM)/I
InvoiceNumber Text (50) Lender's loan number. R I
ReceivedDate Long Date material was received. - I
OriginalDueDate Long Original Due date for loan. - -
DateClosed Long Date loan was closed. - -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampModified Date/Time Default value: Now() - I
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - I
Closed Integer   - -
YesNo1 Integer   - -
YesNo2 Integer   - -
CurrentDueDate Long   - I
Index name:  Attributes & index properties
BorrowID:  BorrowID (Duplicates OK)
Candidate:  CollectionID; InvoiceNumber (Unique values)
CollectionID:  CollectionID (Duplicates OK)
CurrentDueDate:  CurrentDueDate (Duplicates OK)
InvoiceNumber:  InvoiceNumber (Duplicates OK)
LastEditedBy:  LastEditedBy (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
PrimaryKey:  BorrowID (Primary key; Unique values)
ReceivedDate:  ReceivedDate (Duplicates OK)
TimestampModified:  TimestampModified (Duplicates OK)
Relation type:  Fields involved
Deletions cascade  Borrow.BorrowID ? BorrowAgents.BorrowID
Deletions cascade  Borrow.BorrowID ? BorrowMaterial.BorrowID
Deletions cascade  Borrow.BorrowID ? BorrowShipments.BorrowID

BorrowAgents

Associates agents with incoming material.

Attributes and indices of the entity 'BorrowAgents'
Name Type Description / Default value & validation Rqrd./Index
BorrowAgentsID Autonumber Default value: GenUniqueID() - I (U)
BorrowID Long ID of borrow in which Agent played role. R I/I (UM)
AgentAddressID Long Address/Organization from which agent participated in the borrow. R I
Role Text (50) Role played by agent in borrow.
validation message: List.
R -
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
RoleID Long Link to Lookup table for Role. - I
Index name:  Attributes & index properties
{32B88ABA-69C6-11D2-A962-00...:  AgentAddressID (Duplicates OK)
{32B88AD9-69C6-11D2-A962-00...:  BorrowID (Duplicates OK)
BorrowAgentID:  BorrowAgentsID (Unique values)
PrimaryKey:  BorrowID; AgentAddressID; Role (Primary key; Unique values)
RoleID:  RoleID (Duplicates OK)
Relation type:  Fields involved
Referential integrity  AgentAddress.AgentAddressID ? BorrowAgents.AgentAddressID
Deletions cascade  Borrow.BorrowID ? BorrowAgents.BorrowID

BorrowMaterial

Information about borrowed material.

Attributes and indices of the entity 'BorrowMaterial'
Name Type Description / Default value & validation Rqrd./Index
BorrowMaterialID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
BorrowID Long ID of the Borrow containing the Prep. R I
MaterialNumber Text (50) e.g. 'FMNH 223456'. R -
Description Text (50) Description of the material. 'e.g. Bufo bufo skull'. - -
Quantity Integer Number of specimens (for lots). - -
OutComments Memo Notes concerning the return of the material. - -
InComments Memo Notes concerning the receipt of the material. - -
QuantityResolved Integer Quantity resolved (Returned, Accessioned, Lost, Discarded, Destroyed ...). - -
QuantityReturned Integer Quantity returned. - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88ADA-69C6-11D2-A962-00...:  BorrowID (Duplicates OK)
BorrowMaterialID:  BorrowMaterialID (Primary key; Unique values)
Relation type:  Fields involved
Deletions cascade  Borrow.BorrowID ? BorrowMaterial.BorrowID
Deletions cascade  BorrowMaterial.BorrowMaterialID ? BorrowReturnMaterial.BorrowMaterialID

BorrowReturnMaterial

Return information for borrowed material.

Attributes and indices of the entity 'BorrowReturnMaterial'
Name Type Description / Default value & validation Rqrd./Index
BorrowReturnMaterialID Autonumber Default value: GenUniqueID() - I (U)
BorrowMaterialID Long Borrowed preparation returned. R I
Date Long Date Returned. - -
Quantity Integer Quantity of preparations returned. - -
ReturnedByID Long person processing the return. - I
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88AC7-69C6-11D2-A962-00...:  ReturnedByID (Duplicates OK)
{32B88ADC-69C6-11D2-A962-00...:  BorrowMaterialID (Duplicates OK)
BorrowReturnMaterialID:  BorrowReturnMaterialID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  Agent.AgentID ? BorrowReturnMaterial.ReturnedByID
Deletions cascade  BorrowMaterial.BorrowMaterialID ? BorrowReturnMaterial.BorrowMaterialID

BorrowShipments

Shipments of borrowed material to lenders.

Attributes and indices of the entity 'BorrowShipments'
Name Type Description / Default value & validation Rqrd./Index
BorrowShipmentsID Autonumber   - I (U)
BorrowID Long The borrow being shipped (returned). R I/I (UM)
ShipmentID Long The shipment. R I
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88ADB-69C6-11D2-A962-00...:  BorrowID (Duplicates OK)
{32B88B21-69C6-11D2-A962-00...:  ShipmentID (Duplicates OK)
BorrowShipmentsID:  BorrowShipmentsID (Unique values)
PrimaryKey:  BorrowID; ShipmentID (Primary key; Unique values)
Relation type:  Fields involved
Deletions cascade  Borrow.BorrowID ? BorrowShipments.BorrowID
Referential integrity  Shipment.ShipmentID ? BorrowShipments.ShipmentID

CatalogSeries

Information about catalog series within collections.

Attributes and indices of the entity 'CatalogSeries'
Name Type Description / Default value & validation Rqrd./Index
CatalogSeriesID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
CollectionID Long   R I
SeriesName Text (50) Textual name for Catalog series. E.g. Main specimen collection. - -
CatalogSeriesPrefix Text (50) Text Displayed with Catalog numbers. E.g. 'KU'. - -
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88AE4-69C6-11D2-A962-00...:  CollectionID (Duplicates OK)
PrimaryKey:  CatalogSeriesID (Primary key; Unique values)
Relation type:  Fields involved
Deletions cascade  CatalogSeries.CatalogSeriesID ? CatalogSeriesDefinition.CatalogSeriesID
Referential integrity  CatalogSeries.CatalogSeriesID ? CollectionObjectCatalog.CatalogSeriesID
Deletions cascade  Collection.CollectionID ? CatalogSeries.CollectionID

CatalogSeriesDefinition

Detailed information on catalog series.

Attributes and indices of the entity 'CatalogSeriesDefinition'
Name Type Description / Default value & validation Rqrd./Index
CatalogSeriesDefinitionID Autonumber Default value: GenUniqueID() - I (U)
CatalogSeriesID Long CatalogSeries that includes ObjectType. R I/I (UM)
ObjectTypeID Long Link to CollectionObjectType. R I
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88ADD-69C6-11D2-A962-00...:  CatalogSeriesID (Duplicates OK)
{32B88AFB-69C6-11D2-A962-00...:  ObjectTypeID (Duplicates OK)
CatalogSeriesDefinitionID:  CatalogSeriesDefinitionID (Primary key; Unique values)
CatalogSeriesType:  CatalogSeriesID; ObjectTypeID (Unique values)
Relation type:  Fields involved
Deletions cascade  CatalogSeries.CatalogSeriesID ? CatalogSeriesDefinition.CatalogSeriesID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? CatalogSeriesDefinition.ObjectTypeID

CollectingEvent

Collecting event information for BiologicalObjects.

Attributes and indices of the entity 'CollectingEvent'
Name Type Description / Default value & validation Rqrd./Index
CollectingEventID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
BiologicalObjectTypeCollectedID Long Type of BiologicalObject collected. R I
LocalityID Long Locality where collection took place. - I
StationFieldNumber Text (50) Station number or field number of the site where collecting event took place, A number or code recorded in field notes and/or written on field tags that identifies ALL material collected in a CollectingEvent. - I
Method Text (50) The method used to obtain the biological object.
validation message: List*.
- -
VerbatimDate Text (50) Date which collector recorded in field book, exactly as reported by the collector. Should indicate whether reported as range, season, month, etc. - -
StartDate Long The date collecting event began. - I
EndDate Long The date collecting event ended. - I
StartTime Integer Start time in military format.
Default value: -1
- -
EndTime Integer End time in military format.
Default value: -1
- -
VerbatimLocality Memo Original statement (literal quotation) of the location of the CollectingEvent as given by the Collector. - -
GroupPermittedToView Long The name of the group that this record is visible to.
validation message: List.
- -
Remarks Memo Free text to record information that does not conform to structured fields, or to explain data recorded in those fields, particularly problematic interpretations of data given by collector(s). - -
TimestampModified Date/Time Default value: Now() - I
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - I
MethodID Long Link to Lookup table for Method. - I
GroupPermittedToViewID Long Link to Lookup table for GroupPermittedToView. - I
Index name:  Attributes & index properties
{32B88AFC-69C6-11D2-A962-00...:  BiologicalObjectTypeCollectedID (Duplicates OK)
{32B88B16-69C6-11D2-A962-00...:  LocalityID (Duplicates OK)
CollectingEventID:  CollectingEventID (Primary key; Unique values)
EndDate:  EndDate (Duplicates OK)
GroupPermittedToViewID:  GroupPermittedToViewID (Duplicates OK)
LastEditedBy:  LastEditedBy (Duplicates OK)
MethodID:  MethodID (Duplicates OK)
StartDate:  StartDate (Duplicates OK)
StationFieldNumber:  StationFieldNumber (Duplicates OK)
TimestampModified:  TimestampModified (Duplicates OK)
Relation type:  Fields involved
Referential integrity  CollectingEvent.CollectingEventID ? CollectionObject.CollectingEventID
Deletions cascade  CollectingEvent.CollectingEventID ? Collectors.CollectingEventID
Deletions cascade, one-to-one  CollectingEvent.CollectingEventID ? Habitat.HabitatID
Deletions cascade, one-to-one  CollectingEvent.CollectingEventID ? Stratigraphy.StratigraphyID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? CollectingEvent.BiologicalObjectTypeCollectedID
Referential integrity  Locality.LocalityID ? CollectingEvent.LocalityID

Collection

Information about collections - address, personnel, etc.

Attributes and indices of the entity 'Collection'
Name Type Description / Default value & validation Rqrd./Index
CollectionID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
CollectionName Text (50) Text name for the collection. - -
CollectionIdentifier Text (50) Abbreviation for the collection; displayed as a prefix with catalog numbers from the collection. - -
OrganizationID Long AgentAddressID for Organization. - I
Description Memo Textual description of collection. - -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88AC8-69C6-11D2-A962-00...:  OrganizationID (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
PrimaryKey:  CollectionID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  Agent.AgentID ? Collection.OrganizationID
Referential integrity  Collection.CollectionID ? Accession.CollectionID
Deletions cascade  Collection.CollectionID ? CatalogSeries.CollectionID
Deletions cascade  Collection.CollectionID ? CollectionTaxonomyTypes.CollectionID
Referential integrity  Collection.CollectionID ? Deaccession.CollectionID
Referential integrity  Collection.CollectionID ? ExchangeIn.CollectionID
Referential integrity  Collection.CollectionID ? ExchangeOut.CollectionID

CollectionObject

Attributes and indices of the entity 'CollectionObject'
Name Type Description / Default value & validation Rqrd./Index
CollectionObjectID Autonumber Default value: GenUniqueID() - I (U)
DerivedFromID Long Preparation, Sound.
Default value: Null
- I
ContainerID Long Preparation, Container.
Default value: Null
- I
CollectionObjectTypeID Long Default value: 0 - I
FieldNumber Text (50) BiologicalObject (Bird, Fish, etc). - I
CollectingEventID Long BiologicalObject (Bird, Fish, etc). - I
Description Text (50) Image, Sound, Preparation, Container(Container Label?). - I
PreparationMethod Text (50) Image, Sound, Preparation. - -
ContainerType Text (50) Container.
validation message: List*.
- -
ContainerTypeID Long Container. - I
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - I
LastEditedBy Text (50)   - I
PreparationMethodID Long   - -
YesNo1 Integer   - -
YesNo2 Integer   - -
Count Long   - -
Remarks Memo   - -
Lat1Text Text (40)   - -
Long1Text Text (40)   - -
Lat2Text Text (40)   - -
Long2Text Text (40)   - -
Index name:  Attributes & index properties
{32B88ADF-69C6-11D2-A962-00...:  CollectingEventID (Duplicates OK)
{32B88AED-69C6-11D2-A962-00...:  DerivedFromID (Duplicates OK)
{32B88AEE-69C6-11D2-A962-00...:  ContainerID (Duplicates OK)
{32B88AFE-69C6-11D2-A962-00...:  CollectionObjectTypeID (Duplicates OK)
CollectionObjectID:  CollectionObjectID (Primary key; Unique values)
ContainerTypeID:  ContainerTypeID (Duplicates OK)
Description:  Description (Duplicates OK)
FieldNumber:  FieldNumber (Duplicates OK)
LastEditedBy:  LastEditedBy (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
TimestampModified:  TimestampModified (Duplicates OK)
Relation type:  Fields involved
Referential integrity  CollectingEvent.CollectingEventID ? CollectionObject.CollectingEventID
Deletions cascade, one-to-one  CollectionObject.CollectionObjectID ? BiologicalObjectAttributes.BiologicalObjectAttributesID
Referential integrity  CollectionObject.CollectionObjectID ? BiologicalObjectRelation.BiologicalObjectID
Referential integrity  CollectionObject.CollectionObjectID ? BiologicalObjectRelation.RelatedBiologicalObjectID
Deletions cascade  CollectionObject.CollectionObjectID ? CollectionObject.DerivedFromID
Referential integrity  CollectionObject.CollectionObjectID ? CollectionObject.ContainerID
Deletions cascade, one-to-one  CollectionObject.CollectionObjectID ? CollectionObjectCatalog.CollectionObjectCatalogID
Deletions cascade  CollectionObject.CollectionObjectID ? CollectionObjectCitation.BiologicalObjectID
Deletions cascade  CollectionObject.CollectionObjectID ? Determination.BiologicalObjectID
Deletions cascade  CollectionObject.CollectionObjectID ? Determination.PreparationID
Deletions cascade, one-to-one  CollectionObject.CollectionObjectID ? Image.ImageID
Referential integrity  CollectionObject.CollectionObjectID ? ImageCollectionObjects.CollectionlObjectID
Deletions cascade, one-to-one  CollectionObject.CollectionObjectID ? Observation.BiologicalObjectID
Deletions cascade, one-to-one  CollectionObject.CollectionObjectID ? Preparation.PreparationID
Deletions cascade, one-to-one  CollectionObject.CollectionObjectID ? Sound.SoundID
Deletions cascade  CollectionObject.CollectionObjectID ? SoundEventStorage.SoundRecordingID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? CollectionObject.CollectionObjectTypeID
Deletions cascade  CollectionObject.CollectionObjectID ? USYSCatalogNumber.CollectionObjectID

CollectionObjectCatalog

Attributes and indices of the entity 'CollectionObjectCatalog'
Name Type Description / Default value & validation Rqrd./Index
CollectionObjectCatalogID Autonumber   - I (U)/I (U)
CollectionObjectTypeID Long   R I
CatalogSeriesID Long The catalog series that contains the object.
Default value: Null
- I/I (UM)/I (UM)
SubNumber Long Default value: Null - -
Name Text (50)   - -
Modifier Text (50)   - -
AccessionID Long The accession for the collection object.
Default value: Null
- I
CatalogerID Long Person who cataloged the object.
Default value: Null
- I
CatalogedDate Long Date the object was cataloged.
Default value: Null
- -
Location Text (50) Information about the physical location of the object. - -
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Deaccessioned Integer   - -
CatalogNumber Double   - I
Index name:  Attributes & index properties
{32B88AB7-69C6-11D2-A962-00...:  AccessionID (Duplicates OK)
{32B88ACF-69C6-11D2-A962-00...:  CatalogerID (Duplicates OK)
{32B88ADE-69C6-11D2-A962-00...:  CatalogSeriesID (Duplicates OK)
{32B88AEF-69C6-11D2-A962-00...:  CollectionObjectCatalogID (Unique values)
{32B88B01-69C6-11D2-A962-00...:  CollectionObjectTypeID (Duplicates OK)
CatalogNumber:  CatalogNumber (Duplicates OK)
CatalogNumber1:  CatalogSeriesID; CatalogNumber; SubNumber (Unique values)
CatalogNumber2:  CatalogSeriesID; CatalogNumber; Name; Modifier (Unique values)
CollectionObjectID:  CollectionObjectCatalogID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  Accession.AccessionID ? CollectionObjectCatalog.AccessionID
Referential integrity  Agent.AgentID ? CollectionObjectCatalog.CatalogerID
Referential integrity  CatalogSeries.CatalogSeriesID ? CollectionObjectCatalog.CatalogSeriesID
Deletions cascade, one-to-one  CollectionObject.CollectionObjectID ? CollectionObjectCatalog.CollectionObjectCatalogID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? CollectionObjectCatalog.CollectionObjectTypeID
Referential integrity  CollectionObjectCatalog.CollectionObjectCatalogID ? DeaccessionCollectionObject.CollectionObjectID
Referential integrity  CollectionObjectCatalog.CollectionObjectCatalogID ? LoanPhysicalObject.PhysicalObjectID
Deletions cascade  CollectionObjectCatalog.CollectionObjectCatalogID ? OtherIdentifier.CollectionObjectID
Referential integrity  CollectionObjectCatalog.CollectionObjectCatalogID ? ProjectCollectionObjects.CollectionObjectID

CollectionObjectCitation

Associates publications with BiologicalObjects.

Attributes and indices of the entity 'CollectionObjectCitation'
Name Type Description / Default value & validation Rqrd./Index
CollectionObjectCitationID Autonumber Default value: GenUniqueID() - I (U)
ReferenceWorkID Long The associated reference. R I
BiologicalObjectID Long Biological Object cited. R I/I (UM)
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88AF0-69C6-11D2-A962-00...:  BiologicalObjectID (Duplicates OK)
{32B88B1C-69C6-11D2-A962-00...:  ReferenceWorkID (Duplicates OK)
CandidateKey:  BiologicalObjectID; ReferenceWorkID (Unique values)
CollectionObjectCitationID:  CollectionObjectCitationID (Primary key; Unique values)
Relation type:  Fields involved
Deletions cascade  CollectionObject.CollectionObjectID ? CollectionObjectCitation.BiologicalObjectID
Referential integrity  ReferenceWork.ReferenceWorkID ? CollectionObjectCitation.ReferenceWorkID

CollectionObjectType

Attributes and indices of the entity 'CollectionObjectType'
Name Type Description / Default value & validation Rqrd./Index
CollectionObjectTypeID Long Default value: 0 - I (U)
CollectionObjectTypeName Text (50)   - -
Category Text (50)   - -
Index name:  Attributes & index properties
CollectionObjectTypeID:  CollectionObjectTypeID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? BiologicalObjectAttributes.BiologicalObjectTypeID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? CollectionTaxonomyTypes.BiologicalObjectTypeID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? CatalogSeriesDefinition.ObjectTypeID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? CollectingEvent.BiologicalObjectTypeCollectedID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? CollectionObject.CollectionObjectTypeID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? Determination.BiologicalObjectTypeID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? Habitat.BiologicalObjectTypeCollectedID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? CollectionObjectCatalog.CollectionObjectTypeID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? Preparation.PhysicalObjectTypeID

CollectionTaxonomyTypes

Attributes and indices of the entity 'CollectionTaxonomyTypes'
Name Type Description / Default value & validation Rqrd./Index
CollectionTaxonomyTypesID Autonumber Primary Key.
Default value: GenUniqueID()
- I (U)
CollectionID Long Link to the Collection for which the mapping holds. R I
BiologicalObjectTypeID Long Link to CollectionObjectTypeID code for BiologicalObject. R I/I (UM)
TaxonomyTypeID Long Link to TaxonomyTypeID associated with the BiologicalObjectType specified above. R I
TimestampModified Date/Time Date/Time the record was last modified.
Default value: Now()
- -
TimestampCreated Date/Time Date/Time the record was created.
Default value: Now()
- -
LastEditedBy Text (50) Login name of user who last modified the record. - -
Index name:  Attributes & index properties
{32B88AE6-69C6-11D2-A962-00...:  CollectionID (Duplicates OK)
{32B88AFA-69C6-11D2-A962-00...:  BiologicalObjectTypeID (Duplicates OK)
{32B88B2D-69C6-11D2-A962-00...:  TaxonomyTypeID (Duplicates OK)
BiologicalObjectTaxonomyTyp...:  CollectionTaxonomyTypesID (Primary key; Unique values)
CandidateKey:  BiologicalObjectTypeID; TaxonomyTypeID (Unique values)
Relation type:  Fields involved
Deletions cascade  Collection.CollectionID ? CollectionTaxonomyTypes.CollectionID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? CollectionTaxonomyTypes.BiologicalObjectTypeID
Referential integrity  TaxonomyType.TaxonomyTypeID ? CollectionTaxonomyTypes.TaxonomyTypeID

Collectors

Associates agents with collecting events.

Attributes and indices of the entity 'Collectors'
Name Type Description / Default value & validation Rqrd./Index
CollectorsID Autonumber Default value: GenUniqueID() - I (U)
CollectingEventID Long The CollectingEvent the agent participated in. R I/I (UM)/I (UM)
AgentID Long Link to Collector's record in Agent table. R I
Order Long The order of AgentID relative to Cother collectors for CollectingEventID. R -
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88AC9-69C6-11D2-A962-00...:  AgentID (Duplicates OK)
{32B88AE0-69C6-11D2-A962-00...:  CollectingEventID (Duplicates OK)
CollectorsID:  CollectorsID (Unique values)
CollEventIDOrder:  CollectingEventID; Order (Unique values)
PrimaryKey:  CollectingEventID; AgentID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  Agent.AgentID ? Collectors.AgentID
Deletions cascade  CollectingEvent.CollectingEventID ? Collectors.CollectingEventID

DATAVIEWS

Attributes and indices of the entity 'DATAVIEWS'
Name Type Description / Default value & validation Rqrd./Index
ClassName Text (40)   - -
ClassDescription Text (40)   - -
Description Text (40)   - -
Template Memo   - -
Name Text (50)   - I (U)
Index name:  Attributes & index properties
PrimaryKey:  Name (Primary key; Unique values)

Deaccession

Information about deaccessioned material.

Attributes and indices of the entity 'Deaccession'
Name Type Description / Default value & validation Rqrd./Index
DeaccessionID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
CollectionID Long Collection material is deaccessioned from. R I
Type Text (50) Description of the Type of deaccession; i.e. Gift, disposal, lost.
validation message: List.
- -
DeaccessionNumber Text (50) Name institution assigns to the deacession. - I
Date Long Date of deaccession. - -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampModified Date/Time Default value: Now() - I
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - I
TypeID Long Link to Lookup table for Type. - I
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88AE7-69C6-11D2-A962-00...:  CollectionID (Duplicates OK)
DeaccessionNumber:  DeaccessionNumber (Duplicates OK)
LastEditedBy:  LastEditedBy (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
PrimaryKey:  DeaccessionID (Primary key; Unique values)
TimestampModified:  TimestampModified (Duplicates OK)
TypeID:  TypeID (Duplicates OK)
Relation type:  Fields involved
Referential integrity  Collection.CollectionID ? Deaccession.CollectionID
Deletions cascade  Deaccession.DeaccessionID ? DeaccessionAgents.DeaccessionID
Deletions cascade  Deaccession.DeaccessionID ? DeaccessionCollectionObject.DeaccessionID

DeaccessionAgents

Associates agents with deaccessions.

Attributes and indices of the entity 'DeaccessionAgents'
Name Type Description / Default value & validation Rqrd./Index
DeaccessionAgentsID Autonumber Default value: GenUniqueID() - I (U)
DeaccessionID Long Deaccession agent played role in. R I/I (UM)
AgentAddressID Long AgentAddressID for agent. R I
Role Text (50) Role agent played in deaccession.
validation message: List.
R -
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
RoleID Long Link to Lookup table for Role. - I
Index name:  Attributes & index properties
{32B88ABB-69C6-11D2-A962-00...:  AgentAddressID (Duplicates OK)
{32B88B04-69C6-11D2-A962-00...:  DeaccessionID (Duplicates OK)
DeaccessionAgentsID:  DeaccessionAgentsID (Unique values)
PrimaryKey:  DeaccessionID; AgentAddressID; Role (Primary key; Unique values)
RoleID:  RoleID (Duplicates OK)
Relation type:  Fields involved
Referential integrity  AgentAddress.AgentAddressID ? DeaccessionAgents.AgentAddressID
Deletions cascade  Deaccession.DeaccessionID ? DeaccessionAgents.DeaccessionID

DeaccessionCollectionObject

Information about deaccessioned physical objects.

Attributes and indices of the entity 'DeaccessionCollectionObject'
Name Type Description / Default value & validation Rqrd./Index
DeaccessionCollectionObjectID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
DeaccessionID Long The deaccession. R I
CollectionObjectID Long The object being deaccessioned. R I
Quantity Integer Number of specimens deaccessioned (necessary for lots). - -
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88B05-69C6-11D2-A962-00...:  DeaccessionID (Duplicates OK)
{32B88B0B-69C6-11D2-A962-00...:  CollectionObjectID (Duplicates OK)
DeaccessionPhysicalObjectID:  DeaccessionCollectionObjectID (Primary key; Unique values)
Relation type:  Fields involved
Deletions cascade  Deaccession.DeaccessionID ? DeaccessionCollectionObject.DeaccessionID
Referential integrity  DeaccessionCollectionObject.DeaccessionCollectionObjectID ? LoanReturnPhysicalObject.DeaccessionPhysicalObjectID
Referential integrity  CollectionObjectCatalog.CollectionObjectCatalogID ? DeaccessionCollectionObject.CollectionObjectID

Determination

Taxonomic identifications of BiologicalObjects.

Attributes and indices of the entity 'Determination'
Name Type Description / Default value & validation Rqrd./Index
DeterminationID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
Current Boolean Yes if the determination is considered the 'best' (maybe even one of the better). - I
DeterminerID Long id of the Person making the determination.
Default value: Null
- I
TypeStatusName Text (50) e.g. 'Holotype', 'Paratype'...
validation message: List*.
- -
TaxonNameID Long The id of the taxon name. - I
BiologicalObjectID Long BiologicalObject determined.
Default value: Null
- I
PreparationID Long Preparations can also be assigned determinations. Must a Preparation of BiologicalObjectID.
Default value: Null
- I
BiologicalObjectTypeID Long   R I
Date Long Date the determination was made. - -
Confidence Text (50) Confidence of determination.
validation message: List*.
- -
Method Text (50) Method of determination.
validation message: List*.
- -
FeatureOrBasis Text (50) Body part, or characteristic used as the basis of a determination. - -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time Date/Time the record was created.
Default value: Now()
- -
TimestampModified Date/Time Date/Time the record was modified.
Default value: Now()
- -
LastEditedBy Text (50)   - -
TypeStatusNameID Long Link to Lookup table for TypeStatusName. - I
ConfidenceID Long Link to Lookup table for Confidence. - I
MethodID Long Link to Lookup table for Method. - I
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88ACA-69C6-11D2-A962-00...:  DeterminerID (Duplicates OK)
{32B88AF1-69C6-11D2-A962-00...:  BiologicalObjectID (Duplicates OK)
{32B88AF2-69C6-11D2-A962-00...:  PreparationID (Duplicates OK)
{32B88AFF-69C6-11D2-A962-00...:  BiologicalObjectTypeID (Duplicates OK)
{32B88B25-69C6-11D2-A962-00...:  TaxonNameID (Duplicates OK)
ConfidenceID:  ConfidenceID (Duplicates OK)
Current:  Current (Duplicates OK)
DeterminationID:  DeterminationID (Primary key; Unique values)
MethodID:  MethodID (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
TypeStatusNameID:  TypeStatusNameID (Duplicates OK)
Relation type:  Fields involved
Referential integrity  Agent.AgentID ? Determination.DeterminerID
Deletions cascade  CollectionObject.CollectionObjectID ? Determination.BiologicalObjectID
Deletions cascade  CollectionObject.CollectionObjectID ? Determination.PreparationID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? Determination.BiologicalObjectTypeID
Deletions cascade  Determination.DeterminationID ? DeterminationCitation.DeterminationID
Referential integrity  TaxonName.TaxonNameID ? Determination.TaxonNameID

DeterminationCitation

Associates publications with Determinations.

Attributes and indices of the entity 'DeterminationCitation'
Name Type Description / Default value & validation Rqrd./Index
DeterminationCitationID Autonumber Default value: GenUniqueID() - I (U)
ReferenceWorkID Long ID of the publication citing the determination. R I/I (UM)
DeterminationID Long Determination being cited. R I
Remarks Memo   - -
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88B07-69C6-11D2-A962-00...:  DeterminationID (Duplicates OK)
{32B88B1D-69C6-11D2-A962-00...:  ReferenceWorkID (Duplicates OK)
DeterminationCitationID:  DeterminationCitationID (Unique values)
PrimaryKey:  ReferenceWorkID; DeterminationID (Primary key; Unique values)
Relation type:  Fields involved
Deletions cascade  Determination.DeterminationID ? DeterminationCitation.DeterminationID
Referential integrity  ReferenceWork.ReferenceWorkID ? DeterminationCitation.ReferenceWorkID

ExchangeIn

Information on incoming exchanges of botanical material.

Attributes and indices of the entity 'ExchangeIn'
Name Type Description / Default value & validation Rqrd./Index
ExchangeInID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
ExchangeDate Long Date exchange was received. - I
QuantityExchanged Integer Number of items received. - -
CollectionID Long ID of Collection making the exchange. R I
ReceivedFromOrganizationID Long AgentAddress ID of organization that sent material. R I
CatalogedByID Long Agent ID of person recording the exchange. R I
DescriptionOfMaterial Text (120)   - -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time   - -
TimestampModified Date/Time   - I
LastEditedBy Text (50)   - I
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88ABC-69C6-11D2-A962-00...:  ReceivedFromOrganizationID (Duplicates OK)
{32B88ACB-69C6-11D2-A962-00...:  CatalogedByID (Duplicates OK)
{32B88AE8-69C6-11D2-A962-00...:  CollectionID (Duplicates OK)
ExchangeDate:  ExchangeDate (Duplicates OK)
ExchangeInID:  ExchangeInID (Primary key; Unique values)
LastEditedBy:  LastEditedBy (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
TimestampModified:  TimestampModified (Duplicates OK)
Relation type:  Fields involved
Referential integrity  AgentAddress.AgentAddressID ? ExchangeIn.ReceivedFromOrganizationID
Referential integrity  Agent.AgentID ? ExchangeIn.CatalogedByID
Referential integrity  Collection.CollectionID ? ExchangeIn.CollectionID

ExchangeOut

Information on outgoing exchanges of botanical material.

Attributes and indices of the entity 'ExchangeOut'
Name Type Description / Default value & validation Rqrd./Index
ExchangeOutID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
ExchangeDate Long Date exchange was sent. - I
QuantityExchanged Integer Number of items sent. R -
CollectionID Long ID of Collection making the exchange. R I
SentToOrganizationID Long AgentAddress ID of organization material was sent to. R I
CatalogedByID Long Agent ID of person who recorded the exchange. R I
ShipmentID Long Shipment information for the exchange. R I
DescriptionOfMaterial Text (120)   - -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time   - -
TimestampModified Date/Time   - -
LastEditedBy Text (50)   - -
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88ABD-69C6-11D2-A962-00...:  SentToOrganizationID (Duplicates OK)
{32B88ACC-69C6-11D2-A962-00...:  CatalogedByID (Duplicates OK)
{32B88AE9-69C6-11D2-A962-00...:  CollectionID (Duplicates OK)
{32B88B22-69C6-11D2-A962-00...:  ShipmentID (Duplicates OK)
ExchangedDate:  ExchangeDate (Duplicates OK)
ExchangeID:  ExchangeOutID (Primary key; Unique values)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
Relation type:  Fields involved
Referential integrity  AgentAddress.AgentAddressID ? ExchangeOut.SentToOrganizationID
Referential integrity  Agent.AgentID ? ExchangeOut.CatalogedByID
Referential integrity  Collection.CollectionID ? ExchangeOut.CollectionID
Referential integrity  Shipment.ShipmentID ? ExchangeOut.ShipmentID

Geography

Authority file for geographic information.

Attributes and indices of the entity 'Geography'
Name Type Description / Default value & validation Rqrd./Index
GeographyID Autonumber Primary Key.
Default value: GenUniqueID()
- I (U)
CurrentID Long Link to current equivalent if IsCurrent is 'No'. - I
ContinentOrOcean Text (100)   - I (N)
Country Text (50)   - I (N)
State Text (50)   - I (N)
County Text (50)   - I (N)
IslandGroup Text (50)   - I (N)
Island Text (50)   - I (N)
WaterBody Text (50)   - I (N)
Drainage Text (50)   - I (N)
FullGeographicName Text (255)   - -
Remarks Memo   - -
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - I
TimestampVersion Date/Time Default value: Null - -
LastEditedBy Text (50)   - I
IsCurrent Integer   - -
Index name:  Attributes & index properties
{32B88B08-69C6-11D2-A962-00...:  CurrentID (Duplicates OK)
ContinentOcean:  ContinentOrOcean (Duplicates OK; Ignore Nulls)
Country:  Country (Duplicates OK; Ignore Nulls)
County:  County (Duplicates OK; Ignore Nulls)
Drainage:  Drainage (Duplicates OK; Ignore Nulls)
GeographyID:  GeographyID (Primary key; Unique values)
Island:  Island (Duplicates OK; Ignore Nulls)
IslandGroup:  IslandGroup (Duplicates OK; Ignore Nulls)
LastEditedBy:  LastEditedBy (Duplicates OK)
State:  State (Duplicates OK; Ignore Nulls)
TimestampModified:  TimestampModified (Duplicates OK)
WaterBody:  WaterBody (Duplicates OK; Ignore Nulls)
Relation type:  Fields involved
Deletions cascade  Geography.GeographyID ? Geography.CurrentID
Referential integrity  Geography.GeographyID ? Locality.GeographyID

GeologicTimeBoundary

Boundaries for geologic time periods.

Attributes and indices of the entity 'GeologicTimeBoundary'
Name Type Description / Default value & validation Rqrd./Index
GeologicTimeBoundaryID Autonumber Default value: GenUniqueID() - I (U)
Age Single   - I
AgeUncertainty Single   - -
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
TimestampVersion Date/Time   - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
Age:  Age (Duplicates OK)
PrimaryKey:  GeologicTimeBoundaryID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  GeologicTimeBoundary.GeologicTimeBoundaryID ? GeologicTimePeriod.UpperBoundaryID
Referential integrity  GeologicTimeBoundary.GeologicTimeBoundaryID ? GeologicTimePeriod.LowerBoundaryID

GeologicTimePeriod

Geologic time periods.

Attributes and indices of the entity 'GeologicTimePeriod'
Name Type Description / Default value & validation Rqrd./Index
GeologicTimePeriodID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
RankCode Long Numeric representation of Items rank in stratigraphic hierarchy. - I
RankName Text (50) Type of period; i.e. Era, Epoch, etc. - I
Name Text (50)   - -
UpperBoundaryID Long Link to UpperBoundary time. - I
LowerBoundaryID Long Link to LowerBoundary time. - I
Standard Text (50) The system of stratigraphy the record is included in. - -
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
TimestampVersion Date/Time   - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88AB3-69C6-11D2-A962-00...:  UpperBoundaryID (Duplicates OK)
{32B88AB4-69C6-11D2-A962-00...:  LowerBoundaryID (Duplicates OK)
PrimaryKey:  GeologicTimePeriodID (Primary key; Unique values)
RankCode:  RankName (Duplicates OK)
RankCode1:  RankCode (Duplicates OK)
Relation type:  Fields involved
Referential integrity  GeologicTimeBoundary.GeologicTimeBoundaryID ? GeologicTimePeriod.UpperBoundaryID
Referential integrity  GeologicTimeBoundary.GeologicTimeBoundaryID ? GeologicTimePeriod.LowerBoundaryID
Referential integrity  GeologicTimePeriod.GeologicTimePeriodID ? Stratigraphy.GeologicTimePeriodID

GroupPersons

Associates agents into groups.

Attributes and indices of the entity 'GroupPersons'
Name Type Description / Default value & validation Rqrd./Index
GroupPersonsID Autonumber Default value: GenUniqueID() - I (U)
GroupID Long AgentID of group. R I/I (UM)/I (UM)
MemberID Long AgentID of member (member must be of type Person). R I
Order Integer Members position in group; i.e. 1st, 2nd, 3rd ... R -
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88ACD-69C6-11D2-A962-00...:  GroupID (Duplicates OK)
{32B88ACE-69C6-11D2-A962-00...:  MemberID (Duplicates OK)
GroupOrder:  GroupID; Order (Unique values)
GroupPersonsID:  GroupPersonsID (Unique values)
PrimaryKey:  GroupID; MemberID (Primary key; Unique values)
Relation type:  Fields involved
Deletions cascade  Agent.AgentID ? GroupPersons.GroupID
Referential integrity  Agent.AgentID ? GroupPersons.MemberID

Habitat

Ecological data associated with collecting events.

Attributes and indices of the entity 'Habitat'
Name Type Description / Default value & validation Rqrd./Index
HabitatID Long CollectingEventID of related CollectingEvent record. R I (U)/I (U)
BiologicalObjectTypeCollectedID Long   R I
AirTempC Single Default value: Null - -
WaterTempC Single Default value: Null - -
WaterpH Single Default value: Null - -
Turbidity Text (50)   - -
Clarity Text (50)   - -
Salinity Text (50)   - -
SoilType Text (50)   - -
SoilPh Single Default value: Null - -
SoilTempC Single Default value: Null - -
SoilMoisture Text (50)   - -
Slope Text (50)   - -
Vegetation Text (50)   - -
HabitatType Text (50) validation message: List*. - -
Current Text (50)   - -
Substrate Text (50)   - -
SubstrateMoisture Text (50)   - -
HeightAboveGround Single Default value: Null - -
NearestNeighbor Text (50)   - -
Remarks Memo   - -
MinDepth Single Default value: Null - -
MaxDepth Single Default value: Null - -
HostTaxonID Long Link to TaxonName (Added primarily for insect collecting events). - I
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
HabitatTypeID Long Link to Lookup table for HabitatType. - I
YesNo1 Integer   - -
YesNo2 Integer   - -
Number3 Single   - -
Number4 Single   - -
Number5 Single   - -
Text3 Text (100)   - -
Text4 Text (100)   - -
Text5 Text (100)   - -
YesNo3 Integer   - -
YesNo4 Integer   - -
YesNo5 Integer   - -
Index name:  Attributes & index properties
{32B88AE1-69C6-11D2-A962-00...:  HabitatID (Unique values)
{32B88B00-69C6-11D2-A962-00...:  BiologicalObjectTypeCollectedID (Duplicates OK)
{32B88B27-69C6-11D2-A962-00...:  HostTaxonID (Duplicates OK)
CollectingEventID:  HabitatID (Primary key; Unique values)
HabitatTypeID:  HabitatTypeID (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
Relation type:  Fields involved
Deletions cascade, one-to-one  CollectingEvent.CollectingEventID ? Habitat.HabitatID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? Habitat.BiologicalObjectTypeCollectedID
Referential integrity  TaxonName.TaxonNameID ? Habitat.HostTaxonID

Image

Attributes and indices of the entity 'Image'
Name Type Description / Default value & validation Rqrd./Index
ImageID Long Default value: Null R I (U)/I (U)
MadeByID Long   - I
MadeDate Long   - -
CopyrightOwnerID Long Default value: Null - I
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88AD0-69C6-11D2-A962-00...:  MadeByID (Duplicates OK)
{32B88AD1-69C6-11D2-A962-00...:  CopyrightOwnerID (Duplicates OK)
{32B88AF3-69C6-11D2-A962-00...:  ImageID (Unique values)
CollectionObjectID:  ImageID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  Agent.AgentID ? Image.MadeByID
Referential integrity  Agent.AgentID ? Image.CopyrightOwnerID
Deletions cascade, one-to-one  CollectionObject.CollectionObjectID ? Image.ImageID
Deletions cascade  Image.ImageID ? ImageAgents.ImageID
Deletions cascade  Image.ImageID ? ImageCollectionObjects.ImageID
Deletions cascade  Image.ImageID ? ImageLocalities.ImageID

ImageAgents

Associates agents (as subject matter) with images.

Attributes and indices of the entity 'ImageAgents'
Name Type Description / Default value & validation Rqrd./Index
ImageAgentsID Autonumber Default value: GenUniqueID() - I (U)
ImageID Long ID of image depicting Agent. R I/I (UM)
AgentID Long Agent depicted by image. R I
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88AD2-69C6-11D2-A962-00...:  AgentID (Duplicates OK)
{32B88B0F-69C6-11D2-A962-00...:  ImageID (Duplicates OK)
ImageAgentsID:  ImageAgentsID (Unique values)
PrimaryKey:  ImageID; AgentID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  Agent.AgentID ? ImageAgents.AgentID
Deletions cascade  Image.ImageID ? ImageAgents.ImageID

ImageCollectionObjects

Associates BiologicalObjects (as subject matter) with images.

Attributes and indices of the entity 'ImageCollectionObjects'
Name Type Description / Default value & validation Rqrd./Index
ImageCollectionObjectsID Autonumber Default value: GenUniqueID() - I (U)
ImageID Long ID of image depicting CollectionlObject. R I/I (UM)
CollectionlObjectID Long CollectionlObject depicted in image. R I
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88AF4-69C6-11D2-A962-00...:  CollectionlObjectID (Duplicates OK)
{32B88B10-69C6-11D2-A962-00...:  ImageID (Duplicates OK)
ImageBiologicalObjectsID:  ImageCollectionObjectsID (Unique values)
PrimaryKey:  ImageID; CollectionlObjectID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  CollectionObject.CollectionObjectID ? ImageCollectionObjects.CollectionlObjectID
Deletions cascade  Image.ImageID ? ImageCollectionObjects.ImageID

ImageLocalities

Associates localities (as subject matter) with images.

Attributes and indices of the entity 'ImageLocalities'
Name Type Description / Default value & validation Rqrd./Index
ImageLocalitiesID Autonumber Default value: GenUniqueID() - I (U)
ImageID Long ID of image depicting locality. R I/I (UM)
LocalityID Long ID of locality depicted in image. R I
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88B11-69C6-11D2-A962-00...:  ImageID (Duplicates OK)
{32B88B17-69C6-11D2-A962-00...:  LocalityID (Duplicates OK)
ImageLocalitiesID:  ImageLocalitiesID (Unique values)
PrimaryKey:  ImageID; LocalityID (Primary key; Unique values)
Relation type:  Fields involved
Deletions cascade  Image.ImageID ? ImageLocalities.ImageID
Referential integrity  Locality.LocalityID ? ImageLocalities.LocalityID

Journal

Information about journals involved in citations.

Attributes and indices of the entity 'Journal'
Name Type Description / Default value & validation Rqrd./Index
JournalID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
JournalName Text (255) Full name of the journal. - -
JournalAbbreviation Text (50)   - I
Remarks Memo   - -
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - I
LastEditedBy Text (50)   - I
Index name:  Attributes & index properties
JournalAbbreviation:  JournalAbbreviation (Duplicates OK)
LastEditedBy:  LastEditedBy (Duplicates OK)
PrimaryKey:  JournalID (Primary key; Unique values)
TimestampModified:  TimestampModified (Duplicates OK)
Relation type:  Fields involved
Referential integrity  Journal.JournalID ? ReferenceWork.JournalID

Loan

Information about outgoing loans.

Attributes and indices of the entity 'Loan'
Name Type Description / Default value & validation Rqrd./Index
LoanID Autonumber PrimaryKey.
Default value: GenUniqueID()
- I (U)
ShipmentID Long Link to Shipment table. - I
CollectionID Long ID of The department making the loan. R I (UM)
LoanNumber Text (50) Invoice number. R -
LoanDate Long Date the Loan was created. - I
CurrentDueDate Long Date the loan is due for return (Same as original Due date unless loan period has been extended). - I
OriginalDueDate Long Date the loan was originally due. - -
DateClosed Long Date loan was closed. - -
Category Byte Type of record: loan(0), Gift(1).
Default value: 0
- -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time The date the record was created.
Default value: Now()
- -
TimestampModified Date/Time The date the record was modified.
Default value: Now()
- I
LastEditedBy Text (50) Login name of the user who last edited the record. - I
Closed Integer   - -
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88B23-69C6-11D2-A962-00...:  ShipmentID (Duplicates OK)
CurrentDueDate:  CurrentDueDate (Duplicates OK)
LastEditedBy:  LastEditedBy (Duplicates OK)
LoanDate:  LoanDate (Duplicates OK)
LoanNumber:  CollectionID; LoanNumber (Unique values)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
PrimaryKey:  LoanID (Primary key; Unique values)
TimestampModified:  TimestampModified (Duplicates OK)
Relation type:  Fields involved
Deletions cascade  Loan.LoanID ? LoanAgents.LoanID
Deletions cascade  Loan.LoanID ? LoanPhysicalObject.LoanID
Referential integrity  Shipment.ShipmentID ? Loan.ShipmentID

LoanAgents

Associations between agents and loans.

Attributes and indices of the entity 'LoanAgents'
Name Type Description / Default value & validation Rqrd./Index
LoanAgentsID Autonumber Default value: GenUniqueID() - I (U)
LoanID Long ID of loan agent at AgentAddressID played a role in. R I/I (UM)
AgentAddressID Long Address of agent. R I
Role Text (50) Role the agent played in the loan.
validation message: List.
R -
Remarks Memo   - -
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
RoleID Long Link to Lookup table for Role. - I
Index name:  Attributes & index properties
{32B88ABE-69C6-11D2-A962-00...:  AgentAddressID (Duplicates OK)
{32B88B13-69C6-11D2-A962-00...:  LoanID (Duplicates OK)
LoanAgentsID:  LoanAgentsID (Unique values)
PrimaryKey:  LoanID; AgentAddressID; Role (Primary key; Unique values)
RoleID:  RoleID (Duplicates OK)
Relation type:  Fields involved
Referential integrity  AgentAddress.AgentAddressID ? LoanAgents.AgentAddressID
Deletions cascade  Loan.LoanID ? LoanAgents.LoanID

LoanPhysicalObject

Information on loaned preparations.

Attributes and indices of the entity 'LoanPhysicalObject'
Name Type Description / Default value & validation Rqrd./Index
LoanPhysicalObjectID Autonumber PrimaryKey.
Default value: GenUniqueID()
- I (U)
PhysicalObjectID Long PhysicalObject being loaned. - I
LoanID Long Loan containing the PhysicalObject. R I
Quantity Integer The total number of specimens loaned (necessary for lots).
Default value: 1
- -
DescriptionOfMaterial Text (255) Description of loaned material (intended to be used for non-cataloged items, i.e. when PreparationID is null). - -
OutComments Memo Comments on item when loaned. - -
InComments Memo Comments on item when returned. - -
QuantityResolved Integer Number of specimens returned, deaccessioned or otherwise accounted for. (necessary for Lots). - -
QuantityReturned Integer Number of specimens returned. (necessary for Lots). - -
TimestampCreated Date/Time Date the record was created.
Default value: Now()
- -
TimestampModified Date/Time Date the record was modified.
Default value: Now()
- -
LastEditedBy Text (50) Login name of the user last editing the record. - -
Index name:  Attributes & index properties
{32B88B0C-69C6-11D2-A962-00...:  PhysicalObjectID (Duplicates OK)
{32B88B14-69C6-11D2-A962-00...:  LoanID (Duplicates OK)
PrimaryKey:  LoanPhysicalObjectID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  CollectionObjectCatalog.CollectionObjectCatalogID ? LoanPhysicalObject.PhysicalObjectID
Deletions cascade  Loan.LoanID ? LoanPhysicalObject.LoanID
Deletions cascade  LoanPhysicalObject.LoanPhysicalObjectID ? LoanReturnPhysicalObject.LoanPhysicalObjectID

LoanReturnPhysicalObject

Return information for loaned preparations.

Attributes and indices of the entity 'LoanReturnPhysicalObject'
Name Type Description / Default value & validation Rqrd./Index
LoanReturnPhysicalObjectID Autonumber PrimaryKey.
Default value: GenUniqueID()
- I (U)
LoanPhysicalObjectID Long Link to LoanPhysicalObject table. - I
Date Long Date of return. - I
Quantity Integer Quantity of items returned (necessary for lots). - -
ReceivedByID Long Person processing the loan return. - I
DeaccessionPhysicalObjectID Long ID of associated (if present) DeaccessionPhysicalObject record. - I
Remarks Memo   - -
TimestampCreated Date/Time Date the record was created.
Default value: Now()
- -
TimestampModified Date/Time Date the record was modified.
Default value: Now()
- -
LastEditedBy Text (50) user ID of the person last editing the record. - -
Index name:  Attributes & index properties
{32B88AD3-69C6-11D2-A962-00...:  ReceivedByID (Duplicates OK)
{32B88B06-69C6-11D2-A962-00...:  DeaccessionPhysicalObjectID (Duplicates OK)
{32B88B15-69C6-11D2-A962-00...:  LoanPhysicalObjectID (Duplicates OK)
Date:  Date (Duplicates OK)
PrimaryKey:  LoanReturnPhysicalObjectID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  Agent.AgentID ? LoanReturnPhysicalObject.ReceivedByID
Referential integrity  DeaccessionCollectionObject.DeaccessionCollectionObjectID ? LoanReturnPhysicalObject.DeaccessionPhysicalObjectID
Deletions cascade  LoanPhysicalObject.LoanPhysicalObjectID ? LoanReturnPhysicalObject.LoanPhysicalObjectID

Locality

Locality where CollectingEvent took place.

Attributes and indices of the entity 'Locality'
Name Type Description / Default value & validation Rqrd./Index
LocalityID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
GeographyID Long Link to Country, State, County, WaterBody, Island, IslandGroup ... info. - I
NamedPlace Text (255) The named place the locality is closest to.
validation message: Ouch.
- I
RelationToNamedPlace Text (120) Relation of the locality to the named place. - -
LocalityName Text (120) The full name of the locality.
validation message: Ouch.
R I
BaseMeridian Text (50) BaseMeridian for the Range/Township/Section data. - -
Range Text (50) The Range of a legal description. - -
RangeDirection Text (50)   - -
Township Text (50) The Township of a legal description. - -
TownshipDirection Text (50)   - -
Section Text (50) The Section of a legal description. - -
SectionPart Text (50)   - -
VerbatimElevation Text (50) The verbatim elevation including units as given in the field notes. - -
OriginalElevationUnit Text (50) i.e. Meters, Feet, ... - -
MinElevation Single The minimum elevation in Meters.
Default value: Null
- I (N)
MaxElevation Single The maximum elevation in Meters.
Default value: Null
- I (N)
ElevationMethod Text (50) The method used to determine the elevation.
validation message: List.
- -
ElevationAccuracy Single plus or minus--in meters. - -
OriginalLatLongUnit Text (50) i.e. Decimal, Deg/Min/Sec, ... - -
LatLongType Text (50) The type of area described by the lat long data (Point,Line,Rectangle).
validation message: List.
- -
Latitude1 Single Latitude of first point.
Default value: Null
- I (N)
Longitude1 Single Longitude of first point.
Default value: Null
- I (N)
Latitude2 Single Latitude of second point.
Default value: Null
- I (N)
Longitude2 Single Longitude of second point.
Default value: Null
- I (N)
LatLongMethod Text (50) the method used to determine the LatitudeLongitude.
validation message: List.
- -
LatLongAccuracy Single radius--in decimal degrees. - -
Datum Text (50) GPSDatum. - -
GroupPermittedToView Long The name of the group that this record is visible to. (Default to public).
validation message: List.
- -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time Date the record was created.
Default value: Now()
- -
TimestampModified Date/Time Date the record was modified.
Default value: Now()
- I
LastEditedBy Text (50) Name of the person last editing the record. - I
ElevationMethodID Long Link to Lookup table for ElevationMethod. - I
LatLongTypeID Long Link to Lookup table for LatLongType. - I
LatLongMethodID Long Link to Lookup table for LatLongMethod. - I
GroupPermittedToViewID Long Link to Lookup table for GroupPermittedToView. - I
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88B09-69C6-11D2-A962-00...:  GeographyID (Duplicates OK)
ElevationMethodID:  ElevationMethodID (Duplicates OK)
GroupPermittedToViewID:  GroupPermittedToViewID (Duplicates OK)
LastEditedBy:  LastEditedBy (Duplicates OK)
Lat1:  Latitude1 (Duplicates OK; Ignore Nulls)
Lat2:  Latitude2 (Duplicates OK; Ignore Nulls)
LatLongMethodID:  LatLongMethodID (Duplicates OK)
LatLongTypeID:  LatLongTypeID (Duplicates OK)
LocalityName:  LocalityName (Duplicates OK)
Long1:  Longitude1 (Duplicates OK; Ignore Nulls)
Long2:  Longitude2 (Duplicates OK; Ignore Nulls)
MaxElevation:  MaxElevation (Duplicates OK; Ignore Nulls)
MinElevation:  MinElevation (Duplicates OK; Ignore Nulls)
NamedPlaceID:  NamedPlace (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
PrimaryKey:  LocalityID (Primary key; Unique values)
TimestampModified:  TimestampModified (Duplicates OK)
Relation type:  Fields involved
Referential integrity  Geography.GeographyID ? Locality.GeographyID
Referential integrity  Locality.LocalityID ? CollectingEvent.LocalityID
Referential integrity  Locality.LocalityID ? ImageLocalities.LocalityID
Deletions cascade  Locality.LocalityID ? LocalityCitation.LocalityID

LocalityCitation

Associates publications with localities.

Attributes and indices of the entity 'LocalityCitation'
Name Type Description / Default value & validation Rqrd./Index
LocalityCitationID Autonumber Default value: GenUniqueID() - I (U)
ReferenceWorkID Long ID of work citing locality. R I
LocalityID Long ID of locality cited. R I/I (UM)
Remarks Memo   - -
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88B18-69C6-11D2-A962-00...:  LocalityID (Duplicates OK)
{32B88B1E-69C6-11D2-A962-00...:  ReferenceWorkID (Duplicates OK)
LocalityCitationID:  LocalityCitationID (Unique values)
PrimaryKey:  LocalityID; ReferenceWorkID (Primary key; Unique values)
Relation type:  Fields involved
Deletions cascade  Locality.LocalityID ? LocalityCitation.LocalityID
Referential integrity  ReferenceWork.ReferenceWorkID ? LocalityCitation.ReferenceWorkID

Observation

Observational data about a BiologicalObject.

Attributes and indices of the entity 'Observation'
Name Type Description / Default value & validation Rqrd./Index
ObservationID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
BiologicalObjectID Long The id of the biological object. R I (U)
ObservationMethod Text (24) How the observation was made.
validation message: List*.
- -
Count Integer Number of objects. - -
Description Memo Description of the observed animal. - -
Activity Memo What it was doing. - -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
ObservationMethodID Long Link to Lookup table for ObservationMethod. - I
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88AF5-69C6-11D2-A962-00...:  BiologicalObjectID (Unique values)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
ObservationMethodID:  ObservationMethodID (Duplicates OK)
PrimaryKey:  ObservationID (Primary key; Unique values)
Relation type:  Fields involved
Deletions cascade, one-to-one  CollectionObject.CollectionObjectID ? Observation.BiologicalObjectID

OtherIdentifier

Associates current identifiers with previous or additional catalog numbers or other identifiers.

Attributes and indices of the entity 'OtherIdentifier'
Name Type Description / Default value & validation Rqrd./Index
OtherIdentifierID Autonumber Default value: GenUniqueID() - I (U)
CollectionObjectID Long ID of object identified by Identifier. R I/I (UM)
Identifier Text (50)   R I
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88B0D-69C6-11D2-A962-00...:  CollectionObjectID (Duplicates OK)
Identifier:  Identifier (Duplicates OK)
OtherIdentifierID:  OtherIdentifierID (Unique values)
PrimaryKey:  CollectionObjectID; Identifier (Primary key; Unique values)
Relation type:  Fields involved
Deletions cascade  CollectionObjectCatalog.CollectionObjectCatalogID ? OtherIdentifier.CollectionObjectID

Permit

Information about permits from organizations or individuals.

Attributes and indices of the entity 'Permit'
Name Type Description / Default value & validation Rqrd./Index
PermitID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
IssuerID Long AgentAddressID of Issuer. - I
IssueeID Long AgentAddressID of Issuee. - I
PermitNumber Text (50) Identifier for the permit. R I
Type Text (50) Permit category - 'CITES', 'Migratory Bird Treaty Act', ...
validation message: List.
- -
IssuedDate Long Date permit was issued. - I
StartDate Long Date permit becomes effective. - I
EndDate Long Date permit expires. - I
RenewalDate Long Date of renewal. - -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - I
LastEditedBy Text (50)   - I
TypeID Long Link to Lookup table for Type. - I
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88ABF-69C6-11D2-A962-00...:  IssuerID (Duplicates OK)
{32B88AC0-69C6-11D2-A962-00...:  IssueeID (Duplicates OK)
EndDate:  EndDate (Duplicates OK)
IssuedDate:  IssuedDate (Duplicates OK)
LastEditedBy:  LastEditedBy (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
PermitNumber:  PermitNumber (Duplicates OK)
PrimaryKey:  PermitID (Primary key; Unique values)
StartDate:  StartDate (Duplicates OK)
TimestampModified:  TimestampModified (Duplicates OK)
TypeID:  TypeID (Duplicates OK)
Relation type:  Fields involved
Referential integrity  AgentAddress.AgentAddressID ? Permit.IssuerID
Referential integrity  AgentAddress.AgentAddressID ? Permit.IssueeID
Referential integrity  Permit.PermitID ? AccessionAuthorizations.PermitID

Preparation

Attributes and indices of the entity 'Preparation'
Name Type Description / Default value & validation Rqrd./Index
PreparationID Long   R I (U)/I (U)
PhysicalObjectTypeID Long Default value: 0 R I
PreparedByID Long   - I
PreparedDate Long   - -
Medium Text (50) The medium in which the preparation is stored or embedded.
validation message: List.
- -
MediumID Long   - I
PartInformation Text (50) HistoSlideSeries, SpecimenPreparation... - -
StartBoxNumber Text (50) HistoSlideSeries. - -
EndBoxNumber Text (50) HistoSlideSeries. - -
StartSlideNumber Text (50) HistoSlideSeries. - -
EndSlideNumber Text (50) HistoSlideSeries. - -
SectionOrientation Text (50) HistoSlideSeries. - -
SectionWidth Text (50) HistoSlideSeries. - -
Size Text (50) ImagePrint, ? - -
URL Text (50) ImagePrint.URL, SoundRecording.URL, Spectrogram.URL. - -
Identifier Text (50) KaryoSlide.SlideNumber, TissueOrExtract.ContainerNumber. - I
NestLining Text (50) NestEgg. - -
NestMaterial Text (50) NestEgg. - -
NestLocation Text (50) NestEgg. - -
SetMark Text (50) NestEgg. - -
CollectedEggCount Long NestEgg. - -
CollectedParasiteEggCount Long NestEgg. - -
FieldEggCount Long NestEgg. - -
FieldParasiteEggCount Long NestEgg. - -
EggIncubationStage Text (50) NestEgg. - -
EggDescription Text (50) NestEgg. - -
ParasiteTaxonNameID Long NestEgg. - I
Format Text (50) SoundRecording.Format. - -
StorageInfo Text (50) Spectrogram. - -
PreparationType Text (50) TissueOrExtract.
validation message: List*.
- -
PreparationTypeID Long TissueOrExtract. - I
ContainerType Text (50) TissueOrExtract.
validation message: List*.
- -
ContainerTypeID Text (50)   - I
DNAConcentration Text (50) TissueOrExtract. - -
Volume Text (50) TissueOrExtract. - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
Remarks Memo   - -
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
NestCollected Integer   - -
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88AD4-69C6-11D2-A962-00...:  PreparedByID (Duplicates OK)
{32B88AF6-69C6-11D2-A962-00...:  PreparationID (Unique values)
{32B88B02-69C6-11D2-A962-00...:  PhysicalObjectTypeID (Duplicates OK)
{32B88B28-69C6-11D2-A962-00...:  ParasiteTaxonNameID (Duplicates OK)
ContainerTypeID:  ContainerTypeID (Duplicates OK)
Identifier:  Identifier (Duplicates OK)
MediumID:  MediumID (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
PhysicalObjectID:  PreparationID (Primary key; Unique values)
TissueTypeID:  PreparationTypeID (Duplicates OK)
Relation type:  Fields involved
Referential integrity  Agent.AgentID ? Preparation.PreparedByID
Deletions cascade, one-to-one  CollectionObject.CollectionObjectID ? Preparation.PreparationID
Referential integrity  CollectionObjectType.CollectionObjectTypeID ? Preparation.PhysicalObjectTypeID
Referential integrity  TaxonName.TaxonNameID ? Preparation.ParasiteTaxonNameID

Project

Information about projects that use or produce material in a collection.

Attributes and indices of the entity 'Project'
Name Type Description / Default value & validation Rqrd./Index
ProjectID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
ProjectName Text (50) Name of the project. R -
ProjectDescription Memo Description of project. - -
URL Text (50) URL for project. - -
StartDate Long Date project began. - -
EndDate Long Date project ended. - -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - I
LastEditedBy Text (50)   - I
YesNo1 Integer   - -
YesNo2 Integer   - -
ProjectAgentID Long   - I
Index name:  Attributes & index properties
AgentIDProjectAgentID:  ProjectAgentID (Duplicates OK)
LastEditedBy:  LastEditedBy (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
PrimaryKey:  ProjectID (Primary key; Unique values)
TimestampModified:  TimestampModified (Duplicates OK)
Relation type:  Fields involved
Deletions cascade  Project.ProjectID ? ProjectCollectionObjects.ProjectID
Referential integrity  Agent.AgentID ? Project.ProjectAgentID

ProjectCollectionObjects

Associates Identifiers with projects.

Attributes and indices of the entity 'ProjectCollectionObjects'
Name Type Description / Default value & validation Rqrd./Index
ProjectCollectionObjectsID Autonumber Default value: GenUniqueID() - I (U)
ProjectID Long   R I/I (UM)
CollectionObjectID Long   R I
Remarks Memo   - -
TimestampModified Date/Time Default value: Now() - -
TimestampCreated Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88B0E-69C6-11D2-A962-00...:  CollectionObjectID (Duplicates OK)
{32B88B1A-69C6-11D2-A962-00...:  ProjectID (Duplicates OK)
PrimaryKey:  ProjectID; CollectionObjectID (Primary key; Unique values)
ProjectIdentifiersID:  ProjectCollectionObjectsID (Unique values)
Relation type:  Fields involved
Referential integrity  CollectionObjectCatalog.CollectionObjectCatalogID ? ProjectCollectionObjects.CollectionObjectID
Deletions cascade  Project.ProjectID ? ProjectCollectionObjects.ProjectID

ReferenceWork

Information about reference works.

Attributes and indices of the entity 'ReferenceWork'
Name Type Description / Default value & validation Rqrd./Index
ReferenceWorkID Autonumber PrimaryKey.
Default value: GenUniqueID()
- I (U)
JournalID Long Link to Journal containing the reference (if applicable). - I
ContainingReferenceWorkID Long Link to Reference containing (if Section). - I
ReferenceWorkType Byte Type of Reference (Book(0), Electronic Media(1), Paper(2), Technical Report(3), Thesis(4), Section in book(5)). R -
Title Text (255) Title of reference. - -
Publisher Text (50)   - -
PlaceOfPublication Text (50)   - -
Date Text (25)   - -
Volume Text (25) Volume/Issue for Journal articles. - -
Pages Text (50) Number of pages or Page range for Journal articles. - -
URL Text (128)   - -
LibraryNumber Text (50)   - -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time Default value: Now() R -
TimestampModified Date/Time Default value: Now() R I
LastEditedBy Text (50) Default value: 'Unknown' R I
Published Integer   - -
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88B12-69C6-11D2-A962-00...:  JournalID (Duplicates OK)
{32B88B1F-69C6-11D2-A962-00...:  ContainingReferenceWorkID (Duplicates OK)
LastEditedBy:  LastEditedBy (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
PrimaryKey:  ReferenceWorkID (Primary key; Unique values)
TimestampModified:  TimestampModified (Duplicates OK)
Relation type:  Fields involved
Referential integrity  Journal.JournalID ? ReferenceWork.JournalID
Deletions cascade  ReferenceWork.ReferenceWorkID ? Authors.ReferenceWorkID
Referential integrity  ReferenceWork.ReferenceWorkID ? CollectionObjectCitation.ReferenceWorkID
Referential integrity  ReferenceWork.ReferenceWorkID ? DeterminationCitation.ReferenceWorkID
Referential integrity  ReferenceWork.ReferenceWorkID ? LocalityCitation.ReferenceWorkID
Deletions cascade  ReferenceWork.ReferenceWorkID ? ReferenceWork.ContainingReferenceWorkID
Referential integrity  ReferenceWork.ReferenceWorkID ? TaxonCitation.ReferenceWorkID

REPORTS

Attributes and indices of the entity 'REPORTS'
Name Type Description / Default value & validation Rqrd./Index
Number Long   - I
Name Text (40)   - I (U)
DataViewName Text (40)   - -
Description Text (40)   - -
Template Memo   - -
LastEditedBy Text (50)   - -
GroupPermittedToView Long   - -
Index name:  Attributes & index properties
Number:  Number (Duplicates OK)
REPORTS#PX:  Name (Primary key; Unique values)

Shipment

Information on outgoing shipments.

Attributes and indices of the entity 'Shipment'
Name Type Description / Default value & validation Rqrd./Index
ShipmentID Autonumber Primary key.
Default value: GenUniqueID()
- I (U)
ShipmentDate Long Date of shipment. - -
ShipperID Long AgentAddressID of agent transporting the material. - I
ShipmentNumber Text (50) Shipper's tracking number. R I
ShippedToID Long AgentAddressID of agent material is shipped to. - I
ShippedByID Long AgentID of person approving/initiating the shipment. - I
ShipmentMethod Text (50) Description of shipment. E.g. 'Hand-carried', 'Overnight', 'Air', 'Land', 'Sea', ...
validation message: List.
- -
NumberOfPackages Integer Number of packages shipped. - I
Weight Text (50) The weight of the shipment. - -
InsuredForAmount Text (50)   - -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - I
LastEditedBy Text (50)   - I
ShipmentMethodID Long Link to Lookup table for ShipmentMethod. - I
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88AC1-69C6-11D2-A962-00...:  ShipperID (Duplicates OK)
{32B88AC2-69C6-11D2-A962-00...:  ShippedToID (Duplicates OK)
{32B88AD6-69C6-11D2-A962-00...:  ShippedByID (Duplicates OK)
LastEditedBy:  LastEditedBy (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
NumberOfPackages:  NumberOfPackages (Duplicates OK)
PrimaryKey:  ShipmentID (Primary key; Unique values)
ShipmentMethodID:  ShipmentMethodID (Duplicates OK)
ShipmentNumber:  ShipmentNumber (Duplicates OK)
TimestampModified:  TimestampModified (Duplicates OK)
Relation type:  Fields involved
Referential integrity  AgentAddress.AgentAddressID ? Shipment.ShipperID
Referential integrity  AgentAddress.AgentAddressID ? Shipment.ShippedToID
Referential integrity  Agent.AgentID ? Shipment.ShippedByID
Referential integrity  Shipment.ShipmentID ? BorrowShipments.ShipmentID
Referential integrity  Shipment.ShipmentID ? ExchangeOut.ShipmentID
Referential integrity  Shipment.ShipmentID ? Loan.ShipmentID

Sound

Attributes and indices of the entity 'Sound'
Name Type Description / Default value & validation Rqrd./Index
SoundID Long Default value: 0 R I (U)/I (U)
RecordedByID Long Default value: Null - I
RecordedDate Long   - -
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
Index name:  Attributes & index properties
{32B88AD7-69C6-11D2-A962-00...:  RecordedByID (Duplicates OK)
{32B88AF7-69C6-11D2-A962-00...:  SoundID (Unique values)
CollectionObjectID:  SoundID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  Agent.AgentID ? Sound.RecordedByID
Deletions cascade, one-to-one  CollectionObject.CollectionObjectID ? Sound.SoundID
Referential integrity  Sound.SoundID ? SoundEventStorage.SoundEventID

SoundEventStorage

Information about a SoundEvent's position (tape side, cue number, etc.) on recordings of the event.

Attributes and indices of the entity 'SoundEventStorage'
Name Type Description / Default value & validation Rqrd./Index
SoundEventStorageID Autonumber Default value: GenUniqueID() - I (U)
SoundEventID Long   - I
SoundRecordingID Long   - I/I (UM)
SoundRecordingPosition Text (100) i.e. Tape side, tape counter start, tape counter end ... - -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88AF8-69C6-11D2-A962-00...:  SoundRecordingID (Duplicates OK)
{32B88B24-69C6-11D2-A962-00...:  SoundEventID (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
PrimaryKey:  SoundRecordingID; SoundEventID (Primary key; Unique values)
SoundEventStorageID:  SoundEventStorageID (Unique values)
Relation type:  Fields involved
Deletions cascade  CollectionObject.CollectionObjectID ? SoundEventStorage.SoundRecordingID
Referential integrity  Sound.SoundID ? SoundEventStorage.SoundEventID

Stratigraphy

Paleontological data about a site.

Attributes and indices of the entity 'Stratigraphy'
Name Type Description / Default value & validation Rqrd./Index
StratigraphyID Long CollectingEventID of related collecting event. - I (U)/I (U)
GeologicTimePeriodID Long Link to GeologicTimePeriod table. - I
SuperGroup Text (50) Lithostratigraphic supergroup. - -
Group Text (50) Lithostratigraphic group. - -
Formation Text (50) Lithostratigraphic formation. - -
Member Text (50) Lithostratigraphic member. - -
Bed Text (50) Lithostratigraphic bed. - -
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88AE2-69C6-11D2-A962-00...:  StratigraphyID (Unique values)
{32B88B0A-69C6-11D2-A962-00...:  GeologicTimePeriodID (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
PrimaryKey:  StratigraphyID (Primary key; Unique values)
Relation type:  Fields involved
Deletions cascade, one-to-one  CollectingEvent.CollectingEventID ? Stratigraphy.StratigraphyID
Referential integrity  GeologicTimePeriod.GeologicTimePeriodID ? Stratigraphy.GeologicTimePeriodID

TaxonCitation

Associates publications with taxon names.

Attributes and indices of the entity 'TaxonCitation'
Name Type Description / Default value & validation Rqrd./Index
TaxonCitationID Autonumber Default value: GenUniqueID() - I (U)
ReferenceWorkID Long The ID of reference work that cites the taxon name. - I/I (UM)
TaxonNameID Long The ID of the taxon name. - I/I
Remarks Memo   - -
Text1 Text (50) User definable. - -
Text2 Text (50) User definable. - -
Number1 Single User definable. - I
Number2 Single User definable. - I
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - -
LastEditedBy Text (50)   - -
YesNo1 Integer   - -
YesNo2 Integer   - -
Index name:  Attributes & index properties
{32B88B20-69C6-11D2-A962-00...:  ReferenceWorkID (Duplicates OK)
Number1:  Number1 (Duplicates OK)
Number2:  Number2 (Duplicates OK)
PrimaryKey:  ReferenceWorkID; TaxonNameID (Primary key; Unique values)
TaxonCitationID:  TaxonCitationID (Unique values)
TaxonNameID:  TaxonNameID (Duplicates OK)
TaxonNameTaxonCitation:  TaxonNameID (Duplicates OK)
Relation type:  Fields involved
Referential integrity  ReferenceWork.ReferenceWorkID ? TaxonCitation.ReferenceWorkID
Deletions cascade  TaxonName.TaxonNameID ? TaxonCitation.TaxonNameID

TaxonName

Taxonomic authority records.

Attributes and indices of the entity 'TaxonName'
Name Type Description / Default value & validation Rqrd./Index
TaxonNameID Autonumber Primary Key.
Default value: GenUniqueID()
- I (U)
ParentTaxonNameID Long Link to the TaxonName record for the taxon's parent taxon. - I
TaxonomyTypeID Long Link to info about the type (Bird, Fish, Mammal, ...) of the taxon. R I
AcceptedID Long If not Accepted then a link to the TaxonName record for the accepted taxon, else null. - I
TaxonomicUnitTypeID Long Link to info about the rank (Family, Genus Species...) of the taxon. - I
TaxonomicSerialNumber Long If the record has been imported from an Authority File then this field stores a unique ID assigned by the provider, else it is null. - I
TaxonName Text (50) The monomial name for the taxon (e.g. 'pipiens'). - -
UnitInd1 Text (50)   - -
UnitName1 Text (50)   - -
UnitInd2 Text (50)   - -
UnitName2 Text (50)   - -
UnitInd3 Text (50)   - -
UnitName3 Text (50)   - -
UnitInd4 Text (50)   - -
UnitName4 Text (50)   - -
FullTaxonName Text (255) The full name of the taxon (e.g. 'Rana pipiens'). - I
CommonName Text (100)   - -
Author Text (100)   - -
Source Text (50) If the record has been imported then this field holds information about the authority file it was obtained from, else it is user-editable. - -
GroupPermittedToView Long Minimum security level required to view the record.
validation message: List.
- -
EnvironmentalProtectionStatus Text (50)   - -
Remarks Memo   - -
NodeNumber Long   - I
HighestChildNodeNumber Long   - I
TimestampCreated Date/Time Default value: Now() - -
TimestampModified Date/Time Default value: Now() - I
LastEditedBy Text (50)   - I
GroupPermittedToViewID Long Link to Lookup table for GroupPermittedToView. - I
Accepted Integer   - -
RankID Long   - I
GroupNumber Text (20)   - I
Index name:  Attributes & index properties
{32B88B29-69C6-11D2-A962-00...:  AcceptedID (Duplicates OK)
{32B88B2A-69C6-11D2-A962-00...:  ParentTaxonNameID (Duplicates OK)
{32B88B2C-69C6-11D2-A962-00...:  TaxonomicUnitTypeID (Duplicates OK)
{32B88B2E-69C6-11D2-A962-00...:  TaxonomyTypeID (Duplicates OK)
FullTaxonName:  FullTaxonName (Duplicates OK)
GroupNumber:  GroupNumber (Duplicates OK)
GroupPermittedToViewID:  GroupPermittedToViewID (Duplicates OK)
HighestChildNodeNumber:  HighestChildNodeNumber (Duplicates OK)
LastEditedBy:  LastEditedBy (Duplicates OK)
NodeNumber:  NodeNumber (Duplicates OK)
PrimaryKey:  TaxonNameID (Primary key; Unique values)
RankNumber:  RankID (Duplicates OK)
TaxonomicSerialNumber:  TaxonomicSerialNumber (Duplicates OK)
TimestampModified:  TimestampModified (Duplicates OK)
Relation type:  Fields involved
Referential integrity  TaxonName.TaxonNameID ? Determination.TaxonNameID
Referential integrity  TaxonName.TaxonNameID ? Habitat.HostTaxonID
Referential integrity  TaxonName.TaxonNameID ? Preparation.ParasiteTaxonNameID
Referential integrity  TaxonName.TaxonNameID ? TaxonName.AcceptedID
Deletions cascade  TaxonName.TaxonNameID ? TaxonName.ParentTaxonNameID
Referential integrity  TaxonomicUnitType.TaxonomicUnitTypeID ? TaxonName.TaxonomicUnitTypeID
Referential integrity  TaxonomyType.TaxonomyTypeID ? TaxonName.TaxonomyTypeID
Deletions cascade  TaxonName.TaxonNameID ? TaxonCitation.TaxonNameID

TaxonomicUnitType

Attributes and indices of the entity 'TaxonomicUnitType'
Name Type Description / Default value & validation Rqrd./Index
TaxonomicUnitTypeID Autonumber Default value: GenUniqueID() - I (U)/I (U)
Kingdom Byte   - -
RankID Integer   - I
RankName Text (15)   - -
DirectParentRankID Integer   - I
RequiredParentRankID Integer   - I
TaxonomyTypeID Long   - I
Index name:  Attributes & index properties
{32B88B2F-69C6-11D2-A962-00...:  TaxonomyTypeID (Duplicates OK)
direct_parent_rank_id:  DirectParentRankID (Duplicates OK)
PrimaryKey:  TaxonomicUnitTypeID (Primary key; Unique values)
RankID:  RankID (Duplicates OK)
required_parent_rank_id:  RequiredParentRankID (Duplicates OK)
TaxonomicUnitID:  TaxonomicUnitTypeID (Unique values)
Relation type:  Fields involved
Referential integrity  TaxonomicUnitType.TaxonomicUnitTypeID ? TaxonName.TaxonomicUnitTypeID
Referential integrity  TaxonomyType.TaxonomyTypeID ? TaxonomicUnitType.TaxonomyTypeID

TaxonomyType

List of valid taxonomies.

Attributes and indices of the entity 'TaxonomyType'
Name Type Description / Default value & validation Rqrd./Index
TaxonomyTypeID Long Default value: 0 - I (U)
KingdomID Long   - I
TaxonomyTypeName Text (50)   - I (U)
TreeInfoUpToDate Boolean 'Yes' unless the Structural info about the taxonomy (as stored in TaxonName.NodeNumber and .HighestChildNodeNumber) is out of date. - -
Index name:  Attributes & index properties
KingdomID:  KingdomID (Duplicates OK)
TaxonomyTypeID:  TaxonomyTypeID (Primary key; Unique values)
TaxonomyTypeName:  TaxonomyTypeName (Unique values)
Relation type:  Fields involved
Referential integrity  TaxonomyType.TaxonomyTypeID ? CollectionTaxonomyTypes.TaxonomyTypeID
Referential integrity  TaxonomyType.TaxonomyTypeID ? TaxonName.TaxonomyTypeID
Referential integrity  TaxonomyType.TaxonomyTypeID ? TaxonomicUnitType.TaxonomyTypeID

Footnotes: The following abbreviations have been used in the tables: R: It is required to enter data in this field. I: The field is indexed to enable faster searching. Different types of indices are denoted by additional letters in parentheses: U = unique index, N = Null values are ignored in the index, M = the index contains more than one attribute. In the first column the names of attributes that are part of the primary key are underlined.

Data types: 'Text (255)' indicates a text of varying length for which no specific design restrictions have been formulated. 255 characters should be read as a proposed technical maximum limit, that can be changed if required by the database management system. In contrast, 'Memo' is explicitly defined as text of unlimited length.

Created by admin
Last modified 2004-02-11 09:09 AM

---
United States
---
Brazil
---
Germany
---
France
---
Portugal
---
Canada
---
Scotland
---
Mexico
---
European Union
---
Turkey
---
Swaziland
---
Italy
---
United Kingdom
---
Togo
---
Zaire
---
Czech Republic
---
New Zealand
---
Antarctica
---
 
 

Powered by Plone

This site conforms to the following standards: