Updated: 10-30-2017
Contents
Table of Contents
Table Descriptions
Table Indexes

Table of Contents

Table Definitions

Accession
Field Type Length Descriptions
AccessionID Integer   Primary Key
Accession Condition String 255 Physical description of the condition of the accession.
Accession Number String 60 Usually an integer or alphanumeric value that is assigned to material when it enters the collection. The format of accession numbers varies among collections, but all refer to the acquisition of specimens, observations, or other collection objects.
Date Accessioned Calendar   Date of Accession.
Date Acknowledged Calendar    
Date Received Calendar   Date material was received.
Integer1 Integer    
Integer2 Integer    
Integer3 Integer    
Number1 Float   A user-visible identifier of the Accession. Typically an integer, but may include alphanumeric characters as prefix, suffix, and separators.
Number2 Float   User definable.
Remarks Memo 4096 Additional Comments.
Status String 32 Status of Accession, e.g. `In process`, `Complete` ...
Text1 Memo 65535 User definable.
Text2 Memo 65535 User definable.
Text3 Memo 65535 User definable.
Timestamp Created Timestamp   The date and time the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Total Value BigDecimal   The total monetary value of the accession.
Type String 32 Source of Accession, e.g. `Collecting`, `Gift`, `Bequest` ...
Verbatim Date String 50 Accommodates historical accessions.
Version Integer    
Yes No1 Boolean   User definable.
Yes No2 Boolean   User definable.
Relationships
Type Name To Table
OneToMany accessionAgents Accession Agent
OneToMany accessionAttachments Accession Attachment
OneToMany accessionAuthorizations Accession Authorization
ManyToOne addressOfRecord Address Of Record
OneToMany appraisals Appraisal
OneToMany collectionObjects Collection Object
ManyToOne createdByAgent Agent
OneToMany deaccessions Deaccession
ManyToOne division Division
ManyToOne modifiedByAgent Agent
ManyToOne repositoryAgreement Repository Agreement
OneToMany treatmentEvents Treatment Event


Accession Agent
Field Type Length Descriptions
AccessionAgentID Integer   Primary Key
Remarks Memo 4096 Additional Comments.
Role String 50 Role the agent played in the accession process.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne accession Accession
ManyToOne agent Agent
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne repositoryAgreement Repository Agreement


Accession Attachment
Field Type Length Descriptions
AccessionAttachmentID Integer   Primary Key
Ordinal Integer   Provides a sequencial order for the attachments.
Remarks Memo 4096 Additional comments.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne accession Accession
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Accession Authorization
Field Type Length Descriptions
AccessionAuthorizationID Integer   Primary Key
Remarks Memo 4096 Additional comments.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne accession Accession
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne permit Permit
ManyToOne repositoryAgreement Repository Agreement


Address
Field Type Length Descriptions
AddressID Integer   Primary Key
Address String 255 Address as it should appear on mailing labels.
Address2 String 255 Second line of address (optional).
Address3 String 64  
Address4 String 64  
Address5 String 64  
City String 64 The city.
Country String 64 The country.
End Date Calendar   The last date the agent was at the address.
Fax String 50 The fax number.
Is Current Boolean   Indicates if this is the current address.
Is Primary Boolean   Indicates whether this is the primary address.
Is Shipping Boolean   Indicates if this is the shipping address.
Ordinal Integer   Allows multiple addresses to be ordered.
Phone1 String 50 The primary phone number.
Phone2 String 50 The secondary phone number.
Position Held String 32 The position held by the agent while at this address.
Postal Code String 32 Postal code (Zip Code).
Remarks Memo 4096 Additional comments.
Room/Building String 50 The room or building of the agent.
Start Date Calendar   The first date the the agent was at this address.
State String 64 The state within the country.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Type Of Addr String 32  
Version Integer    
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToOne createdByAgent Agent
OneToMany divisions Division
OneToMany insitutions Institution
ManyToOne modifiedByAgent Agent


Address Of Record
Field Type Length Descriptions
AddressOfRecordID Integer   Primary Key
Address String 255 Primary address of record.
Address2 String 255 Secondary address of record.
City String 64 City of record.
Country String 64 Country of record.
Postal Code String 32 Postal code of record (zip code).
Remarks Memo 4096 Additional comments.
State String 64 State of record.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
OneToMany accessions Accession
ManyToOne agent Agent
ManyToOne createdByAgent Agent
OneToMany exchangeIns Exchange In
OneToMany exchangeOuts Exchange Out
OneToMany loans Loan
ManyToOne modifiedByAgent Agent
OneToMany repositoryAgreements Repository Agreement


Agent
Field Type Length Descriptions
AgentID Integer   Primary Key
Abbreviation String 50 Abbreviation of organization.
Agent Type Byte   Discriminator between Organization(0), Person(1), Other(2), and Group(3).
Date Of Birth Calendar   Date agent was born.
Date Of Birth Precision Byte    
Date Of Death Calendar    
Date Of Death Precision Byte    
Date Type Byte    
Email String 50 Email address for agent.
First Name String 50 First name of agent.
GUID String 128 Global Unique Identifier.
Initials String 8 Initials of agent.
Interests String 255 Interests of Person or Organization.
Job Title String 50 Agent`s (person) job title at specified address and organization.
Last Name String 120 Last name of Person.
Middle Initial String 50 Middle initial of Person.
Remarks Memo 4096 Additional comments.
Suffix String 50  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Title String 50 Title of Person.
Url String 1024 An URL for the web site of a Person or Group.
Version Integer    
Relationships
Type Name To Table
OneToMany addresses Address
OneToMany agentAttachments Agent Attachment
OneToMany agentGeographies Agent Geography
OneToMany agentSpecialties Agent Specialty
ManyToOne collContentContact Collection
ManyToOne collTechContact Collection
OneToMany collectors Collector
ManyToOne createdByAgent Agent
ManyToOne division Division
OneToMany groups Group Person
ManyToOne instContentContact Institution
ManyToOne instTechContact Institution
OneToMany members Group Person
ManyToOne modifiedByAgent Agent
OneToMany orgMembers Agent
ManyToOne organization Agent
ManyToOne specifyUser Specify User
OneToMany variants Agent Variant


Agent Attachment
Field Type Length Descriptions
AgentAttachmentID Integer   Primary Key
Ordinal Integer   This allows the attachments to be ordered.
Remarks Memo 4096 Additional comments.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Agent Geography
Field Type Length Descriptions
AgentGeographyID Integer   Primary Key
Remarks Memo 4096 Additional comments.
Role String 64 Role of the agent as "author" or "collector" within the geography.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToOne createdByAgent Agent
ManyToOne geography Geography
ManyToOne modifiedByAgent Agent


Agent Specialty
Field Type Length Descriptions
AgentSpecialtyID Integer   Primary Key
Order Number Integer   The priority of specialization, for agents with primary and secondary areas of specialization.
Specialty Name String 64 The name of the field of specialization.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Agent Variant
Field Type Length Descriptions
AgentVariantID Integer   Primary Key
Country String 2 Country of variant or vernacular name.
Language String 2 International character code for language as it pertains to the agent variant.
Name String 255 THe full name used as a variant or vernacular name.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Var Type Byte   Indicates whether the record is a variant (0) or a vernacular name (1).
Variant String 2  
Version Integer    
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Appraisal
Field Type Length Descriptions
AppraisalID Integer   Primary Key
Appraisal Date Calendar   Date of the appraisal.
Appraisal Number String 64 Unique number for the appraisal.
Appraisal Value BigDecimal   Monetary value of the appraisal.
Monetary Unit Type String 8 Type of monetary unit.
Notes Memo 2048 Additional comments.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne accession Accession
ManyToOne agent Agent
OneToMany collectionObjects Collection Object
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Attachment
Field Type Length Descriptions
AttachmentID Integer   Primary Key
Attachment Location String 128 Location of attachment repository.
Capture Device String 128  
Copyright Date String 64 Date of copyright of attachment.
Copyright Holder String 64  
Credit String 64 Attachment credit.
Date Imaged String 64  
File Created Date Calendar    
GUID String 128  
Is Public Boolean    
License String 64 Attachment license information.
License Logo Url String 256  
Metadata Text String 256  
Mime Type String 64 Describes the attachment file type.
Original Filename String 20000 Original name of file.
Remarks Memo 4096 Additional comments.
Scope I D Integer    
Scope Type Byte    
Subject Orientation String 64  
Subtype String 64  
Table I D Short    
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Title String 255 Title of attachment.
Type String 64  
Version Integer    
Visibility Byte    
Relationships
Type Name To Table
OneToMany accessionAttachments Accession Attachment
OneToMany agentAttachments Agent Attachment
ManyToOne attachmentImageAttribute Attachment Image Attribute
OneToMany borrowAttachments Borrow Attachment
OneToMany collectingEventAttachments Collecting Event Attachment
OneToMany collectionObjectAttachments Collection Object Attachment
OneToMany conservDescriptionAttachments Conservator Description Attachment
OneToMany conservEventAttachments Conservator Event Attachment
ManyToOne createdByAgent Agent
ManyToOne creator Agent
OneToMany dnaSequenceAttachments DNA Sequence Attachment
OneToMany dnaSequencingRunAttachments dnasequencingrunattachment
OneToMany fieldNotebookAttachments Field Notebook Attachment
OneToMany fieldNotebookPageAttachments Field Notebook Page Attachment
OneToMany fieldNotebookPageSetAttachments Field Notebook Page Set Attachment
OneToMany giftAttachments Gift Attachment
OneToMany loanAttachments Loan Attachment
OneToMany localityAttachments Locality Attachment
OneToMany metadata Attachment MetadataMetadados
ManyToOne modifiedByAgent Agent
OneToMany permitAttachments Permit Attachment
OneToMany preparationAttachments Preparation Attachment
OneToMany referenceWorkAttachments Reference Work Attachment
OneToMany repositoryAgreementAttachments Repository Agreement Attachment
OneToMany storageAttachments Storage Attachment
OneToMany tags Attachment Tag
OneToMany taxonAttachments Taxon Attachment
OneToMany treatmentEventAttachments Treatment Event Attachment
ManyToOne visibilitySetBy Specify User


Attachment Image Attribute
Field Type Length Descriptions
AttachmentImageAttributeID Integer   Primary Key
Creative Commons String 500  
Height Integer 24  
Image Type String 80  
Magnification Double 24  
Mb Image Id Integer 24  
Number1 Double 24  
Number2 Double 24  
Remarks Memo 4096  
Resolution Double 24  
Text1 String 200  
Text2 String 200  
Timestamp Created Timestamp    
Timestamp Last Send Timestamp    
Timestamp Last Update Check Timestamp    
Timestamp Modified Timestamp    
Version Integer    
View Description String 80  
Width Integer 24  
Yes No1 Boolean    
Yes No2 Boolean    
Relationships
Type Name To Table
OneToMany attachments Attachment
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne morphBankView Morph Bank View


Attachment MetadataMetadados
Field Type Length Descriptions
AttachmentMetadataID Integer   Primary Key
Name String 64 The name of the meta data field.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Value String 128 The value of the meta data field.
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Attachment Tag
Field Type Length Descriptions
AttachmentTagID Integer   Primary Key
Tag String 64 Name of tag.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Attribute Definition
Field Type Length Descriptions
AttributeDefID Integer   Primary Key
Data Type Short   The data type of the attribute.
Field Name String 32 The field name of the attribute.
Table Type Short   The type of table it is attached to, this is internal to Specify.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
OneToMany collectingEventAttrs Collecting Event Attribute
OneToMany collectionObjectAttrs Collection Object Attribute
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne modifiedByAgent Agent
ManyToOne prepType Preparation Type
OneToMany preparationAttrs Preparation Attribute


Author
Field Type Length Descriptions
AuthorID Integer   Primary Key
Order Number Short   the order of AgentID relative to other authors of reference.
Remarks Memo 4096 Additional comments.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne referenceWork Reference Work


Auto Numbering Scheme
Field Type Length Descriptions
AutoNumberingSchemeID Integer   Primary Key
Format Name String 64  
Is Numeric Only Boolean   Yes if number scheme is only numeric.
Scheme Class Name String 64  
Scheme Name String 64 Name of the scheme (sequence).
Table Number Integer    
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToMany collections Collection
ManyToOne createdByAgent Agent
ManyToMany disciplines Discipline
ManyToMany divisions Division
ManyToOne modifiedByAgent Agent


Borrow
Field Type Length Descriptions
BorrowID Integer   Primary Key
Borrow Date Calendar    
Borrow Date Precision Byte    
Collection Member Id Integer    
Current Due Date Calendar   Date loan is currently due. (Same as Original Due Date unless loan period has been extended)
Date Closed Calendar 10 Date loan was closed.
Invoice Number String 50 Lender`s loan number.
Is Closed Boolean   Indicates whether the borrow was closed (returned).
Is Financial Responsibility Boolean    
Number1 Float 24 User definable.
Number2 Float 24 User definable.
Number Of Items Borrowed Integer 24  
Original Due Date Calendar   Original due date for loan.
Received Date Calendar   Date material was received.
Remarks Memo 4096 Additional comments.
Text1 Memo 65535 User definable.
Text2 Memo 65535 User definable.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Extension Granted Boolean   User definable.
Yes No2 Boolean   User definable.
Relationships
Type Name To Table
ManyToOne addressOfRecord Address Of Record
OneToMany borrowAgents Borrow Agent
OneToMany borrowAttachments Borrow Attachment
OneToMany borrowMaterials Borrow Material
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
OneToMany shipments Shipment


Borrow Agent
Field Type Length Descriptions
BorrowAgentID Integer   Primary Key
Collection Member Id Integer    
Remarks Memo 4096 Additional comments.
Role String 32 Role played by agent in the borrow.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToOne borrow Borrow
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Borrow Attachment
Field Type Length Descriptions
BorrowAttachmentID Integer   Primary Key
Ordinal Integer    
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne borrow Borrow
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Borrow Material
Field Type Length Descriptions
BorrowMaterialID Integer   Primary Key
Collection Member Id Integer    
Description String 50 Description of the material. `e.g. Bufo bufo skull`.
In Comments Memo 1024 Notes concerning the receipt of the material.
Material Number String 50 e.g. `FMNH 223456`
Out Comments Memo 1024 Notes concerning the return of the material.
Quantity Short   Number of specimens (for lots).
Quantity Resolved Short   Quantity resolved (Returned, Accessioned, Lost, Discarded, Destroyed ...).
Quantity Returned Short   Quantity returned.
Text1 Memo 6667  
Text2 Memo 6667  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne borrow Borrow
OneToMany borrowReturnMaterials Borrow Return Material
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Borrow Return Material
Field Type Length Descriptions
BorrowReturnMaterialID Integer   Primary Key
Collection Member Id Integer    
Quantity Short   Quantity of preparations returned.
Remarks Memo 4096 Additional comments.
Returned Date Calendar   The date the material was returned.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToOne borrowMaterial Borrow Material
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Collecting Event
Field Type Length Descriptions
CollectingEventID Integer   Primary Key
End Date Calendar   The date collecting event ended.
End Date Precision Byte    
End Date Verbatim String 50  
End Time Short   End time in military format.
GUID String 128  
Integer1 Integer    
Integer2 Integer    
Method String 50 A method, such as net or trap, which is used to obtain the specimen.
Locality and\n Habitat Notes Memo 4096 Field to record information on locality and habitat where specimen was collected.
Reserved Integer3 Integer    
Reserved Integer4 Integer    
Reserved Text1 String 128  
Reserved Text2 String 128  
Sgr Status Byte    
Start Date Calendar   The date collecting event began.
Start Date Precision Byte    
Start Date Verbatim String 50  
Start Time Short   Start time in military format.
Collector Number String 50 Collector Number
Station Field Number Modifier1 String 50  
Station Field Number Modifier2 String 50  
Station Field Number Modifier3 String 50  
Text1 Memo 65535  
Text2 Memo 65535  
Text3 Memo 65535  
Text4 Memo 65535  
Text5 Memo 65535  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Verbatim Date String 50 Date which collector recorded in field book, exactly as reported by the collector. Should indicate whether reported as range, season, month, etc.
Verbatim Locality Memo 2048 Original statement (literal quotation) of the location of the Collecting Event as given by the Collector.
Version Integer    
Visibility Byte    
Relationships
Type Name To Table
OneToMany collectingEventAttachments Collecting Event Attachment
ManyToOne collectingEventAttribute Collecting Event Attribute
OneToMany collectingEventAttrs Collecting Event Attribute
ManyToOne collectingTrip Collecting Trip
OneToMany collectionObjects Collection Object
OneToMany collectors Collector
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne locality Locality
ManyToOne modifiedByAgent Agent
ManyToOne paleoContext Paleo Context
ManyToOne visibilitySetBy Specify User


Collecting Event Attachment
Field Type Length Descriptions
CollectingEventAttachmentID Integer   Primary Key
Collection Member Id Integer    
Ordinal Integer   The order or position of the attachment.
Remarks Memo 4096 Additonal comments.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne collectingEvent Collecting Event
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Collecting Event Attribute
Field Type Length Descriptions
AttrID Integer   Primary Key
Collection Member Id Integer    
Double Value Double    
String Value String 255  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne collectingEvent Collecting Event
ManyToOne createdByAgent Agent
ManyToOne definition Attribute Definition
ManyToOne modifiedByAgent Agent


Collecting Event Attribute
Field Type Length Descriptions
CollectingEventAttributeID Integer   Primary Key
Integer1 Integer    
Integer10 Integer    
Integer2 Integer    
Integer3 Integer    
Integer4 Integer    
Integer5 Integer    
Integer6 Integer    
Integer7 Integer    
Integer8 Integer    
Integer9 Integer    
Number1 Float    
Number10 Float    
Number11 Float    
Number12 Float    
Number13 Float    
Number2 Float    
Number3 Float    
Number4 Float    
Number5 Float    
Number6 Float    
Number7 Float    
Number8 Float    
Number9 Float    
Remarks Memo 4096  
Text1 Memo 65535  
Text10 String 50  
Text11 String 50  
Text12 String 50  
Text13 String 50  
Text14 String 50  
Text15 String 50  
Text16 String 50  
Text17 String 50  
Text2 Memo 65535  
Text3 Memo 65535  
Text4 String 100  
Text5 String 100  
Text6 String 50  
Text7 String 50  
Text8 String 50  
Text9 String 50  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Yes No1 Boolean    
Yes No2 Boolean    
Yes No3 Boolean    
Yes No4 Boolean    
Yes No5 Boolean    
Relationships
Type Name To Table
OneToMany collectingEvents Collecting Event
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne hostTaxon Taxon
ManyToOne modifiedByAgent Agent


Collecting Trip
Field Type Length Descriptions
CollectingTripID Integer   Primary Key
Trip Name String 64 Name of the collecting trip.
Cruise String 250  
End Date Calendar   The ending date of the collecting trip.
End Date Precision Byte    
End Date Verbatim String 50  
End Time Short   The ending time of the collecting trip.
Expedition String 250  
Number1 Integer    
Number2 Integer    
Remarks Memo 4096 Additional comments.
Sponsor String 64 Name of sponsor of collecting trip.
Start Date Calendar   The start date of the collecting trip.
Start Date Precision Byte    
Start Date Verbatim String 50  
Start Time Short   The start time of the collecting trip.
Text1 String 255  
Text2 String 128  
Text3 String 64  
Text4 String 64  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Vessel String 250  
Yes No1 Boolean    
Yes No2 Boolean    
Relationships
Type Name To Table
OneToMany collectingEvents Collecting Event
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
OneToMany fundingAgents Funding Agent
ManyToOne modifiedByAgent Agent


Collection
Field Type Length Descriptions
UserGroupScopeId Integer   Primary Key
Catalog Num Format Name String 64 Name of catalog number format the collection uses.
Code String 50 Unique code for collection.
Collection Name String 50 The name of the collection.
Collection Type String 32 Textual description of collection. ABCD schema field.
Db Content Version String 32 ABCD schema field.
Description Memo 2048 Textual description of collection.
Development Status String 32 ABCD schema field.
Estimated Size Integer   ABCD schema field.
GUID String 128  
Institution Type String 32 ABCD schema field.
Is Embedded Collecting Event Boolean   Yes if collecting event is one-to-one relationship.
ISA Number String 24 ISA number.
Kingdom Coverage String 32 ABCD schema field.
Preservation\n Method Type String 32 ABCD schema field.
Primary Focus String 32 ABCD schema field.
Primary Purpose String 32 ABCD schema field.
Reg Number String 24  
Remarks Memo 4096 Additional comments.
Scope Memo 2048 ABCD schema field.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Web Portal URI String 255  
Web Site URI String 255  
Relationships
Type Name To Table
ManyToOne adminContact Agent
OneToMany contentContacts Agent
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne institutionNetwork Institution
OneToMany leftSideRelTypes Collection Relationship Type
ManyToOne modifiedByAgent Agent
ManyToMany numberingSchemes Auto Numbering Scheme
OneToMany pickLists Pick List
OneToMany prepTypes Preparation Type
OneToMany rightSideRelTypes Collection Relationship Type
OneToMany technicalContacts Agent
OneToMany userGroups Sp Principal


Collection Object
Field Type Length Descriptions
CollectionObjectID Integer   Primary Key
Alt Cat Number String 64 Alternate Catalog Number.
Availability String 32  
Catalog Number String 32 The number that identifies an individual specimen, a lot of specimens, or an observation as a part of a museum collection.
Cataloged Date Calendar   Date the object was cataloged.
Cataloged Date Precision Byte    
Cataloged Date Verbatim String 32 The verbatim date the specimen was collected.
Collection Member Id Integer    
Count Amount Integer   The number of objects (specimens, slides, pieces) prepared.
Deaccessioned Boolean   True if the object has been deaccessioned.
Specimen\nDescription String 255 Image, Sound, Preparation, Container(Container Label?).
Field Number String 50 A unique number a collector assigns to each specimen at the time of collection. For example, botanists often keep a running count of the individual specimens they have collected (LKK1023, LKK1024, etc.).
GUID String 128 Global Unique Identifier
Integer1 Integer    
Integer2 Integer    
Inventory Date Calendar    
Modifier String 50  
Name String 64  
Notifications String 32  
Number1 Float 24 User definable.
Number2 Float 24 User definable.
Object Condition String 64  
Ocr Memo 4096  
Project Number String 64  
Remarks Memo 4096 Additional Comments.
Reserved Integer3 Integer    
Reserved Integer4 Integer    
Reserved Text String 128  
Reserved Text2 String 128  
Reserved Text3 String 128  
Restrictions String 32  
Sgr Status Byte    
Phenology Memo 65535 User definable.
Text2 Memo 65535 User definable.
Text3 Memo 4096  
Timestamp Created Timestamp   The timestamp the record was created.
Modified Date Timestamp   The timestamp the record was last modified.
Total Value BigDecimal    
Version Integer    
Visibility Byte 10  
Yes No1 Boolean   User definable.
Yes No2 Boolean   User definable.
Yes No3 Boolean   User definable.
Yes No4 Boolean   User definable.
Yes No5 Boolean   User definable.
Yes No6 Boolean   User definable.
Relationships
Type Name To Table
ManyToOne accession Accession
ManyToOne appraisal Appraisal
ManyToOne cataloger Agent
ManyToOne collectingEvent Collecting Event
ManyToOne collection Collection
OneToMany collectionObjectAttachments Collection Object Attachment
ManyToOne collectionObjectAttribute Collection Object Attribute
OneToMany collectionObjectAttrs Collection Object Attribute
OneToMany collectionObjectCitations Collection Object Citation
OneToMany conservDescriptions Conservator Description
ManyToOne container Container
ManyToOne containerOwner Container
ManyToOne createdByAgent Agent
OneToMany determinations Determination
OneToMany dnaSequences DNA Sequence
OneToMany exsiccataItems Exsiccata Item
ManyToOne fieldNotebookPage Field Notebook Page
ManyToOne inventorizedBy Agent
OneToMany leftSideRels Collection Relationship
ManyToOne modifiedByAgent Agent
OneToMany otherIdentifiers Other Identifier
ManyToOne paleoContext Paleo Context
OneToMany preparations Preparation
ManyToMany projects Project
OneToMany rightSideRels Collection Relationship
OneToMany treatmentEvents Treatment Event
ManyToOne visibilitySetBy Specify User


Collection Object Attachment
Field Type Length Descriptions
CollectionObjectAttachmentID Integer   Primary Key
Collection Member Id Integer    
Ordinal Integer   The order in the attachment list.
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne collectionObject Collection Object
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Collection Object Attribute
Field Type Length Descriptions
AttrID Integer   Primary Key
Collection Member Id Integer    
Double Value Double    
String Value String 255  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne collectionObject Collection Object
ManyToOne createdByAgent Agent
ManyToOne definition Attribute Definition
ManyToOne modifiedByAgent Agent


Collection Object Attribute
Field Type Length Descriptions
CollectionObjectAttributeID Integer   Primary Key
Bottom Distance Float    
Collection Member Id Integer    
Direction String 32  
Distance Units String 16  
Integer1 Integer    
Integer10 Integer    
Integer2 Integer    
Integer3 Integer    
Integer4 Integer    
Integer5 Integer    
Integer6 Integer    
Integer7 Integer    
Integer8 Integer    
Integer9 Integer    
Number1 Float    
Number10 Float    
Number11 Float    
Number12 Float    
Number13 Float    
Number14 Float    
Number15 Float    
Number16 Float    
Number17 Float    
Number18 Float    
Number19 Float    
Number2 Float    
Number20 Float    
Number21 Float    
Number22 Float    
Number23 Float    
Number24 Float    
Number25 Float    
Number26 Float    
Number27 Float    
Number28 Float    
Number29 Float    
Number3 Float    
Number30 Short    
Number31 Float    
Number32 Float    
Number33 Float    
Number34 Float    
Number35 Float    
Number36 Float    
Number37 Float    
Number38 Float    
Number39 Float    
Number4 Float    
Number40 Float    
Number41 Float    
Number42 Float    
Number5 Float    
Number6 Float    
Number7 Float    
Number8 Byte    
Number9 Float    
Position State String 32  
Remarks Memo 4096  
Text1 Memo 65535  
Text10 String 50  
Text11 String 50  
Text12 String 50  
Text13 String 50  
Text14 String 50  
Text15 String 64  
Text16 Memo 65535  
Text17 Memo 65535  
Text18 Memo 65535  
Text19 Memo 65535  
Text2 Memo 65535  
Text20 Memo 65535  
Text21 Memo 65535  
Text22 Memo 65535  
Text23 Memo 65535  
Text24 Memo 65535  
Text25 Memo 65535  
Text26 Memo 65535  
Text27 Memo 65535  
Text28 Memo 65535  
Text29 Memo 65535  
Text3 Memo 65535  
Text30 Memo 65535  
Text4 String 50  
Text5 String 50  
Text6 String 100  
Text7 String 100  
Text8 String 50  
Text9 String 50  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Top Distance Float    
Version Integer    
Yes No1 Boolean    
Yes No10 Boolean    
Yes No11 Boolean    
Yes No12 Boolean    
Yes No13 Boolean    
Yes No14 Boolean    
Yes No15 Boolean    
Yes No16 Boolean    
Yes No17 Boolean    
Yes No18 Boolean    
Yes No19 Boolean    
Yes No2 Boolean    
Yes No20 Boolean    
Yes No3 Boolean    
Yes No4 Boolean    
Yes No5 Boolean    
Yes No6 Boolean    
Yes No7 Boolean    
Yes No8 Boolean    
Yes No9 Boolean    
Relationships
Type Name To Table
OneToMany collectionObjects Collection Object
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Collection Object Citation
Field Type Length Descriptions
CollectionObjectCitationID Integer   Primary Key
Collection Member Id Integer    
Figure Number String 50  
Is Figured Boolean    
Page Number String 50  
Plate Number String 50  
Remarks Memo 4096 Additional Comments.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne collectionObject Collection Object
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne referenceWork Reference Work


Collection Relationship
Field Type Length Descriptions
CollectionRelationshipID Integer   Primary Key
Text1 String 32 User definable.
Text2 String 32 User definable.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne collectionRelType Collection Relationship Type
ManyToOne createdByAgent Agent
ManyToOne leftSide Collection Object
ManyToOne modifiedByAgent Agent
ManyToOne rightSide Collection Object


Collection Relationship Type
Field Type Length Descriptions
CollectionRelTypeID Integer   Primary Key
Name String 32 The name of the Collection Relationship.
Remarks String 4096 Additional comments.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne leftSideCollection Collection
ManyToOne modifiedByAgent Agent
ManyToOne rightSideCollection Collection


Collector
Field Type Length Descriptions
CollectorID Integer   Primary Key
Is Primary Boolean    
Order Number Integer   The position in the list of collectors.
Remarks Memo 4096 Additional comments.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToOne collectingEvent Collecting Event
ManyToOne createdByAgent Agent
ManyToOne division Division
ManyToOne modifiedByAgent Agent


Common Name
Field Type Length Descriptions
CommonNameTxID Integer   Primary Key
Author String 128  
Country String 2 The country code.
Language String 2 The language code.
Name String 255  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Variant String 2 The variant code of the language.
Version Integer    
Relationships
Type Name To Table
OneToMany citations Common Name Tx Citation
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne taxon Taxon


Common Name Tx Citation
Field Type Length Descriptions
CommonNameTxCitationID Integer   Primary Key
Number1 Float    
Number2 Float    
Remarks Memo 4096  
Text1 Memo 65535 User definable.
Text2 Memo 65535 User definable.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Yes No1 Boolean    
Yes No2 Boolean    
Relationships
Type Name To Table
ManyToOne commonNameTx Common Name
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne referenceWork Reference Work


Conservator Description
Field Type Length Descriptions
ConservDescriptionID Integer   Primary Key
Background Info Memo 8192 Any background information on the object.
Composition Memo 8192  
Description Memo 8192  
Display Recommendations Memo 4096  
Height Float   The height of the object.
Light Recommendations Memo 4096  
Object Length Float   The length of the object.
Other Recommendations Memo 4096  
Remarks Memo 8192 Additional Comments
Short Description String 128 A short description of the object.
Source Memo 8192  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Units String 16 The units for the measurements (`feet` or `meters`).
Version Integer    
Width Float   The width of the object.
Relationships
Type Name To Table
ManyToOne collectionObject Collection Object
OneToMany conservDescriptionAttachments Conservator Description Attachment
ManyToOne createdByAgent Agent
ManyToOne division Division
OneToMany events Conservator Event
ManyToOne modifiedByAgent Agent


Conservator Description Attachment
Field Type Length Descriptions
ConservDescriptionAttachmentID Integer   Primary Key
Ordinal Integer   The order or position
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne conservDescription Conservator Description
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Conservator Event
Field Type Length Descriptions
ConservEventID Integer   Primary Key
Advanced Testing Exam Memo 8192 The advanced testing that was used to examine the object
Advanced Testing Exam Results Memo 8192 The results of the advanced testing
Completed Comments Memo 4096  
Completed Date Calendar    
Completed Date Precision Byte    
Condition Report Memo 8192 A report on the condition
Approval Date Calendar 8192  
Curator Approval Date Precision Byte    
Exam Date Calendar   The date the object was examined
Exam Date Precision Byte    
Number1 Integer    
Number2 Integer    
Photo Documentation Memo 8192 Any documentation on the photos that were taken
Remarks Memo 4096  
Text1 String 64  
Text2 String 64  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Treatment Completion Date Calendar    
Treatment Comp Date Precision Byte    
Treatment Report Memo 8192 A description of the treatment that is needed.
Version Integer    
Yes No1 Boolean    
Yes No2 Boolean    
Relationships
Type Name To Table
ManyToOne conservDescription Conservator Description
OneToMany conservEventAttachments Conservator Event Attachment
ManyToOne createdByAgent Agent
ManyToOne curator Agent
ManyToOne examinedByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne treatedByAgent Agent


Conservator Event Attachment
Field Type Length Descriptions
ConservEventAttachmentID Integer   Primary Key
Ordinal Integer   The order or position
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne conservEvent Conservator Event
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Container
Field Type Length Descriptions
ContainerID Integer   Primary Key
Collection Member Id Integer    
Description String 255 A description of the container
Name String 64 The name of the container
Number Integer   User definable
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Type Short   The type of container
Version Integer    
Relationships
Type Name To Table
OneToMany children Container
OneToMany collectionObjectKids Collection Object
OneToMany collectionObjects Collection Object
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne parent Container
ManyToOne storage Storage


Data Type
Field Type Length Descriptions
DataTypeID Integer   Primary Key
Name String 50  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Deaccession
Field Type Length Descriptions
DeaccessionID Integer   Primary Key
Deaccession Date Calendar    
Deaccession Number String 50 Name institution assigns to the deaccession
Number1 Float 24 User definable
Number2 Float 24 User definable
Remarks Memo 4096 Additional Comments
Text1 Memo 65535 User definable
Text2 Memo 65535 User definable
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Type String 64 Description of the Type of deaccession; i.e. Gift, disposal, lost
Version Integer    
Yes No1 Boolean   User definable
Yes No2 Boolean   User definable
Relationships
Type Name To Table
ManyToOne accession Accession
ManyToOne createdByAgent Agent
OneToMany deaccessionAgents Deaccession Agent
OneToMany deaccessionPreparations Deaccession Preparation
ManyToOne modifiedByAgent Agent


Deaccession Agent
Field Type Length Descriptions
DeaccessionAgentID Integer   Primary Key
Remarks Memo 4096 Additional Comments
Role String 50 Role agent played in deaccession
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToOne createdByAgent Agent
ManyToOne deaccession Deaccession
ManyToOne modifiedByAgent Agent


Deaccession Preparation
Field Type Length Descriptions
DeaccessionPreparationID Integer   Primary Key
Quantity Short   The number of items deaccessioned
Remarks Memo 4096 Additional Comments
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne deaccession Deaccession
OneToMany loanReturnPreparations Loan Return Preparation
ManyToOne modifiedByAgent Agent
ManyToOne preparation Preparation


Determination
Field Type Length Descriptions
DeterminationID Integer   Primary Key
Addendum String 16 A Pick List suffix element added to the taxon name to indicate a concept or citation for that name. For example; sensu lato.
Alternate Name String 128 A free text field for insertion of a name (scientific or common) not recognized in the taxon tree authority. This field operates as an �either/or� condition with Preferred Taxon; both cannot be entered in a single Determination.
Collection Member Id Integer    
Confidence String 50 Confidence of determination.
Determined Date Calendar   The date it was determined.
Determined Date Precision Byte    
Feature Or Basis String 50 Body part, or characteristic used as the basis of a determination.
GUID String 128  
Current Boolean   Yes if the determination is considered the 'best' (maybe even one of the better).
Method String 50 Taxonomic tools and information on which a determination is based. These include professional expertise, published taxonomic keys, molecular DNA, or comparisons with previously cataloged specimens.
Name Usage String 64 User customizable pick list used to describe the context of the name entered into the taxon or Alternate name fields.
Number1 Float 24 User definable.
Number2 Float 24 User definable.
Qualifier String 16 A term to qualify the identification of the taxon name when doubts have arisen as to its identity or as a comparison to a given name (e.g. "cf." or "aff.").
Remarks Memo 4096 Additional Comments.
Sub Sp Qualifier String 16  
Text1 Memo 65535 User definable.
Text2 Memo 65535 User definable.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Type Status String 50 A pick list of all available type designations; Holotype, Paratype, Neotype. Specify ships with predetermined values which are editable for users.
Var Qualifier String 16  
Version Integer    
Yes No1 Boolean   User definable.
Yes No2 Boolean   User definable.
Relationships
Type Name To Table
ManyToOne collectionObject Collection Object
ManyToOne createdByAgent Agent
OneToMany determinationCitations Determination Citation
ManyToOne determiner Agent
ManyToOne modifiedByAgent Agent
ManyToOne preferredTaxon Taxon
ManyToOne taxon Taxon


Determination Citation
Field Type Length Descriptions
DeterminationCitationID Integer   Primary Key
Collection Member Id Integer    
Remarks Memo 4096 Additional Comments.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne determination Determination
ManyToOne modifiedByAgent Agent
ManyToOne referenceWork Reference Work


Discipline
Field Type Length Descriptions
UserGroupScopeId Integer   Primary Key
Is Paleo Context Embedded Boolean    
Name String 64  
Paleo Context Child Table String 50  
Reg Number String 24  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Type String 64  
Version Integer    
Relationships
Type Name To Table
OneToMany attributeDefs Attribute Definition
OneToMany collections Collection
ManyToOne createdByAgent Agent
ManyToOne dataType Data Type
ManyToOne division Division
ManyToOne geographyTreeDef Geography Tree Definition
ManyToOne geologicTimePeriodTreeDef Geological Time Period Tree Definition
ManyToOne lithoStratTreeDef Lithostratigraphy Tree Definition
ManyToOne modifiedByAgent Agent
ManyToMany numberingSchemes Auto Numbering Scheme
OneToMany spExportSchemas Sp Export Schema
OneToMany spLocaleContainers Locale Container
OneToOne taxonTreeDef Taxon Tree Definition
OneToMany userGroups Sp Principal


Division
Field Type Length Descriptions
UserGroupScopeId Integer   Primary Key
Abbreviation String 64 The abbreviation for the division.
Alt Name String 128  
Description Memo 8192  
Discipline String 64 The discipline of the division
Icon URL String 255 The URL to their icon
Name String 255 The name of the division
Reg Number String 24  
Remarks Memo 8192 Additional Comments
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
URL String 255 A URI (web site) address for the department
Version Integer    
Relationships
Type Name To Table
ManyToOne address Address
ManyToOne createdByAgent Agent
OneToMany disciplines Discipline
ManyToOne institution Institution
OneToMany members Agent
ManyToOne modifiedByAgent Agent
ManyToMany numberingSchemes Auto Numbering Scheme
OneToMany userGroups Sp Principal


DNA Primer
Field Type Length Descriptions
DNAPrimerID Integer   Primary Key
Integer1 Integer    
Integer2 Integer    
Number1 Float    
Number2 Float    
Primer Designator String 64  
Primer Name Forward String 64  
Primer Name Rev String 64  
Primer Ref Cit Forward String 300  
Primer Ref Cit Rev String 300  
Primer Ref Link Forward String 300  
Primer Ref Link Rev String 300  
Primer Seq Forward String 128  
Primer Seq Rev String 128  
Purification Method String 255  
Remarks Memo 4096  
Reserved Integer3 Integer    
Reserved Integer4 Integer    
Reserved Number3 Float    
Reserved Number4 Float    
Reserved Text3 Memo 4096  
Reserved Text4 Memo 4096  
Text1 Memo 4096  
Text2 Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Yes No1 Boolean    
Yes No2 Boolean    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
OneToMany dnaSequencingRuns DNA Sequencing Run
ManyToOne modifiedByAgent Agent


DNA Sequence
Field Type Length Descriptions
DnaSequenceID Integer   Primary Key
Ambiguous Integer    
BOLD Barcode Id String 32  
BOLD Last Update Calendar    
BOLD Sample Id String 32  
Bold Translation Matrix String 64  
Collection Member Id Integer    
Comp A Integer    
Comp C Integer    
Comp G Integer    
Comp T Integer    
Genbank Acc # String 32  
Gene Sequence Memo 2048 The actual sequence
Molecule Type String 32  
Number1 Float    
Number2 Float    
Number3 Float    
Remarks Memo 4096  
Target Marker String 32  
Text1 String 32  
Text2 String 32  
Text3 String 64  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Total Residues Integer    
Version Integer    
Yes No1 Boolean    
Yes No2 Boolean    
Yes No3 Boolean    
Relationships
Type Name To Table
OneToMany attachments DNA Sequence Attachment
ManyToOne collectionObject Collection Object
ManyToOne createdByAgent Agent
OneToMany dnaSequencingRuns DNA Sequencing Run
ManyToOne materialSample Material Sample
ManyToOne modifiedByAgent Agent
ManyToOne sequencer Agent


DNA Sequence Attachment
Field Type Length Descriptions
DnaSequenceAttachmentId Integer   Primary Key
Ordinal Integer    
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne dnaSequence DNA Sequence
ManyToOne modifiedByAgent Agent


D N A Sequencing Run Attachment
Field Type Length Descriptions
DnaSequencingRunAttachmentId Integer   Primary Key
Ordinal Integer    
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne dnaSequencingRun DNA Sequencing Run
ManyToOne modifiedByAgent Agent


DNA Sequencing Run
Field Type Length Descriptions
DNASequencingRunID Integer   Primary Key
Collection Member Id Integer    
Dryad DOI String 256  
Gene Sequence Memo    
Number1 Float    
Number2 Float    
Number3 Float    
Ordinal Integer    
PCR Cocktail Primer Boolean    
PCR Forward Primer Code String 32  
PCR Primer Name String 32  
PCR Primer Seq5_3 String 64 PCR Primer Sequence5_3
PCR Rev Primer Code String 32  
Read Direction String 16  
Remarks Memo 4096  
Run Date Calendar    
Score File Name String 32  
Seq Cocktail Primer Boolean    
Seq Primer Code String 32 Sequence Primer Code
Seq Primer Name String 32 Sequence Primer Name
Seq Primer Seq5_3 String 64 Sequence Primer Sequence5_3
SRA Experiment ID String 64  
SRA Run ID String 64  
SRA Submission ID String 64  
Text1 String 32  
Text2 String 32  
Text3 String 64  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Trace File Name String 32  
Version Integer    
Yes No1 Boolean    
Yes No2 Boolean    
Yes No3 Boolean    
Relationships
Type Name To Table
OneToMany attachments dnasequencingrunattachment
OneToMany citations D N A Sequencing Run Citation
ManyToOne createdByAgent Agent
ManyToOne dnaPrimer DNA Primer
ManyToOne dnaSequence DNA Sequence
ManyToOne modifiedByAgent Agent
ManyToOne preparedByAgent Agent
ManyToOne runByAgent Agent


D N A Sequencing Run Citation
Field Type Length Descriptions
DNASequencingRunCitationID Integer   Primary Key
Number1 Float    
Number2 Float    
Remarks Memo 4096  
Text1 Memo 65535  
Text2 Memo 65535  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Yes No1 Boolean    
Yes No2 Boolean    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne referenceWork Reference Work
ManyToOne sequencingRun DNA Sequencing Run


Exchange In
Field Type Length Descriptions
ExchangeInID Integer   Primary Key
Contents Memo 4096  
Description String 120 Description of material.
Exchange Date Calendar   Date exchange was received.
Exchange In # String 50  
Number1 Float 24 User definable.
Number2 Float 24 User definable.
Quantity Exch Short   Number of items received.
Remarks Memo 4096 Additional Comments.
Source Geography String 32  
Source Taxonomy String 32  
Text1 Memo 65535 User definable.
Text2 Memo 65535 User definable.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Yes No1 Boolean   User definable.
Yes No2 Boolean   User definable.
Relationships
Type Name To Table
ManyToOne addressOfRecord Address Of Record
ManyToOne agentCatalogedBy Agent
ManyToOne agentReceivedFrom Agent
ManyToOne createdByAgent Agent
ManyToOne division Division
OneToMany exchangeInPreps Exchange In Prep
ManyToOne modifiedByAgent Agent


Exchange In Prep
Field Type Length Descriptions
ExchangeInPrepID Integer   Primary Key
Comments Memo    
Description Of Material String 255  
Number1 Integer    
Quantity Integer    
Text1 Memo    
Text2 Memo    
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne exchangeIn Exchange In
ManyToOne modifiedByAgent Agent
ManyToOne preparation Preparation


Exchange Out
Field Type Length Descriptions
ExchangeOutID Integer   Primary Key
Contents Memo 4096  
Description String 120  
Exchange Date Calendar   Date exchange was sent.
Exchange Out # String 50  
Number1 Float 24 User definable.
Number2 Float 24 User definable.
Quantity Exch Short   Number of items sent.
Remarks Memo 4096 Additional Comments.
Source Geography String 32  
Source Taxonomy String 32  
Text1 Memo 65535 User definable.
Text2 Memo 65535 User definable.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Yes No1 Boolean   User definable.
Yes No2 Boolean   User definable.
Relationships
Type Name To Table
ManyToOne addressOfRecord Address Of Record
ManyToOne agentCatalogedBy Agent
ManyToOne agentSentTo Agent
ManyToOne createdByAgent Agent
ManyToOne division Division
OneToMany exchangeOutPreps Exchange Out Prep
ManyToOne modifiedByAgent Agent
OneToMany shipments Shipment


Exchange Out Prep
Field Type Length Descriptions
ExchangeOutPrepID Integer   Primary Key
Comments Memo    
Description Of Material String 255  
Number1 Integer    
Quantity Integer    
Text1 Memo    
Text2 Memo    
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne exchangeOut Exchange Out
ManyToOne modifiedByAgent Agent
ManyToOne preparation Preparation


Exsiccata
Field Type Length Descriptions
ExsiccataID Integer   Primary Key
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Title String 255 The title of the exsiccata
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
OneToMany exsiccataItems Exsiccata Item
ManyToOne modifiedByAgent Agent
ManyToOne referenceWork Reference Work


Exsiccata Item
Field Type Length Descriptions
ExsiccataItemID Integer   Primary Key
Fascicle String 16 The fascicle number
Number String 16 The list number of the collection object within the exsiccata
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne collectionObject Collection Object
ManyToOne createdByAgent Agent
ManyToOne exsiccata Exsiccata
ManyToOne modifiedByAgent Agent


Field Notebook
Field Type Length Descriptions
FieldNotebookID Integer   Primary Key
Description Memo 2048  
End Date Calendar    
Location String 64  
Name String 32  
Start Date Calendar    
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
OneToMany attachments Field Notebook Attachment
ManyToOne collection Collection
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne modifiedByAgent Agent
ManyToOne ownerAgent Agent
OneToMany pageSets Field Notebook Page Set


Field Notebook Attachment
Field Type Length Descriptions
FieldNotebookAttachmentId Integer   Primary Key
Ordinal Integer    
Remarks Memo 8192  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne fieldNotebook Field Notebook
ManyToOne modifiedByAgent Agent


Field Notebook Page
Field Type Length Descriptions
FieldNotebookPageID Integer   Primary Key
Description String 128  
Page Number String 32  
Scan Date Calendar    
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
OneToMany attachments Field Notebook Page Attachment
OneToMany collectionObjects Collection Object
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne modifiedByAgent Agent
ManyToOne pageSet Field Notebook Page Set


Field Notebook Page Attachment
Field Type Length Descriptions
FieldNotebookPageAttachmentId Integer   Primary Key
Ordinal Integer    
Remarks Memo 8192  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne fieldNotebookPage Field Notebook Page
ManyToOne modifiedByAgent Agent


Field Notebook Page Set
Field Type Length Descriptions
FieldNotebookPageSetID Integer   Primary Key
Description String 128  
End Date Calendar    
Method String 64  
Order Number Short    
Start Date Calendar    
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
OneToMany attachments Field Notebook Page Set Attachment
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne fieldNotebook Field Notebook
ManyToOne modifiedByAgent Agent
OneToMany pages Field Notebook Page
ManyToOne sourceAgent Agent


Field Notebook Page Set Attachment
Field Type Length Descriptions
FieldNotebookPageSetAttachmentId Integer   Primary Key
Ordinal Integer    
Remarks Memo 8192  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne fieldNotebookPageSet Field Notebook Page Set
ManyToOne modifiedByAgent Agent


Funding Agent
Field Type Length Descriptions
FundingAgentID Integer   Primary Key
Is Primary Boolean    
Order Number Integer    
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Type String 32  
Version Integer    
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToOne collectingTrip Collecting Trip
ManyToOne createdByAgent Agent
ManyToOne division Division
ManyToOne modifiedByAgent Agent


Geo Coord Detail
Field Type Length Descriptions
GeoCoordDetailID Integer   Primary Key
Error Polygon Memo    
Geo Ref Accuracy Double    
Geo Ref Accuracy Units String 20  
Geo Ref Det Date Calendar    
Geo Ref Det Ref String 100  
Geo Ref Remarks Memo    
Geo Ref Verification Status String 50  
Max Uncertainty Est BigDecimal    
Max Uncertainty Est Unit String 8  
Named Place Ext BigDecimal    
No Geo Ref Because String 100  
Original Coord System String 32  
Protocol String 64  
Source String 64  
Text1 Memo 65535  
Text2 Memo 65535  
Text3 Memo 65535  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Uncertainty Polygon Memo    
Validation String 64  
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne geoRefDetBy Agent
ManyToOne locality Locality
ManyToOne modifiedByAgent Agent


Geography
Field Type Length Descriptions
GeographyID Integer   Primary Key
Abbreviation String 16  
Centroid Latitude BigDecimal    
Centroid Longitude BigDecimal    
Common Name String 128  
Full Name String 255  
Geography Code String 24  
GML Memo 4096  
GUID String 128  
Highest Child Node Number Integer    
Is Preferred Boolean   The preferred name of a synonym.
Is Current Boolean   `Yes` if the Name and/or Geographic/Political entity is currently valid.
Name String 64  
Node Number Integer    
Number1 Integer   User definable
Number2 Integer   User definable
Rank Id Integer    
Remarks Memo 4096 Additional Comments
Text1 String 32 User definable.
Text2 String 32 User definable.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Timestamp Version Date    
Version Integer    
Relationships
Type Name To Table
OneToMany acceptedChildren Geography
ManyToOne acceptedGeography Geography
OneToMany children Geography
ManyToOne createdByAgent Agent
ManyToOne definition Geography Tree Definition
ManyToOne definitionItem Geography Tree Definition Item
OneToMany localities Locality
ManyToOne modifiedByAgent Agent
ManyToOne parent Geography


Geography Tree Definition
Field Type Length Descriptions
GeographyTreeDefID Integer   Primary Key
Full Name Direction Integer    
Name String 64  
Remarks Memo 4096 Additional Comments.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
OneToMany disciplines Discipline
ManyToOne modifiedByAgent Agent
OneToMany treeDefItems Geography Tree Definition Item
OneToMany treeEntries Geography


Geography Tree Definition Item
Field Type Length Descriptions
GeographyTreeDefItemID Integer   Primary Key
Full Name Separator String 32  
Is Enforced Boolean    
Is In Full Name Boolean    
Name String 64  
Rank Id Integer    
Remarks Memo 4096 Additional Comments.
Text After String 64 User definable.
Text Before String 64 User definable.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Title String 64  
Version Integer    
Relationships
Type Name To Table
OneToMany children Geography Tree Definition Item
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne parent Geography Tree Definition Item
ManyToOne treeDef Geography Tree Definition
OneToMany treeEntries Geography


Chronostratigraphy
Field Type Length Descriptions
GeologicTimePeriodID Integer   Primary Key
End Period Float    
End Uncertainty Float    
Full Name String 255  
GUID String 128  
Highest Child Node Number Integer    
Is Preferred Boolean    
Is BioStratigraphy Boolean    
Name String 64  
Node Number Integer    
Rank Id Integer   Numeric representation of Items rank in stratigraphic hierarchy.
Remarks Memo 4096 Additional Comments.
Standard String 64 The system of Stratigraphy the record is included in.
Start Period Float    
Start Uncertainty Float    
Text1 String 128  
Text2 String 128  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
OneToMany acceptedChildren Chronostratigraphy
ManyToOne acceptedGeologicTimePeriod Chronostratigraphy
OneToMany bioStratsPaleoContext Paleo Context
OneToMany children Chronostratigraphy
OneToMany chronosStratsPaleoContext Paleo Context
ManyToOne createdByAgent Agent
ManyToOne definition Geological Time Period Tree Definition
ManyToOne definitionItem Geological Time Period Tree Definition Item
ManyToOne modifiedByAgent Agent
ManyToOne parent Chronostratigraphy


Geological Time Period Tree Definition
Field Type Length Descriptions
GeologicTimePeriodTreeDefID Integer   Primary Key
Full Name Direction Integer    
Name String 64  
Remarks Memo 4096 Additional Comments.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
OneToMany disciplines Discipline
ManyToOne modifiedByAgent Agent
OneToMany treeDefItems Geological Time Period Tree Definition Item
OneToMany treeEntries Chronostratigraphy


Geological Time Period Tree Definition Item
Field Type Length Descriptions
GeologicTimePeriodTreeDefItemID Integer   Primary Key
Full Name Separator String 32  
Is Enforced Boolean    
Is In Full Name Boolean    
Name String 64  
Rank Id Integer    
Remarks Memo 4096 Additional Comments.
Text After String 64 User definable.
Text Before String 64 User definable.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Title String 64  
Version Integer    
Relationships
Type Name To Table
OneToMany children Geological Time Period Tree Definition Item
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne parent Geological Time Period Tree Definition Item
ManyToOne treeDef Geological Time Period Tree Definition
OneToMany treeEntries Chronostratigraphy


Gift
Field Type Length Descriptions
GiftID Integer   Primary Key
Contents Memo 4096  
Date Received Calendar    
Gift Date Calendar    
Gift Number String 50  
Integer1 Integer    
Integer2 Integer    
Integer3 Integer    
Is Financial Responsibility Boolean    
Number1 Float 24 User defined.
Number2 Float 24 se
Purpose Of Gift String 64  
Received Comments String 255  
Remarks Memo 4096  
Special Conditions Memo 2048  
Source Geography String 500  
Source Taxonomy String 500  
Text1 Memo 65535 User definable.
Text2 Memo 65535 User definable.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Yes No1 Boolean    
Yes No2 Boolean    
Relationships
Type Name To Table
ManyToOne addressOfRecord Address Of Record
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne division Division
OneToMany giftAgents Gift Agent
OneToMany giftAttachments Gift Attachment
OneToMany giftPreparations Gift Preparation
ManyToOne modifiedByAgent Agent
OneToMany shipments Shipment


Gift Agent
Field Type Length Descriptions
GiftAgentID Integer   Primary Key
Remarks Memo 4096  
Role String 50  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne gift Gift
ManyToOne modifiedByAgent Agent


Gift Attachment
Field Type Length Descriptions
GiftAttachmentID Integer   Primary Key
Ordinal Integer    
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne gift Gift
ManyToOne modifiedByAgent Agent


Gift Preparation
Field Type Length Descriptions
GiftPreparationID Integer   Primary Key
Description String 255  
In Comments Memo 1024  
Out Comments Memo 1024  
Quantity Integer   Number of preparations included in the gift.
Received Comments Memo 1024  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne gift Gift
ManyToOne modifiedByAgent Agent
ManyToOne preparation Preparation


Group Person
Field Type Length Descriptions
GroupPersonID Integer   Primary Key
Order Number Short   Members position in group; i.e. 1st, 2nd, 3rd.
Remarks Memo 4096 Additional Comments.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne division Division
ManyToOne group Agent
ManyToOne member Agent
ManyToOne modifiedByAgent Agent


Information Request
Field Type Length Descriptions
InfoRequestID Integer   Primary Key
Collection Member Id Integer    
Email String 50 Email of agent requesting the information.
First Name String 50  
Info Req Number String 32 Number of Information Request.
Institution String 127  
Last Name String 50  
Remarks Memo 4096 Additional Comments.
Reply Date Calendar    
Request Date Calendar    
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
OneToMany recordSets Record Set


Institution
Field Type Length Descriptions
UserGroupScopeId Integer   Primary Key
Alt Name String 128  
Code String 64  
Copyright Memo 8192  
Current Managed Rel Version String 8  
Current Managed Schema Version String 8  
Description Memo 8192  
Disclaimer Memo 8192 Disclaimer statement, e.g. concerning responsibility for data quality or legal implications.
GUID String 128  
Has Been Asked Boolean    
Icon URL String 255  
IPR Memo 8192 A sequence of statements related to Intellectual Property Rights, credit and acknowledgement.
Are Accessions Global Boolean    
Is Anonymous Boolean    
Is Release Managed Globally Boolean    
Is Security On Boolean    
Is Server Based Boolean    
Is Sharing Localities Boolean    
Is Single Geography Tree Boolean    
License Memo 2048  
LSID Authority String 64  
Minimum Pwd Length Byte    
Name String 255  
Reg Number String 24  
Remarks Memo 8192 Additional Comments
Terms Of Use Memo 8192 Defines conditions under which the data may be analyzed, distributed or changed. "Terms of use" includes concepts like "Usage conditions" and "Specific Restrictions".
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
URL String 255  
Version Integer    
Relationships
Type Name To Table
ManyToOne address Address
OneToMany contentContacts Agent
ManyToOne createdByAgent Agent
OneToMany divisions Division
ManyToOne modifiedByAgent Agent
ManyToOne storageTreeDef Storage Tree Definition
OneToMany technicalContacts Agent
OneToMany userGroups Sp Principal


Institution Network
Field Type Length Descriptions
InstitutionNetworkID Integer   Primary Key
Alt Name String 128  
Code String 64  
Copyright Memo 8192  
Description Memo 8192  
Disclaimer Memo 8192  
Icon U R I String 255  
Ipr Memo 8192  
License Memo 2048  
Name String 255  
Remarks Memo 8192  
Terms Of Use Memo 8192  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Uri String 255  
Version Integer    
Relationships
Type Name To Table
ManyToOne address Address
OneToMany collections Collection
OneToMany contacts Agent
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Journal
Field Type Length Descriptions
JournalID Integer   Primary Key
GUID String 128  
ISSN String 16  
Journal Abbreviation String 50  
Journal Name String 255 Full name of hte journal.
Remarks Memo 4096  
Text1 String 32 User definable.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne institution Institution
ManyToOne modifiedByAgent Agent
OneToMany referenceWorks Reference Work


Lat Lon Polygon
Field Type Length Descriptions
LatLonPolygonID Integer   Primary Key
Description Memo 4096  
Is Polyline Boolean    
Name String 64  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne locality Locality
ManyToOne modifiedByAgent Agent
OneToMany points Lat Lon Polygon Pnt
ManyToOne visualQuery Sp Visual Query


Lat Lon Polygon Pnt
Field Type Length Descriptions
LatLonPolygonPntID Integer   Primary Key
Elevation Integer    
Latitude BigDecimal    
Longitude BigDecimal    
Ordinal Integer    
Relationships
Type Name To Table
ManyToOne latLonPolygon Lat Lon Polygon


Lithostratigraphy
Field Type Length Descriptions
LithoStratID Integer   Primary Key
Full Name String 255  
GUID String 128  
Highest Child Node Number Integer    
Is Preferred Boolean    
Name String 64  
Node Number Integer    
Number1 Double    
Number2 Double    
Rank Id Integer    
Remarks Memo 4096 Additional Comments.
Text1 Memo 65535  
Text2 Memo 65535  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Yes No1 Boolean    
Yes No2 Boolean    
Relationships
Type Name To Table
OneToMany acceptedChildren Lithostratigraphy
ManyToOne acceptedLithoStrat Lithostratigraphy
OneToMany children Lithostratigraphy
ManyToOne createdByAgent Agent
ManyToOne definition Lithostratigraphy Tree Definition
ManyToOne definitionItem Lithostratigraphy Tree Definition Item
ManyToOne modifiedByAgent Agent
OneToMany paleoContexts Paleo Context
ManyToOne parent Lithostratigraphy


Lithostratigraphy Tree Definition
Field Type Length Descriptions
LithoStratTreeDefID Integer   Primary Key
Full Name Direction Integer    
Name String 64  
Remarks Memo 4096 Additional Comments.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
OneToMany disciplines Discipline
ManyToOne modifiedByAgent Agent
OneToMany treeDefItems Lithostratigraphy Tree Definition Item
OneToMany treeEntries Lithostratigraphy


Lithostratigraphy Tree Definition Item
Field Type Length Descriptions
LithoStratTreeDefItemID Integer   Primary Key
Full Name Separator String 32  
Is Enforced Boolean    
Is In Full Name Boolean    
Name String 64  
Rank Id Integer    
Remarks Memo 4096 Additional Comments
Text After String 64 User definable
Text Before String 64 User definable
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Title String 64  
Version Integer    
Relationships
Type Name To Table
OneToMany children Lithostratigraphy Tree Definition Item
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne parent Lithostratigraphy Tree Definition Item
ManyToOne treeDef Lithostratigraphy Tree Definition
OneToMany treeEntries Lithostratigraphy


Loan
Field Type Length Descriptions
LoanID Integer   Primary Key
Contents Memo 4096  
Current Due Date Calendar   Date the loan is due for return (Same as original Due date unless loan period has been extended).
Date Closed Calendar   Date loan was closed.
Date Received Calendar    
Integer1 Integer    
Integer2 Integer    
Integer3 Integer    
Is Closed Boolean   'No' until all preparations in the loan have been returned/resolved.
Is Financial Responsibility Boolean    
Loan Date Calendar   Date the Loan was created.
Loan Number String 50 A field that contains a record of the loan number and which is automatically incremented when a loan is made.
Number1 Float 24 User definable.
Number2 Float 24 User definable.
Original Due Date Calendar   Date the loan was originally due.
Overdue Noti Sent Date Calendar    
Purpose Of Loan String 64  
Received Comments String 255  
Remarks Memo 4096 Additional Comments
Special Conditions Memo 2048  
Source Geography String 500  
Source Taxonomy String 500  
Text1 Memo 65535 User definable.
Text2 Memo 65535 User definable.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Extension Granted Boolean   User definable.
Yes No2 Boolean   User definable.
Relationships
Type Name To Table
ManyToOne addressOfRecord Address Of Record
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne division Division
OneToMany loanAgents Loan Agent
OneToMany loanAttachments Loan Attachment
OneToMany loanPreparations Loan Preparation
ManyToOne modifiedByAgent Agent
OneToMany shipments Shipment


Loan Agent
Field Type Length Descriptions
LoanAgentID Integer   Primary Key
Remarks Memo 4096 Additional Comments
Role String 50 Role the agent played in the loan.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne loan Loan
ManyToOne modifiedByAgent Agent


Loan Attachment
Field Type Length Descriptions
LoanAttachmentID Integer   Primary Key
Ordinal Integer    
Remarks Memo 4096 Additional comments.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne loan Loan
ManyToOne modifiedByAgent Agent


Loan Preparation
Field Type Length Descriptions
LoanPreparationID Integer   Primary Key
Description String 255 Description of loaned material (intended to be used for non-cataloged items, i.e. when PreparationID is null)
In Comments Memo 1024 Comments on item when returned.
Is Resolved Boolean    
Out Comments Memo 1024 Comments on item when loaned.
Quantity Integer   The total number of specimens loaned (necessary for lots).
Quantity Resolved Integer   Number of specimens returned, deaccessioned or otherwise accounted for. (necessary for Lots).
Quantity Returned Integer   Number of specimens returned. (necessary for Lots)
Received Comments Memo 1024  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne loan Loan
OneToMany loanReturnPreparations Loan Return Preparation
ManyToOne modifiedByAgent Agent
ManyToOne preparation Preparation


Loan Return Preparation
Field Type Length Descriptions
LoanReturnPreparationID Integer   Primary Key
Quantity Resolved Integer   Number of specimens returned, deaccessioned or otherwise accounted for. (necessary for Lots).
Quantity Returned Integer   Number of specimens returned. (necessary for Lots).
Remarks Memo 4096 Additional Comments.
Returned Date Calendar   Date of return.
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne deaccessionPreparation Deaccession Preparation
ManyToOne discipline Discipline
ManyToOne loanPreparation Loan Preparation
ManyToOne modifiedByAgent Agent
ManyToOne receivedBy Agent


Locality
Field Type Length Descriptions
LocalityID Integer   Primary Key
Datum String 50 GPS Datum.
Elevation Accuracy Double   Plus or minus -- in meters.
Elevation Method String 50 The method used to determine the elevation.
GML Memo    
GUID String 128  
Lat1text String 50 User entry for Latitude1
Lat2text String 50 User entry for Latitude2
Latitude/Longitude Accuracy Double   radius -- in decimal degrees
Lat/Long Method String 50 the method used to determine the Latitude, Longitude
Latitude/Longitude Type String 50 The type of area described by the Latitude Longitude data (Point, Line, Rectangle)
Latitude1 BigDecimal   Latitude of first point
Latitude2 BigDecimal   Latitude of second point
Locality Name String 255 The full name of the locality.
Long1text String 50 User entry for Longitude1
Long2text String 50 User entry for Longitude2
Longitude1 BigDecimal   Longitude of first point
Longitude2 BigDecimal   Longitude of second point
Max Elevation Double   The maximum elevation in Meters
Min Elevation Double   The minimum elevation in Meters
Named Place String 255 The named place the locality is closest to
Original Elevation Unit String 50 i.e. Meters, Feet, ...
Original Latitude Longitude Unit Integer   i.e. Decimal, Deg/Min/Sec, ...
Relation To Named Place String 120 Relation of the locality to the named place
Remarks Memo 4096 Additional Comments
Sgr Status Byte    
Short Name String 32  
Src Lat Long Unit Byte    
Text1 Memo 65535  
Text2 Memo 65535  
Text3 Memo 65535  
Text4 Memo 65535  
Text5 Memo 65535  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Verbatim Elevation String 50 The verbatim elevation including units as given in the field notes
Verbatim Latitude String 50  
Verbatim Longitude String 50  
Version Integer    
Visibility Byte    
Yes No1 Boolean    
Yes No2 Boolean    
Yes No3 Boolean    
Yes No4 Boolean    
Yes No5 Boolean    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ZeroOrOne geoCoordDetails Geo Coord Detail
ManyToOne geography Geography
OneToMany latLonpolygons Lat Lon Polygon
OneToMany localityAttachments Locality Attachment
OneToMany localityCitations Locality Citation
ZeroOrOne localityDetails Locality Detail
OneToMany localityNameAliass Locality Name Alias
ManyToOne modifiedByAgent Agent
ManyToOne paleoContext Paleo Context
ManyToOne visibilitySetBy Specify User


Locality Attachment
Field Type Length Descriptions
LocalityAttachmentID Integer   Primary Key
Ordinal Integer    
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne locality Locality
ManyToOne modifiedByAgent Agent


Locality Citation
Field Type Length Descriptions
LocalityCitationID Integer   Primary Key
Remarks Memo 4096 Additional Comments
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne locality Locality
ManyToOne modifiedByAgent Agent
ManyToOne referenceWork Reference Work


Locality Detail
Field Type Length Descriptions
LocalityDetailID Integer   Primary Key
Base Meridian String 50  
Drainage String 64  
End Depth Double    
End Depth Unit String 23  
End Depth Verbatim String 32  
Gml Memo    
HUC Code String 16  
Island String 64  
Island Group String 64  
Mgrs Zone String 4  
National Park Name String 64  
Number1 Double    
Number2 Double    
Number3 Float    
Number4 Float    
Number5 Float    
Paleo Latitude String 32  
Paleo Longitude String 32  
Range String 50  
Range Direction String 50  
Section String 50  
Section Part String 50  
Start Depth Double    
Start Depth Unit String 23  
Start Depth Verbatim String 32  
Text1 Memo 65535  
Text2 Memo 65535  
Text3 Memo 65535  
Text4 Memo 65535  
Text5 Memo 65535  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Township String 50  
Township Direction String 50  
UTM Datum String 32  
UTM Easting BigDecimal    
UTM False Easting Integer    
UTM False Northing Integer    
UTM Northing BigDecimal    
UTM Orig Latitude BigDecimal    
UTM Orig Longitude BigDecimal    
UTM Scale BigDecimal    
UTM Zone Short    
Version Integer    
Water Body String 64  
Yes No1 Boolean    
Yes No2 Boolean    
Yes No3 Boolean    
Yes No4 Boolean    
Yes No5 Boolean    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne locality Locality
ManyToOne modifiedByAgent Agent


Locality Name Alias
Field Type Length Descriptions
LocalityNameAliasID Integer   Primary Key
Name String 255 The alias for the locality name.
Source String 64 The source of the alias.
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne locality Locality
ManyToOne modifiedByAgent Agent


Material Sample
Field Type Length Descriptions
MaterialSampleID Integer   Primary Key
Absorb Ratio 260_230 Float    
Absorb Ratio 260_280 Float    
Absorb Ratio Method String 64  
Concentration Float    
Concentration Unit String 64  
Sample Type String 64  
Medium String 64  
Purification Method String 64  
Quality String 64  
Quality Check Date Calendar    
Quality Remarks Memo 4096  
Sample Designation String 128  
Sample Size Float    
Volume Float    
Volume Unit String 64  
Weight Float    
Weight Method String 64  
Weight Unit String 64  
Collection Member Id Integer    
Guid String 128  
Integer1 Integer    
Integer2 Integer    
Number1 Float    
Number2 Float    
Remarks Memo 4096  
Reserved Integer3 Integer    
Reserved Integer4 Integer    
Reserved Number3 Float    
Reserved Number4 Float    
Reserved Text3 Memo 4096  
Reserved Text4 Memo 4096  
SRA Bio Project ID String 64  
SRA Bio Sample ID String 64  
SRA Project ID String 64  
SRA Sample ID String 64  
Text1 Memo 4096  
Text2 Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Yes No1 Boolean    
Yes No2 Boolean    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
OneToMany dnaSequences DNA Sequence
ManyToOne modifiedByAgent Agent
ManyToOne preparation Preparation


Morph Bank View
Field Type Length Descriptions
MorphBankViewID Integer   Primary Key
Development State String 128  
Form String 128  
Imaging Preparation Technique String 128  
Imaging Technique String 128  
Morph Bank External View Id Integer    
Sex String 32  
Specimen Part String 128  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
View Angle String 128  
View Name String 128  
Relationships
Type Name To Table
OneToMany attachmentImageAttributes Attachment Image Attribute
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Other Identifier
Field Type Length Descriptions
OtherIdentifierID Integer   Primary Key
Collection Member Id Integer    
Identifier String 64  
Institution String 64  
Remarks Memo 4096 Additional Comments
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne collectionObject Collection Object
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Paleo Context
Field Type Length Descriptions
PaleoContextID Integer   Primary Key
Number1 Double    
Number2 Double    
Number3 Double    
Number4 Double    
Number5 Double    
Context Name String 80  
Remarks Memo 4096  
Bio Strat String 64  
Text2 String 64  
Text3 String 500  
Text4 String 500  
Text5 String 500  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Yes No1 Boolean    
Yes No2 Boolean    
Yes No3 Boolean    
Yes No4 Boolean    
Yes No5 Boolean    
Relationships
Type Name To Table
ManyToOne bioStrat Chronostratigraphy
ManyToOne chronosStrat Chronostratigraphy
ManyToOne chronosStratEnd Chronostratigraphy
OneToMany collectingEvents Collecting Event
OneToMany collectionObjects Collection Object
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne lithoStrat Lithostratigraphy
OneToMany localities Locality
ManyToOne modifiedByAgent Agent


Permit
Field Type Length Descriptions
PermitID Integer   Primary Key
Copyright String 256  
End Date Calendar   Date permit expires
Is Available Boolean    
Is Required Boolean    
Issued Date Calendar   Date permit was issued
Number1 Float 24 User definable
Number2 Float 24 User definable
Permit Number String 50 Identifier for the permit
Permit Text Memo 4096  
Remarks Memo 4096 Additional Comments
Renewal Date Calendar   Date of renewal
Reserved Integer1 Integer    
Reserved Integer2 Integer    
Reserved Text3 String 128  
Reserved Text4 String 128  
Start Date Calendar   Date permit becomes effective
Status String 64  
Status Qualifier String 128  
Text1 Memo 65535 User definable
Text2 Memo 65535 User definable
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Type String 50 Permit category - `CITES`, `Migratory Bird Treaty Act`, ...
Version Integer    
Yes No1 Boolean   User definable
Yes No2 Boolean   User definable
Relationships
Type Name To Table
OneToMany accessionAuthorizations Accession Authorization
ManyToOne createdByAgent Agent
ManyToOne institution Institution
ManyToOne issuedBy Agent
ManyToOne issuedTo Agent
ManyToOne modifiedByAgent Agent
OneToMany permitAttachments Permit Attachment


Permit Attachment
Field Type Length Descriptions
PermitAttachmentID Integer   Primary Key
Ordinal Integer    
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne permit Permit


Pick List
Field Type Length Descriptions
PickListID Integer   Primary Key
Field Name String 64  
Filter Field Name String 32  
Filter Value String 32  
Formatter String 64  
Is System Boolean   Where system form rely on this picklist, not user defined
Name String 64  
Read Only Boolean    
Size Limit Integer 10  
Sort Type Byte    
Table Name String 64  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Type Byte    
Version Integer    
Relationships
Type Name To Table
ManyToOne collection Collection
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
OneToMany pickListItems Pick List Item


Pick List Item
Field Type Length Descriptions
PickListItemID Integer   Primary Key
Ordinal Integer    
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Title String 128  
Value String 128  
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne pickList Pick List


Preparation
Field Type Length Descriptions
PreparationID Integer   Primary Key
Collection Member Id Integer    
Count Integer   Number of items
Description String 255  
Guid String 128  
Integer1 Integer    
Integer2 Integer    
Number1 Float    
Number2 Float    
Prepared Date Calendar    
Prepared Date Precision Byte    
Remarks Memo 4096 Additional Comments
Reserved Integer3 Integer    
Reserved Integer4 Integer    
Sample Number String 32  
Status String 32  
Storage Location String 50  
Text1 Memo 65535 User definable
Text2 Memo 65535 User definable
Text3 Memo 65535  
Text4 Memo 65535  
Text5 Memo 65535  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Yes No1 Boolean    
Yes No2 Boolean    
Yes No3 Boolean    
Relationships
Type Name To Table
ManyToOne collectionObject Collection Object
ManyToOne createdByAgent Agent
OneToMany deaccessionPreparations Deaccession Preparation
OneToMany exchangeInPreps Exchange In Prep
OneToMany exchangeOutPreps Exchange Out Prep
OneToMany giftPreparations Gift Preparation
OneToMany loanPreparations Loan Preparation
OneToMany materialSamples Material Sample
ManyToOne modifiedByAgent Agent
ManyToOne prepType Preparation Type
OneToMany preparationAttachments Preparation Attachment
ManyToOne preparationAttribute Preparation Attribute
OneToMany preparationAttrs Preparation Attribute
ManyToOne preparedByAgent Agent
ManyToOne storage Storage


Preparation Attachment
Field Type Length Descriptions
PreparationAttachmentID Integer   Primary Key
Collection Member Id Integer    
Ordinal Integer    
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne preparation Preparation


Preparation Attribute
Field Type Length Descriptions
AttrID Integer   Primary Key
Collection Member Id Integer    
Double Value Double    
String Value String 255  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne definition Attribute Definition
ManyToOne modifiedByAgent Agent
ManyToOne preparation Preparation


Preparation Attribute
Field Type Length Descriptions
PreparationAttributeID Integer   Primary Key
Attr Date Calendar 10  
Collection Member Id Integer    
Number1 Float    
Number2 Float    
Number3 Float    
Number4 Integer    
Number5 Integer    
Number6 Integer    
Number7 Integer    
Number8 Integer    
Number9 Short    
Remarks Memo 4096  
Text1 Memo 65535  
Text10 Memo 65535  
Text11 String 50  
Text12 String 50  
Text13 String 50  
Text14 String 50  
Text15 String 50  
Text16 String 50  
Text17 String 50  
Text18 String 50  
Text19 String 50  
Text2 Memo 65535  
Text20 String 50  
Text21 String 50  
Text22 String 50  
Text23 String 50  
Text24 String 50  
Text25 String 50  
Text26 String 50  
Text3 String 50  
Text4 String 50  
Text5 String 50  
Text6 String 50  
Text7 String 50  
Text8 String 50  
Text9 String 50  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Yes No1 Boolean    
Yes No2 Boolean    
Yes No3 Boolean    
Yes No4 Boolean    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
OneToMany preparations Preparation


Preparation Type
Field Type Length Descriptions
PrepTypeID Integer   Primary Key
Is Loanable Boolean    
Name String 64  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
OneToMany attributeDefs Attribute Definition
ManyToOne collection Collection
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Project
Field Type Length Descriptions
ProjectID Integer   Primary Key
Collection Member Id Integer    
End Date Calendar   Date project ended
Grant Agency String 64  
Grant Number String 64  
Number1 Float 24 User definable
Number2 Float 24 User definable
Description String 255 Description of project
Project Name String 128 Name of the project
Project Number String 64  
Remarks Memo 4096 Additional Comments
Start Date Calendar   Date project began
Text1 Memo 65535 User definable
Text2 Memo 65535 User definable
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
URL String 1024 URL for project
Version Integer    
Yes No1 Boolean   User definable
Yes No2 Boolean   User definable
Relationships
Type Name To Table
ManyToOne agent Agent
ManyToMany collectionObjects Collection Object
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Record Set
Field Type Length Descriptions
RecordSetID Integer   Primary Key
All Permission Level Integer    
Collection Member Id Integer    
Database Table Id Integer    
Group Permission Level Integer    
Name String 64  
Owner Permission Level Integer    
Remarks Memo 4096 Additional Comments
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Type Byte    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne group Sp Principal
ManyToOne infoRequest Information Request
ManyToOne modifiedByAgent Agent
OneToMany recordSetItems Record Set Item
ManyToOne specifyUser Specify User


Record Set Item
Field Type Length Descriptions
RecordSetItemID Integer   Primary Key
Order Integer    
Record Id Integer    
Relationships
Type Name To Table
ManyToOne recordSet Record Set


Reference Work
Field Type Length Descriptions
ReferenceWorkID Integer   Primary Key
GUID String 128  
Is Published Boolean    
ISBN String 16  
Library Number String 50  
Number1 Float   User definable
Number2 Float   User definable
Pages String 50 Number of pages or Page range for Journal articles
Place Of Publication String 50  
Publisher String 250  
Type Byte   Type of Reference (Book(0), Electronic Media(1), Paper(2), Technical Report(3), Thesis(4), Section in book(5))
Remarks Memo 4096 Additional Comments
Text1 Memo 65535 User definable
Text2 Memo 65535 User definable
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Title String 255 Title of reference
Url String 1024  
Version Integer    
Volume String 25 Volume/Issue for Journal articles
Work Date String 25  
Yes No1 Boolean   User definable
Yes No2 Boolean   User definable
Relationships
Type Name To Table
OneToMany authors Author
OneToMany collectionObjectCitations Collection Object Citation
ManyToOne containedRFParent Reference Work
OneToMany containedReferenceWorks Reference Work
ManyToOne createdByAgent Agent
OneToMany determinationCitations Determination Citation
OneToMany exsiccatae Exsiccata
ManyToOne institution Institution
ManyToOne journal Journal
OneToMany localityCitations Locality Citation
ManyToOne modifiedByAgent Agent
OneToMany referenceWorkAttachments Reference Work Attachment
OneToMany taxonCitations Taxon Citation


Reference Work Attachment
Field Type Length Descriptions
ReferenceWorkAttachmentID Integer   Primary Key
Ordinal Integer    
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne referenceWork Reference Work


Repository Agreement
Field Type Length Descriptions
RepositoryAgreementID Integer   Primary Key
Date Received Calendar    
End Date Calendar    
Number1 Float   User definable
Number2 Float   User definable
Remarks Memo 4096 Additional Comments
RA Number String 60  
Start Date Calendar    
Status String 32  
Text1 String 255 User definable
Text2 String 255 User definable
Text3 String 255 User definable
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Yes No1 Boolean   User definable
Yes No2 Boolean   User definable
Relationships
Type Name To Table
OneToMany accessions Accession
ManyToOne addressOfRecord Address Of Record
ManyToOne createdByAgent Agent
ManyToOne division Division
ManyToOne modifiedByAgent Agent
ManyToOne originator Agent
OneToMany repositoryAgreementAgents Accession Agent
OneToMany repositoryAgreementAttachments Repository Agreement Attachment
OneToMany repositoryAgreementAuthorizations Accession Authorization


Repository Agreement Attachment
Field Type Length Descriptions
RepositoryAgreementAttachmentID Integer   Primary Key
Ordinal Integer    
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne repositoryAgreement Repository Agreement


