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

Personal tools

Navigation

Specify Forums

Specify Data Dictionary

Document Actions

Index to Specify Data Tables