Schema version: 2.7

Date generated: 2020-08-19

List of tables

Table Definitions

Back to top
Accession
Also called an acquisition. A consignment of specimens acquired either by field collecting of staff members, gifts, purchases, or exchange with another institution.
Field Type Length Description Flags
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 the 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. Required Indexed
Date Accessioned Calendar Date of Accession. Indexed
Date Acknowledged Calendar Date Acknowledged
Date Received Calendar Date material was received.
Integer1 Integer Integer1
Integer2 Integer Integer2
Integer3 Integer Integer3
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 Text 4096 Additional Comments.
Status String 32 Status of Accession, e.g. `In process`, `Complete` ...
Text1 Text 65535 User definable.
Text2 Text 65535 User definable.
Text3 Text 65535 User definable.
Text4 Text 65535 Text4
Text5 Text 65535 Text5
Timestamp Created Timestamp The date and time the record was created. Required
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 Version
Yes No1 Boolean User definable.
Yes No2 Boolean User definable.
Relationships
Type Target Table Field name
one-to-many accessionAgents
one-to-many accessionAttachments
one-to-many accessionAuthorizations
one-to-many accessionCitations
many-to-one addressOfRecord
one-to-many appraisals
one-to-many collectionObjects
many-to-one createdByAgent
one-to-many deaccessions
many-to-one division
many-to-one modifiedByAgent
many-to-one repositoryAgreement
one-to-many treatmentEvents
Back to top
Accession Agent
The person(s) requesting the Accession. This references an Agent.
Field Type Length Description Flags
Remarks Text 4096 Additional Comments.
Role String 50 Role the agent played in the accession process. Required
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one accession
many-to-one agent
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one repositoryAgreement
Back to top
Accession Attachment
An attachment for the Accession. This may be one or more PDF files of paperwork or a photo of the Accession.
Field Type Length Description Flags
Ordinal Integer Provides a sequential order for the attachments. Required
Remarks Text 4096 Additional comments.
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one accession
many-to-one attachment
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Accession Authorization
This represents the person authorizing the Accession. It references an existing Agent.
Field Type Length Description Flags
Remarks Text 4096 Additional comments.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one accession
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one permit
many-to-one repositoryAgreement
Back to top
Accession Citations
Accession Citations
Field Type Length Description Flags
Figure Number String 50 Figure Number
Is Figured Boolean None
Page Number String 50 None
Plate Number String 50 Plate Number
Remarks Text 4096 None
Timestamp Created Timestamp None Required
Timestamp Modified Timestamp None
Version Integer None
Relationships
Type Target Table Field name
many-to-one accession
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one referenceWork
Back to top
Address
The address of an Agent. This also captures a start and end date for the address and the position held while at the address.
Field Type Length Description Flags
Address String 255 Address as it should appear on mailing labels.
Address2 String 255 Second line of address (optional).
Address3 String 64 Address3
Address4 String 64 Address4
Address5 String 64 Address5
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 Text 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. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Type Of Addr String 32 Type Of Addr
Version Integer Version
Relationships
Type Target Table Field name
many-to-one agent
many-to-one createdByAgent
one-to-many divisions
one-to-many insitutions
many-to-one modifiedByAgent
Back to top
Address Of Record
This is the address when the legal action took place.
Field Type Length Description Flags
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 Text 4096 Additional comments.
State String 64 State of record.
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
one-to-many accessions
many-to-one agent
many-to-one createdByAgent
one-to-many exchangeIns
one-to-many exchangeOuts
one-to-many loans
many-to-one modifiedByAgent
one-to-many repositoryAgreements
Back to top
Agent
Contains information about people, groups, and organizations. Some roles for an agent include collector, determiner, preparer, cataloger, donor, issuer of permits, and so forth.
Field Type Length Description Flags
Abbreviation String 50 Abbreviation of organization. Indexed
Agent Type Byte Discriminator between Organization(0), Person(1), Other(2), and Group(3). Required Indexed
Date1 Calendar None
Date1 Precision Byte Date1 Precision
Date1 Calendar None
Date2 Precision Byte Date2 Precision
Date Of Birth Calendar Date agent was born.
Date Of Birth Precision Byte Date Of Birth Precision
Date Of Death Calendar Date Of Death
Date Of Death Precision Byte Date Of Death Precision
Date Type Byte Date Type
Email String 50 Email address for agent.
First Name String 50 First name of agent. Indexed
GUID String 128 Global Unique Identifier. Indexed
Initials String 8 Initials of agent.
Integer1 Integer Integer1
Integer2 Integer Integer2
Interests String 255 Interests of Person or Organization.
Job Title String 50 Agent`s (person) job title at the specified address and organization.
Last Name String 256 Last name of Person. Indexed
Middle Initial String 50 Middle initial of Person.
Remarks Text 4096 Additional comments.
Suffix String 50 Suffix
Text1 Text 65535 None
Text2 Text 65535 None
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Title String 50 Title of Person.
URL String 1024 A URL for the web site of a Person or Group.
Verbatim Date1 String 128 None
Verbatim Date2 String 128 None
Version Integer Version
Relationships
Type Target Table Field name
one-to-many addresses
one-to-many agentAttachments
one-to-many agentGeographies
one-to-many agentSpecialties
many-to-one collContentContact
many-to-one collTechContact
one-to-many collectors
many-to-one createdByAgent
many-to-one division
one-to-many groups
many-to-one instContentContact
many-to-one instTechContact
one-to-many members
many-to-one modifiedByAgent
one-to-many orgMembers
many-to-one organization
many-to-one specifyUser
one-to-many variants
Back to top
Agent Attachment
This table can be used for a picture of the agent or anything else used to further describe the agent.
Field Type Length Description Flags
Ordinal Integer This allows the attachments to be ordered. Required
Remarks Text 4096 Additional comments.
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one agent
many-to-one attachment
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Agent Geography
The geographical region that a particular collector was known for collecting in.
Field Type Length Description Flags
Remarks Text 4096 Additional comments.
Role String 64 Role of the agent as "author" or "collector" within the geography.
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one agent
many-to-one createdByAgent
many-to-one geography
many-to-one modifiedByAgent
Back to top
Agent Specialty
The Taxonomic specialty that a particular agent was known for.
Field Type Length Description Flags
Order Number Integer The priority of specialization, for agents with primary and secondary areas of specialization. Required
Specialty Name String 64 The name of the field of specialization. Required
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one agent
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Agent Variant
This is primarily used by Botanists for capturing Variant and Vernacular names. This table is searchable but does not have any specific business rules associated with it.
Field Type Length Description Flags
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. Required
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). Required
Variant String 2 Variant
Version Integer Version
Relationships
Type Target Table Field name
many-to-one agent
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Appraisal
The monetary appraisal of an Acession or Collection Object
Field Type Length Description Flags
Appraisal Date Calendar Date of the appraisal. Required Indexed
Appraisal Number String 64 Unique number for the appraisal. Required Unique Indexed
Appraisal Value Bigdecimal Monetary value of the appraisal.
Monetary Unit Type String 8 Type of monetary unit.
Notes Text 2048 Additional comments.
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one accession
many-to-one agent
one-to-many collectionObjects
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Attachment
The information in this record identifies everything the application will need to load and display the attachment. The attachment location is an absolute path to the file. The file itself is not stored in the database.
Field Type Length Description Flags
Attachment Location String 128 Location of attachment repository.
Attachment Storage Config Text Attachment Storage Config
Capture Device String 128 Capture Device
Copyright Date String 64 Date of the copyright of attachment.
Copyright Holder String 64 Copyright Holder
Credit String 64 Attachment credit.
Date Imaged String 64 Date Imaged Indexed
File Created Date Calendar File Created Date
GUID String 128 GUID Indexed
Is Public Boolean Is Public Required
License String 64 Attachment license information.
License Logo URL String 256 License Logo URL
Metadata Text String 256 Metadata Text
Mime Type String 64 Describes the attachment file type.
Original Filename String 20000 Original name of file. Required
Remarks Text 4096 Additional comments.
Scope ID Integer Scope ID Indexed
Scope Type Byte Scope Type Indexed
Subject Orientation String 64 Subject Orientation
Subtype String 64 Subtype
Table ID Short Table ID Required
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Title String 255 Title of attachment. Indexed
Type String 64 Type
Version Integer Version
Visibility Byte Visibility
Relationships
Type Target Table Field name
one-to-many accessionAttachments
one-to-many agentAttachments
many-to-one attachmentImageAttribute
one-to-many borrowAttachments
one-to-many collectingEventAttachments
one-to-many collectingTripAttachments
one-to-many collectionObjectAttachments
one-to-many conservDescriptionAttachments
one-to-many conservEventAttachments
many-to-one createdByAgent
many-to-one creator
one-to-many dnaSequenceAttachments
one-to-many dnaSequencingRunAttachments
one-to-many fieldNotebookAttachments
one-to-many fieldNotebookPageAttachments
one-to-many fieldNotebookPageSetAttachments
one-to-many giftAttachments
one-to-many loanAttachments
one-to-many localityAttachments
one-to-many metadata
many-to-one modifiedByAgent
one-to-many permitAttachments
one-to-many preparationAttachments
one-to-many referenceWorkAttachments
one-to-many repositoryAgreementAttachments
one-to-many storageAttachments
one-to-many tags
one-to-many taxonAttachments
one-to-many treatmentEventAttachments
many-to-one visibilitySetBy
Back to top
Attachment Image Attribute
Attachment Image Attribute
Field Type Length Description Flags
Creative Commons String 500 Creative Commons
Height Integer 24 Height
Image Type String 80 Image Type
Magnification Double 24 Magnification
Mb Image Id Integer 24 Mb Image Id
Number1 Double 24 Number1
Number2 Double 24 Number2
Remarks Text 4096 Remarks
Resolution Double 24 Resolution
Text1 String 200 None
Text2 String 200 Text2
Timestamp Created Timestamp Timestamp Created Required
Timestamp Last Send Timestamp Timestamp Last Send
Timestamp Last Update Check Timestamp Timestamp Last Update Check
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
View Description String 80 View Description
Width Integer 24 Width
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Relationships
Type Target Table Field name
one-to-many attachments
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one morphBankView
Back to top
Attachment MetadataMetadados
This holds metadata about the attachment. It is a set of named value pairs.
Field Type Length Description Flags
Name String 64 The name of the metadata field. Required
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Value String 128 The value of the metadata field. Required
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Attachment Tag
An attribute tag of an attachment. This consists of a single text field for storing a tag. In later versions, users will be allowed to search attachments by their tag.
Field Type Length Description Flags
Tag String 64 Name of tag. Required
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Attribute Definition
The definition of an attribute.
Field Type Length Description Flags
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. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
one-to-many collectingEventAttrs
one-to-many collectionObjectAttrs
many-to-one createdByAgent
many-to-one discipline
many-to-one modifiedByAgent
many-to-one prepType
one-to-many preparationAttrs
Back to top
Author
An Author is a reference to an Agent and provides the order for a list of authors of a Reference Work.
Field Type Length Description Flags
Order Number Short the order of AgentID relative to other authors of reference. Required
Remarks Text 4096 Additional comments.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one agent
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one referenceWork
Back to top
Auto Numbering Scheme
This is an internal table used to group parts of a collection with the same numbering scheme.
Field Type Length Description Flags
Format Name String 64 Format Name
Is Numeric Only Boolean Yes if number scheme is only numeric. Required
Schema Class Name String 64 Schema Class Name
Schema Name String 64 Name of the scheme (sequence). Indexed
Table Number Integer Table Number Required
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-many collections
many-to-one createdByAgent
many-to-many disciplines
many-to-many divisions
many-to-one modifiedByAgent
Back to top
Borrow
Contains information about loans from another institution. When one institution borrows a group of objects from another institution, all objects in the borrowed group share a common set of attributes that are defined for the loan.
Field Type Length Description Flags
Borrow Date Calendar Borrow Date
Borrow Date Precision Byte Borrow Date Precision
Collection Member Id Integer Collection Member Id Required Indexed
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. Required Indexed
Is Closed Boolean Indicates whether the borrow was closed (returned).
Is Financial Responsibility Boolean Is Financial Responsibility
Number1 Float 24 User definable.
Number2 Float 24 User definable.
Number Of Items Borrowed Integer 24 Number Of Items Borrowed
Original Due Date Calendar Original due date for loan.
Received Date Calendar Date material was received. Indexed
Remarks Text 4096 Additional comments.
Text1 Text 65535 User definable.
Text2 Text 65535 User definable.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Extension Granted Boolean User definable.
Yes No2 Boolean User definable.
Relationships
Type Target Table Field name
many-to-one addressOfRecord
one-to-many borrowAgents
one-to-many borrowAttachments
one-to-many borrowMaterials
many-to-one createdByAgent
many-to-one modifiedByAgent
one-to-many shipments
Back to top
Borrow Agent
Refers to an Agent and describes their role in the borrowing process.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Remarks Text 4096 Additional comments.
Role String 32 Role played by agent in the borrow. Required
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one agent
many-to-one borrow
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Borrow Attachment
Borrow Attachment
Field Type Length Description Flags
Ordinal Integer Ordinal Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one borrow
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Borrow Material
Describes the material being borrowed.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Description String 50 Description of the material. `e.g. Bufo bufo skull`. Indexed
In Comments Text 1024 Notes concerning the receipt of the material.
Material Number String 50 e.g. `FMNH 223456` Required Indexed
Out Comments Text 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 Text 6667 None
Text2 Text 6667 Text2
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one borrow
one-to-many borrowReturnMaterials
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Borrow Return Material
Describes the material that was returned.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Quantity Short Quantity of preparations returned.
Remarks Text 4096 Additional comments.
Returned Date Calendar The date the material was returned. Indexed
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one agent
many-to-one borrowMaterial
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Collecting Event
A collecting event is a place and time that a collection is made. In some disciplines, a field number is used as the primary designation for place and time information, while in others, locality name and date are used to link specimens.
Field Type Length Description Flags
End Date Calendar The date collecting event ended. Indexed
End Date Precision Byte End Date Precision
End Date Verbatim String 50 End Date Verbatim
End Time Short End time in military format.
GUID String 128 GUID Indexed
Integer1 Integer Integer1
Integer2 Integer Integer2
Method String 50 A method, such as net or trap, which is used to obtain the specimen.
Locality and Habitat Notes Text 4096 Field to record information on locality and habitat where specimen was collected.
Reserved Integer3 Integer Reserved Integer3
Reserved Integer4 Integer Reserved Integer4
Reserved Text1 String 128 Reserved Text1
Reserved Text2 String 128 Reserved Text2
Sgr Status Byte Sgr Status
Start Date Calendar The date collecting event began. Indexed
Start Date Precision Byte Start Date Precision
Start Date Verbatim String 50 Start Date Verbatim
Start Time Short Start time in military format.
Collector Number String 50 Collector Number Indexed
Station Field Number Modifier1 String 50 Station Field Number Modifier1
Station Field Number Modifier2 String 50 Station Field Number Modifier2
Station Field Number Modifier3 String 50 Station Field Number Modifier3
Text1 Text 65535 None
Text2 Text 65535 Text2
Text3 Text 65535 Text3
Text4 Text 65535 Text4
Text5 Text 65535 Text5
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Verbatim Date String 50 Date which collector recorded in a field book, exactly as reported by the collector. It should indicate whether reported as a range, season, month, etc.
Verbatim Locality Text 2048 Original statement (literal quotation) of the location of the Collecting Event as given by the Collector.
Version Integer Version
Visibility Byte Visibility
Relationships
Type Target Table Field name
one-to-many collectingEventAttachments
many-to-one collectingEventAttribute
one-to-many collectingEventAttrs
one-to-many collectingEventAuthorizations
many-to-one collectingTrip
one-to-many collectionObjects
one-to-many collectors
many-to-one createdByAgent
many-to-one discipline
many-to-one locality
many-to-one modifiedByAgent
many-to-one paleoContext
many-to-one visibilitySetBy
Back to top
Collecting Event Attachment
Refers to an attachment and provides an order.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Ordinal Integer The order or position of the attachment. Required
Remarks Text 4096 Additional comments.
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one collectingEvent
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Collecting Event Attribute
Extensible attributes introduced for Specify 6.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Double Value Double Double Value
String Value String 255 String Value
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one collectingEvent
many-to-one createdByAgent
many-to-one definition
many-to-one modifiedByAgent
Back to top
Collecting Event Attribute
Collecting Event Attributes that were also available in Specify 5.
Field Type Length Description Flags
Integer1 Integer Integer1
Integer10 Integer Integer10
Integer2 Integer Integer2
Integer3 Integer Integer3
Integer4 Integer Integer4
Integer5 Integer Integer5
Integer6 Integer Integer6
Integer7 Integer Integer7
Integer8 Integer Integer8
Integer9 Integer Integer9
Number1 Float Number1
Number10 Float Number10
Number11 Float Number11
Number12 Float Number12
Number13 Float Number13
Number2 Float Number2
Number3 Float Number3
Number4 Float Number4
Number5 Float Number5
Number6 Float Number6
Number7 Float Number7
Number8 Float Number8
Number9 Float Number9
Remarks Text 4096 Remarks
Text1 Text 65535 Text1
Text10 String 50 Text10
Text11 String 50 Text11
Text12 String 50 Text12
Text13 String 50 Text13
Text14 String 50 Text14
Text15 String 50 Text15
Text16 String 50 Text16
Text17 String 50 Text17
Text2 Text 65535 Text2
Text3 Text 65535 Text3
Text4 String 100 Text4
Text5 String 100 Text5
Text6 String 50 Text6
Text7 String 50 Text7
Text8 String 50 Text8
Text9 String 50 Text9
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Yes No3 Boolean Yes No3
Yes No4 Boolean Yes No4
Yes No5 Boolean Yes No5
Relationships
Type Target Table Field name
one-to-many collectingEvents
many-to-one createdByAgent
many-to-one discipline
many-to-one hostTaxon
many-to-one modifiedByAgent
Back to top
Collecting Event Authorization
Collecting Event Authorization
Field Type Length Description Flags
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one collectingEvent
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one permit
Back to top
Collecting Trip
Used to group Collecting Events together.
Field Type Length Description Flags
Trip Name String 250 Name of the collecting trip. Indexed
Cruise String 250 Cruise
Date1 Calendar Date1
Date1 Precision Byte Date1 Precision
Date2 Calendar Date2
Date2 Precision Byte Date2 Precision
End Date Calendar The ending date of the collecting trip.
End Date Precision Byte End Date Precision
End Date Verbatim String 50 End Date Verbatim
End Time Short The ending time of the collecting trip.
Expedition String 250 Expedition
Number1 Integer Number1
Number2 Integer Number2
Remarks Text 4096 Additional comments.
Sponsor String 64 Name of sponsor of collecting trip.
Start Date Calendar The start date of the collecting trip. Indexed
Start Date Precision Byte Start Date Precision
Start Date Verbatim String 50 Start Date Verbatim
Start Time Short The start time of the collecting trip.
Text1 String 255 None
Text2 String 128 Text2
Text3 String 64 Text3
Text4 String 64 Text4
Text5 Text 65535 Text5
Text6 Text 65535 Text6
Text7 Text 65535 Text7
Text8 Text 65535 Text8
Text9 Text 65535 Text9
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Vessel String 250 Vessel
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Relationships
Type Target Table Field name
many-to-one agent1
many-to-one agent2
one-to-many collectingEvents
one-to-many collectingTripAttachments
many-to-one collectingTripAttribute
one-to-many collectingTripAuthorizations
many-to-one createdByAgent
many-to-one discipline
one-to-many fundingAgents
many-to-one modifiedByAgent
Back to top
Collecting Trip Attachment
Collecting Trip Attachment
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Ordinal Integer Ordinal Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one collectingTrip
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Collecting Trip Attribute
Collecting Trip Attribute
Field Type Length Description Flags
Integer1 Integer Integer1
Integer10 Integer Integer10
Integer2 Integer Integer2
Integer3 Integer Integer3
Integer4 Integer Integer4
Integer5 Integer Integer5
Integer6 Integer Integer6
Integer7 Integer Integer7
Integer8 Integer Integer8
Integer9 Integer Integer9
Number1 Float Number1
Number10 Float Number10
Number11 Float Number11
Number12 Float Number12
Number13 Float Number13
Number2 Float Number2
Number3 Float Number3
Number4 Float Number4
Number5 Float Number5
Number6 Float Number6
Number7 Float Number7
Number8 Float Number8
Number9 Float Number9
Remarks Text 4096 Remarks
Text1 Text 65535 None
Text10 String 50 Text10
Text11 String 50 Text11
Text12 String 50 Text12
Text13 String 50 Text13
Text14 String 50 Text14
Text15 String 50 Text15
Text16 String 50 Text16
Text17 String 50 Text17
Text2 Text 65535 Text2
Text3 Text 65535 Text3
Text4 String 100 Text4
Text5 String 100 Text5
Text6 String 50 Text6
Text7 String 50 Text7
Text8 String 50 Text8
Text9 String 50 Text9
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Yes No3 Boolean Yes No3
Yes No4 Boolean Yes No4
Yes No5 Boolean Yes No5
Relationships
Type Target Table Field name
one-to-many collectingTrips
many-to-one createdByAgent
many-to-one discipline
many-to-one modifiedByAgent
Back to top
Collecting Trip Authorization
Collecting Trip Authorization
Field Type Length Description Flags
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one collectingTrip
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one permit
Back to top
Collection
A collection holds Collection Objects that are of the same discipline type.
Field Type Length Description Flags
Catalog Num Format Name String 64 Name of catalog number format the collection uses. Required
Code String 50 Unique code for collection.
Collection Name String 50 The name of the collection. Indexed
Collection Type String 32 Textual description of collection. ABCD schema field.
Db Content Version String 32 ABCD schema field.
Description Text 2048 Textual description of collection.
Development Status String 32 ABCD schema field.
Estimated Size Integer ABCD schema field.
GUID String 128 GUID Indexed
Institution Type String 32 ABCD schema field.
Is Embedded Collecting Event Boolean Yes if collecting event is a one-to-one relationship. Required
ISA Number String 24 ISA number.
Kingdom Coverage String 32 ABCD schema field.
Preservation 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 Reg Number
Remarks Text 4096 Additional comments.
Scope Text 2048 ABCD schema field.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Web Portal URI String 255 Web Portal URI
Web Site URI String 255 Web Site URI
Relationships
Type Target Table Field name
many-to-one adminContact
one-to-many contentContacts
many-to-one createdByAgent
many-to-one discipline
many-to-one institutionNetwork
one-to-many leftSideRelTypes
many-to-one modifiedByAgent
many-to-many numberingSchemes
one-to-many pickLists
one-to-many prepTypes
one-to-many rightSideRelTypes
one-to-many technicalContacts
one-to-many userGroups
Back to top
Collection Object
A general term for anything that can be a part of your collection: a specimen, a specimen lot, a sound recording, a slide, a tissue, an extract, or a spectrogram.
Field Type Length Description Flags
Alt Cat Number String 64 Alternate Catalog Number. Indexed
Availability String 32 Availability
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. Indexed
Cataloged Date Calendar Date the object was cataloged. Indexed
Cataloged Date Precision Byte Cataloged Date Precision
Cataloged Date Verbatim String 32 The verbatim date the specimen was collected.
Collection Member Id Integer Collection Member Id Required
Count Amount Integer The number of objects (specimens, slides, pieces) prepared.
Date1 Calendar Date1
Date1 Precision Byte Date1 Precision
Deaccessioned Boolean True if the object has been deaccessioned.
Specimen Description 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.). Indexed
GUID String 128 Global Unique Identifier Indexed
Integer1 Integer Integer1
Integer2 Integer Integer2
Inventory Date Calendar Inventory Date
Inventory Date Precision Byte Inventory Date Precision
Modifier String 50 Modifier
Name String 64 Name
Notifications String 32 Notifications
Number1 Float 24 User definable.
Number2 Float 24 User definable.
Number Of Duplicates Integer Number Of Duplicates
Object Condition String 64 Object Condition
Ocr Text 4096 Ocr
Project Number String 64 Project Number
Remarks Text 4096 Additional Comments.
Reserved Integer3 Integer Reserved Integer3
Reserved Integer4 Integer Reserved Integer4
Reserved Text String 128 Reserved Text
Reserved Text2 String 128 Reserved Text2
Reserved Text3 String 128 Reserved Text3
Restrictions String 32 Restrictions
Sgr Status Byte Sgr Status
Phenology Text 65535 User definable.
Text2 Text 65535 User definable.
Text3 Text 4096 Text3
Timestamp Created Timestamp The timestamp the record was created. Required
Modified Date Timestamp The timestamp the record was last modified.
Total Value Bigdecimal Total Value
Version Integer Version
Visibility Byte 10 Visibility
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 Target Table Field name
many-to-one accession
many-to-one agent1
many-to-one appraisal
many-to-one cataloger
many-to-one collectingEvent
many-to-one collection
one-to-many collectionObjectAttachments
many-to-one collectionObjectAttribute
one-to-many collectionObjectAttrs
one-to-many collectionObjectCitations
one-to-many collectionObjectProperties
one-to-many conservDescriptions
many-to-one container
many-to-one containerOwner
many-to-one createdByAgent
one-to-many determinations
one-to-many dnaSequences
one-to-many exsiccataItems
many-to-one fieldNotebookPage
many-to-one inventorizedBy
one-to-many leftSideRels
many-to-one modifiedByAgent
one-to-many otherIdentifiers
many-to-one paleoContext
one-to-many preparations
many-to-many projects
one-to-many rightSideRels
one-to-many treatmentEvents
many-to-one visibilitySetBy
one-to-many voucherRelationships
Back to top
Collection Object Attachment
An attachment for a collection object and provides order.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Ordinal Integer The order in the attachment list. Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one collectionObject
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Collection Object Attribute
Extensible attributes introduced for Specify 6.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Double Value Double Double Value
String Value String 255 String Value
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one collectionObject
many-to-one createdByAgent
many-to-one definition
many-to-one modifiedByAgent
Back to top
Collection Object Attribute
Collection Object attributes that were also available in Specify 5.
Field Type Length Description Flags
Bottom Distance Float Bottom Distance
Collection Member Id Integer Collection Member Id Required Indexed
Date1 Calendar Date1
Date1 Precision Byte Date1 Precision
Direction String 32 Direction
Distance Units String 16 Distance Units
Integer1 Integer Integer1
Integer10 Integer Integer10
Integer2 Integer Integer2
Integer3 Integer Integer3
Integer4 Integer Integer4
Integer5 Integer Integer5
Integer6 Integer Integer6
Integer7 Integer Integer7
Integer8 Integer Integer8
Integer9 Integer Integer9
Number1 Float Number1
Number10 Float Number10
Number11 Float Number11
Number12 Float Number12
Number13 Float Number13
Number14 Float Number14
Number15 Float Number15
Number16 Float Number16
Number17 Float Number17
Number18 Float Number18
Number19 Float Number19
Number2 Float Number2
Number20 Float Number20
Number21 Float Number21
Number22 Float Number22
Number23 Float Number23
Number24 Float Number24
Number25 Float Number25
Number26 Float Number26
Number27 Float Number27
Number28 Float Number28
Number29 Float Number29
Number3 Float Number3
Number30 Integer Number30
Number31 Float Number31
Number32 Float Number32
Number33 Float Number33
Number34 Float Number34
Number35 Float Number35
Number36 Float Number36
Number37 Float Number37
Number38 Float Number38
Number39 Float Number39
Number4 Float Number4
Number40 Float Number40
Number41 Float Number41
Number42 Float Number42
Number5 Float Number5
Number6 Float Number6
Number7 Float Number7
Number8 Integer Number8
Number9 Float Number9
Position State String 32 Position State
Remarks Text 4096 Remarks
Text1 Text 65535 Text1
Text10 String 50 Text10
Text11 String 50 Text11
Text12 String 50 Text12
Text13 String 50 Text13
Text14 String 50 Text14
Text15 String 64 Text15
Text16 Text 65535 Text16
Text17 Text 65535 Text17
Text18 Text 65535 Text18
Text19 Text 65535 Text19
Text2 Text 65535 Text2
Text20 Text 65535 Text20
Text21 Text 65535 Text21
Text22 Text 65535 Text22
Text23 Text 65535 Text23
Text24 Text 65535 Text24
Text25 Text 65535 Text25
Text26 Text 65535 Text26
Text27 Text 65535 Text27
Text28 Text 65535 Text28
Text29 Text 65535 Text29
Text3 Text 65535 Text3
Text30 Text 65535 Text30
Text4 String 50 Text4
Text5 String 50 Text5
Text6 String 100 Text6
Text7 String 100 Text7
Text8 String 50 Text8
Text9 String 50 Text9
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Top Distance Float Top Distance
Version Integer Version
Yes No1 Boolean Yes No1
Yes No10 Boolean Yes No10
Yes No11 Boolean Yes No11
Yes No12 Boolean Yes No12
Yes No13 Boolean Yes No13
Yes No14 Boolean Yes No14
Yes No15 Boolean Yes No15
Yes No16 Boolean Yes No16
Yes No17 Boolean Yes No17
Yes No18 Boolean Yes No18
Yes No19 Boolean Yes No19
Yes No2 Boolean Yes No2
Yes No20 Boolean Yes No20
Yes No3 Boolean Yes No3
Yes No4 Boolean Yes No4
Yes No5 Boolean Yes No5
Yes No6 Boolean Yes No6
Yes No7 Boolean Yes No7
Yes No8 Boolean Yes No8
Yes No9 Boolean Yes No9
Relationships
Type Target Table Field name
many-to-one agent1
one-to-many collectionObjects
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Collection Object Citation
Refers to a citation for a Collection Object.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Figure Number String 50 Figure Number
Is Figured Boolean Is Figured
Page Number String 50 Page Number
Plate Number String 50 Plate Number
Remarks Text 4096 Additional Comments.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one collectionObject
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one referenceWork
Back to top
Collection Object Property
Collection Object Property
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Date1 Calendar Date1
Date10 Calendar Date10
Date11 Calendar Date11
Date12 Calendar Date12
Date13 Calendar Date13
Date14 Calendar Date14
Date15 Calendar Date15
Date16 Calendar Date16
Date17 Calendar Date17
Date18 Calendar Date18
Date19 Calendar Date19
Date2 Calendar Date2
Date20 Calendar Date20
Date3 Calendar Date3
Date4 Calendar Date4
Date5 Calendar Date5
Date6 Calendar Date6
Date7 Calendar Date7
Date8 Calendar Date8
Date9 Calendar Date9
Guid String 128 Guid
Integer1 Short Integer1
Integer10 Short Integer10
Integer11 Short Integer11
Integer12 Short Integer12
Integer13 Short Integer13
Integer14 Short Integer14
Integer15 Short Integer15
Integer16 Short Integer16
Integer17 Short Integer17
Integer18 Short Integer18
Integer19 Short Integer19
Integer2 Short Integer2
Integer20 Short Integer20
Integer21 Integer Integer21
Integer22 Integer Integer22
Integer23 Integer Integer23
Integer24 Integer Integer24
Integer25 Integer Integer25
Integer26 Integer Integer26
Integer27 Integer Integer27
Integer28 Integer Integer28
Integer29 Integer Integer29
Integer3 Short Integer3
Integer30 Integer Integer30
Integer4 Short Integer4
Integer5 Short Integer5
Integer6 Short Integer6
Integer7 Short Integer7
Integer8 Short Integer8
Integer9 Short Integer9
Number1 Float Number1
Number10 Float Number10
Number11 Float Number11
Number12 Float Number12
Number13 Float Number13
Number14 Float Number14
Number15 Float Number15
Number16 Float Number16
Number17 Float Number17
Number18 Float Number18
Number19 Float Number19
Number2 Float Number2
Number20 Float Number20
Number21 Double Number21
Number22 Double Number22
Number23 Double Number23
Number24 Double Number24
Number25 Double Number25
Number26 Double Number26
Number27 Double Number27
Number28 Double Number28
Number29 Double Number29
Number3 Float Number3
Number30 Double Number30
Number4 Float Number4
Number5 Float Number5
Number6 Float Number6
Number7 Float Number7
Number8 Float Number8
Number9 Float Number9
Remarks Text 4096 Remarks
Text1 String 50 Text1
Text10 String 50 Text10
Text11 String 50 Text11
Text12 String 50 Text12
Text13 String 50 Text13
Text14 String 50 Text14
Text15 String 50 Text15
Text16 String 100 Text16
Text17 String 100 Text17
Text18 String 100 Text18
Text19 String 100 Text19
Text2 String 50 Text2
Text20 String 100 Text20
Text21 String 100 Text21
Text22 String 100 Text22
Text23 String 100 Text23
Text24 String 100 Text24
Text25 String 100 Text25
Text26 String 100 Text26
Text27 String 100 Text27
Text28 String 100 Text28
Text29 String 100 Text29
Text3 String 50 Text3
Text30 String 100 Text30
Text31 Text 65535 Text31
Text32 Text 65535 Text32
Text33 Text 65535 Text33
Text34 Text 65535 Text34
Text35 Text 65535 Text35
Text36 Text 65535 Text36
Text37 Text 65535 Text37
Text38 Text 65535 Text38
Text39 Text 65535 Text39
Text4 String 50 Text4
Text40 Text 65535 Text40
Text5 String 50 Text5
Text6 String 50 Text6
Text7 String 50 Text7
Text8 String 50 Text8
Text9 String 50 Text9
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Yes No1 Boolean Yes No1
Yes No10 Boolean Yes No10
Yes No11 Boolean Yes No11
Yes No12 Boolean Yes No12
Yes No13 Boolean Yes No13
Yes No14 Boolean Yes No14
Yes No15 Boolean Yes No15
Yes No16 Boolean Yes No16
Yes No17 Boolean Yes No17
Yes No18 Boolean Yes No18
Yes No19 Boolean Yes No19
Yes No2 Boolean Yes No2
Yes No20 Boolean Yes No20
Yes No3 Boolean Yes No3
Yes No4 Boolean Yes No4
Yes No5 Boolean Yes No5
Yes No6 Boolean Yes No6
Yes No7 Boolean Yes No7
Yes No8 Boolean Yes No8
Yes No9 Boolean Yes No9
Relationships
Type Target Table Field name
many-to-one agent1
many-to-one agent10
many-to-one agent11
many-to-one agent12
many-to-one agent13
many-to-one agent14
many-to-one agent15
many-to-one agent16
many-to-one agent17
many-to-one agent18
many-to-one agent19
many-to-one agent2
many-to-one agent20
many-to-one agent3
many-to-one agent4
many-to-one agent5
many-to-one agent6
many-to-one agent7
many-to-one agent8
many-to-one agent9
many-to-one collectionObject
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Collection Relationship Type
Describes the type of relationship between two collection objects.
Field Type Length Description Flags
Name String 32 The name of the Collection Relationship.
Remarks String 4096 Additional comments.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one leftSideCollection
many-to-one modifiedByAgent
many-to-one rightSideCollection
Back to top
Collection Relationship
Enables two collection objects to refer to each other, for example, voucher and tissue.
Field Type Length Description Flags
Text1 String 32 User-definable.
Text2 String 32 User definable.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one collectionRelType
many-to-one createdByAgent
many-to-one leftSide
many-to-one modifiedByAgent
many-to-one rightSide
Back to top
Collector
In Specify, the person or persons who collected a specimen. Collector records are stored in the Agent table.
Field Type Length Description Flags
Is Primary Boolean Is Primary Required
Order Number Integer The position in the list of collectors. Required
Remarks Text 4096 Additional comments.
Text1 Text 65535 None
Text2 Text 65535 Text2
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Relationships
Type Target Table Field name
many-to-one agent
many-to-one collectingEvent
many-to-one createdByAgent
many-to-one division
many-to-one modifiedByAgent
Back to top
Common Name
Describes a common name and the localization of the name. This table is used to describe additional Common Names in other languages.
Field Type Length Description Flags
Author String 128 Author
Country String 2 The country code. Indexed
Language String 2 The language code.
Name String 255 Name Indexed
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Variant String 2 The variant code of the language.
Version Integer Version
Relationships
Type Target Table Field name
one-to-many citations
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one taxon
Back to top
Common Name Tx Citation
Common Name Tx Citation
Field Type Length Description Flags
Number1 Float Number1
Number2 Float Number2
Remarks Text 4096 Remarks
Text1 Text 65535 User definable.
Text2 Text 65535 User definable.
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Relationships
Type Target Table Field name
many-to-one commonNameTx
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one referenceWork
Back to top
Conservator Description
Describes an object that has participated in a Conservator action. There is only one of these for each Collection Object.
Field Type Length Description Flags
Background Info Text 8192 Any background information on the object.
Composition Text 8192 Composition
Description Text 8192 Description
Determined Date Calendar Determined Date
Display Recommendations Text 4096 Display Recommendations
Height Float The height of the object.
Light Recommendations Text 4096 Light Recommendations
Object Length Float The length of the object.
Other Recommendations Text 4096 Other Recommendations
Remarks Text 8192 Additional Comments
Short Description String 128 A short description of the object. Indexed
Source Text 8192 Source
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Units String 16 The units for the measurements (`feet` or `meters`).
Version Integer Version
Width Float The width of the object.
Relationships
Type Target Table Field name
many-to-one collectionObject
one-to-many conservDescriptionAttachments
many-to-one createdByAgent
many-to-one division
one-to-many events
many-to-one modifiedByAgent
many-to-one preparation
Back to top
Conservator Description Attachment
Refers to an attachment and provides order.
Field Type Length Description Flags
Ordinal Integer The order or position Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one conservDescription
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Conservator Event
An action that takes place as part of a Conservation Description. Over a period of time there may be multiple incidents that require a Conservator to take action.
Field Type Length Description Flags
Advanced Testing Exam Text 8192 The advanced testing that was used to examine the object
Advanced Testing Exam Results Text 8192 The results of the advanced testing
Completed Comments Text 4096 Completed Comments
Completed Date Calendar Completed Date
Completed Date Precision Byte Completed Date Precision
Condition Report Text 8192 A report on the condition
Approval Date Calendar 8192 Approval Date
Curator Approval Date Precision Byte Curator Approval Date Precision
Exam Date Calendar The date the object was examined Indexed
Exam Date Precision Byte Exam Date Precision
Number1 Integer Number1
Number2 Integer Number2
Photo Documentation Text 8192 Any documentation on the photos that were taken
Remarks Text 4096 Remarks
Text1 String 64 None
Text2 String 64 Text2
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Treatment Completion Date Calendar Treatment Completion Date
Treatment Comp Date Precision Byte Treatment Comp Date Precision
Treatment Report Text 8192 A description of the treatment that is needed.
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Relationships
Type Target Table Field name
many-to-one conservDescription
one-to-many conservEventAttachments
many-to-one createdByAgent
many-to-one curator
many-to-one examinedByAgent
many-to-one modifiedByAgent
many-to-one treatedByAgent
Back to top
Conservator Event Attachment
Refers to an attachment and provides order.
Field Type Length Description Flags
Ordinal Integer The order or position Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one conservEvent
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Container
A container can optionally be cataloged as a collection object and it contains other collection objects. Describes a logical or physical container.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Description String 255 A description of the container
Name String 64 The name of the container Indexed
Number Integer User definable
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Type Short The type of container
Version Integer Version
Relationships
Type Target Table Field name
one-to-many children
one-to-many collectionObjectKids
one-to-many collectionObjects
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one parent
many-to-one storage
Back to top
DNA Primer
DNA Primer
Field Type Length Description Flags
Integer1 Integer Integer1
Integer2 Integer Integer2
Number1 Float Number1
Number2 Float Number2
Primer Designator String 64 Primer Designator Indexed
Primer Name Forward String 64 Primer Name Forward
Primer Name Rev String 64 Primer Name Rev
Primer Ref Cit Forward String 300 Primer Ref Cit Forward
Primer Ref Cit Rev String 300 Primer Ref Cit Rev
Primer Ref Link Forward String 300 Primer Ref Link Forward
Primer Ref Link Rev String 300 Primer Ref Link Rev
Primer Seq Forward String 128 Primer Seq Forward
Primer Seq Rev String 128 Primer Seq Rev
Purification Method String 255 Purification Method
Remarks Text 4096 Remarks
Reserved Integer3 Integer Reserved Integer3
Reserved Integer4 Integer Reserved Integer4
Reserved Number3 Float Reserved Number3
Reserved Number4 Float Reserved Number4
Reserved Text3 Text 4096 Reserved Text3
Reserved Text4 Text 4096 Reserved Text4
Text1 Text 4096 None
Text2 Text 4096 Text2
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Relationships
Type Target Table Field name
many-to-one createdByAgent
one-to-many dnaSequencingRuns
many-to-one modifiedByAgent
Back to top
DNA Sequence
Tracks DNA Sequencing information for a Collection Object.
Field Type Length Description Flags
Ambiguous Integer Ambiguous
BOLD Barcode Id String 32 BOLD Barcode Id Indexed
BOLD Last Update Calendar BOLD Last Update
BOLD Sample Id String 32 BOLD Sample Id Indexed
Bold Translation Matrix String 64 Bold Translation Matrix
Collection Member Id Integer Collection Member Id Required
Comp A Integer Comp A
Comp C Integer Comp C
Comp G Integer Comp G
Comp T Integer Comp T
Extraction Date Calendar Extraction Date
Extraction Date Precision Byte Extraction Date Precision
Genbank Acc # String 32 Genbank Acc # Indexed
Gene Sequence Text 2048 The actual sequence
Molecule Type String 32 Molecule Type
Number1 Float Number1
Number2 Float Number2
Number3 Float Number3
Remarks Text 4096 Remarks
Sequence Date Calendar Sequence Date
Sequence Date Precision Byte Sequence Date Precision
Target Marker String 32 Target Marker
Text1 String 32 Text1
Text2 String 32 Text2
Text3 String 64 Text3
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Total Residues Integer Total Residues
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Yes No3 Boolean Yes No3
Relationships
Type Target Table Field name
one-to-many attachments
many-to-one collectionObject
many-to-one createdByAgent
one-to-many dnaSequencingRuns
many-to-one extractor
one-to-many extractors
many-to-one materialSample
many-to-one modifiedByAgent
one-to-many pcrPersons
many-to-one sequencer
Back to top
DNA Sequence Attachment
Refers to an attachment and provides order.
Field Type Length Description Flags
Ordinal Integer Ordinal Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one dnaSequence
many-to-one modifiedByAgent
Back to top
DNA Sequencing Run
DNA Sequencing Run
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required
Dryad DOI String 256 Dryad DOI
Gene Sequence Text Gene Sequence
Number1 Float Number1
Number2 Float Number2
Number3 Float Number3
Ordinal Integer Ordinal
PCR Cocktail Primer Boolean PCR Cocktail Primer
PCR Forward Primer Code String 32 PCR Forward Primer Code
PCR Primer Name String 32 PCR Primer Name
PCR Primer Seq5_3 String 64 PCR Primer Sequence5_3
PCR Rev Primer Code String 32 PCR Rev Primer Code
Read Direction String 16 Read Direction
Remarks Text 4096 Remarks
Run Date Calendar Run Date
Score File Name String 32 Score File Name
Seq Cocktail Primer Boolean Seq Cocktail Primer
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 Experiment ID
SRA Run ID String 64 SRA Run ID
SRA Submission ID String 64 SRA Submission ID
Text1 String 32 Text1
Text2 String 32 Text2
Text3 String 64 Text3
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Trace File Name String 32 Trace File Name
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Yes No3 Boolean Yes No3
Relationships
Type Target Table Field name
one-to-many attachments
one-to-many citations
many-to-one createdByAgent
many-to-one dnaPrimer
many-to-one dnaSequence
many-to-one modifiedByAgent
many-to-one preparedByAgent
many-to-one runByAgent
Back to top
DNA Sequencing Run Attachment
DNA Sequencing Run Attachment
Field Type Length Description Flags
Ordinal Integer Ordinal Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one dnaSequencingRun
many-to-one modifiedByAgent
Back to top
DNA Sequencing Run Citation
DNA Sequencing Run Citation
Field Type Length Description Flags
Number1 Float Number1
Number2 Float Number2
Remarks Text 4096 Remarks
Text1 Text 65535 Text1
Text2 Text 65535 Text2
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one referenceWork
many-to-one sequencingRun
Back to top
Data Type
A data type represents a core type of collection data.
Field Type Length Description Flags
Name String 50 Name
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Deaccession
Removal of a biological object (specimen, observation, or preparation type) from the collection. Deaccessions may include loans to other collections that are subsequently given to the borrower, lost specimens, and specimens that are destroyed.
Field Type Length Description Flags
Deaccession Date Calendar Deaccession Date Indexed
Deaccession Number String 50 Name institution assigns to the deaccession Indexed
Number1 Float 24 User definable
Number2 Float 24 User definable
Remarks Text 4096 Additional Comments
Text1 Text 65535 User definable
Text2 Text 65535 User definable
Timestamp Created Timestamp The timestamp the record was created. Required
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 Version
Yes No1 Boolean User definable
Yes No2 Boolean User definable
Relationships
Type Target Table Field name
many-to-one accession
many-to-one createdByAgent
one-to-many deaccessionAgents
one-to-many deaccessionPreparations
many-to-one modifiedByAgent
Back to top
Deaccession Agent
Refers to an agent and contains their role in the deaccession.
Field Type Length Description Flags
Remarks Text 4096 Additional Comments
Role String 50 Role agent played in deaccession Required
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one agent
many-to-one createdByAgent
many-to-one deaccession
many-to-one modifiedByAgent
Back to top
Deaccession Preparation
The preparation that was deaccessioned.
Field Type Length Description Flags
Quantity Short The number of items deaccessioned
Remarks Text 4096 Additional Comments
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one deaccession
one-to-many loanReturnPreparations
many-to-one modifiedByAgent
many-to-one preparation
Back to top
Determination
The determination of the collection object.
Field Type Length Description Flags
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. Indexed
Collection Member Id Integer Collection Member Id Required Indexed
Confidence String 50 Confidence of determination.
Determined Date Calendar The date it was determined. Indexed
Determined Date Precision Byte Determined Date Precision
Feature Or Basis String 50 Body part, or characteristic used as the basis of a determination.
GUID String 128 GUID Indexed
Current Boolean Yes if the determination is considered the 'best' (maybe even one of the better). Required
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 picklist 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 Text 4096 Additional Comments.
Sub Sp Qualifier String 16 Sub Sp Qualifier
Text1 Text 65535 User definable.
Text2 Text 65535 User definable.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Type Status String 50 A picklist of all available type designations; Holotype, Paratype, Neotype. Specify ships with predetermined values that are editable for users. Indexed
Var Qualifier String 16 Var Qualifier
Version Integer Version
Yes No1 Boolean User definable.
Yes No2 Boolean User definable.
Relationships
Type Target Table Field name
many-to-one collectionObject
many-to-one createdByAgent
one-to-many determinationCitations
many-to-one determiner
many-to-one modifiedByAgent
many-to-one preferredTaxon
many-to-one taxon
Back to top
Determination Citation
Refers to a citation for the determination.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Remarks Text 4096 Additional Comments.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one determination
many-to-one modifiedByAgent
many-to-one referenceWork
Back to top
Discipline
May include one or more collections that share the Taxon, Geography, LithoStratigraphy, and Chronostratigraphy Trees, Localities, Agents and Determination Status.
Field Type Length Description Flags
Is Paleo Context Embedded Boolean Is Paleo Context Embedded Required
Name String 64 Name Indexed
Paleo Context Child Table String 50 Paleo Context Child Table
Reg Number String 24 Reg Number
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Type String 64 Type
Version Integer Version
Relationships
Type Target Table Field name
one-to-many attributeDefs
one-to-many collections
many-to-one createdByAgent
many-to-one dataType
many-to-one division
many-to-one geographyTreeDef
many-to-one geologicTimePeriodTreeDef
many-to-one lithoStratTreeDef
many-to-one modifiedByAgent
many-to-many numberingSchemes
one-to-many spExportSchemas
one-to-many spLocaleContainers
one-to-one taxonTreeDef
one-to-many userGroups
Back to top
Division
The division (or department) containing agents.
Field Type Length Description Flags
Abbreviation String 64 The abbreviation for the division.
Alt Name String 128 Alt Name
Description Text 8192 Description
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 Indexed
Reg Number String 24 Reg Number
Remarks Text 8192 Additional Comments
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
URL String 255 A URI (web site) address for the department
Version Integer Version
Relationships
Type Target Table Field name
many-to-one address
many-to-one createdByAgent
one-to-many disciplines
many-to-one institution
one-to-many members
many-to-one modifiedByAgent
many-to-many numberingSchemes
one-to-many userGroups
Back to top
Exchange In
Describes an incoming Exchanged Specimen from a different institution.
Field Type Length Description Flags
Contents Text 4096 Contents
Description String 120 Description of material. Indexed
Exchange Date Calendar Date exchange was received. Indexed
Exchange In # String 50 Exchange In #
Number1 Float 24 User definable.
Number2 Float 24 User definable.
Quantity Exch Short Number of items received.
Remarks Text 4096 Additional Comments.
Source Geography String 32 Source Geography
Source Taxonomy String 32 Source Taxonomy
Text1 Text 65535 User definable.
Text2 Text 65535 User definable.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Yes No1 Boolean User definable.
Yes No2 Boolean User definable.
Relationships
Type Target Table Field name
many-to-one addressOfRecord
many-to-one agentCatalogedBy
many-to-one agentReceivedFrom
many-to-one createdByAgent
many-to-one division
one-to-many exchangeInPreps
many-to-one modifiedByAgent
Back to top
Exchange In Prep
Exchange In Prep
Field Type Length Description Flags
Comments Text Comments
Description Of Material String 255 Description Of Material
Number1 Integer Number1
Quantity Integer Quantity
Text1 Text Text1
Text2 Text Text2
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one discipline
many-to-one exchangeIn
many-to-one modifiedByAgent
many-to-one preparation
Back to top
Exchange Out
Describes an outgoing Exchanged Specimen to a different institution.
Field Type Length Description Flags
Contents Text 4096 Contents
Description String 120 Description Indexed
Exchange Date Calendar Date exchange was sent. Indexed
Exchange Out # String 50 Exchange Out #
Number1 Float 24 User definable.
Number2 Float 24 User definable.
Quantity Exch Short Number of items sent.
Remarks Text 4096 Additional Comments.
Source Geography String 32 Source Geography
Source Taxonomy String 32 Source Taxonomy
Text1 Text 65535 User definable.
Text2 Text 65535 User definable.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Yes No1 Boolean User definable.
Yes No2 Boolean User definable.
Relationships
Type Target Table Field name
many-to-one addressOfRecord
many-to-one agentCatalogedBy
many-to-one agentSentTo
many-to-one createdByAgent
many-to-one division
one-to-many exchangeOutPreps
many-to-one modifiedByAgent
one-to-many shipments
Back to top
Exchange Out Prep
Exchange Out Prep
Field Type Length Description Flags
Comments Text Comments
Description Of Material String 255 Description Of Material
Number1 Integer Number1
Quantity Integer Quantity
Text1 Text Text1
Text2 Text Text2
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one discipline
many-to-one exchangeOut
many-to-one modifiedByAgent
many-to-one preparation
Back to top
Exsiccata
Exsiccata
Field Type Length Description Flags
Remarks Text 65535 Remarks
Schedae String 255 Schedae
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Title String 255 The title of the exsiccata Required
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
one-to-many exsiccataItems
many-to-one modifiedByAgent
many-to-one referenceWork
Back to top
Exsiccata Item
Exsiccata Item
Field Type Length Description Flags
Fascicle String 16 The fascicle number
Number String 16 The list number of the collection object within the exsiccata
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one collectionObject
many-to-one createdByAgent
many-to-one exsiccata
many-to-one modifiedByAgent
Back to top
Extractor
None
Field Type Length Description Flags
Order Number Integer Order Number Required
Remarks Text 4096 None
Text1 Text 4096 None
Text2 Text 4096 None
Timestamp Created Timestamp None Required
Timestamp Modified Timestamp None
Version Integer None
Yes No1 Boolean None
Yes No2 Boolean None
Relationships
Type Target Table Field name
many-to-one agent
many-to-one createdByAgent
many-to-one dnaSequence
many-to-one modifiedByAgent
Back to top
Field Notebook
Describes a physical Field NoteBook.
Field Type Length Description Flags
Description Text 2048 Description
End Date Calendar End Date Indexed
Location String 64 Location
Name String 32 Name Indexed
Start Date Calendar Start Date Indexed
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
one-to-many attachments
many-to-one collection
many-to-one createdByAgent
many-to-one discipline
many-to-one modifiedByAgent
many-to-one ownerAgent
one-to-many pageSets
Back to top
Field Notebook Attachment
Refers to an attachment and provides order.
Field Type Length Description Flags
Ordinal Integer Ordinal Required
Remarks Text 8192 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one fieldNotebook
many-to-one modifiedByAgent
Back to top
Field Notebook Page
Describes a page from a Field Note Book.
Field Type Length Description Flags
Description String 128 Description
Page Number String 32 Page Number Required Indexed
Scan Date Calendar Scan Date Indexed
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
one-to-many attachments
one-to-many collectionObjects
many-to-one createdByAgent
many-to-one discipline
many-to-one modifiedByAgent
many-to-one pageSet
Back to top
Field Notebook Page Attachment
Refers to an attachment and provides order.
Field Type Length Description Flags
Ordinal Integer Ordinal Required
Remarks Text 8192 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one fieldNotebookPage
many-to-one modifiedByAgent
Back to top
Field Notebook Page Set
Describes a set of Field Note Book pages. This can be used to group pages together that were scanned in together.
Field Type Length Description Flags
Description String 128 Description
End Date Calendar End Date Indexed
Method String 64 Method
Order Number Short Order Number
Start Date Calendar Start Date Indexed
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
one-to-many attachments
many-to-one createdByAgent
many-to-one discipline
many-to-one fieldNotebook
many-to-one modifiedByAgent
one-to-many pages
many-to-one sourceAgent
Back to top
Field Notebook Page Set Attachment
Refers to an attachment and provides order.
Field Type Length Description Flags
Ordinal Integer Ordinal Required
Remarks Text 8192 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one fieldNotebookPageSet
many-to-one modifiedByAgent
Back to top
Funding Agent
Funding Agent
Field Type Length Description Flags
Is Primary Boolean Is Primary Required
Order Number Integer Order Number Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Type String 32 Type
Version Integer Version
Relationships
Type Target Table Field name
many-to-one agent
many-to-one collectingTrip
many-to-one createdByAgent
many-to-one division
many-to-one modifiedByAgent
Back to top
Geo Coord Detail
Describes extra detail for a Locality for Manis data.
Field Type Length Description Flags
Error Polygon Text Error Polygon
Geo Ref Accuracy Double Geo Ref Accuracy
Geo Ref Accuracy Units String 20 Geo Ref Accuracy Units
Geo Ref Compiled Date Calendar Geo Ref Compiled Date
Geo Ref Det Date Calendar Geo Ref Det Date
Geo Ref Det Ref String 100 Geo Ref Det Ref
Geo Ref Remarks Text Geo Ref Remarks
Geo Ref Verification Status String 50 Geo Ref Verification Status
Max Uncertainty Est Bigdecimal Max Uncertainty Est
Max Uncertainty Est Unit String 8 Max Uncertainty Est Unit
Named Place Ext Bigdecimal Named Place Ext
No Geo Ref Because String 100 No Geo Ref Because
Original Coord System String 32 Original Coord System
Protocol String 64 Protocol
Source String 64 Source
Text1 Text 65535 None
Text2 Text 65535 Text2
Text3 Text 65535 Text3
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Uncertainty Polygon Text Uncertainty Polygon
Validation String 64 Validation
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one geoRefCompiledBy
many-to-one geoRefDetBy
many-to-one locality
many-to-one modifiedByAgent
Back to top
Geography
Represents politcal boundary (Country, State, County, Township, etc.).
Field Type Length Description Flags
Abbreviation String 16 Abbreviation
Centroid Latitude Bigdecimal Centroid Latitude
Centroid Longitude Bigdecimal Centroid Longitude
Common Name String 128 Common Name
Full Name String 500 Full Name Indexed
Geography Code String 24 Geography Code
GML Text 4096 GML
GUID String 128 GUID
Highest Child Node Number Integer Highest Child Node Number
Is Preferred Boolean The preferred name of a synonym. Required
Is Current Boolean `Yes` if the Name and/or Geographic/Political entity is currently valid.
Name String 128 Name Required Indexed
Node Number Integer Node Number
Number1 Integer User definable
Number2 Integer User definable
Rank Id Integer Rank Id Required
Remarks Text 4096 Additional Comments
Text1 String 32 User definable.
Text2 String 32 User definable.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Timestamp Version Date Timestamp Version
Version Integer Version
Relationships
Type Target Table Field name
one-to-many acceptedChildren
many-to-one acceptedGeography
one-to-many children
many-to-one createdByAgent
many-to-one definition
many-to-one definitionItem
one-to-many localities
many-to-one modifiedByAgent
many-to-one parent
Back to top
Geography Tree Definition
Defines the levels of the Geography tree.
Field Type Length Description Flags
Full Name Direction Integer Full Name Direction
Name String 64 Name Required
Remarks Text 4096 Additional Comments.
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
one-to-many disciplines
many-to-one modifiedByAgent
one-to-many treeDefItems
one-to-many treeEntries
Back to top
Geography Tree Definition Item
Describes a level in the definition of the tree.
Field Type Length Description Flags
Full Name Separator String 32 Full Name Separator
Is Enforced Boolean Is Enforced
Is In Full Name Boolean Is In Full Name
Name String 64 Name Required
Rank Id Integer Rank Id Required
Remarks Text 4096 Additional Comments.
Text After String 64 User definable.
Text Before String 64 User definable.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Title String 64 Title
Version Integer Version
Relationships
Type Target Table Field name
one-to-many children
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one parent
many-to-one treeDef
one-to-many treeEntries
Back to top
Chronostratigraphy
Describes Chronostratigraphy.
Field Type Length Description Flags
End Period Float End Period
End Uncertainty Float End Uncertainty
Full Name String 255 Full Name Indexed
GUID String 128 GUID Indexed
Highest Child Node Number Integer Highest Child Node Number
Is Preferred Boolean Is Preferred Required
Is BioStratigraphy Boolean Is BioStratigraphy
Name String 64 Name Required Indexed
Node Number Integer Node Number
Rank Id Integer Numeric representation of Items rank in the stratigraphic hierarchy. Required
Remarks Text 4096 Additional Comments.
Standard String 64 The system of Stratigraphy the record is included in.
Start Period Float Start Period
Start Uncertainty Float Start Uncertainty
Text1 String 128 Text1
Text2 String 128 Text2
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
one-to-many acceptedChildren
many-to-one acceptedGeologicTimePeriod
one-to-many bioStratsPaleoContext
one-to-many children
one-to-many chronosStratsPaleoContext
many-to-one createdByAgent
many-to-one definition
many-to-one definitionItem
many-to-one modifiedByAgent
many-to-one parent
Back to top
Geological Time Period Tree Definition
Defines the levels of the GTP tree.
Field Type Length Description Flags
Full Name Direction Integer Full Name Direction
Name String 64 Name Required
Remarks Text 4096 Additional Comments.
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
one-to-many disciplines
many-to-one modifiedByAgent
one-to-many treeDefItems
one-to-many treeEntries
Back to top
Geological Time Period Tree Definition Item
Describes a level in the definition of the tree.
Field Type Length Description Flags
Full Name Separator String 32 Full Name Separator
Is Enforced Boolean Is Enforced
Is In Full Name Boolean Is In Full Name
Name String 64 Name Required
Rank Id Integer Rank Id Required
Remarks Text 4096 Additional Comments.
Text After String 64 User definable.
Text Before String 64 User definable.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Title String 64 Title
Version Integer Version
Relationships
Type Target Table Field name
one-to-many children
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one parent
many-to-one treeDef
one-to-many treeEntries
Back to top
Gift
Describes a Gift.
Field Type Length Description Flags
Contents Text 4096 Contents
Date Received Calendar Date Received
Gift Date Calendar Gift Date Indexed
Gift Number String 50 Gift Number Required Indexed
Integer1 Integer Integer1
Integer2 Integer Integer2
Integer3 Integer Integer3
Is Financial Responsibility Boolean Is Financial Responsibility
Number1 Float 24 User-defined.
Number2 Float 24 se
Purpose Of Gift String 64 Purpose Of Gift
Received Comments String 255 Received Comments
Remarks Text 4096 Remarks
Special Conditions Text 2048 Special Conditions
Source Geography String 500 Source Geography
Source Taxonomy String 500 Source Taxonomy
Text1 Text 65535 User definable.
Text2 Text 65535 User definable.
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Relationships
Type Target Table Field name
many-to-one addressOfRecord
many-to-one createdByAgent
many-to-one discipline
many-to-one division
one-to-many giftAgents
one-to-many giftAttachments
one-to-many giftPreparations
many-to-one modifiedByAgent
one-to-many shipments
Back to top
Gift Agent
Describes the role the Agent played in the giving of a Gift.
Field Type Length Description Flags
Remarks Text 4096 Remarks
Role String 50 Role Required
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one agent
many-to-one createdByAgent
many-to-one discipline
many-to-one gift
many-to-one modifiedByAgent
Back to top
Gift Attachment
Gift Attachment
Field Type Length Description Flags
Ordinal Integer Ordinal Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one gift
many-to-one modifiedByAgent
Back to top
Gift Preparation
Points a gift to a preparation.
Field Type Length Description Flags
Description String 255 Description
In Comments Text 1024 In Comments
Out Comments Text 1024 Out Comments
Quantity Integer Number of preparations included in the gift.
Received Comments Text 1024 Received Comments
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one discipline
many-to-one gift
many-to-one modifiedByAgent
many-to-one preparation
Back to top
Group Person
This is a join table for Agents that are Institutions and Organizations that contain other Agents. It also provides order.
Field Type Length Description Flags
Order Number Short Members position in the group; i.e. 1st, 2nd, 3rd. Required
Remarks Text 4096 Additional Comments.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one division
many-to-one group
many-to-one member
many-to-one modifiedByAgent
Back to top
Information Request
Describes a request for information on a collection and refers to a Bundle of Collection Objects.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Email String 50 Email
First Name String 50 First Name
Info Req Number String 32 Number of Information Request.
Institution String 127 Institution
Last Name String 50 Last Name
Remarks Text 4096 Additional Comments.
Reply Date Calendar Reply Date
Request Date Calendar Request Date
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one agent
many-to-one createdByAgent
many-to-one modifiedByAgent
one-to-many recordSets
Back to top
Institution
The parent institution. An institution is made up of one or more divisions.
Field Type Length Description Flags
Alt Name String 128 Alt Name
Code String 64 Code
Copyright Text 8192 Copyright
Current Managed Rel Version String 8 Current Managed Rel Version
Current Managed Schema Version String 8 Current Managed Schema Version
Description Text 8192 Description
Disclaimer Text 8192 Disclaimer statement, e.g. concerning responsibility for data quality or legal implications.
GUID String 128 GUID Indexed
Has Been Asked Boolean Has Been Asked
Icon URL String 255 Icon URL
IPR Text 8192 A sequence of statements related to Intellectual Property Rights, credit and acknowledgment.
Are Accessions Global Boolean Are Accessions Global Required
Is Anonymous Boolean Is Anonymous
Is Release Managed Globally Boolean Is Release Managed Globally
Is Security On Boolean Is Security On Required
Is Server Based Boolean Is Server Based Required
Is Sharing Localities Boolean Is Sharing Localities Required
Is Single Geography Tree Boolean Is Single Geography Tree Required
License Text 2048 License
LSID Authority String 64 LSID Authority
Minimum Pwd Length Byte Minimum Pwd Length
Name String 255 Name Indexed
Reg Number String 24 Reg Number
Remarks Text 8192 Additional Comments
Terms Of Use Text 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. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
URL String 255 URL
Version Integer Version
Relationships
Type Target Table Field name
many-to-one address
one-to-many contentContacts
many-to-one createdByAgent
one-to-many divisions
many-to-one modifiedByAgent
many-to-one storageTreeDef
one-to-many technicalContacts
one-to-many userGroups
Back to top
Institution Network
Institution Network
Field Type Length Description Flags
Alt Name String 128 Alt Name
Code String 64 Code
Copyright Text 8192 Copyright
Description Text 8192 Description
Disclaimer Text 8192 Disclaimer
Icon URI String 255 Icon URI
Ipr Text 8192 Ipr
License Text 2048 License
Name String 255 Name Indexed
Remarks Text 8192 Remarks
Terms Of Use Text 8192 Terms Of Use
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Uri String 255 Uri
Version Integer Version
Relationships
Type Target Table Field name
many-to-one address
one-to-many collections
one-to-many contacts
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Journal
Refers to a published journal.
Field Type Length Description Flags
GUID String 128 GUID Indexed
ISSN String 16 ISSN
Journal Abbreviation String 50 Journal Abbreviation
Journal Name String 255 Full name of the journal. Indexed
Remarks Text 4096 Remarks
Text1 String 32 User definable.
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one institution
many-to-one modifiedByAgent
one-to-many referenceWorks
Back to top
Lat Lon Polygon
Lat Lon Polygon
Field Type Length Description Flags
Description Text 4096 Description
Is Polyline Boolean Is Polyline Required
Name String 64 Name Required
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one locality
many-to-one modifiedByAgent
one-to-many points
many-to-one visualQuery
Back to top
Lat Lon Polygon Pnt
Lat Lon Polygon Pnt
Field Type Length Description Flags
Elevation Integer Elevation
Latitude Bigdecimal Latitude Required
Longitude Bigdecimal Longitude Required
Ordinal Integer Ordinal Required
Relationships
Type Target Table Field name
many-to-one latLonPolygon
Back to top
Lithostratigraphy
The Lithostratigraphy tree.
Field Type Length Description Flags
Full Name String 255 Full Name Indexed
GUID String 128 GUID Indexed
Highest Child Node Number Integer Highest Child Node Number
Is Preferred Boolean Is Preferred Required
Name String 64 Name Required Indexed
Node Number Integer Node Number
Number1 Double Number1
Number2 Double Number2
Rank Id Integer Rank Id Required
Remarks Text 4096 Additional Comments.
Text1 Text 65535 Text1
Text2 Text 65535 Text2
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Relationships
Type Target Table Field name
one-to-many acceptedChildren
many-to-one acceptedLithoStrat
one-to-many children
many-to-one createdByAgent
many-to-one definition
many-to-one definitionItem
many-to-one modifiedByAgent
one-to-many paleoContexts
many-to-one parent
Back to top
Lithostratigraphy Tree Definition
Defines the levels of the tree.
Field Type Length Description Flags
Full Name Direction Integer Full Name Direction
Name String 64 Name Required
Remarks Text 4096 Additional Comments.
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
one-to-many disciplines
many-to-one modifiedByAgent
one-to-many treeDefItems
one-to-many treeEntries
Back to top
Lithostratigraphy Tree Definition Item
Describes a level in the definition of the tree.
Field Type Length Description Flags
Full Name Separator String 32 Full Name Separator
Is Enforced Boolean Is Enforced
Is In Full Name Boolean Is In Full Name
Name String 64 Name Required
Rank Id Integer Rank Id Required
Remarks Text 4096 Additional Comments
Text After String 64 User definable
Text Before String 64 User definable
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Title String 64 Title
Version Integer Version
Relationships
Type Target Table Field name
one-to-many children
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one parent
many-to-one treeDef
one-to-many treeEntries
Back to top
Loan
A group of specimens that another institution borrows from your collection. Specify lets you manage all aspects of loans electronically so that you always have an up-to-date record of which specimen have been loaned and which have been returned.
Field Type Length Description Flags
Contents Text 4096 Contents
Current Due Date Calendar Date the loan is due for return (Same as original Due date unless loan period has been extended). Indexed
Date Closed Calendar Date loan was closed.
Date Received Calendar Date Received
Integer1 Integer Integer1
Integer2 Integer Integer2
Integer3 Integer Integer3
Is Closed Boolean 'No' until all preparations in the loan have been returned/resolved.
Is Financial Responsibility Boolean Is Financial Responsibility
Loan Date Calendar Date the Loan was created. Indexed
Loan Number String 50 A field that contains a record of the loan number and which is automatically incremented when a loan is made. Required Indexed
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 Overdue Noti Sent Date
Purpose Of Loan String 64 Purpose Of Loan
Received Comments String 255 Received Comments
Remarks Text 4096 Additional Comments
Special Conditions Text 2048 Special Conditions
Source Geography String 500 Source Geography
Source Taxonomy String 500 Source Taxonomy
Text1 Text 65535 User definable.
Text2 Text 65535 User definable.
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Extension Granted Boolean User definable.
Yes No2 Boolean User definable.
Relationships
Type Target Table Field name
many-to-one addressOfRecord
many-to-one createdByAgent
many-to-one discipline
many-to-one division
one-to-many loanAgents
one-to-many loanAttachments
one-to-many loanPreparations
many-to-one modifiedByAgent
one-to-many shipments
Back to top
Loan Agent
An agent associated with a loan. Each agent includes the role played in the loan process.
Field Type Length Description Flags
Remarks Text 4096 Additional Comments
Role String 50 Role the agent played in the loan. Required
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one agent
many-to-one createdByAgent
many-to-one discipline
many-to-one loan
many-to-one modifiedByAgent
Back to top
Loan Attachment
Refers to an attachment and provides order.
Field Type Length Description Flags
Ordinal Integer Ordinal Required
Remarks Text 4096 Additional comments.
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one loan
many-to-one modifiedByAgent
Back to top
Loan Preparation
A join table between the Loan and the Preparation. It contains comments and quantity fields.
Field Type Length Description Flags
Description String 255 Description of loaned material (intended to be used for non-cataloged items, i.e. when PreparationID is null)
In Comments Text 1024 Comments on item when returned.
Is Resolved Boolean Is Resolved Required
Out Comments Text 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 Text 1024 Received Comments
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one discipline
many-to-one loan
one-to-many loanReturnPreparations
many-to-one modifiedByAgent
many-to-one preparation
Back to top
Loan Return Preparation
This is used for tracking a returned Preparation for a loan.
Field Type Length Description Flags
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 Text 4096 Additional Comments.
Returned Date Calendar Date of return. Indexed
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one deaccessionPreparation
many-to-one discipline
many-to-one loanPreparation
many-to-one modifiedByAgent
many-to-one receivedBy
Back to top
Locality
The name of the location where a specimen was collected or observed. Some taxonomic disciplines or collectors may use a locality name instead of a field number to associate a collecting event with a specimen.
Field Type Length Description Flags
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 Text GML
GUID String 128 GUID
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 the first point
Latitude2 Bigdecimal Latitude of the second point
Locality Name String 255 The full name of the locality. Required Indexed
Long1text String 50 User entry for Longitude1
Long2text String 50 User entry for Longitude2
Longitude1 Bigdecimal Longitude of the first point
Longitude2 Bigdecimal Longitude of the 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 Indexed
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 Indexed
Remarks Text 4096 Additional Comments
Sgr Status Byte Sgr Status
Short Name String 32 Short Name
Src Lat Long Unit Byte Src Lat Long Unit Required
Text1 Text 65535 Text1
Text2 Text 65535 Text2
Text3 Text 65535 Text3
Text4 Text 65535 Text4
Text5 Text 65535 Text5
Timestamp Created Timestamp The timestamp the record was created. Required
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 Latitude
Verbatim Longitude String 50 Verbatim Longitude
Version Integer Version
Visibility Byte Visibility
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Yes No3 Boolean Yes No3
Yes No4 Boolean Yes No4
Yes No5 Boolean Yes No5
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one discipline
zero-to-one geoCoordDetails
many-to-one geography
one-to-many latLonpolygons
one-to-many localityAttachments
one-to-many localityCitations
zero-to-one localityDetails
one-to-many localityNameAliass
many-to-one modifiedByAgent
many-to-one paleoContext
many-to-one visibilitySetBy
Back to top
Locality Attachment
Refers to an attachment and provides order.
Field Type Length Description Flags
Ordinal Integer Ordinal Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one locality
many-to-one modifiedByAgent
Back to top
Locality Citation
A join table to link a Locality to a Citation.
Field Type Length Description Flags
Remarks Text 4096 Additional Comments
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one discipline
many-to-one locality
many-to-one modifiedByAgent
many-to-one referenceWork
Back to top
Locality Detail
Describes additional Locality detail. For example, water body and island information. Includes UTM fields.
Field Type Length Description Flags
Base Meridian String 50 Base Meridian
Drainage String 64 Drainage
End Depth Double End Depth
End Depth Unit String 23 End Depth Unit
End Depth Verbatim String 32 End Depth Verbatim
Gml Text Gml
HUC Code String 16 HUC Code
Island String 64 Island
Island Group String 64 Island Group
Mgrs Zone String 4 Mgrs Zone
National Park Name String 64 National Park Name
Number1 Double Number1
Number2 Double Number2
Number3 Float Number3
Number4 Float Number4
Number5 Float Number5
Paleo Latitude String 32 Paleo Latitude
Paleo Longitude String 32 Paleo Longitude
Range String 50 Range
Range Direction String 50 Range Direction
Section String 50 Section
Section Part String 50 Section Part
Start Depth Double Start Depth
Start Depth Unit String 23 Start Depth Unit
Start Depth Verbatim String 32 Start Depth Verbatim
Text1 Text 65535 Text1
Text2 Text 65535 Text2
Text3 Text 65535 Text3
Text4 Text 65535 Text4
Text5 Text 65535 Text5
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Township String 50 Township
Township Direction String 50 Township Direction
UTM Datum String 32 UTM Datum
UTM Easting Bigdecimal UTM Easting
UTM False Easting Integer UTM False Easting
UTM False Northing Integer UTM False Northing
UTM Northing Bigdecimal UTM Northing
UTM Orig Latitude Bigdecimal UTM Orig Latitude
UTM Orig Longitude Bigdecimal UTM Orig Longitude
UTM Scale Bigdecimal UTM Scale
UTM Zone Short UTM Zone
Version Integer Version
Water Body String 64 Water Body
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Yes No3 Boolean Yes No3
Yes No4 Boolean Yes No4
Yes No5 Boolean Yes No5
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one locality
many-to-one modifiedByAgent
Back to top
Locality Name Alias
Describes additional names for a given Locality.
Field Type Length Description Flags
Name String 255 The alias for the locality name. Required Indexed
Source String 64 The source of the alias. Required
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one discipline
many-to-one locality
many-to-one modifiedByAgent
Back to top
Material Sample
Material Sample
Field Type Length Description Flags
Absorb Ratio 260_230 Float Absorb Ratio 260_230
Absorb Ratio 260_280 Float Absorb Ratio 260_280
Absorb Ratio Method String 64 Absorb Ratio Method
Concentration Float Concentration
Concentration Unit String 64 Concentration Unit
Sample Type String 64 Sample Type
Medium String 64 Medium
Purification Method String 64 Purification Method
Quality String 64 Quality
Quality Check Date Calendar Quality Check Date
Quality Remarks Text 4096 Quality Remarks
Sample Designation String 128 Sample Designation Indexed
Sample Size Float Sample Size
Volume Float Volume
Volume Unit String 64 Volume Unit
Weight Float Weight
Weight Method String 64 Weight Method
Weight Unit String 64 Weight Unit
Collection Member Id Integer Collection Member Id Required
Extraction Date Calendar Extraction Date
Guid String 128 Guid
Integer1 Integer Integer1
Integer2 Integer Integer2
Number1 Float Number1
Number2 Float Number2
Remarks Text 4096 Remarks
Reserved Integer3 Integer Reserved Integer3
Reserved Integer4 Integer Reserved Integer4
Reserved Number3 Float Reserved Number3
Reserved Number4 Float Reserved Number4
Reserved Text3 Text 4096 Reserved Text3
Reserved Text4 Text 4096 Reserved Text4
SRA Bio Project ID String 64 SRA Bio Project ID
SRA Bio Sample ID String 64 SRA Bio Sample ID
SRA Project ID String 64 SRA Project ID
SRA Sample ID String 64 SRA Sample ID
Text1 Text 4096 None
Text2 Text 4096 Text2
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Relationships
Type Target Table Field name
many-to-one createdByAgent
one-to-many dnaSequences
many-to-one extractor
many-to-one modifiedByAgent
many-to-one preparation
Back to top
Morph Bank View
Morph Bank View
Field Type Length Description Flags
Development State String 128 Development State
Form String 128 Form
Imaging Preparation Technique String 128 Imaging Preparation Technique
Imaging Technique String 128 Imaging Technique
Morph Bank External View Id Integer Morph Bank External View Id
Sex String 32 Sex
Specimen Part String 128 Specimen Part
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
View Angle String 128 View Angle
View Name String 128 View Name
Relationships
Type Target Table Field name
one-to-many attachmentImageAttributes
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Other Identifier
Describes an identifier (Catalog Number) of a Collection Object from a different Institution.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Identifier String 64 Identifier Required
Institution String 64 Institution
Remarks Text 4096 Additional Comments
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one collectionObject
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Paleo Context
Describes the paleontologic information for a Collection Object. This also references Chronostratigraphy and Bio Stratigray.
Field Type Length Description Flags
Number1 Double Number1
Number2 Double Number2
Number3 Double Number3
Number4 Double Number4
Number5 Double Number5
Context Name String 80 Context Name Indexed
Remarks Text 4096 Remarks
Bio Strat String 64 Bio Strat
Text2 String 64 Text2
Text3 String 500 Text3
Text4 String 500 Text4
Text5 String 500 Text5
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Yes No3 Boolean Yes No3
Yes No4 Boolean Yes No4
Yes No5 Boolean Yes No5
Relationships
Type Target Table Field name
many-to-one bioStrat
many-to-one chronosStrat
many-to-one chronosStratEnd
one-to-many collectingEvents
one-to-many collectionObjects
many-to-one createdByAgent
many-to-one discipline
many-to-one lithoStrat
one-to-many localities
many-to-one modifiedByAgent
Back to top
Pcr Persons
Pcr Persons
Field Type Length Description Flags
Order Number Integer Order Number Required
Remarks Text 4096 None
Text1 Text 4096 None
Text2 Text 4096 None
Timestamp Created Timestamp None Required
Timestamp Modified Timestamp None
Version Integer None
Yes No1 Boolean None
Yes No2 Boolean None
Relationships
Type Target Table Field name
many-to-one agent
many-to-one createdByAgent
many-to-one dnaSequence
many-to-one modifiedByAgent
Back to top
Permit
The permit transaction window is designed to hold information linked to legal paperwork for permission from a government agency to collect a specimen or specimens. Preparation: A subdivision of a collection object that refers to the preparation method.
Field Type Length Description Flags
Copyright String 256 Copyright
End Date Calendar Date permit expires
Is Available Boolean Is Available
Is Required Boolean Is Required
Issued Date Calendar Date permit was issued Indexed
Number1 Float 24 User definable
Number2 Float 24 User definable
Permit Number String 50 Identifier for the permit Required Indexed
Permit Text Text 4096 Permit Text
Remarks Text 4096 Additional Comments
Renewal Date Calendar Date of renewal
Reserved Integer1 Integer Reserved Integer1
Reserved Integer2 Integer Reserved Integer2
Reserved Text3 String 128 Reserved Text3
Reserved Text4 String 128 Reserved Text4
Start Date Calendar Date permit becomes effective
Status String 64 Status
Status Qualifier String 128 Status Qualifier
Text1 Text 65535 User definable
Text2 Text 65535 User definable
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Type String 50 Permit category - `CITES`, `Migratory Bird Treaty Act`, ...
Version Integer Version
Yes No1 Boolean User definable
Yes No2 Boolean User definable
Relationships
Type Target Table Field name
one-to-many accessionAuthorizations
one-to-many collectingEventAuthorizations
one-to-many collectingTripAuthorizations
many-to-one createdByAgent
many-to-one institution
many-to-one issuedBy
many-to-one issuedTo
many-to-one modifiedByAgent
one-to-many permitAttachments
Back to top
Permit Attachment
Refers to an attachment and provides order.
Field Type Length Description Flags
Ordinal Integer Ordinal Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one permit
Back to top
Pick List
System Table: A list of items that can be choosen to produce a controlled vocabulary.
Field Type Length Description Flags
Field Name String 64 Field Name
Filter Field Name String 32 Filter Field Name
Filter Value String 32 Filter Value
Formatter String 64 Formatter
Is System Boolean Where system form rely on this picklist, not user-defined Required
Name String 64 Name Required Indexed
Read Only Boolean Read Only Required
Size Limit Integer 10 Size Limit
Sort Type Byte Sort Type
Table Name String 64 Table Name
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Type Byte Type Required
Version Integer Version
Relationships
Type Target Table Field name
many-to-one collection
many-to-one createdByAgent
many-to-one modifiedByAgent
one-to-many pickListItems
Back to top
Pick List Item
Pick List Item
Field Type Length Description Flags
Ordinal Integer Ordinal
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Title String 128 Title Required
Value String 128 Value
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one pickList
Back to top
Preparation Type
Describe a Preparation Type. For example, Cleared and Stained, Mounted, etc.
Field Type Length Description Flags
Is Loanable Boolean Is Loanable Required
Name String 64 Name Required
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
one-to-many attributeDefs
many-to-one collection
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Preparation
Preparation information describes the physical status of a specimen and its storage media. Specify provides an extensive array of utilities for curatorial management of specimen preparations.
Field Type Length Description Flags
Bar Code String 256 None Indexed
Collection Member Id Integer Collection Member Id Required Indexed
Count Integer Number of items
Date1 Calendar Date1
Date1 Precision Byte Date1 Precision
Date2 Calendar Date2
Date2 Precision Byte Date2 Precision
Date3 Calendar Date3
Date3 Precision Byte Date3 Precision
Date4 Calendar Date4
Date4 Precision Byte Date4 Precision
Description String 255 Description
Guid String 128 Guid Indexed
Integer1 Integer Integer1
Integer2 Integer Integer2
Number1 Float Number1
Number2 Float Number2
Prepared Date Calendar Prepared Date
Prepared Date Precision Byte Prepared Date Precision
Remarks Text 4096 Additional Comments
Reserved Integer3 Integer Reserved Integer3
Reserved Integer4 Integer Reserved Integer4
Sample Number String 32 Sample Number Indexed
Status String 32 Status
Storage Location String 50 Storage Location
Text1 Text 65535 User definable
Text2 Text 65535 User definable
Text3 Text 65535 Text3
Text4 Text 65535 Text4
Text5 Text 65535 Text5
Text6 Text 65535 Text6
Text7 Text 65535 Text7
Text8 Text 65535 Text8
Text9 Text 65535 Text9
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Yes No3 Boolean Yes No3
Relationships
Type Target Table Field name
many-to-one alternateStorage
many-to-one collectionObject
one-to-many conservDescriptions
many-to-one createdByAgent
one-to-many deaccessionPreparations
one-to-many exchangeInPreps
one-to-many exchangeOutPreps
one-to-many giftPreparations
one-to-many loanPreparations
one-to-many materialSamples
many-to-one modifiedByAgent
many-to-one prepType
one-to-many preparationAttachments
many-to-one preparationAttribute
one-to-many preparationAttrs
one-to-many preparationProperties
many-to-one preparedByAgent
many-to-one storage
Back to top
Preparation Attachment
Refers to an attachment and provides order.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Ordinal Integer Ordinal Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one preparation
Back to top
Preparation Attribute
Extensible attributes introduced for Specify 6.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Double Value Double Double Value
String Value String 255 String Value
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one definition
many-to-one modifiedByAgent
many-to-one preparation
Back to top
Preparation Attribute
Preparation attributes that were also available in Specify 5.
Field Type Length Description Flags
Attr Date Calendar 10 Attr Date
Collection Member Id Integer Collection Member Id Required Indexed
Number1 Float Number1
Number2 Float Number2
Number3 Float Number3
Number4 Integer Number4
Number5 Integer Number5
Number6 Integer Number6
Number7 Integer Number7
Number8 Integer Number8
Number9 Short Number9
Remarks Text 4096 Remarks
Text1 Text 65535 Text1
Text10 Text 65535 Text10
Text11 String 50 Text11
Text12 String 50 Text12
Text13 String 50 Text13
Text14 String 50 Text14
Text15 String 50 Text15
Text16 String 50 Text16
Text17 String 50 Text17
Text18 String 50 Text18
Text19 String 50 Text19
Text2 Text 65535 Text2
Text20 String 50 Text20
Text21 String 50 Text21
Text22 String 50 Text22
Text23 String 50 Text23
Text24 String 50 Text24
Text25 String 50 Text25
Text26 String 50 Text26
Text3 String 50 Text3
Text4 String 50 Text4
Text5 String 50 Text5
Text6 String 50 Text6
Text7 String 50 Text7
Text8 String 50 Text8
Text9 String 50 Text9
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Yes No3 Boolean Yes No3
Yes No4 Boolean Yes No4
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
one-to-many preparations
Back to top
Preparation Property
Preparation Property
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Date1 Calendar Date1
Date10 Calendar Date10
Date11 Calendar Date11
Date12 Calendar Date12
Date13 Calendar Date13
Date14 Calendar Date14
Date15 Calendar Date15
Date16 Calendar Date16
Date17 Calendar Date17
Date18 Calendar Date18
Date19 Calendar Date19
Date2 Calendar Date2
Date20 Calendar Date20
Date3 Calendar Date3
Date4 Calendar Date4
Date5 Calendar Date5
Date6 Calendar Date6
Date7 Calendar Date7
Date8 Calendar Date8
Date9 Calendar Date9
Guid String 128 Guid
Integer1 Short Integer1
Integer10 Short Integer10
Integer11 Short Integer11
Integer12 Short Integer12
Integer13 Short Integer13
Integer14 Short Integer14
Integer15 Short Integer15
Integer16 Short Integer16
Integer17 Short Integer17
Integer18 Short Integer18
Integer19 Short Integer19
Integer2 Short Integer2
Integer20 Short Integer20
Integer21 Integer Integer21
Integer22 Integer Integer22
Integer23 Integer Integer23
Integer24 Integer Integer24
Integer25 Integer Integer25
Integer26 Integer Integer26
Integer27 Integer Integer27
Integer28 Integer Integer28
Integer29 Integer Integer29
Integer3 Short Integer3
Integer30 Integer Integer30
Integer4 Short Integer4
Integer5 Short Integer5
Integer6 Short Integer6
Integer7 Short Integer7
Integer8 Short Integer8
Integer9 Short Integer9
Number1 Float Number1
Number10 Float Number10
Number11 Float Number11
Number12 Float Number12
Number13 Float Number13
Number14 Float Number14
Number15 Float Number15
Number16 Float Number16
Number17 Float Number17
Number18 Float Number18
Number19 Float Number19
Number2 Float Number2
Number20 Float Number20
Number21 Double Number21
Number22 Double Number22
Number23 Double Number23
Number24 Double Number24
Number25 Double Number25
Number26 Double Number26
Number27 Double Number27
Number28 Double Number28
Number29 Double Number29
Number3 Float Number3
Number30 Double Number30
Number4 Float Number4
Number5 Float Number5
Number6 Float Number6
Number7 Float Number7
Number8 Float Number8
Number9 Float Number9
Remarks Text 4096 Remarks
Text1 String 50 None
Text10 String 50 Text10
Text11 String 50 Text11
Text12 String 50 Text12
Text13 String 50 Text13
Text14 String 50 Text14
Text15 String 50 Text15
Text16 String 100 Text16
Text17 String 100 Text17
Text18 String 100 Text18
Text19 String 100 Text19
Text2 String 50 Text2
Text20 String 100 Text20
Text21 String 100 Text21
Text22 String 100 Text22
Text23 String 100 Text23
Text24 String 100 Text24
Text25 String 100 Text25
Text26 String 100 Text26
Text27 String 100 Text27
Text28 String 100 Text28
Text29 String 100 Text29
Text3 String 50 Text3
Text30 String 100 Text30
Text31 Text 65535 Text31
Text32 Text 65535 Text32
Text33 Text 65535 Text33
Text34 Text 65535 Text34
Text35 Text 65535 Text35
Text36 Text 65535 Text36
Text37 Text 65535 Text37
Text38 Text 65535 Text38
Text39 Text 65535 Text39
Text4 String 50 Text4
Text40 Text 65535 Text40
Text5 String 50 Text5
Text6 String 50 Text6
Text7 String 50 Text7
Text8 String 50 Text8
Text9 String 50 Text9
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Yes No1 Boolean Yes No1
Yes No10 Boolean Yes No10
Yes No11 Boolean Yes No11
Yes No12 Boolean Yes No12
Yes No13 Boolean Yes No13
Yes No14 Boolean Yes No14
Yes No15 Boolean Yes No15
Yes No16 Boolean Yes No16
Yes No17 Boolean Yes No17
Yes No18 Boolean Yes No18
Yes No19 Boolean Yes No19
Yes No2 Boolean Yes No2
Yes No20 Boolean Yes No20
Yes No3 Boolean Yes No3
Yes No4 Boolean Yes No4
Yes No5 Boolean Yes No5
Yes No6 Boolean Yes No6
Yes No7 Boolean Yes No7
Yes No8 Boolean Yes No8
Yes No9 Boolean Yes No9
Relationships
Type Target Table Field name
many-to-one agent1
many-to-one agent10
many-to-one agent11
many-to-one agent12
many-to-one agent13
many-to-one agent14
many-to-one agent15
many-to-one agent16
many-to-one agent17
many-to-one agent18
many-to-one agent19
many-to-one agent2
many-to-one agent20
many-to-one agent3
many-to-one agent4
many-to-one agent5
many-to-one agent6
many-to-one agent7
many-to-one agent8
many-to-one agent9
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one preparation
Back to top
Project
Describes a grouping of Collection Objects.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required
End Date Calendar Date project ended
Grant Agency String 64 Grant Agency
Grant Number String 64 Grant Number
Number1 Float 24 User definable
Number2 Float 24 User definable
Description String 255 Description of the project
Project Name String 128 Name of the project Required Indexed
Project Number String 64 Project Number Indexed
Remarks Text 4096 Additional Comments
Start Date Calendar Date project began
Text1 Text 65535 User definable
Text2 Text 65535 User definable
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
URL String 1024 URL for project
Version Integer Version
Yes No1 Boolean User definable
Yes No2 Boolean User definable
Relationships
Type Target Table Field name
many-to-one agent
many-to-many collectionObjects
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Record Set
Describes a set of records of any type that can be acted upon within the applicatiton.
Field Type Length Description Flags
All Permission Level Integer All Permission Level
Collection Member Id Integer Collection Member Id Required
Database Table Id Integer Database Table Id Required
Group Permission Level Integer Group Permission Level
Name String 64 Name Required
Owner Permission Level Integer Owner Permission Level
Remarks Text 4096 Additional Comments
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Type Byte Type Required
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one group
many-to-one infoRequest
many-to-one modifiedByAgent
one-to-many recordSetItems
many-to-one specifyUser
Back to top
Record Set Item
Record Set Item
Field Type Length Description Flags
Order Integer Order
Record Id Integer Record Id Required
Relationships
Type Target Table Field name
many-to-one recordSet
Back to top
Reference Work
A literary reference work.
Field Type Length Description Flags
Doi Text 65535 Doi
GUID String 128 GUID Indexed
Is Published Boolean Is Published
ISBN String 16 ISBN Indexed
Library Number String 50 Library Number
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 Place Of Publication
Publisher String 250 Publisher Indexed
Type Byte Type of Reference (Book(0), Electronic Media(1), Paper(2), Technical Report(3), Thesis(4), Section in book(5)) Required
Remarks Text 4096 Additional Comments
Text1 Text 65535 User definable
Text2 Text 65535 User definable
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Title String 255 Title of reference Required Indexed
Uri Text 65535 Uri
URL String 1024 URL
Version Integer Version
Volume String 25 Volume/Issue for Journal articles
Work Date String 25 Work Date
Yes No1 Boolean User definable
Yes No2 Boolean User definable
Relationships
Type Target Table Field name
one-to-many authors
one-to-many collectionObjectCitations
many-to-one containedRFParent
one-to-many containedReferenceWorks
many-to-one createdByAgent
one-to-many determinationCitations
one-to-many exsiccatae
many-to-one institution
many-to-one journal
one-to-many localityCitations
many-to-one modifiedByAgent
one-to-many referenceWorkAttachments
one-to-many taxonCitations
Back to top
Reference Work Attachment
Reference Work Attachment
Field Type Length Description Flags
Ordinal Integer Ordinal Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one referenceWork
Back to top
Repository Agreement
An agreement for allowing an Accession to occur, but does not include ownership.
Field Type Length Description Flags
Date Received Calendar Date Received
End Date Calendar End Date
Number1 Float User definable
Number2 Float User definable
Remarks Text 4096 Additional Comments
RA Number String 60 RA Number Required Indexed
Start Date Calendar Start Date Indexed
Status String 32 Status
Text1 String 255 User definable
Text2 String 255 User definable
Text3 String 255 User definable
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Yes No1 Boolean User definable
Yes No2 Boolean User definable
Relationships
Type Target Table Field name
one-to-many accessions
many-to-one addressOfRecord
many-to-one createdByAgent
many-to-one division
many-to-one modifiedByAgent
many-to-one originator
one-to-many repositoryAgreementAgents
one-to-many repositoryAgreementAttachments
one-to-many repositoryAgreementAuthorizations
Back to top
Repository Agreement Attachment
Refers to an attachment and provides order.
Field Type Length Description Flags
Ordinal Integer Ordinal
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one repositoryAgreement
Back to top
Shipment
Describes the shipment of a Loan or Exchange.
Field Type Length Description Flags
Insured For Amount String 50 Insured For Amount
Number1 Float 24 User definable
Number2 Float 24 User definable
Num Of Packages Short Number of packages shipped
Remarks Text 4096 Additional Comments
Shipment Date Calendar Date of shipment Indexed
Method String 50 Description of shipment. E.g. `Hand-carried`, `Overnight`, `Air`, `Land`, `Sea`, ... Indexed
Shipment Number String 50 Shipper`s tracking number Required Indexed
Text1 Text 65535 User definable
Text2 Text 65535 User definable
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Weight String 50 The weight of the shipment
Yes No1 Boolean User definable
Yes No2 Boolean User definable
Relationships
Type Target Table Field name
many-to-one borrow
many-to-one createdByAgent
many-to-one discipline
many-to-one exchangeOut
many-to-one gift
many-to-one loan
many-to-one modifiedByAgent
many-to-one shippedBy
many-to-one shippedTo
many-to-one shipper
Back to top
App Resource
System Table: This represents a resource, typically XML, that the application uses during run time.
Field Type Length Description Flags
All Permission Level Integer All Permission Level
Description String 255 Description
Group Permission Level Integer Group Permission Level
Level Short Level Required
Meta Data String 255 Meta Data
Mime Type String 255 Mime Type Indexed
Name String 64 Name Required Indexed
Owner Permission Level Integer Owner Permission Level
Timestamp Created Timestamp The timestamp the record was created. Required
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one group
many-to-one modifiedByAgent
one-to-many spAppResourceDatas
many-to-one spAppResourceDir
one-to-many spReports
many-to-one specifyUser
Back to top
App Resource Data
System Table: The data associated with an application resource.
Field Type Length Description Flags
Data Text 16000000 Data
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one spAppResource
many-to-one spViewSetObj
Back to top
App Resource Default
System Table: the default for application resources.
Field Type Length Description Flags
Discipline Type String 64 Discipline Type Indexed
Is Personal Boolean Is Personal Required
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
User Group String 64 User Group
Version Integer Version
Relationships
Type Target Table Field name
many-to-one collection
many-to-one createdByAgent
many-to-one discipline
many-to-one modifiedByAgent
one-to-many spPersistedAppResources
one-to-many spPersistedViewSets
many-to-one specifyUser
Back to top
Sp Audit Log
Sp Audit Log
Field Type Length Description Flags
Action Byte Action Required
Parent Record Id Integer Parent Record Id
Parent Table Num Short Parent Table Num
Record Id Integer Record Id
Record Version Integer Record Version Required
Table Num Short Table Num Required
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
one-to-many fields
many-to-one modifiedByAgent
Back to top
Sp Audit Log Field
Sp Audit Log Field
Field Type Length Description Flags
Field Name String 128 Field Name Required
New Value Text 65535 New Value
Old Value Text 65535 Old Value
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one spAuditLog
Back to top
Sp Export Schema
System Table:
Field Type Length Description Flags
Description String 255 Description
Schema Name String 80 Schema Name
Schema Version String 80 Schema Version
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one discipline
many-to-one modifiedByAgent
one-to-many spExportSchemaItems
many-to-many spExportSchemaMappings
Back to top
Sp Export Schema Item
System Table:
Field Type Length Description Flags
Data Type String 32 Data Type
Description String 255 Description
Field Name String 64 Field Name
Formatter String 32 Formatter
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one spExportSchema
many-to-one spLocaleContainerItem
Back to top
Sp Export Schema Item Mapping
Sp Export Schema Item Mapping
Field Type Length Description Flags
Exported Field Name String 64 Exported Field Name
Remarks String 255 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one exportSchemaItem
many-to-one exportSchemaMapping
many-to-one modifiedByAgent
many-to-one queryField
Back to top
Sp Export Schema Mapping
Sp Export Schema Mapping
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Description String 255 Description
Mapping Name String 50 Mapping Name
Timestamp Created Timestamp Timestamp Created Required
Timestamp Exported Timestamp Timestamp Exported
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
one-to-many mappings
many-to-one modifiedByAgent
many-to-many spExportSchemas
one-to-many symbiotaInstances
Back to top
Sp Field Value Default
System Table: This represents a default field value for a form.
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Field Name String 32 Field Name
Id Value Integer Id Value
Str Value String 64 Str Value
Table Name String 32 Table Name
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
Locale Container
System Table: This is used for localizing the database schema it has a localized name and description but can also contain localizable items.
Field Type Length Description Flags
Aggregator String 64 Aggregator
Default U I String 64 Default U I
Format String 64 Format
Is Hidden Boolean Is Hidden Required
Is System Boolean Is System Required
Is U I Formatter Boolean Is U I Formatter
Name String 64 Name Required Indexed
Pick List Name String 64 Pick List Name
Schema Type Byte The type of schema it belongs to: the core schema or the workbench schema Required
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Type String 32 Type
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
one-to-many descs
many-to-one discipline
one-to-many items
many-to-one modifiedByAgent
one-to-many names
Back to top
Locale Container Item
System Table: This is used for localizing the database schema it has a localized name and description.
Field Type Length Description Flags
Format String 64 Format
Is Hidden Boolean Is Hidden Required
Is Required Boolean 32 Is Required
Is System Boolean Is System Required
Is U I Formatter Boolean Is U I Formatter
Name String 64 Name Required Indexed
Pick List Name String 64 Pick List Name
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Type String 32 Type
Version Integer Version
Web Link Name String 32 Web Link Name
Relationships
Type Target Table Field name
many-to-one container
many-to-one createdByAgent
one-to-many descs
many-to-one modifiedByAgent
one-to-many names
one-to-many spExportSchemaItems
Back to top
Locale Item String
System Table: This is used for localizing the database schema it represents a string and also a Language, Country and Variant for that string.
Field Type Length Description Flags
Country String 2 Country Indexed
Language String 2 Language Required Indexed
Text String 255 Text Required
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Variant String 2 Variant
Version Integer Version
Relationships
Type Target Table Field name
many-to-one containerDesc
many-to-one containerName
many-to-one createdByAgent
many-to-one itemDesc
many-to-one itemName
many-to-one modifiedByAgent
Back to top
Sp Permission
System Table:
Field Type Length Description Flags
Actions String 256 Actions
Name String 64 Name
Permission Class String 256 Permission Class Required
Target Id Integer Target Id
Relationships
Type Target Table Field name
many-to-many principals
Back to top
Sp Principal
System Table:
Field Type Length Description Flags
Group Sub Class String 255 Group Sub Class Required
Group Type String 32 Group Type
Name String 64 Name Required
Priority Byte Priority Required
Remarks Text Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-many permissions
many-to-one scope
many-to-many specifyUsers
Back to top
Sp Query
System Table: This represents a saved Query.
Field Type Length Description Flags
Context Name String 64 Context Name Required
Context Table Id Short Context Table Id Required
Count Only Boolean Count Only
Format Audit Rec Ids Boolean Format Audit Rec Ids
Is Favorite Boolean Is Favorite
Name String 64 Name Required Indexed
Ordinal Short Ordinal
Remarks Text 4096 Remarks
Search Synonymy Boolean Search Synonymy
Select Distinct Boolean Select Distinct
Smushed Boolean Smushed
SQL Str Text 4096 SQL Str
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
one-to-many fields
many-to-one modifiedByAgent
one-to-many reports
many-to-one specifyUser
Back to top
Sp Query Field
System Table: This represents a single field in a saved Query.
Field Type Length Description Flags
Allow Nulls Boolean Allow Nulls
Always Filter Boolean Always Filter
Column Alias String 64 Column Alias
Context Table Ident Integer Context Table Ident
End Value String 1000 End Value
Field Name String 32 Field Name Required
Format Name String 64 Format Name
Is Display Boolean Is Display Required
Is Not Boolean Is Not Required
Is Prompt Boolean Is Prompt
Is Rel Fld Boolean Is Rel Fld
Oper End Byte Oper End
Oper Start Byte Oper Start Required
Position Short Position Required
Sort Type Byte Sort Type Required
Start Value String 1000 Start Value Required
String Id String 500 String Id Required
Table List String 500 Table List Required
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
one-to-many mappings
many-to-one modifiedByAgent
many-to-one query
Back to top
Sp Report
System Table: This represents a saved Report.
Field Type Length Description Flags
Name String 64 Name Required Indexed
Remarks Text 4096 Remarks
Repeat Count Integer Repeat Count
Repeat Field String 255 Repeat Field
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one appResource
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one query
many-to-one specifyUser
one-to-one workbenchTemplate
Back to top
Sp Symbiota Instance
Sp Symbiota Instance
Field Type Length Description Flags
Collection Member Id Integer Collection Member Id Required Indexed
Description String 256 Description
Instance Name String 256 Instance Name
Last Cache Build Calendar Last Cache Build
Last Pull Calendar Last Pull
Last Push Calendar Last Push
Remarks Text Remarks
Symbiota Key String 128 Symbiota Key
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one schemaMapping
Back to top
Sp Task Semaphore
System Table:
Field Type Length Description Flags
Context String 32 Context
Is Locked Boolean Is Locked
Locked Time Timestamp Locked Time
Machine Name String 64 Machine Name
Scope Byte Scope
Task Name String 32 Task Name
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Usage Count Integer Usage Count
Version Integer Version
Relationships
Type Target Table Field name
many-to-one collection
many-to-one createdByAgent
many-to-one discipline
many-to-one modifiedByAgent
many-to-one owner
Back to top
Sp Version
Sp Version
Field Type Length Description Flags
App Name String 32 App Name
App Version String 16 App Version
Db Closed By String 32 Db Closed By
Is D B Closed Boolean Is D B Closed
Schema Version String 16 Schema Version
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Workbench Schema Version String 16 Workbench Schema Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
View Set Object
System Table: This represents a View Set used in the form system.
Field Type Length Description Flags
Description String 255 Description
File Name String 255 File Name
Level Short Level Required
Meta Data String 255 Meta Data
Name String 64 Name Required Indexed
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
one-to-many spAppResourceDatas
many-to-one spAppResourceDir
Back to top
Sp Visual Query
Sp Visual Query
Field Type Length Description Flags
Description Text 4096 Description
Name String 64 Name Required Indexed
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
one-to-many polygons
many-to-one specifyUser
Back to top
Specify User
System Table: This represents Specify User within the application.
Field Type Length Description Flags
Accumulated Minutes Logged In Long Accumulated Minutes Logged In
Email String 64 Email
Is Logged In Boolean Is Logged In Required
Is Logged In Report Boolean Is Logged In Report Required
Login Collection Name String 64 Login Collection Name
Login Discipline Name String 64 Login Discipline Name
Login Out Time Timestamp Login Out Time
Name String 64 Name Required Unique
Password String 255 Password Required
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
User Group String 32 User Group
Version Integer Version
Relationships
Type Target Table Field name
one-to-many agents
many-to-one createdByAgent
many-to-one modifiedByAgent
one-to-many spAppResourceDirs
one-to-many spAppResources
many-to-many spPrincipals
one-to-many spQuerys
one-to-many taskSemaphores
one-to-many workbenchTemplates
one-to-many workbenches
Back to top
Storage
A tree data structure for describing where Collection Objects are physically stored.
Field Type Length Description Flags
Abbreviation String 16 Abbreviation
Full Name String 255 Full Name Indexed
Highest Child Node Number Integer Highest Child Node Number
Is Preferred Boolean Is Preferred Required
Name String 64 Name Required Indexed
Node Number Integer Node Number
Number1 Integer User definable
Number2 Integer User definable
Rank Id Integer Rank Id Required
Remarks Text 4096 Additional Comments
Text1 String 32 User definable
Text2 String 32 User definable
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Timestamp Version Date Timestamp Version
Version Integer Version
Relationships
Type Target Table Field name
one-to-many acceptedChildren
many-to-one acceptedStorage
one-to-many children
one-to-many containers
many-to-one createdByAgent
many-to-one definition
many-to-one definitionItem
many-to-one modifiedByAgent
many-to-one parent
one-to-many preparations
one-to-many storageAttachments
Back to top
Storage Attachment
Storage Attachment
Field Type Length Description Flags
Ordinal Integer Ordinal Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one storage
Back to top
Storage Tree Definition
Defines the levels of the tree.
Field Type Length Description Flags
Full Name Direction Integer Full Name Direction
Name String 64 Name Required
Remarks Text 4096 Additional Comments
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
one-to-many institutions
many-to-one modifiedByAgent
one-to-many treeDefItems
one-to-many treeEntries
Back to top
Storage Tree Definition Item
Describes a level in the definition of the tree.
Field Type Length Description Flags
Full Name Separator String 32 Full Name Separator
Is Enforced Boolean Is Enforced
Is In Full Name Boolean Is In Full Name
Name String 64 Name Required
Rank Id Integer Rank Id Required
Remarks Text 4096 Additional Comments
Text After String 64 User definable
Text Before String 64 User definable
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Title String 64 Title
Version Integer Version
Relationships
Type Target Table Field name
one-to-many children
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one parent
many-to-one treeDef
one-to-many treeEntries
Back to top
Taxon
Describes the taxonomy of a Determination.
Field Type Length Description Flags
Author String 128 Author
CITES Status String 32 CITES Status
Col Status String 32 Col Status
Common Name String 128 Common Name Indexed
Cultivar Name String 32 Cultivar Name
Environmental Protection Status String 64 Environmental Protection Status Indexed
ESA Status String 64 ESA Status
Full Name String 255 Full Name Indexed
Group Number String 20 Taxonomic group number
GUID String 128 GUID Indexed
Highest Child Node Number Integer Highest Child Node Number
Integer1 Long Integer1
Integer2 Long Integer2
Integer3 Long Integer3
Integer4 Integer Integer4
Integer5 Integer Integer5
Is Preferred Boolean Is Preferred Required
Is Hybrid Boolean Is Hybrid Required
ISIS Number String 16 ISIS Number
Label Format String 64 Label Format
LSID Text LSID
Name String 64 Name Required Indexed
NCBI Taxon Number String 8 NCBI Taxon Number
Node Number Integer Node Number
Number 1 Integer Number 1
Number 2 Integer Number 2
Number3 Float Number3
Number4 Float Number4
Number5 Float Number5
Rank ID Integer Rank ID Required
Remarks Text 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 Indexed
Text 1 String 32 Text 1
Text10 String 128 Text10
Text11 String 128 Text11
Text12 String 128 Text12
Text13 String 128 Text13
Text14 String 256 Text14
Text15 String 256 Text15
Text16 String 256 Text16
Text17 String 256 Text17
Text18 String 256 Text18
Text19 String 256 Text19
Text 2 String 32 Text 2
Text20 String 256 Text20
Text3 Text 65535 Text3
Text4 Text 65535 Text4
Text5 Text 65535 Text5
Text6 Text 65535 Text6
Text7 Text 65535 Text7
Text8 Text 65535 Text8
Text9 Text 65535 Text9
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Unit Ind1 String 50 Unit Ind1
Unit Ind2 String 50 Unit Ind2
Unit Ind3 String 50 Unit Ind3
Unit Ind4 String 50 Unit Ind4
Unit Name1 String 50 Unit Name1
Unit Name2 String 50 Unit Name2
Unit Name3 String 50 Unit Name3
Unit Name4 String 50 Unit Name4
USFWS Code String 16 USFWS Code
Version Integer Version
Visibility Byte Visibility
Yes No1 Boolean Yes No1
Yes No10 Boolean Yes No10
Yes No11 Boolean Yes No11
Yes No12 Boolean Yes No12
Yes No13 Boolean Yes No13
Yes No14 Boolean Yes No14
Yes No15 Boolean Yes No15
Yes No16 Boolean Yes No16
Yes No17 Boolean Yes No17
Yes No18 Boolean Yes No18
Yes No19 Boolean Yes No19
Yes No2 Boolean Yes No2
Yes No3 Boolean Yes No3
Yes No4 Boolean Yes No4
Yes No5 Boolean Yes No5
Yes No6 Boolean Yes No6
Yes No7 Boolean Yes No7
Yes No8 Boolean Yes No8
Yes No9 Boolean Yes No9
Relationships
Type Target Table Field name
one-to-many acceptedChildren
many-to-one acceptedTaxon
one-to-many children
one-to-many collectingEventAttributes
one-to-many commonNames
many-to-one createdByAgent
many-to-one definition
many-to-one definitionItem
one-to-many determinations
one-to-many hybridChildren1
one-to-many hybridChildren2
many-to-one hybridParent1
many-to-one hybridParent2
many-to-one modifiedByAgent
many-to-one parent
one-to-many taxonAttachments
many-to-one taxonAttribute
one-to-many taxonCitations
many-to-one visibilitySetBy
Back to top
Taxon Attachment
This refers to an attachment and provides order.
Field Type Length Description Flags
Ordinal Integer Ordinal Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one taxon
Back to top
Taxon Attribute
Taxon Attribute
Field Type Length Description Flags
Date1 Calendar None
Date1 Precision Byte Date1 Precision
Number1 Float None
Number10 Float None
Number11 Float None
Number12 Float None
Number13 Float None
Number14 Float None
Number15 Float None
Number16 Float None
Number17 Float None
Number18 Float None
Number19 Float None
Number2 Float None
Number20 Float None
Number3 Float None
Number4 Float None
Number5 Float None
Number6 Float None
Number7 Float None
Number8 Float None
Number9 Float None
Remarks Text 65535 None
Text1 String 128 None
Text10 String 128 None
Text11 String 128 None
Text12 String 128 None
Text13 String 128 None
Text14 String 128 None
Text15 String 128 None
Text16 String 128 None
Text17 String 128 None
Text18 String 128 None
Text19 String 128 None
Text2 String 128 None
Text20 String 128 None
Text21 String 128 None
Text22 String 128 None
Text23 String 128 None
Text24 String 128 None
Text25 String 128 None
Text26 String 128 None
Text27 String 256 None
Text28 String 256 None
Text29 String 256 None
Text3 String 128 None
Text30 String 256 None
Text31 String 256 None
Text32 String 256 None
Text33 String 256 None
Text34 String 256 None
Text35 String 256 None
Text36 String 256 None
Text37 String 256 None
Text38 String 256 None
Text39 String 256 None
Text4 String 128 None
Text40 String 256 None
Text41 String 256 None
Text42 String 256 None
Text43 String 256 None
Text44 String 256 None
Text45 String 256 None
Text46 String 256 None
Text47 String 256 None
Text48 String 256 None
Text49 Text 65535 None
Text5 String 128 None
Text50 Text 65535 None
Text51 Text 65535 None
Text52 Text 65535 None
Text53 Text 65535 None
Text54 Text 65535 None
Text55 Text 65535 None
Text56 Text 65535 None
Text57 Text 65535 None
Text58 Text 65535 None
Text6 String 128 None
Text7 String 128 None
Text8 String 128 None
Text9 String 128 None
Timestamp Created Timestamp None Required
Timestamp Modified Timestamp None
Version Integer None
Yes No1 Boolean None
Yes No10 Boolean None
Yes No11 Boolean None
Yes No12 Boolean None
Yes No13 Boolean None
Yes No14 Boolean None
Yes No15 Boolean None
Yes No16 Boolean None
Yes No17 Boolean None
Yes No18 Boolean None
Yes No19 Boolean None
Yes No2 Boolean None
Yes No20 Boolean None
Yes No21 Boolean None
Yes No22 Boolean None
Yes No23 Boolean None
Yes No24 Boolean None
Yes No25 Boolean None
Yes No26 Boolean None
Yes No27 Boolean None
Yes No28 Boolean None
Yes No29 Boolean None
Yes No3 Boolean None
Yes No30 Boolean None
Yes No31 Boolean None
Yes No32 Boolean None
Yes No33 Boolean None
Yes No34 Boolean None
Yes No35 Boolean None
Yes No36 Boolean None
Yes No37 Boolean None
Yes No38 Boolean None
Yes No39 Boolean None
Yes No4 Boolean None
Yes No40 Boolean None
Yes No41 Boolean None
Yes No42 Boolean None
Yes No43 Boolean None
Yes No44 Boolean None
Yes No45 Boolean None
Yes No46 Boolean None
Yes No47 Boolean None
Yes No48 Boolean None
Yes No49 Boolean None
Yes No5 Boolean None
Yes No50 Boolean None
Yes No51 Boolean None
Yes No52 Boolean None
Yes No53 Boolean None
Yes No54 Boolean None
Yes No55 Boolean None
Yes No56 Boolean None
Yes No57 Boolean None
Yes No58 Boolean None
Yes No59 Boolean None
Yes No6 Boolean None
Yes No60 Boolean None
Yes No61 Boolean None
Yes No62 Boolean None
Yes No63 Boolean None
Yes No64 Boolean None
Yes No65 Boolean None
Yes No66 Boolean None
Yes No67 Boolean None
Yes No68 Boolean None
Yes No69 Boolean None
Yes No7 Boolean None
Yes No70 Boolean None
Yes No71 Boolean None
Yes No72 Boolean None
Yes No73 Boolean None
Yes No74 Boolean None
Yes No75 Boolean None
Yes No76 Boolean None
Yes No77 Boolean None
Yes No78 Boolean None
Yes No79 Boolean None
Yes No8 Boolean None
Yes No80 Boolean None
Yes No81 Boolean None
Yes No82 Boolean None
Yes No9 Boolean None
Relationships
Type Target Table Field name
many-to-one agent1
many-to-one createdByAgent
many-to-one modifiedByAgent
one-to-many taxons
Back to top
Taxon Citation
Linkage from the Taxonomic record to a published document.
Field Type Length Description Flags
Number1 Float 24 User definable
Number2 Float 24 User definable
Remarks Text 4096 Additional Comments
Text1 Text 65535 User definable
Text2 Text 65535 User definable
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Yes No1 Boolean User definable
Yes No2 Boolean User definable
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one referenceWork
many-to-one taxon
Back to top
Taxon Tree Definition
Defines the levels of the tree.
Field Type Length Description Flags
Full Name Direction Integer Full Name Direction
Name String 64 Name Required
Remarks String 255 Additional Comments
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
one-to-one discipline
many-to-one modifiedByAgent
one-to-many treeDefItems
one-to-many treeEntries
Back to top
Taxon Tree Definition Item
Describes a level in the definition of the tree.
Field Type Length Description Flags
Format Token String 32 Format Token
Full Name Separator String 32 Full Name Separator
Is Enforced Boolean Is Enforced
Is In Full Name Boolean Is In Full Name
Name String 64 Name Required
Rank Id Integer Rank Id Required
Remarks Text 4096 Additional Comments
Text After String 64 User definable
Text Before String 64 User definable
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Title String 64 Title
Version Integer Version
Relationships
Type Target Table Field name
one-to-many children
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one parent
many-to-one treeDef
one-to-many treeEntries
Back to top
Treatment Event
An action that occurs to a Conservation Description.
Field Type Length Description Flags
Date Boxed Calendar Date Boxed
Date Cleaned Calendar Date Cleaned
Date Completed Calendar Date Completed
Date Received Calendar Date Received Indexed
Date To Isolation Calendar Date To Isolation
End Date Calendar End Date
Start Date Calendar Start Date Indexed
Field Number String 50 Field Number Indexed
Location String 64 Location
Number1 Integer Number1
Number2 Integer Number2
Number3 Float Number3
Number4 Float Number4
Number5 Float Number5
Remarks Text 2048 Remarks
Text1 Text 65535 None
Text2 Text 65535 Text2
Text3 Text 65535 Text3
Text4 Text 65535 Text4
Text5 Text 65535 Text5
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Treat Number String 32 Treat Number Indexed
Type String 128 Type
Version Integer Version
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Yes No3 Boolean Yes No3
Relationships
Type Target Table Field name
many-to-one accession
many-to-one authorizedBy
many-to-one collectionObject
many-to-one createdByAgent
many-to-one division
many-to-one modifiedByAgent
many-to-one performedBy
one-to-many treatmentEventAttachments
Back to top
Treatment Event Attachment
Treatment Event Attachment
Field Type Length Description Flags
Ordinal Integer Ordinal Required
Remarks Text 4096 Remarks
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one attachment
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one treatmentEvent
Back to top
Voucher Relationship
Voucher Relationship
Field Type Length Description Flags
Collection Code String 64 Collection Code
Collection Member Id Integer Collection Member Id Required Indexed
Institution Code String 64 Institution Code
Integer1 Integer Integer1
Integer2 Integer Integer2
Integer3 Integer Integer3
Number1 Float Number1
Number2 Float Number2
Number3 Float Number3
Remarks Text 65535 Remarks
Text1 Text 65535 None
Text2 Text 65535 Text2
Text3 Text 65535 Text3
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
URL Link String 1024 URL Link
Version Integer Version
Voucher Number String 256 Voucher Number
Yes No1 Boolean Yes No1
Yes No2 Boolean Yes No2
Yes No3 Boolean Yes No3
Relationships
Type Target Table Field name
many-to-one collectionObject
many-to-one createdByAgent
many-to-one modifiedByAgent
Back to top
WorkBench
A WorkBench DataSet.
Field Type Length Description Flags
All Permission Level Integer All Permission Level
Database Table Id Integer Database Table Id
Export Institution Name String 128 Export Institution Name
Exported From Table Name String 128 Exported From Table Name
Form Id Integer Form Id
Group Permission Level Integer Group Permission Level
Locked By User Name String 64 Locked By User Name
Name String 64 Name
Owner Permission Level Integer Owner Permission Level
Remarks Text 4096 Additional Comments
Source File Path String 255 Source File Path
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one group
many-to-one modifiedByAgent
many-to-one specifyUser
one-to-many workbenchRows
many-to-one workbenchTemplate
Back to top
WorkBench Data Item
A cell of data.
Field Type Length Description Flags
Cell Data Text Cell Data
Row Number Short Row Number
Validation Status Short Validation Status
Relationships
Type Target Table Field name
many-to-one workbenchRow
many-to-one workbenchTemplateMappingItem
Back to top
Workbench Row
A row of data.
Field Type Length Description Flags
Bio Geomancer Results Text 8192 The XML returned from Bio Geomancer
Card Image Data Text 16000000 A single image attached to the row
Card Image Full Path String 255 The full path of the image
Error Estimate Bigdecimal Error Estimate
Error Polygon Text 65535 Error Polygon
Lat1 Text String 50 Lat1 Text
Lat2 Text String 50 Lat2 Text
Long1 Text String 50 Long1 Text
Long2 Text String 50 Long2 Text
Record Id Integer Record Id
Row Number Short The row number Indexed
Sgr Status Byte Sgr Status
Upload Status Byte Upload Status
Relationships
Type Target Table Field name
many-to-one workbench
one-to-many workbenchDataItems
one-to-many workbenchRowExportedRelationships
one-to-many workbenchRowImages
Back to top
Workbench Row Exported Relationship
Workbench Row Exported Relationship
Field Type Length Description Flags
Record Id Integer Record Id
Relationship Name String 120 Relationship Name
Sequence Integer Sequence
Table Name String 120 Table Name
Timestamp Created Timestamp Timestamp Created Required
Timestamp Modified Timestamp Timestamp Modified
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one workbenchRow
Back to top
Workbench Row Image
An image associated with a row.
Field Type Length Description Flags
Attach To Table Name String 64 Attach To Table Name
Card Image Data Text 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 Target Table Field name
many-to-one workbenchRow
Back to top
WorkBench Template
The mapping description of the WorkBench.
Field Type Length Description Flags
Name String 64 Name
Remarks Text 4096 Additional Comments
Source File Path String 255 Source File Path
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
many-to-one specifyUser
one-to-many workbenchTemplateMappingItems
one-to-many workbenches
Back to top
WorkBench Template Mapping Item
One column of the mapped description.
Field Type Length Description Flags
Caption String 64 Caption
Carry Forward Boolean Carry Forward
Data Field Length Short Data Field Length
Field Name String 255 Field Name
Field Type Short Field Type
Imported Column Name String 255 Imported Column Name
Is Editable Boolean Is Editable
Is Exportable To Content Boolean Is Exportable To Content
Is Included In Title Boolean Is Included In Title
Is Required Boolean Is Required
Meta Data String 128 Meta Data
Original Import Column Index Short Original Import Column Index
Source Table Id Integer 64 Source Table Id
Table Name String 64 Table Name
Timestamp Created Timestamp The timestamp the record was created. Required
Timestamp Modified Timestamp The timestamp the record was last modified.
Version Integer Version
View Order Short View Order
X Coordinate Short X Coordinate
Y Coordinate Short Y Coordinate
Relationships
Type Target Table Field name
many-to-one createdByAgent
many-to-one modifiedByAgent
one-to-many workbenchDataItems
many-to-one workbenchTemplate