Shipment
Field Type Length Descriptions
ShipmentID Integer   Primary Key
Insured For Amount String 50  
Number1 Float 24 User definable
Number2 Float 24 User definable
Num Of Packages Short   Number of packages shipped
Remarks Memo 4096 Additional Comments
Shipment Date Calendar   Date of shipment
Method String 50 Description of shipment. E.g. `Hand-carried`, `Overnight`, `Air`, `Land`, `Sea`, ...
Shipment Number String 50 Shipper`s tracking number
Text1 Memo 65535 User definable
Text2 Memo 65535 User definable
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Weight String 50 The weight of the shipment
Yes No1 Boolean   User definable
Yes No2 Boolean   User definable
Relationships
Type Name To Table
ManyToOne borrow Borrow
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne exchangeOut Exchange Out
ManyToOne gift Gift
ManyToOne loan Loan
ManyToOne modifiedByAgent Agent
ManyToOne shippedBy Agent
ManyToOne shippedTo Agent
ManyToOne shipper Agent


App Resource
Field Type Length Descriptions
SpAppResourceID Integer   Primary Key
All Permission Level Integer    
Description String 255  
Group Permission Level Integer    
Level Short    
Meta Data String 255  
Mime Type String 255  
Name String 64  
Owner Permission Level Integer    
Timestamp Created Timestamp   The timestamp the record was created.
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne group Sp Principal
ManyToOne modifiedByAgent Agent
OneToMany spAppResourceDatas App Resource Data
ManyToOne spAppResourceDir App Resource Default
OneToMany spReports Sp Report
ManyToOne specifyUser Specify User


App Resource Data
Field Type Length Descriptions
SpAppResourceDataID Integer   Primary Key
Data Memo 16000000  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne spAppResource App Resource
ManyToOne spViewSetObj View Set Object


App Resource Default
Field Type Length Descriptions
SpAppResourceDirID Integer   Primary Key
Discipline Type String 64  
Is Personal Boolean    
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
User Group String 64  
Version Integer    
Relationships
Type Name To Table
ManyToOne collection Collection
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne modifiedByAgent Agent
OneToMany spPersistedAppResources App Resource
OneToMany spPersistedViewSets View Set Object
ManyToOne specifyUser Specify User


Sp Audit Log
Field Type Length Descriptions
SpAuditLogID Integer   Primary Key
Action Byte    
Parent Record Id Integer    
Parent Table Num Short    
Record Id Integer    
Record Version Integer    
Table Num Short    
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
OneToMany fields Sp Audit Log Field
ManyToOne modifiedByAgent Agent


Sp Audit Log Field
Field Type Length Descriptions
SpAuditLogFieldID Integer   Primary Key
Field Name String 32  
New Value String 64  
Old Value String 64  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne spAuditLog Sp Audit Log


Specify User
Field Type Length Descriptions
SpecifyUserID Integer   Primary Key
Accumulated Minutes Logged In Long    
Email String 64  
Is Logged In Boolean    
Is Logged In Report Boolean    
Login Collection Name String 64  
Login Discipline Name String 64  
Login Out Time Timestamp    
Name String 64  
Password String 255  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
User Group String 32  
Version Integer    
Relationships
Type Name To Table
OneToMany agents Agent
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
OneToMany spAppResourceDirs App Resource Default
OneToMany spAppResources App Resource
ManyToMany spPrincipals Sp Principal
OneToMany spQuerys Sp Query
OneToMany taskSemaphores Sp Task Semaphore
OneToMany workbenchTemplates WorkBench Template
OneToMany workbenches WorkBench


Sp Export Schema
Field Type Length Descriptions
SpExportSchemaID Integer   Primary Key
Description String 255  
Schema Name String 80  
Schema Version String 80  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne modifiedByAgent Agent
OneToMany spExportSchemaItems Sp Export Schema Item
ManyToMany spExportSchemaMappings Sp Export Schema Mapping


Sp Export Schema Item
Field Type Length Descriptions
SpExportSchemaItemID Integer   Primary Key
Data Type String 32  
Description String 255  
Field Name String 64  
Formatter String 32  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne spExportSchema Sp Export Schema
ManyToOne spLocaleContainerItem Locale Container Item


Sp Export Schema Item Mapping
Field Type Length Descriptions
SpExportSchemaItemMappingID Integer   Primary Key
Exported Field Name String 64  
Remarks String 255  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne exportSchemaItem Sp Export Schema Item
ManyToOne exportSchemaMapping Sp Export Schema Mapping
ManyToOne modifiedByAgent Agent
ManyToOne queryField Sp Query Field


Sp Export Schema Mapping
Field Type Length Descriptions
SpExportSchemaMappingID Integer   Primary Key
Collection Member Id Integer    
Description String 255  
Mapping Name String 50  
Timestamp Created Timestamp    
Timestamp Exported Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
OneToMany mappings Sp Export Schema Item Mapping
ManyToOne modifiedByAgent Agent
ManyToMany spExportSchemas Sp Export Schema
OneToMany symbiotaInstances Sp Symbiota Instance


Sp Field Value Default
Field Type Length Descriptions
SpFieldValueDefaultID Integer   Primary Key
Collection Member Id Integer    
Field Name String 32  
Id Value Integer    
Str Value String 64  
Table Name String 32  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


Locale Container
Field Type Length Descriptions
SpLocaleContainerID Integer   Primary Key
Aggregator String 64  
Default U I String 64  
Format String 64  
Is Hidden Boolean    
Is System Boolean    
Is U I Formatter Boolean    
Name String 64  
Pick List Name String 64  
Schema Type Byte   The type of schema it belongs to: the core schema or the workbench schema
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Type String 32  
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
OneToMany descs Locale Item String
ManyToOne discipline Discipline
OneToMany items Locale Container Item
ManyToOne modifiedByAgent Agent
OneToMany names Locale Item String


Locale Container Item
Field Type Length Descriptions
SpLocaleContainerItemID Integer   Primary Key
Format String 64  
Is Hidden Boolean    
Is Required Boolean 32  
Is System Boolean    
Is U I Formatter Boolean    
Name String 64  
Pick List Name String 64  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Type String 32  
Version Integer    
Web Link Name String 32  
Relationships
Type Name To Table
ManyToOne container Locale Container
ManyToOne createdByAgent Agent
OneToMany descs Locale Item String
ManyToOne modifiedByAgent Agent
OneToMany names Locale Item String
OneToMany spExportSchemaItems Sp Export Schema Item


Locale Item String
Field Type Length Descriptions
SpLocaleItemStrID Integer   Primary Key
Country String 2  
Language String 2  
Text String 255  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Variant String 2  
Version Integer    
Relationships
Type Name To Table
ManyToOne containerDesc Locale Container
ManyToOne containerName Locale Container
ManyToOne createdByAgent Agent
ManyToOne itemDesc Locale Container Item
ManyToOne itemName Locale Container Item
ManyToOne modifiedByAgent Agent


Sp Permission
Field Type Length Descriptions
SpPermissionID Integer   Primary Key
Actions String 256  
Name String 64  
Permission Class String 256  
Target Id Integer    
Relationships
Type Name To Table
ManyToMany principals Sp Principal


Sp Principal
Field Type Length Descriptions
SpPrincipalID Integer   Primary Key
Group Sub Class String 255  
Group Type String 32  
Name String 64  
Priority Byte    
Remarks Memo    
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToMany permissions Sp Permission
ManyToOne scope usergroupscope
ManyToMany specifyUsers Specify User


Sp Query
Field Type Length Descriptions
SpQueryID Integer   Primary Key
Context Name String 64  
Context Table Id Short    
Count Only Boolean    
Is Favorite Boolean    
Name String 64  
Ordinal Short    
Remarks Memo 4096  
Search Synonymy Boolean    
Select Distinct Boolean    
Smushed Boolean    
Sql Str Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
OneToMany fields Sp Query Field
ManyToOne modifiedByAgent Agent
OneToMany reports Sp Report
ManyToOne specifyUser Specify User


Sp Query Field
Field Type Length Descriptions
SpQueryFieldID Integer   Primary Key
Allow Nulls Boolean    
Always Filter Boolean    
Column Alias String 64  
Context Table Ident Integer    
End Value String 255  
Field Name String 32  
Format Name String 64  
Is Display Boolean    
Is Not Boolean    
Is Prompt Boolean    
Is Rel Fld Boolean    
Oper End Byte    
Oper Start Byte    
Position Short    
Sort Type Byte    
Start Value String 255  
String Id String 500  
Table List String 500  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
OneToMany mappings Sp Export Schema Item Mapping
ManyToOne modifiedByAgent Agent
ManyToOne query Sp Query


Sp Report
Field Type Length Descriptions
SpReportId Integer   Primary Key
Name String 64  
Remarks Memo 4096  
Repeat Count Integer    
Repeat Field String 255  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne appResource App Resource
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne query Sp Query
ManyToOne specifyUser Specify User
OneToOne workbenchTemplate WorkBench Template


Sp Symbiota Instance
Field Type Length Descriptions
SpSymbiotaInstanceID Integer   Primary Key
Collection Member Id Integer    
Description String 256  
Instance Name String 256  
Last Cache Build Calendar    
Last Pull Calendar    
Last Push Calendar    
Remarks Memo    
Symbiota Key String 128  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne schemaMapping Sp Export Schema Mapping


Sp Task Semaphore
Field Type Length Descriptions
TaskSemaphoreID Integer   Primary Key
Context String 32  
Is Locked Boolean    
Locked Time Timestamp    
Machine Name String 64  
Scope Byte    
Task Name String 32  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Usage Count Integer    
Version Integer    
Relationships
Type Name To Table
ManyToOne collection Collection
ManyToOne createdByAgent Agent
ManyToOne discipline Discipline
ManyToOne modifiedByAgent Agent
ManyToOne owner Specify User


Sp Version
Field Type Length Descriptions
SpVersionID Integer   Primary Key
App Name String 32  
App Version String 16  
Db Closed By String 32  
Is D B Closed Boolean    
Schema Version String 16  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Workbench Schema Version String 16  
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent


View Set Object
Field Type Length Descriptions
SpViewSetObjID Integer   Primary Key
Description String 255  
File Name String 255  
Level Short    
Meta Data String 255  
Name String 64  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
OneToMany spAppResourceDatas App Resource Data
ManyToOne spAppResourceDir App Resource Default


Sp Visual Query
Field Type Length Descriptions
SpVisualQueryID Integer   Primary Key
Description Memo 4096  
Name String 64  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
OneToMany polygons Lat Lon Polygon
ManyToOne specifyUser Specify User


Storage
Field Type Length Descriptions
StorageID Integer   Primary Key
Abbreviation String 16  
Full Name String 255  
Highest Child Node Number Integer    
Is Preferred Boolean    
Name String 64  
Node Number Integer    
Number1 Integer   User definable
Number2 Integer   User definable
Rank Id Integer    
Remarks Memo 4096 Additional Comments
Text1 String 32 User definable
Text2 String 32 User definable
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Timestamp Version Date    
Version Integer    
Relationships
Type Name To Table
OneToMany acceptedChildren Storage
ManyToOne acceptedStorage Storage
OneToMany children Storage
OneToMany containers Container
ManyToOne createdByAgent Agent
ManyToOne definition Storage Tree Definition
ManyToOne definitionItem Storage Tree Definition Item
ManyToOne modifiedByAgent Agent
ManyToOne parent Storage
OneToMany preparations Preparation
OneToMany storageAttachments Storage Attachment


Storage Attachment
Field Type Length Descriptions
StorageAttachmentID Integer   Primary Key
Ordinal Integer    
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne storage Storage


Storage Tree Definition
Field Type Length Descriptions
StorageTreeDefID Integer   Primary Key
Full Name Direction Integer    
Name String 64  
Remarks Memo 4096 Additional Comments
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
OneToMany institutions Institution
ManyToOne modifiedByAgent Agent
OneToMany treeDefItems Storage Tree Definition Item
OneToMany treeEntries Storage


Storage Tree Definition Item
Field Type Length Descriptions
StorageTreeDefItemID Integer   Primary Key
Full Name Separator String 32  
Is Enforced Boolean    
Is In Full Name Boolean    
Name String 64  
Rank Id Integer    
Remarks Memo 4096 Additional Comments
Text After String 64 User definable
Text Before String 64 User definable
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Title String 64  
Version Integer    
Relationships
Type Name To Table
OneToMany children Storage Tree Definition Item
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne parent Storage Tree Definition Item
ManyToOne treeDef Storage Tree Definition
OneToMany treeEntries Storage


Taxon
Field Type Length Descriptions
TaxonID Integer   Primary Key
Author String 128  
CITES Status String 32  
Col Status String 32  
Common Name String 128  
Cultivar Name String 32  
Environmental Protection Status String 64  
ESA Status String 64  
Full Name String 255  
Group Number String 20 Taxonomic group number
GUID String 128  
Highest Child Node Number Integer    
Integer1 Long    
Integer2 Long    
Integer3 Long    
Integer4 Integer    
Integer5 Integer    
Is Preferred Boolean    
Is Hybrid Boolean    
ISIS Number String 16  
Label Format String 64  
Name String 64  
NCBI Taxon Number String 8  
Node Number Integer    
Number 1 Integer    
Number 2 Integer    
Number3 Float    
Number4 Float    
Number5 Float    
Rank ID Integer    
Remarks Memo 4096 Additional Comments
Source String 64 If the record has been imported then this field holds information about the authority file it was obtained from, else it is user-editable.
Taxonomic Serial Number String 50 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
Text 1 String 32  
Text10 String 128  
Text11 String 128  
Text12 String 128  
Text13 String 128  
Text14 String 256  
Text15 String 256  
Text16 String 256  
Text17 String 256  
Text18 String 256  
Text19 String 256  
Text 2 String 32  
Text20 String 256  
Text3 Memo 65535  
Text4 Memo 65535  
Text5 Memo 65535  
Text6 Memo 65535  
Text7 Memo 65535  
Text8 Memo 65535  
Text9 Memo 65535  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Unit Ind1 String 50  
Unit Ind2 String 50  
Unit Ind3 String 50  
Unit Ind4 String 50  
Unit Name1 String 50  
Unit Name2 String 50  
Unit Name3 String 50  
Unit Name4 String 50  
USFWS Code String 16  
Version Integer    
Visibility Byte    
Yes No1 Boolean    
Yes No10 Boolean    
Yes No11 Boolean    
Yes No12 Boolean    
Yes No13 Boolean    
Yes No14 Boolean    
Yes No15 Boolean    
Yes No16 Boolean    
Yes No17 Boolean    
Yes No18 Boolean    
Yes No19 Boolean    
Yes No2 Boolean    
Yes No3 Boolean    
Yes No4 Boolean    
Yes No5 Boolean    
Yes No6 Boolean    
Yes No7 Boolean    
Yes No8 Boolean    
Yes No9 Boolean    
Relationships
Type Name To Table
OneToMany acceptedChildren Taxon
ManyToOne acceptedTaxon Taxon
OneToMany children Taxon
OneToMany collectingEventAttributes Collecting Event Attribute
OneToMany commonNames Common Name
ManyToOne createdByAgent Agent
ManyToOne definition Taxon Tree Definition
ManyToOne definitionItem Taxon Tree Definition Item
OneToMany determinations Determination
OneToMany hybridChildren1 Taxon
OneToMany hybridChildren2 Taxon
ManyToOne hybridParent1 Taxon
ManyToOne hybridParent2 Taxon
ManyToOne modifiedByAgent Agent
ManyToOne parent Taxon
OneToMany taxonAttachments Taxon Attachment
OneToMany taxonCitations Taxon Citation
ManyToOne visibilitySetBy Specify User


Taxon Attachment
Field Type Length Descriptions
TaxonAttachmentID Integer   Primary Key
Ordinal Integer    
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne taxon Taxon


Taxon Citation
Field Type Length Descriptions
TaxonCitationID Integer   Primary Key
Number1 Float 24 User definable
Number2 Float 24 User definable
Remarks Memo 4096 Additional Comments
Text1 Memo 65535 User definable
Text2 Memo 65535 User definable
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Yes No1 Boolean   User definable
Yes No2 Boolean   User definable
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne referenceWork Reference Work
ManyToOne taxon Taxon


Taxon Tree Definition
Field Type Length Descriptions
TaxonTreeDefID Integer   Primary Key
Full Name Direction Integer    
Name String 64  
Remarks String 255 Additional Comments
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
OneToOne discipline Discipline
ManyToOne modifiedByAgent Agent
OneToMany treeDefItems Taxon Tree Definition Item
OneToMany treeEntries Taxon


Taxon Tree Definition Item
Field Type Length Descriptions
TaxonTreeDefItemID Integer   Primary Key
Format Token String 32  
Full Name Separator String 32  
Is Enforced Boolean    
Is In Full Name Boolean    
Name String 64  
Rank Id Integer    
Remarks Memo 4096 Additional Comments
Text After String 64 User definable
Text Before String 64 User definable
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Title String 64  
Version Integer    
Relationships
Type Name To Table
OneToMany children Taxon Tree Definition Item
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne parent Taxon Tree Definition Item
ManyToOne treeDef Taxon Tree Definition
OneToMany treeEntries Taxon


Treatment Event
Field Type Length Descriptions
TreatmentEventID Integer   Primary Key
Date Boxed Calendar    
Date Cleaned Calendar    
Date Completed Calendar    
Date Received Calendar    
Date To Isolation Calendar    
End Date Calendar    
Start Date Calendar    
Field Number String 50  
Location String 64  
Number1 Integer    
Number2 Integer    
Number3 Float    
Number4 Float    
Number5 Float    
Remarks Memo 2048  
Text1 Memo 65535  
Text2 Memo 65535  
Text3 Memo 65535  
Text4 Memo 65535  
Text5 Memo 65535  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Treat Number String 32  
Type String 32  
Version Integer    
Yes No1 Boolean    
Yes No2 Boolean    
Yes No3 Boolean    
Relationships
Type Name To Table
ManyToOne accession Accession
ManyToOne authorizedBy Agent
ManyToOne collectionObject Collection Object
ManyToOne createdByAgent Agent
ManyToOne division Division
ManyToOne modifiedByAgent Agent
ManyToOne performedBy Agent
OneToMany treatmentEventAttachments Treatment Event Attachment


Treatment Event Attachment
Field Type Length Descriptions
TreatmentEventAttachmentID Integer   Primary Key
Ordinal Integer    
Remarks Memo 4096  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne attachment Attachment
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne treatmentEvent Treatment Event


WorkBench
Field Type Length Descriptions
WorkbenchID Integer   Primary Key
All Permission Level Integer    
Database Table Id Integer    
Export Institution Name String 128  
Exported From Table Name String 128  
Form Id Integer    
Group Permission Level Integer    
Locked By User Name String 64  
Name String 64  
Owner Permission Level Integer    
Remarks Memo 4096 Additional Comments
Source File Path String 255  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne group Sp Principal
ManyToOne modifiedByAgent Agent
ManyToOne specifyUser Specify User
OneToMany workbenchRows Workbench Row
ManyToOne workbenchTemplate WorkBench Template


WorkBench Data Item
Field Type Length Descriptions
WorkbenchDataItemID Integer   Primary Key
Cell Data Memo    
Row Number Short    
Validation Status Short    
Relationships
Type Name To Table
ManyToOne workbenchRow Workbench Row
ManyToOne workbenchTemplateMappingItem WorkBench Template Mapping Item


Workbench Row
Field Type Length Descriptions
WorkbenchRowID Integer   Primary Key
Bio Geomancer Results Memo 8192 The XML returned from Bio Geomancer
Card Image Data Memo 16000000 A single image attached to the row
Card Image Full Path String 255 The full path of the image
Error Estimate BigDecimal    
Error Polygon Memo 65535  
Lat1 Text String 50  
Lat2 Text String 50  
Long1 Text String 50  
Long2 Text String 50  
Record Id Integer    
Row Number Short   The row number
Sgr Status Byte    
Upload Status Byte    
Relationships
Type Name To Table
ManyToOne workbench WorkBench
OneToMany workbenchDataItems WorkBench Data Item
OneToMany workbenchRowExportedRelationships Workbench Row Exported Relationship
OneToMany workbenchRowImages Workbench Row Image


Workbench Row Exported Relationship
Field Type Length Descriptions
WorkbenchRowExportedRelationshipID Integer   Primary Key
Record Id Integer    
Relationship Name String 120  
Sequence Integer    
Table Name String 120  
Timestamp Created Timestamp    
Timestamp Modified Timestamp    
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne workbenchRow Workbench Row


Workbench Row Image
Field Type Length Descriptions
WorkbenchRowImageID Integer   Primary Key
Attach To Table Name String 64  
Card Image Data Memo 16000000 The thumbnail data
Card Image Full Path String 255 The full path to the image
Image Order Integer   The position in the list of images
Relationships
Type Name To Table
ManyToOne workbenchRow Workbench Row


WorkBench Template
Field Type Length Descriptions
WorkbenchTemplateID Integer   Primary Key
Name String 64  
Remarks Memo 4096 Additional Comments
Source File Path String 255  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
ManyToOne specifyUser Specify User
OneToMany workbenchTemplateMappingItems WorkBench Template Mapping Item
OneToMany workbenches WorkBench


WorkBench Template Mapping Item
Field Type Length Descriptions
WorkbenchTemplateMappingItemID Integer   Primary Key
Caption String 64  
Carry Forward Boolean    
Data Field Length Short    
Field Name String 255  
Field Type Short    
Imported Column Name String 255  
Is Editable Boolean    
Is Exportable To Content Boolean    
Is Included In Title Boolean    
Is Required Boolean    
Meta Data String 128  
Original Import Column Index Short    
Source Table Id Integer 64  
Table Name String 64  
Timestamp Created Timestamp   The timestamp the record was created.
Timestamp Modified Timestamp   The timestamp the record was last modified.
Version Integer    
View Order Short    
X Coordinate Short    
Y Coordinate Short    
Relationships
Type Name To Table
ManyToOne createdByAgent Agent
ManyToOne modifiedByAgent Agent
OneToMany workbenchDataItems WorkBench Data Item
ManyToOne workbenchTemplate WorkBench Template



Table Descriptions

Table Description
Accession  
Accession Agent  
Accession Attachment  
Accession Authorization  
Address  
Address Of Record  
Agent  
Agent Attachment  
Agent Geography  
Agent Specialty  
Agent Variant  
Appraisal  
Attachment  
Attachment Image Attribute  
Attachment MetadataMetadados  
Attachment Tag  
Attribute Definition  
Author  
Auto Numbering Scheme  
Borrow  
Borrow Agent  
Borrow Attachment  
Borrow Material  
Borrow Return Material  
Collecting Event  
Collecting Event Attachment  
Collecting Event Attribute  
Collecting Event Attribute  
Collecting Trip  
Collection  
Collection Object  
Collection Object Attachment  
Collection Object Attribute  
Collection Object Attribute  
Collection Object Citation  
Collection Relationship  
Collection Relationship Type  
Collector  
Common Name  
Common Name Tx Citation  
Conservator Description  
Conservator Description Attachment  
Conservator Event  
Conservator Event Attachment  
Container  
Data Type  
Deaccession  
Deaccession Agent  
Deaccession Preparation  
Determination  
Determination Citation  
Discipline  
Division  
DNA Primer  
DNA Sequence  
DNA Sequence Attachment  
D N A Sequencing Run Attachment  
DNA Sequencing Run  
D N A Sequencing Run Citation  
Exchange In  
Exchange In Prep  
Exchange Out  
Exchange Out Prep  
Exsiccata  
Exsiccata Item  
Field Notebook  
Field Notebook Attachment  
Field Notebook Page  
Field Notebook Page Attachment  
Field Notebook Page Set  
Field Notebook Page Set Attachment  
Funding Agent  
Geo Coord Detail  
Geography  
Geography Tree Definition  
Geography Tree Definition Item  
Chronostratigraphy  
Geological Time Period Tree Definition  
Geological Time Period Tree Definition Item  
Gift  
Gift Agent  
Gift Attachment  
Gift Preparation  
Group Person  
Information Request  
Institution  
Institution Network  
Journal  
Lat Lon Polygon  
Lat Lon Polygon Pnt  
Lithostratigraphy  
Lithostratigraphy Tree Definition  
Lithostratigraphy Tree Definition Item  
Loan  
Loan Agent  
Loan Attachment  
Loan Preparation  
Loan Return Preparation  
Locality  
Locality Attachment  
Locality Citation  
Locality Detail  
Locality Name Alias  
Material Sample  
Morph Bank View  
Other Identifier  
Paleo Context  
Permit  
Permit Attachment  
Pick List  
Pick List Item  
Preparation  
Preparation Attachment  
Preparation Attribute  
Preparation Attribute  
Preparation Type  
Project  
Record Set  
Record Set Item  
Reference Work  
Reference Work Attachment  
Repository Agreement  
Repository Agreement Attachment  
Shipment  
App Resource  
App Resource Data  
App Resource Default  
Sp Audit Log  
Sp Audit Log Field  
Specify User  
Sp Export Schema  
Sp Export Schema Item  
Sp Export Schema Item Mapping  
Sp Export Schema Mapping  
Sp Field Value Default  
Locale Container  
Locale Container Item  
Locale Item String  
Sp Permission  
Sp Principal  
Sp Query  
Sp Query Field  
Sp Report  
Sp Symbiota Instance  
Sp Task Semaphore  
Sp Version  
View Set Object  
Sp Visual Query  
Storage  
Storage Attachment  
Storage Tree Definition  
Storage Tree Definition Item  
Taxon  
Taxon Attachment  
Taxon Citation  
Taxon Tree Definition  
Taxon Tree Definition Item  
Treatment Event  
Treatment Event Attachment  
WorkBench  
WorkBench Data Item  
Workbench Row  
Workbench Row Exported Relationship  
Workbench Row Image  
WorkBench Template  
WorkBench Template Mapping Item  

Table Indexes

Index Name Column Name Table
DateAccessioned AccessionDateIDX Accession
AccessionNumber AccessionNumberIDX Accession
Abbreviation AbbreviationIDX Agent
FirstName AgentFirstNameIDX Agent
GUID AgentGuidIDX Agent
LastName AgentLastNameIDX Agent
AgentType AgentTypeIDX Agent
AppraisalDate AppraisalDateIDX Appraisal
AppraisalNumber AppraisalNumberIDX Appraisal
ScopeID AttchScopeIDIDX Attachment
ScopeType AttchScopeTypeIDX Attachment
GUID AttchmentGuidIDX Attachment
DateImaged DateImagedIDX Attachment
Title TitleIDX Attachment
SchemeName SchemeNameIDX Auto Numbering Scheme
CollectionMemberID BorColMemIDX Borrow
InvoiceNumber BorInvoiceNumberIDX Borrow
ReceivedDate BorReceivedDateIDX Borrow
CollectionMemberID BorColMemIDX2 Borrow Agent
CollectionMemberID BorMaterialColMemIDX Borrow Material
MaterialNumber BorMaterialNumberIDX Borrow Material
Description DescriptionIDX Borrow Material
CollectionMemberID BorrowReturnedColMemIDX Borrow Return Material
ReturnedDate BorrowReturnedDateIDX Borrow Return Material
EndDate CEEndDateIDX Collecting Event
GUID CEGuidIDX Collecting Event
StartDate CEStartDateIDX Collecting Event
StationFieldNumber CEStationFieldNumberIDX Collecting Event
CollectionMemberID CEAColMemIDX Collecting Event Attachment
CollectionMemberID COLEVATColMemIDX Collecting Event Attribute
DisciplineID COLEVATSDispIDX Collecting Event Attribute
CollectingTripName COLTRPNameIDX Collecting Trip
StartDate COLTRPStartDateIDX Collecting Trip
GUID CollectionGuidIDX Collection
CollectionName CollectionNameIDX Collection
AltCatalogNumber AltCatalogNumberIDX Collection Object
CollectionmemberID COColMemIDX Collection Object
CatalogNumber CatalogNumberIDX Collection Object
CatalogedDate CatalogedDateIDX Collection Object
GUID ColObjGuidIDX Collection Object
FieldNumber FieldNumberIDX Collection Object
CollectionMemberID COLOBJATTColMemIDX Collection Object Attachment
CollectionMemberID COLOBJATRSColMemIDX Collection Object Attribute
CollectionMemberID COLOBJATTRSColMemIDX Collection Object Attribute
CollectionMemberID COCITColMemIDX Collection Object Citation
DivisionID COLTRDivIDX Collector
Country CommonNameTxCountryIDX Common Name
Name CommonNameTxNameIDX Common Name
ShortDesc ConservDescShortDescIDX Conservator Description
completedDate ConservCompletedDateIDX Conservator Event
ExamDate ConservExamDateIDX Conservator Event
CollectionMemberID ContainerMemIDX Container
Name ContainerNameIDX Container
DeaccessionDate DeaccessionDateIDX Deaccession
DeaccessionNumber DeaccessionNumberIDX Deaccession
AlternateName AlterNameIDX Determination
CollectionMemberID DetMemIDX Determination
GUID DeterminationGuidIDX Determination
DeterminedDate DeterminedDateIDX Determination
TypeStatusName TypeStatusNameIDX Determination
CollectionMemberID DetCitColMemIDX Determination Citation
Name DisciplineNameIDX Discipline
Name DivisionNameIDX Division
PrimerDesignator DesignatorIDX DNA Primer
BOLDBarcodeID BOLDBarcodeIDX DNA Sequence
BOLDSampleID BOLDSampleIDX DNA Sequence
GenBankAccessionNumber GenBankAccIDX DNA Sequence
DescriptionOfMaterial DescriptionOfMaterialIDX Exchange In
ExchangeDate ExchangeDateIDX Exchange In
DisciplineID ExchgInPrepDspMemIDX Exchange In Prep
DescriptionOfMaterial DescriptionOfMaterialIDX2 Exchange Out
ExchangeDate ExchangeOutdateIDX Exchange Out
DisciplineID ExchgOutPrepDspMemIDX Exchange Out Prep
EndDate FNBEndDateIDX Field Notebook
Name FNBNameIDX Field Notebook
StartDate FNBStartDateIDX Field Notebook
PageNumber FNBPPageNumberIDX Field Notebook Page
ScanDate FNBPScanDateIDX Field Notebook Page
EndDate FNBPSEndDateIDX Field Notebook Page Set
StartDate FNBPSStartDateIDX Field Notebook Page Set
DivisionID COLTRIPDivIDX Funding Agent
FullName GeoFullNameIDX Geography
Name GeoNameIDX Geography
FullName GTPFullNameIDX Chronostratigraphy
GUID GTPGuidIDX Chronostratigraphy
Name GTPNameIDX Chronostratigraphy
GiftDate GiftDateIDX Gift
GiftNumber GiftNumberIDX Gift
DisciplineID GiftAgDspMemIDX Gift Agent
DisciplineID GiftPrepDspMemIDX Gift Preparation
CollectionMemberID IRColMemIDX Information Request
GUID InstGuidIDX Institution
Name InstNameIDX Institution
Name InstNetworkNameIDX Institution Network
GUID JournalGUIDIDX Journal
JournalName JournalNameIDX Journal
FullName LithoFullNameIDX Lithostratigraphy
GUID LithoGuidIDX Lithostratigraphy
Name LithoNameIDX Lithostratigraphy
CurrentDueDate CurrentDueDateIDX Loan
LoanDate LoanDateIDX Loan
LoanNumber LoanNumberIDX Loan
DisciplineID LoanAgDspMemIDX Loan Agent
DisciplineID LoanPrepDspMemIDX Loan Preparation
DisciplineID LoanRetPrepDspMemIDX Loan Return Preparation
ReturnedDate LoanReturnedDateIDX Loan Return Preparation
DisciplineID LocalityDisciplineIDX Locality
NamedPlace NamedPlaceIDX Locality
RelationToNamedPlace RelationToNamedPlaceIDX Locality
LocalityName localityNameIDX Locality
DisciplineID LocCitDspMemIDX Locality Citation
Name LocalityNameAliasIDX Locality Name Alias
GGBNSampleDesignation DesignationIDX Material Sample
CollectionMemberID OthIdColMemIDX Other Identifier
DisciplineID PaleoCxtDisciplineIDX Paleo Context
PaleoContextName PaleoCxtNameIDX Paleo Context
IssuedDate IssuedDateIDX Permit
PermitNumber PermitNumberIDX Permit
Name PickListNameIDX Pick List
CollectionMemberID PrepColMemIDX Preparation
GUID PrepGuidIDX Preparation
preparedDate PreparedDateIDX Preparation
CollectionMemberID PrepAttColMemIDX Preparation Attachment
CollectionMemberID PrepAttrColMemIDX Preparation Attribute
CollectionMemberID PrepAttrsColMemIDX Preparation Attribute
ProjectName ProjectNameIDX Project
ProjectNumber ProjectNumberIDX Project
name RecordSetNameIDX Record Set
ISBN ISBNIDX Reference Work
GUID RefWrkGuidIDX Reference Work
Publisher RefWrkPublisherIDX Reference Work
Title RefWrkTitleIDX Reference Work
RepositoryAgreementNumber RefWrkNumberIDX Repository Agreement
StartDate RefWrkStartDate Repository Agreement
ShipmentDate ShipmentDateIDX Shipment
DisciplineID ShipmentDspMemIDX Shipment
ShipmentMethod ShipmentMethodIDX Shipment
ShipmentNumber ShipmentNumberIDX Shipment
MimeType SpAppResMimeTypeIDX App Resource
Name SpAppResNameIDX App Resource
DisciplineType SpAppResourceDirDispTypeIDX App Resource Default
CollectionMemberID SPEXPSCHMMAPColMemIDX Sp Export Schema Mapping
CollectionMemberID SpFieldValueDefaultColMemIDX Sp Field Value Default
Name SpLocaleContainerNameIDX Locale Container
Name SpLocaleContainerItemNameIDX Locale Container Item
Country SpLocaleCountyIDX Locale Item String
Language SpLocaleLanguageIDX Locale Item String
Name SpQueryNameIDX Sp Query
Name SpReportNameIDX Sp Report
CollectionMemberID SPSYMINSTColMemIDX Sp Symbiota Instance
Name SpViewObjNameIDX View Set Object
Name SpVisualQueryNameIDX Sp Visual Query
FullName StorFullNameIDX Storage
Name StorNameIDX Storage
EnvironmentalProtectionStatus EnvironmentalProtectionStatusIDX Taxon
CommonName TaxonCommonNameIDX Taxon
FullName TaxonFullNameIDX Taxon
GUID TaxonGuidIDX Taxon
Name TaxonNameIDX Taxon
TaxonomicSerialNumber TaxonomicSerialNumberIDX Taxon
DateReceived TEDateReceivedIDX Treatment Event
DateTreatmentStarted TEDateTreatmentStartedIDX Treatment Event
FieldNumber TEFieldNumberIDX Treatment Event
TreatmentNumber TETreatmentNumberIDX Treatment Event
name WorkbenchNameIDX WorkBench
rowNumber DataItemRowNumberIDX WorkBench Data Item
RowNumber RowNumberIDX Workbench Row

Updated: 10-30-2017