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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 | ||
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 | |
String | 50 | |||
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 | ||
String | 64 | |||
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |