Updated: 11-03-2009

Contents

Table of Contents

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

Table Definitions

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
AccessionID	Integer		Primary Key
Accession Condition	String	255	Physical description of the condition of the accession.
Accession Number	String	60	Usually an integer or alphanumeric value that is assigned to material when it enters the collection. The format of accession numbers varies among collections, but all refer to the acquisition of specimens, observations, or other collection objects.
Date Accessioned	Calendar		Date of Accession.
Date Acknowledged	Calendar
Date Received	Calendar		Date material was received.
Number1	Float		A user-visible identifier of the Accession. Typically an integer, but may include alphanumeric characters as prefix, suffix, and separators.
Number2	Float		User definable.
Remarks	Memo	4096	Additional Comments.
Status	String	32	Status of Accession, e.g. `In process`, `Complete` ...
Text1	String	300	User definable.
Text2	String	300	User definable.
Text3	String	300	User definable.
Timestamp Created	Timestamp		The date and time the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Total Value	BigDecimal		The total monetary value of the accession.
Type	String	32	Source of Accession, e.g. `Collecting`, `Gift`, `Bequest` ...
Verbatim Date	String	50	Accommodates historical accessions.
Version	Integer
Yes No1	Boolean		User definable.
Yes No2	Boolean		User definable.
Relationships
Type		Name	To Table
one-to-many		Accession Agents	AccessionAgent
one-to-many		Accession Attachments	AccessionAttachment
one-to-many		Accession Authorizations	AccessionAuthorization
many-to-one		Address Of Record	AddressOfRecord
one-to-many		Appraisals	Appraisal
one-to-many		Collection Objects	CollectionObject
many-to-one		Created By Agent	Agent
one-to-many		Deaccessions	Deaccession
many-to-one		Division	Division
many-to-one		Modified By Agent	Agent
many-to-one		Repository Agreement	RepositoryAgreement
one-to-many		Treatment Events	TreatmentEvent

Accession Agent The person(s) requesting the Accession. This references an Agent.
Field	Type	Length	Description
AccessionAgentID	Integer		Primary Key
Remarks	Memo	4096	Additional Comments.
Role	String	50	Role the agent played in the accession process.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Accession	Accession
many-to-one		Agent	Agent
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Repository Agreement	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
AccessionAttachmentID	Integer		Primary Key
Ordinal	Integer		Provides a sequencial order for the attachments.
Remarks	Memo	4096	Additional comments.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Accession	Accession
many-to-one		Attachment	Attachment
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

Accession Authorization This represents the person authorizing the Accession. It references an existing Agent.
Field	Type	Length	Description
AccessionAuthorizationID	Integer		Primary Key
Remarks	Memo	4096	Additional comments.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Accession	Accession
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Permit	Permit
many-to-one		Repository Agreement	RepositoryAgreement

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

Address Of Record This is the address when the legal action took place.
Field	Type	Length	Description
AddressOfRecordID	Integer		Primary Key
Address	String	255	Primary address of record.
Address2	String	255	Secondary address of record.
City	String	64	City of record.
Country	String	64	Country of record.
Postal Code	String	32	Postal code of record (zip code).
Remarks	Memo	4096	Additional comments.
State	String	64	State of record.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Accessions	Accession
many-to-one		Agent	Agent
many-to-one		Created By Agent	Agent
one-to-many		Exchange Ins	ExchangeIn
one-to-many		Exchange Outs	ExchangeOut
one-to-many		Loans	Loan
many-to-one		Modified By Agent	Agent
one-to-many		Repository Agreements	RepositoryAgreement

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
AgentID	Integer		Primary Key
Abbreviation	String	50	Abbreviation of organization.
Agent Type	Byte		Discriminator between Organization(0), Person(1), Other(2), and Group(3).
Date Of Birth	Calendar		Date agent was born.
Date Of Death	Calendar
Email	String	50	Email address for agent.
First Name	String	50	First name of agent.
GUID	String	128	Global Unique Identifier.
Initials	String	8	Initials of agent.
Interests	String	255	Interests of Person or Organization.
Job Title	String	50	Agent`s (person) job title at specified address and organization.
Last Name	String	120	Last name of Person.
Middle Initial	String	50	Middle initial of Person.
Remarks	Memo	4096	Additional comments.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Title	String	50	Title of Person.
Url	String	1024	An URL for the web site of a Person or Group.
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Addresses	Address
one-to-many		Agent Attachments	AgentAttachment
one-to-many		Agent Geographies	AgentGeography
one-to-many		Agent Specialties	AgentSpecialty
many-to-one		Coll Content Contact	Collection
many-to-one		Coll Tech Contact	Collection
one-to-many		Collectors	Collector
many-to-one		Created By Agent	Agent
many-to-many		Disciplines	Discipline
many-to-one		Division	Division
one-to-many		Groups	GroupPerson
many-to-one		Inst Content Contact	Institution
many-to-one		Inst Tech Contact	Institution
one-to-many		Members	GroupPerson
many-to-one		Modified By Agent	Agent
one-to-many		Org Members	Agent
many-to-one		Organization	Agent
many-to-one		Specify User	SpecifyUser
one-to-many		Variants	AgentVariant

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
AgentAttachmentID	Integer		Primary Key
Ordinal	Integer		This allows the attachments to be ordered.
Remarks	Memo	4096	Additional comments.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Agent	Agent
many-to-one		Attachment	Attachment
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

Agent Geography The geographical region that a particular collector was known for collecting in.
Field	Type	Length	Description
AgentGeographyID	Integer		Primary Key
Remarks	Memo	4096	Additional comments.
Role	String	64	Role of the agent as "author" or "collector" within the geography.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Agent	Agent
many-to-one		Created By Agent	Agent
many-to-one		Geography	Geography
many-to-one		Modified by Agent	Agent

Agent Specialty The Taxonomic specialty that a particular agent was known for.
Field	Type	Length	Description
AgentSpecialtyID	Integer		Primary Key
Order Number	Integer		The priority of specialization, for agents with primary and secondary areas of specialization.
Specialty Name	String	64	The name of the field of specialization.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Agent	Agent
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

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
AgentVariantID	Integer		Primary Key
Country	String	2	Country of variant or vernacular name.
Language	String	2	International character code for language as it pertains to the agent variant.
Name	String	255	THe full name used as a variant or vernacular name.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Var Type	Byte		Indicates whether the record is a variant (0) or a vernacular name (1).
Variant	String	2
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Agent	Agent
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

App Resource System Table: This represents a resource, typically XML, that the application uses during run time.
Field	Type	Length	Description
SpAppResourceID	Integer		Primary Key
All Permission Level	Integer
Description	String	255
Group Permission Level	Integer
Level	Short
Meta Data	String	255
Mime Type	String	255
Name	String	64
Owner Permission Level	Integer
Timestamp Created	Timestamp		The timestamp the record was created.
Version	Integer
Relationships
Type		Name	To Table
one-to-many		App Resource Datas	SpAppResourceData
many-to-one		Created By Agent	Agent
many-to-one		Group	SpPrincipal
many-to-one		Modified By Agent	Agent
many-to-one		Sp App Resource Dir	SpAppResourceDir
one-to-many		Sp Reports	SpReport
many-to-one		Specify User	SpecifyUser

App Resource Data System Table: The data associated with an application resource.
Field	Type	Length	Description
SpAppResourceDataID	Integer		Primary Key
Data	Memo	16000000
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		App Resource	SpAppResource
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		View Set Obj	SpViewSetObj

App Resource Default System Table: the default for application resources.
Field	Type	Length	Description
SpAppResourceDirID	Integer		Primary Key
Discipline Type	String	64
Is Personal	Boolean
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
User Group	String	64
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Collection	Collection
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Modified By Agent	Agent
one-to-many		Sp Persisted App Resources	SpAppResource
one-to-many		Sp Persisted View Sets	SpViewSetObj
many-to-one		Specify User	SpecifyUser

Appraisal The monetary appraisal of an Acession or Collection Object
Field	Type	Length	Description
AppraisalID	Integer		Primary Key
Appraisal Date	Calendar		Date of the appraisal.
Appraisal Number	String	64	Unique number for the appraisal.
Appraisal Value	BigDecimal		Monetary value of the appraisal.
Monetary Unit Type	String	8	Type of monetary unit.
Notes	Memo	2048	Additional comments.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Accession	Accession
many-to-one		Agent	Agent
one-to-many		Collection Objects	CollectionObject
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

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
AttachmentID	Integer		Primary Key
Attachment Location	String	128	Location of attachment repository.
Copyright Date	String	64	Date of copyright of attachment.
Copyright Holder	String	64
Credit	String	64	Attachment credit.
Date Imaged	String	64
File Created Date	Calendar
License	String	64	Attachment license information.
Mime Type	String	64	Describes the attachment file type.
Original Filename	String	128	Original name of file.
Remarks	Memo	4096	Additional comments.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Title	String	64	Title of attachment.
Version	Integer
Visibility	Byte
Relationships
Type		Name	To Table
one-to-many		Accession Attachments	AccessionAttachment
one-to-many		Agent Attachments	AgentAttachment
one-to-many		Collecting Event Attachments	CollectingEventAttachment
one-to-many		Collection Object Attachments	CollectionObjectAttachment
one-to-many		Conserv Description Attachments	ConservDescriptionAttachment
one-to-many		Conserv Event Attachments	ConservEventAttachment
many-to-one		Created By Agent	Agent
one-to-many		Dna Sequence Attachments	DNASequencingRunAttachment
one-to-many		Field Notebook Attachments	FieldNotebookAttachment
one-to-many		Field Notebook Page Attachments	FieldNotebookPageAttachment
one-to-many		Field Notebook Page Set Attachments	FieldNotebookPageSetAttachment
one-to-many		Loan Attachments	LoanAttachment
one-to-many		Locality Attachments	LocalityAttachment
one-to-many		Metadata	AttachmentMetadata
many-to-one		Modified By Agent	Agent
one-to-many		Permit Attachments	PermitAttachment
one-to-many		Preparation Attachments	PreparationAttachment
one-to-many		Repository Agreement Attachments	RepositoryAgreementAttachment
one-to-many		Tags	AttachmentTag
one-to-many		Taxon Attachments	TaxonAttachment
many-to-one		Visibility Set By	SpecifyUser

Attachment Metadata This holds meta data about the attachment. It is a set of named value pairs.
Field	Type	Length	Description
AttachmentMetadataID	Integer		Primary Key
Name	String	64	The name of the meta data field.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Value	String	128	The value of the meta data field.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

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
AttachmentTagID	Integer		Primary Key
Tag	String	64	Name of tag.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

Attribute Definition The definition of an attribute.
Field	Type	Length	Description
AttributeDefID	Integer		Primary Key
Data Type	Short		The data type of the attribute.
Field Name	String	32	The field name of the attribute.
Table Type	Short		The type of table it is attached to, this is internal to Specify.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Collecting Event Attrs	CollectingEventAttr
one-to-many		Collection Object Attrs	CollectionObjectAttr
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Modified By Agent	Agent
many-to-one		Prep Type	PrepType
one-to-many		Preparation Attrs	PreparationAttr

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
AuthorID	Integer		Primary Key
Order Number	Short		the order of AgentID relative to other authors of reference.
Remarks	Memo	4096	Additional comments.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Agent	Agent
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Reference Work	ReferenceWork

Auto Numbering Scheme This is an internal table used to group together parts of a collection with the same numbering scheme.
Field	Type	Length	Description
AutoNumberingSchemeID	Integer		Primary Key
Format Name	String	64
Is Numeric Only	Boolean		Yes if number scheme is only numeric.
Scheme Class Name	String	64
Scheme Name	String	64	Name of the scheme (sequence).
Table Number	Integer
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-many		Collections	Collection
many-to-one		Created By Agent	Agent
many-to-many		Disciplines	Discipline
many-to-many		Divisions	Division
many-to-one		Modified By Agent	Agent

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
BorrowID	Integer		Primary Key
Collection Member Id	Integer
Current Due Date	Calendar		Date loan is currently due. (Same as Original Due Date unless loan period has been extended)
Date Closed	Calendar	10	Date loan was closed.
Extension Granted	Boolean		User definable.
Invoice Number	String	50	Lender`s loan number.
Is Closed	Boolean		Indicates whether the borrow was closed (returned).
Is Financial Responsibility	Boolean
Number1	Float	24	User definable.
Number2	Float	24	User definable.
Original Due Date	Calendar		Original due date for loan.
Received Date	Calendar		Date material was received.
Remarks	Memo	4096	Additional comments.
Text1	String	300	User definable.
Text2	String	300	User definable.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Yes No2	Boolean		User definable.
Relationships
Type		Name	To Table
many-to-one		Address Of Record	AddressOfRecord
one-to-many		Borrow Agents	BorrowAgent
one-to-many		Borrow Materials	BorrowMaterial
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
one-to-many		Shipments	Shipment

Borrow Agent Refers to an Agent and describes their role in the borrowing process.
Field	Type	Length	Description
BorrowAgentID	Integer		Primary Key
Collection Member Id	Integer
Remarks	Memo	4096	Additional comments.
Role	String	32	Role played by agent in the borrow.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Agent	Agent
many-to-one		Borrow	Borrow
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

Borrow Material Describes the material being borrowed.
Field	Type	Length	Description
BorrowMaterialID	Integer		Primary Key
Collection Member Id	Integer
Description	String	50	Description of the material. `e.g. Bufo bufo skull`.
In Comments	Memo	1024	Notes concerning the receipt of the material.
Material Number	String	50	e.g. `FMNH 223456`
Out Comments	Memo	1024	Notes concerning the return of the material.
Quantity	Short		Number of specimens (for lots).
Quantity Resolved	Short		Quantity resolved (Returned, Accessioned, Lost, Discarded, Destroyed ...).
Quantity Returned	Short		Quantity returned.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Borrow	Borrow
one-to-many		Borrow Return Materials	BorrowReturnMaterial
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

Borrow Return Material Describes the material that was returned.
Field	Type	Length	Description
BorrowReturnMaterialID	Integer		Primary Key
Collection Member Id	Integer
Quantity	Short		Quantity of preparations returned.
Remarks	Memo	4096	Additional comments.
Returned Date	Calendar		The date the material was returned.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Agent	Agent
many-to-one		Borrow Material	BorrowMaterial
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

Chronostratigraphy Describes Chronostratigraphy.
Field	Type	Length	Description
GeologicTimePeriodID	Integer		Primary Key
End Period	Float
End Uncertainty	Float
Full Name	String	255
GUID	String	128
Highest Child Node Number	Integer
Is BioStratigraphy	Boolean
Is Preferred	Boolean
Name	String	64
Node Number	Integer
Rank Id	Integer		Numeric representation of Items rank in stratigraphic hierarchy.
Remarks	Memo	4096	Additional Comments.
Standard	String	64	The system of Stratigraphy the record is included in.
Start Period	Float
Start Uncertainty	Float
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Bio Strats Paleo Context	PaleoContext
one-to-many		Child Nodes	GeologicTimePeriod
one-to-many		Chronos Strats Paleo Context	PaleoContext
many-to-one		Created By Agent	Agent
many-to-one		Definition	GeologicTimePeriodTreeDef
many-to-one		Modified By Agent	Agent
many-to-one		Parent	GeologicTimePeriod
many-to-one		Preferred Chronostratigraphy	GeologicTimePeriod
many-to-one		Rank	GeologicTimePeriodTreeDefItem
one-to-many		Synonyms	GeologicTimePeriod

Collecting Event A collecting event is the 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
CollectingEventID	Integer		Primary Key
End Date	Calendar		The date collecting event ended.
End Date Precision	Byte
End Date Verbatim	String	50
End Time	Short		End time in military format.
Field Number	String	50	Station number or field number of the site where collecting event took place, A number or code recorded in field notes and/or written on field tags that identifies ALL material collected in a Collecting Event.
Method	String	50	A method, such as net or trap, which is used to obtain the specimen.
Remarks	Memo	4096	Free text to record information that does not conform to structured fields, or to explain data recorded in those fields, particularly problematic interpretations of data given by collector(s).
Start Date	Calendar		The date collecting event began.
Start Date Precision	Byte
Start Date Verbatim	String	50
Start Time	Short		Start time in military format.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Verbatim Date	String	50	Date which collector recorded in field book, exactly as reported by the collector. Should indicate whether reported as range, season, month, etc.
Verbatim Locality	Memo	2048	Original statement (literal quotation) of the location of the Collecting Event as given by the Collector.
Version	Integer
Visibility	Byte
Relationships
Type		Name	To Table
one-to-many		Collecting Event Attachments	CollectingEventAttachment
many-to-one		Collecting Event Attribute	CollectingEventAttribute
one-to-many		Collecting Event Attrs	CollectingEventAttr
many-to-one		Collecting Trip	CollectingTrip
one-to-many		Collection Objects	CollectionObject
one-to-many		Collectors	Collector
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Locality	Locality
many-to-one		Modified By Agent	Agent
many-to-one		Visibility Set By	SpecifyUser

Collecting Event Attachment Refers to an attachment and provides an order.
Field	Type	Length	Description
CollectingEventAttachmentID	Integer		Primary Key
Collection Member Id	Integer
Ordinal	Integer		The order or position of the attachment.
Remarks	Memo	4096	Additonal comments.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Collecting Event	CollectingEvent
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

Collecting Event Attribute Extensible attributes introduced for Specify 6.
Field	Type	Length	Description
AttrID	Integer		Primary Key
Collection Member Id	Integer
Double Value	Double
String Value	String	255
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Collecting Event	CollectingEvent
many-to-one		Created By Agent	Agent
many-to-one		Definition	AttributeDef
many-to-one		Modified By Agent	Agent

Collecting Event Attribute Collecting Event Attributes that were also available in Specify 5.
Field	Type	Length	Description
CollectingEventAttributeID	Integer		Primary Key
Collection Member Id	Integer
Number1	Float
Number10	Float
Number11	Float
Number12	Float
Number13	Float
Number2	Float
Number3	Float
Number4	Float
Number5	Float
Number6	Float
Number7	Float
Number8	Float
Number9	Float
Remarks	Memo	4096
Text1	String	300
Text10	String	50
Text11	String	50
Text12	String	50
Text13	String	50
Text14	String	50
Text15	String	50
Text16	String	50
Text17	String	50
Text2	String	300
Text3	String	300
Text4	String	100
Text5	String	100
Text6	String	50
Text7	String	50
Text8	String	50
Text9	String	50
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Yes No3	Boolean
Yes No4	Boolean
Yes No5	Boolean
Relationships
Type		Name	To Table
one-to-many		Collecting Events	CollectingEvent
many-to-one		Created By Agent	Agent
many-to-one		Host Taxon	Taxon
many-to-one		Modified By Agent	Agent

Collecting Trip Used to group Collecting Events together.
Field	Type	Length	Description
CollectingTripID	Integer		Primary Key
End Date	Calendar		The ending date of the collecting trip.
End Date Verbatim	String	50
End Time	Short		The ending time of the collecting trip.
Remarks	Memo	4096	Additional comments.
Sponsor	String	64	Name of sponsor of collecting trip.
Start Date	Calendar		The start date of the collecting trip.
Start Date Verbatim	String	50
Start Time	Short		The start time of the collecting trip.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Trip Name	String	64	Name of the collecting trip.
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Collecting Information	CollectingEvent
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Modified By Agent	Agent

Collection A collection holds Collection Objects that are of the same discipline type.
Field	Type	Length	Description
UserGroupScopeId	Integer		Primary Key
Catalog Num Format Name	String	64	Name of catalog number format the collection uses.
Code	String	50	Unique code for collection.
Collection Name	String	50	The name of the collection.
Collection Type	String	32	Textual description of collection. ABCD schema field.
Db Content Version	String	32	ABCD schema field.
Description	Memo	2048	Textual description of collection.
Development Status	String	32	ABCD schema field.
Estimated Size	Integer		ABCD schema field.
ISA Number	String	24	ISA number.
Institution Type	String	32	ABCD schema field.
Is Embedded Collecting Event	Boolean		Yes if collecting event is one-to-one relationship.
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
Remarks	Memo	4096	Additional comments.
Scope	Memo	2048	ABCD schema field.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Web Portal URI	String	255
Web Site URI	String	255
Relationships
Type		Name	To Table
one-to-many		Content Contacts	Agent
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
one-to-many		Left Side Rel Types	CollectionRelType
many-to-one		Modified By Agent	Agent
many-to-many		Numbering Schemes	AutoNumberingScheme
one-to-many		Pick Lists	PickList
one-to-many		Prep Types	PrepType
one-to-many		Right Side Rel Types	CollectionRelType
one-to-many		Technical Contacts	Agent
one-to-many		User Groups	SpPrincipal

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
CollectionObjectID	Integer		Primary Key
Alt Cat Number	String	32	Alternate Catalog Number.
Availability	String	32
Catalog Number	String	32	The number that identifies an individual specimen, a lot of specimens, or an observation as a part of a museum collection.
Cataloged Date	Calendar		Date the object was cataloged.
Cataloged Date Precision	Byte
Cataloged Date Verbatim	String	32	The verbatim date the specimen was collected.
Collection Member Id	Integer
Count Amount	Integer		The number of objects (specimens, slides, pieces) prepared.
Deaccessioned	Boolean		True if the object has been deaccessioned.
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.).
GUID	String	128	Global Unique Identifier
Inventory Date	Calendar
Modifier	String	50
Name	String	64
Notifications	String	32
Number1	Float	24	User definable.
Number2	Float	24	User definable.
Object Condition	String	64
Project Number	String	64
Remarks	Memo	4096	Additional Comments.
Restrictions	String	32
Text1	String	300	User definable.
Text2	String	300	User definable.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Total Value	BigDecimal
Version	Integer
Visibility	Byte	10
Yes No1	Boolean		User definable.
Yes No2	Boolean		User definable.
Yes No3	Boolean		User definable.
Yes No4	Boolean		User definable.
Yes No5	Boolean		User definable.
Yes No6	Boolean		User definable.
Relationships
Type		Name	To Table
many-to-one		Accession	Accession
many-to-one		Appraisal	Appraisal
many-to-one		Cataloger	Agent
many-to-one		Col Obj Attribute	CollectionObjectAttribute
many-to-one		Collecting Event	CollectingEvent
many-to-one		Collection	Collection
one-to-many		Collection Object Attachments	CollectionObjectAttachment
one-to-many		Collection Object Attrs	CollectionObjectAttr
one-to-many		Collection Object Citations	CollectionObjectCitation
one-to-many		Conserv Descriptions	ConservDescription
many-to-one		Container	Container
many-to-one		Container Owner	Container
many-to-one		Created By Agent	Agent
one-to-many		DNA Sequences	DNASequence
one-to-many		Determinations	Determination
one-to-many		Exsiccata Items	ExsiccataItem
many-to-one		Field Notebook Page	FieldNotebookPage
one-to-many		Left Side Rels	CollectionRelationship
many-to-one		Modified By Agent	Agent
one-to-many		Other Identifiers	OtherIdentifier
many-to-one		Paleo Context	PaleoContext
one-to-many		Preparations	Preparation
many-to-many		Projects	Project
one-to-many		Right Side Rels	CollectionRelationship
one-to-many		Treatment Events	TreatmentEvent
many-to-one		Visibility Set By	SpecifyUser

Collection Object Attachment An attachment for a collection object and provides order.
Field	Type	Length	Description
CollectionObjectAttachmentID	Integer		Primary Key
Collection Member Id	Integer
Ordinal	Integer		The order in the attachment list.
Remarks	Memo	4096
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Collection Object	CollectionObject
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

Collection Object Attribute Extensible attributes introduced for Specify 6.
Field	Type	Length	Description
AttrID	Integer		Primary Key
Collection Member Id	Integer
Double Value	Double
String Value	String	255
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Collection Object	CollectionObject
many-to-one		Created By Agent	Agent
many-to-one		Definition	AttributeDef
many-to-one		Modified By Agent	Agent

Collection Object Attribute Collection Object attributes that were also available in Specify 5.
Field	Type	Length	Description
CollectionObjectAttributeID	Integer		Primary Key
Collection Member Id	Integer
Number1	Float
Number10	Float
Number11	Float
Number12	Float
Number13	Float
Number14	Float
Number15	Float
Number16	Float
Number17	Float
Number18	Float
Number19	Float
Number2	Float
Number20	Float
Number21	Float
Number22	Float
Number23	Float
Number24	Float
Number25	Float
Number26	Float
Number27	Float
Number28	Float
Number29	Float
Number3	Float
Number30	Short
Number31	Float
Number32	Float
Number33	Float
Number34	Float
Number35	Float
Number36	Float
Number37	Float
Number38	Float
Number39	Float
Number4	Float
Number40	Float
Number41	Float
Number42	Float
Number5	Float
Number6	Float
Number7	Float
Number8	Byte
Number9	Float
Remarks	Memo	4096
Remarks	String	50
Text1	String	300
Text10	String	50
Text11	String	50
Text12	String	50
Text13	String	50
Text2	String	300
Text3	String	300
Text4	String	50
Text5	String	50
Text6	String	100
Text7	String	100
Text8	String	50
Text9	String	50
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Yes No3	Boolean
Yes No4	Boolean
Yes No5	Boolean
Yes No6	Boolean
Yes No7	Boolean
Relationships
Type		Name	To Table
one-to-many		Collection Objects	CollectionObject
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

Collection Object Citation Refers to a citation for a Collection Object.
Field	Type	Length	Description
CollectionObjectCitationID	Integer		Primary Key
Collection Member Id	Integer
Is Figured	Boolean
Remarks	Memo	4096	Additional Comments.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Collection Object	CollectionObject
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Reference Work	ReferenceWork

Collection Relationship Enables two collection objects to refer to each other, for example, voucher and tissue.
Field	Type	Length	Description
CollectionRelationshipID	Integer		Primary Key
Text1	String	32	User definable.
Text2	String	32	User definable.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Collection Rel Type	CollectionRelType
many-to-one		Created By Agent	Agent
many-to-one		Left Side	CollectionObject
many-to-one		Modified By Agent	Agent
many-to-one		Right Side	CollectionObject

Collection Relationship Type Describes the type of relationship between two collection objects.
Field	Type	Length	Description
CollectionRelTypeID	Integer		Primary Key
Name	String	32	The name of the Collection Relationship.
Remarks	String	4096	Additional comments.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Left Side Collection	Collection
many-to-one		Modified By Agent	Agent
one-to-many		Relationships	CollectionRelationship
many-to-one		Right Side Collection	Collection

Collector In Specify, the person or persons who collected a specimen. Collector records are stored in the Agent table.
Field	Type	Length	Description
CollectorID	Integer		Primary Key
Collection Member Id	Integer
Is Primary	Boolean
Order Number	Integer		The position in the list of collectors.
Remarks	Memo	4096	Additional comments.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Agent	Agent
many-to-one		Collecting Event	CollectingEvent
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

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
CommonNameTxID	Integer		Primary Key
Author	String	128
Country	String	2	The country code.
Language	String	2	The language code.
Name	String	255
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Variant	String	2	The variant code of the language.
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Citations	CommonNameTxCitation
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Taxon	Taxon

Common Name Tx Citation
Field	Type	Length	Description
CommonNameTxCitationID	Integer		Primary Key
Number1	Float
Number2	Float
Remarks	Memo	4096
Text1	String	300	User definable.
Text2	String	300	User definable.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Relationships
Type		Name	To Table
many-to-one		Common Name Tx	CommonNameTx
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Reference Work	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
ConservDescriptionID	Integer		Primary Key
Background Info	Memo	8192	Any background information on the object.
Composition	Memo	8192
Description	Memo	8192
Display Recommendations	Memo	4096
Height	Float		The height of the object.
Light Recommendations	Memo	4096
Object Length	Float		The length of the object.
Other Recommendations	Memo	4096
Remarks	Memo	8192	Additional Comments
Short Description	String	128	A short description of the object.
Source	Memo	8192
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Units	String	16	The units for the measurements (`feet` or `meters`).
Version	Integer
Width	Float		The width of the object.
Relationships
Type		Name	To Table
many-to-one		Collection Object	CollectionObject
one-to-many		Conserv Description Attachments	ConservDescriptionAttachment
many-to-one		Created By Agent	Agent
many-to-one		Division	Division
one-to-many		Events	ConservEvent
many-to-one		Modified By Agent	Agent

Conservator Description Attachment Refers to an attachment and provides order.
Field	Type	Length	Description
ConservDescriptionAttachmentID	Integer		Primary Key
Ordinal	Integer		The order or position
Remarks	Memo	4096
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Conserv Description	ConservDescription
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

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
ConservEventID	Integer		Primary Key
Advanced Testing Exam	Memo	8192	The advanced testing that was used to examine the object
Advanced Testing Exam Results	Memo	8192	The results of the advanced testing
Approval Date	Calendar	8192
Completed Comments	Memo	4096
Completed Date	Calendar
Condition Report	Memo	8192	A report on the condition
Exam Date	Calendar		The date the object was examined
Photo Documentation	Memo	8192	Any documentation on the photos that were taken
Remarks	Memo	4096
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Treatment Completion Date	Calendar
Treatment Report	Memo	8192	A description of the treatment that is needed.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Conserv Description	ConservDescription
one-to-many		Conserv Event Attachments	ConservEventAttachment
many-to-one		Created By Agent	Agent
many-to-one		Curator	Agent
many-to-one		Examined By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Treated By Agent	Agent

Conservator Event Attachment Refers to an attachment and provides order.
Field	Type	Length	Description
ConservEventAttachmentID	Integer		Primary Key
Ordinal	Integer		The order or position
Remarks	Memo	4096
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Conserv Event	ConservEvent
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

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
ContainerID	Integer		Primary Key
Collection Member Id	Integer
Description	String	255	A description of the container
Name	String	64	The name of the container
Number	Integer		User definable
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Type	Short		The type of container
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Children	Container
one-to-many		Collection Object Owners	CollectionObject
one-to-many		Collection Objects	CollectionObject
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Parent	Container
many-to-one		Storage	Storage

D N A Sequencing Run
Field	Type	Length	Description
DNASequencingRunID	Integer		Primary Key
Collection Member Id	Integer
Number1	Float
Number2	Float
Number3	Float
Ordinal	Integer
Pcr Cocktail Primer	Boolean
Pcr Forward Primer Code	String	32
Pcr Primer Name	String	32
Pcr Primer Seq5_3	String	64	Pcr Primer Sequence5_3
Pcr Reverse Primer Code	String	32
Read Direction	String	16
Remarks	Memo	4096
Run Date	Calendar
Score File Name	String	32
Seq Cocktail Primer	Boolean
Seq Primer Code	String	32	Sequence Primer Code
Seq Primer Name	String	32	Sequence Primer Name
Seq Primer Seq5_3	String	64	Sequence Primer Sequence5_3
Text1	String	32
Text2	String	32
Text3	String	64
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Trace File Name	String	32
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Yes No3	Boolean
Relationships
Type		Name	To Table
one-to-many		Attachments	DNASequencingRunAttachment
one-to-many		Citations	DNASequencingRunCitation
many-to-one		Created By Agent	Agent
many-to-one		Dna Sequence	DNASequence
many-to-one		Modified By Agent	Agent

D N A Sequencing Run Citation
Field	Type	Length	Description
DNASequencingRunCitationID	Integer		Primary Key
Number1	Float
Number2	Float
Remarks	Memo	4096
Text1	String	300
Text2	String	300
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Reference Work	ReferenceWork
many-to-one		Sequencing Run	DNASequencingRun

DNA Sequence Tracks DNA Sequencing information for a Collection Object.
Field	Type	Length	Description
DnaSequenceID	Integer		Primary Key
Ambiguous	Integer
BOLD Barcode Id	String	32
BOLD Last Update	Calendar
BOLD Sample Id	String	32
Bold Translation Matrix	String	64
Collection Member Id	Integer
Comp A	Integer
Comp C	Integer
Comp G	Integer
Comp T	Integer
Genbank Accession Number	String	32
Gene Sequence	Memo	2048	The actual sequence
Molecule Type	String	32
Number1	Float
Number2	Float
Number3	Float
Remarks	Memo	4096
Target Marker	String	32
Text1	String	32
Text2	String	32
Text3	String	64
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Total Residues	Integer
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Yes No3	Boolean
Relationships
Type		Name	To Table
many-to-one		Collection Object	CollectionObject
many-to-one		Created By Agent	Agent
one-to-many		Dna Sequencing Runs	DNASequencingRun
many-to-one		Modified By Agent	Agent
many-to-one		Sequencer	Agent

DNA Sequence Attachment Refers to an attachment and provides order.
Field	Type	Length	Description
DnaSequencingRunAttachmentId	Integer		Primary Key
Ordinal	Integer
Remarks	Memo	4096
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Created By Agent	Agent
many-to-one		Dna Sequencing Run	DNASequencingRun
many-to-one		Modified By Agent	Agent

Data Type A data type represents a core type of collection data.
Field	Type	Length	Description
DataTypeID	Integer		Primary Key
Name	String	50
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

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
DeaccessionID	Integer		Primary Key
Deaccession Date	Calendar
Deaccession Number	String	50	Name institution assigns to the deaccession
Number1	Float	24	User definable
Number2	Float	24	User definable
Remarks	Memo	4096	Additional Comments
Text1	String	300	User definable
Text2	String	300	User definable
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Type	String	64	Description of the Type of deaccession; i.e. Gift, disposal, lost
Version	Integer
Yes No1	Boolean		User definable
Yes No2	Boolean		User definable
Relationships
Type		Name	To Table
many-to-one		Accession	Accession
many-to-one		Created By Agent	Agent
one-to-many		Deaccession Agents	DeaccessionAgent
one-to-many		Deaccession Preparations	DeaccessionPreparation
many-to-one		Modified By Agent	Agent

Deaccession Agent Refers to an agent and contains their role in the deaccession.
Field	Type	Length	Description
DeaccessionAgentID	Integer		Primary Key
Remarks	Memo	4096	Additional Comments
Role	String	50	Role agent played in deaccession
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Agent	Agent
many-to-one		Created By Agent	Agent
many-to-one		Deaccession	Deaccession
many-to-one		Modified By Agent	Agent

Deaccession Preparation The preparation that was deaccessioned.
Field	Type	Length	Description
DeaccessionPreparationID	Integer		Primary Key
Quantity	Short		The number of items deaccessioned
Remarks	Memo	4096	Additional Comments
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Deaccession	Deaccession
one-to-many		Loan Return Preparations	LoanReturnPreparation
many-to-one		Modified By Agent	Agent
many-to-one		Preparation	Preparation

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

Determination Citation Refers to a citation for the determination.
Field	Type	Length	Description
DeterminationCitationID	Integer		Primary Key
Collection Member Id	Integer
Remarks	Memo	4096	Additional Comments.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Determination	Determination
many-to-one		Modified By Agent	Agent
many-to-one		Reference Work	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
UserGroupScopeId	Integer		Primary Key
Name	String	64
Reg Number	String	24
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Type	String	64
Version	Integer
Relationships
Type		Name	To Table
many-to-many		Agents	Agent
one-to-many		Attribute Defs	AttributeDef
many-to-one		Chronostratigraphy Tree Def	GeologicTimePeriodTreeDef
one-to-many		Collections	Collection
many-to-one		Created By Agent	Agent
many-to-one		Data Type	DataType
many-to-one		Division	Division
many-to-one		Geography Tree Def	GeographyTreeDef
many-to-one		Litho Strat Tree Def	LithoStratTreeDef
many-to-one		Modified By Agent	Agent
many-to-many		Numbering Schemes	AutoNumberingScheme
one-to-many		Sp Export Schemas	SpExportSchema
one-to-many		Sp Locale Containers	SpLocaleContainer
one-to-one		Taxon Tree Def	TaxonTreeDef
one-to-many		User Groups	SpPrincipal

Division The division (or department) containing agents.
Field	Type	Length	Description
UserGroupScopeId	Integer		Primary Key
Abbreviation	String	64	The abbreviation for the division.
Alt Name	String	128
Description	Memo	8192
Discipline	String	64	The discipline of the division
Icon URI	String	255	The URL to their icon
Name	String	255	The name of the division
Reg Number	String	24
Remarks	Memo	8192	Additional Comments
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
URI	String	255	A URI (web site) address for the department
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Address	Address
many-to-one		Created By Agent	Agent
one-to-many		Disciplines	Discipline
many-to-one		Institution	Institution
one-to-many		Members	Agent
many-to-one		Modified By Agent	Agent
many-to-many		Numbering Schemes	AutoNumberingScheme
one-to-many		User Groups	SpPrincipal

Exchange In Describes an incoming Exchanged Specimen from a different institution.
Field	Type	Length	Description
ExchangeInID	Integer		Primary Key
Description	String	120	Description of material.
Exchange Date	Calendar		Date exchange was received.
Number1	Float	24	User definable.
Number2	Float	24	User definable.
Quantity Exchanged	Short		Number of items received.
Remarks	Memo	4096	Additional Comments.
Source Geography	String	32
Source Taxonomy	String	32
Text1	String	300	User definable.
Text2	String	300	User definable.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Yes No1	Boolean		User definable.
Yes No2	Boolean		User definable.
Relationships
Type		Name	To Table
many-to-one		Address Of Record	AddressOfRecord
many-to-one		Cataloged By	Agent
many-to-one		Created By Agent	Agent
many-to-one		Division	Division
many-to-one		Modified By Agent	Agent
many-to-one		Received From	Agent

Exchange Out Describes an outgoing Exchanged Specimen to a different institution.
Field	Type	Length	Description
ExchangeOutID	Integer		Primary Key
Description	String	120
Exchange Date	Calendar		Date exchange was sent.
Number1	Float	24	User definable.
Number2	Float	24	User definable.
Quantity Exchanged	Short		Number of items sent.
Remarks	Memo	4096	Additional Comments.
Source Geography	String	32
Source Taxonomy	String	32
Text1	String	300	User definable.
Text2	String	300	User definable.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Yes No1	Boolean		User definable.
Yes No2	Boolean		User definable.
Relationships
Type		Name	To Table
many-to-one		Address Of Record	AddressOfRecord
many-to-one		Cataloged By	Agent
many-to-one		Created By Agent	Agent
many-to-one		Division	Division
many-to-one		Modified By Agent	Agent
many-to-one		Sent To	Agent
one-to-many		Shipments	Shipment

Exsiccata
Field	Type	Length	Description
ExsiccataID	Integer		Primary Key
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Title	String	255	The title of the exsiccata
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
one-to-many		Exsiccata Items	ExsiccataItem
many-to-one		Modified By Agent	Agent
many-to-one		Reference Work	ReferenceWork

Exsiccata Item
Field	Type	Length	Description
ExsiccataItemID	Integer		Primary Key
Fascicle	String	16	The fascicle number
Number	String	16	The list number of the collection object within the exsiccata
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Collection Object	CollectionObject
many-to-one		Created By Agent	Agent
many-to-one		Exsiccata	Exsiccata
many-to-one		Modified By Agent	Agent

Field Notebook Describes a physical Field NoteBook.
Field	Type	Length	Description
FieldNotebookID	Integer		Primary Key
Description	Memo	2048
End Date	Calendar
Location	String	64
Name	String	32
Start Date	Calendar
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Attachments	FieldNotebookAttachment
many-to-one		Collection	Collection
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Modified By Agent	Agent
many-to-one		Owner	Agent
one-to-many		Page Sets	FieldNotebookPageSet

Field Notebook Attachment Refers to an attachment and provides order.
Field	Type	Length	Description
FieldNotebookAttachmentId	Integer		Primary Key
Ordinal	Integer
Remarks	Memo	8192
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Created By Agent	Agent
many-to-one		Field Notebook	FieldNotebook
many-to-one		Modified By Agent	Agent

Field Notebook Page Describes a page from a Field Note Book.
Field	Type	Length	Description
FieldNotebookPageID	Integer		Primary Key
Description	String	128
Page Number	String	16
Scan Date	Calendar
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Attachments	FieldNotebookPageAttachment
one-to-many		Collection Objects	CollectionObject
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Modified By Agent	Agent
many-to-one		Page Set	FieldNotebookPageSet

Field Notebook Page Attachment Refers to an attachment and provides order.
Field	Type	Length	Description
FieldNotebookPageAttachmentId	Integer		Primary Key
Ordinal	Integer
Remarks	Memo	8192
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Created By Agent	Agent
many-to-one		Field Notebook Page	FieldNotebookPage
many-to-one		Modified By Agent	Agent

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
FieldNotebookPageSetID	Integer		Primary Key
Description	String	128
End Date	Calendar
Method	String	64
Order Number	Short
Start Date	Calendar
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Attachments	FieldNotebookPageSetAttachment
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Field Notebook	FieldNotebook
many-to-one		Modified By Agent	Agent
one-to-many		Pages	FieldNotebookPage
many-to-one		Source Agent	Agent

Field Notebook Page Set Attachment Refers to an attachment and provides order.
Field	Type	Length	Description
FieldNotebookPageSetAttachmentId	Integer		Primary Key
Ordinal	Integer
Remarks	Memo	8192
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Created By Agent	Agent
many-to-one		Field Notebook Page Set	FieldNotebookPageSet
many-to-one		Modified By Agent	Agent

Geo Coord Detail Describes extra detail for a Locality for Manis data.
Field	Type	Length	Description
GeoCoordDetailID	Integer		Primary Key
Geo Ref Accuracy Units	String	20
Geo Ref Det Date	Calendar
Geo Ref Det Ref	String	100
Geo Ref Remarks	Memo
Geo Ref Verification Status	String	50
Max Uncertainty Est	Float
Max Uncertainty Est Unit	String	8
Named Place Extent	Float
No Geo Ref Because	String	100
Original Coord System	String	32
Protocol	String	64
Source	String	64
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Validation	String	64
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Geo Ref Det By	Agent
many-to-one		Locality	Locality
many-to-one		Modified By Agent	Agent

Geography Represents a politcal boundary (Country, State, County, Township, etc.).
Field	Type	Length	Description
GeographyID	Integer		Primary Key
Abbreviation	String	16
Centroid Latitude	BigDecimal
Centroid Longitude	BigDecimal
Common Name	String	128
Full Name	String	255
GML	Memo	4096
GUID	String	128
Geography Code	String	8
Highest Child Node Number	Integer
Is Current	Boolean		`Yes` if the Name and/or Geographic/Political entity is currently valid.
Is Preferred	Boolean		The preferred name of a synonym.
Name	String	64
Node Number	Integer
Number1	Integer		User definable
Number2	Integer		User definable
Rank Id	Integer
Remarks	Memo	4096	Additional Comments
Text1	String	32	User definable.
Text2	String	32	User definable.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Timestamp Version	Date
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Child Nodes	Geography
many-to-one		Created By Agent	Agent
many-to-one		Definition	GeographyTreeDef
many-to-one		Geographic Rank	GeographyTreeDefItem
one-to-many		Localities	Locality
many-to-one		Modified By Agent	Agent
many-to-one		Parent	Geography
many-to-one		Preferred Geo	Geography
one-to-many		Synonyms	Geography

Geography Tree Definition Defines the levels of the Geography tree.
Field	Type	Length	Description
GeographyTreeDefID	Integer		Primary Key
Full Name Direction	Integer
Name	String	64
Remarks	Memo	4096	Additional Comments.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
one-to-many		Disciplines	Discipline
many-to-one		Modified By Agent	Agent
one-to-many		Tree Def Items	GeographyTreeDefItem
one-to-many		Tree Entries	Geography

Geography Tree Definition Item Describes a level in the definition of the tree.
Field	Type	Length	Description
GeographyTreeDefItemID	Integer		Primary Key
Full Name Separator	String	32
Is Enforced	Boolean
Is In Full Name	Boolean
Name	String	64
Rank Id	Integer
Remarks	Memo	4096	Additional Comments.
Text After	String	64	User definable.
Text Before	String	64	User definable.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Child Nodes	GeographyTreeDefItem
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Parent	GeographyTreeDefItem
many-to-one		Tree Definition	GeographyTreeDef
one-to-many		Tree Entries	Geography

Geological Time Period Tree Definition Defines the levels of the GTP tree.
Field	Type	Length	Description
GeologicTimePeriodTreeDefID	Integer		Primary Key
Full Name Direction	Integer
Name	String	64
Remarks	Memo	4096	Additional Comments.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
one-to-many		Disciplines	Discipline
many-to-one		Modified By Agent	Agent
one-to-many		Tree Def Items	GeologicTimePeriodTreeDefItem
one-to-many		Tree Entries	GeologicTimePeriod

Geological Time Period Tree Definition Item Describes a level in the definition of the tree.
Field	Type	Length	Description
GeologicTimePeriodTreeDefItemID	Integer		Primary Key
Full Name Separator	String	32
Is Enforced	Boolean
Is In Full Name	Boolean
Name	String	64
Rank Id	Integer
Remarks	Memo	4096	Additional Comments.
Text After	String	64	User definable.
Text Before	String	64	User definable.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Child Nodes	GeologicTimePeriodTreeDefItem
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Parent	GeologicTimePeriodTreeDefItem
many-to-one		Tree Definition	GeologicTimePeriodTreeDef
one-to-many		Tree Entries	GeologicTimePeriod

Gift Describes a Gift.
Field	Type	Length	Description
GiftID	Integer		Primary Key
Date Received	Calendar
Gift Date	Calendar
Gift Number	String	50
Is Financial Responsibility	Boolean
Number1	Float	24	User defined.
Number2	Float	24	se
Purpose Of Gift	String	64
Received Comments	String	255
Remarks	Memo	4096
Source Geography	String	32
Source Taxonomy	String	32
Special Conditions	Memo	2048
Text1	String	300	User definable.
Text2	String	300	User definable.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Relationships
Type		Name	To Table
many-to-one		Address Of Record	AddressOfRecord
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Division	Division
one-to-many		Gift Agents	GiftAgent
one-to-many		Gift Preparations	GiftPreparation
many-to-one		Modified By Agent	Agent
one-to-many		Shipments	Shipment

Gift Agent Describes the role the Agent played in the giving of a Gift.
Field	Type	Length	Description
GiftAgentID	Integer		Primary Key
Remarks	Memo	4096
Role	String	50
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Agent	Agent
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Gift	Gift
many-to-one		Modified By Agent	Agent

Gift Preparation Points a gift to a preparation.
Field	Type	Length	Description
GiftPreparationID	Integer		Primary Key
Description	String	255
In Comments	Memo	1024
Out Comments	Memo	1024
Quantity	Integer		Number of preparations included in the gift.
Received Comments	Memo	1024
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Gift	Gift
many-to-one		Modified By Agent	Agent
many-to-one		Preparation	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
GroupPersonID	Integer		Primary Key
Order Number	Short		Members position in group; i.e. 1st, 2nd, 3rd.
Remarks	Memo	4096	Additional Comments.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Division	Division
many-to-one		Group	Agent
many-to-one		Member	Agent
many-to-one		Modified By Agent	Agent

Information Request Describes a request for information of a collection and refers to a Bundle of Collection Objects.
Field	Type	Length	Description
InfoRequestID	Integer		Primary Key
Collection Member Id	Integer
Email	String	50	Email of agent requesting the information.
First Name	String	50
Info Req Number	String	32	Number of Information Request.
Institution	String	127
Last Name	String	50
Remarks	Memo	4096	Additional Comments.
Reply Date	Calendar
Request Date	Calendar
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Agent	Agent
many-to-one		Created By Agent	Agent
one-to-many		Items	RecordSet
many-to-one		Modified By Agent	Agent

Institution The parent institution. An institution is made up of one or more divisions.
Field	Type	Length	Description
UserGroupScopeId	Integer		Primary Key
Alt Name	String	128
Are Accessions Global	Boolean
Code	String	64
Copyright	Memo	8192
Description	Memo	8192
Disclaimer	Memo	8192	Disclaimer statement, e.g. concerning responsibility for data quality or legal implications.
Has Been Asked	Boolean
IPR	Memo	8192	A sequence of statements related to Intellectual Property Rights, credit and acknowledgement.
Icon URI	String	255
Is Anonymous	Boolean
Is Security On	Boolean
Is Server Based	Boolean
LSID Authority	String	64
License	Memo	2048
Name	String	255
Reg Number	String	24
Remarks	Memo	8192	Additional Comments
Terms Of Use	Memo	8192	Defines conditions under which the data may be analyzed, distributed or changed. "Terms of use" includes concepts like "Usage conditions" and "Specific Restrictions".
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
URI	String	255
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Address	Address
one-to-many		Content Contacts	Agent
many-to-one		Created By Agent	Agent
one-to-many		Divisions	Division
many-to-one		Modified By Agent	Agent
many-to-one		Storage Tree Def	StorageTreeDef
one-to-many		Technical Contacts	Agent
one-to-many		User Groups	SpPrincipal

Journal Refers to a published journal.
Field	Type	Length	Description
JournalID	Integer		Primary Key
GUID	String	128
ISSN	String	16
Journal Abbreviation	String	50
Journal Name	String	255	Full name of hte journal.
Remarks	Memo	4096
Text1	String	32	User definable.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
one-to-many		Reference Works	ReferenceWork

Lat Lon Polygon
Field	Type	Length	Description
LatLonPolygonID	Integer		Primary Key
Description	Memo	4096
Is Polyline	Boolean
Name	String	64
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Locality	Locality
many-to-one		Modified By Agent	Agent
one-to-many		Points	LatLonPolygonPnt
many-to-one		Visual Query	SpVisualQuery

Lat Lon Polygon Pnt
Field	Type	Length	Description
LatLonPolygonPntID	Integer		Primary Key
Elevation	Integer
Latitude	BigDecimal
Longitude	BigDecimal
Ordinal	Integer
Relationships
Type		Name	To Table
many-to-one		Lat Lon Polygon	LatLonPolygon

Lithostratigraphy The Litho stratigraphy tree.
Field	Type	Length	Description
LithoStratID	Integer		Primary Key
Full Name	String	255
GUID	String	128
Highest Child Node Number	Integer
Is Preferred	Boolean
Name	String	64
Node Number	Integer
Number1	Double
Number2	Double
Rank Id	Integer
Remarks	Memo	4096	Additional Comments.
Text1	String	300
Text2	String	300
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Relationships
Type		Name	To Table
one-to-many		Child Nodes	LithoStrat
many-to-one		Created By Agent	Agent
many-to-one		Definition	LithoStratTreeDef
many-to-one		Modified By Agent	Agent
one-to-many		Paleo Contexts	PaleoContext
many-to-one		Parent	LithoStrat
many-to-one		Preferred Litho Strat	LithoStrat
many-to-one		Rank	LithoStratTreeDefItem
one-to-many		Synonyms	LithoStrat

Lithostratigraphy Tree Definition Defines the levels of the tree.
Field	Type	Length	Description
LithoStratTreeDefID	Integer		Primary Key
Full Name Direction	Integer
Name	String	64
Remarks	Memo	4096	Additional Comments.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
one-to-many		Disciplines	Discipline
many-to-one		Modified By Agent	Agent
one-to-many		Tree Def Items	LithoStratTreeDefItem
one-to-many		Tree Entries	LithoStrat

Lithostratigraphy Tree Definition Item Describes a level in the definition of the tree.
Field	Type	Length	Description
LithoStratTreeDefItemID	Integer		Primary Key
Full Name Separator	String	32
Is Enforced	Boolean
Is In Full Name	Boolean
Name	String	64
Rank Id	Integer
Remarks	Memo	4096	Additional Comments
Text After	String	64	User definable
Text Before	String	64	User definable
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Children	LithoStratTreeDefItem
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Parent	LithoStratTreeDefItem
many-to-one		Tree Def	LithoStratTreeDef
one-to-many		Tree Entries	LithoStrat

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
LoanID	Integer		Primary Key
Current Due Date	Calendar		Date the loan is due for return (Same as original Due date unless loan period has been extended).
Date Closed	Calendar		Date loan was closed.
Date Received	Calendar
Extension Granted	Boolean		User definable.
Is Closed	Boolean		'No' until all preparations in the loan have been returned/resolved.
Is Financial Responsibility	Boolean
Loan Date	Calendar		Date the Loan was created.
Loan Number	String	50	A field that contains a record of the loan number and which is automatically incremented when a loan is made.
Number1	Float	24	User definable.
Number2	Float	24	User definable.
Original Due Date	Calendar		Date the loan was originally due.
Overdue Noti Sent Date	Calendar
Purpose Of Loan	String	64
Received Comments	String	255
Remarks	Memo	4096	Additional Comments
Source Geography	String	32
Source Taxonomy	String	32
Special Conditions	Memo	2048
Text1	String	300	User definable.
Text2	String	300	User definable.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Yes No2	Boolean		User definable.
Relationships
Type		Name	To Table
many-to-one		Address Of Record	AddressOfRecord
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Division	Division
one-to-many		Loan Agents	LoanAgent
one-to-many		Loan Attachments	LoanAttachment
one-to-many		Loan Preparations	LoanPreparation
many-to-one		Modified By Agent	Agent
one-to-many		Shipments	Shipment

Loan Agent An agent associated with a loan. Each agent includes the role played in the loan process.
Field	Type	Length	Description
LoanAgentID	Integer		Primary Key
Remarks	Memo	4096	Additional Comments
Role	String	50	Role the agent played in the loan.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Agent	Agent
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Loan	Loan
many-to-one		Modified By Agent	Agent

Loan Attachment Refers to an attachment and provides order.
Field	Type	Length	Description
LoanAttachmentID	Integer		Primary Key
Ordinal	Integer
Remarks	Memo	4096	Additional comments.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Created By Agent	Agent
many-to-one		Loan	Loan
many-to-one		Modified By Agent	Agent

Loan Preparation A join table between the Loan and the Preparation. It contains comments and quantity fields.
Field	Type	Length	Description
LoanPreparationID	Integer		Primary Key
Description	String	255	Description of loaned material (intended to be used for non-cataloged items, i.e. when PreparationID is null)
In Comments	Memo	1024	Comments on item when returned.
Is Resolved	Boolean
Out Comments	Memo	1024	Comments on item when loaned.
Quantity	Integer		The total number of specimens loaned (necessary for lots).
Quantity Resolved	Integer		Number of specimens returned, deaccessioned or otherwise accounted for. (necessary for Lots).
Quantity Returned	Integer		Number of specimens returned. (necessary for Lots)
Received Comments	Memo	1024
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Loan	Loan
one-to-many		Loan Return Preparations	LoanReturnPreparation
many-to-one		Modified By Agent	Agent
many-to-one		Preparation	Preparation

Loan Return Preparation This is used for tracking a returned Preparation for a loan.
Field	Type	Length	Description
LoanReturnPreparationID	Integer		Primary Key
Quantity Resolved	Integer		Number of specimens returned, deaccessioned or otherwise accounted for. (necessary for Lots).
Quantity Returned	Integer		Number of specimens returned. (necessary for Lots).
Remarks	Memo	4096	Additional Comments.
Returned Date	Calendar		Date of return.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Deaccession Preparation	DeaccessionPreparation
many-to-one		Discipline	Discipline
many-to-one		Loan Preparation	LoanPreparation
many-to-one		Modified By Agent	Agent
many-to-one		Received By	Agent

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
SpLocaleContainerID	Integer		Primary Key
Aggregator	String	64
Default U I	String	64
Format	String	64
Is Hidden	Boolean
Is System	Boolean
Is U I Formatter	Boolean
Name	String	64
Pick List Name	String	64
Schema Type	Byte		The type of schema it belongs to: the core schema or the workbench schema
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Type	String	32
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
one-to-many		Descs	SpLocaleItemStr
many-to-one		Discipline	Discipline
one-to-many		Items	SpLocaleContainerItem
many-to-one		Modified By Agent	Agent
one-to-many		Names	SpLocaleItemStr

Locale Container Item System Table: This is used for localizing the database schema it has a localized name and description.
Field	Type	Length	Description
SpLocaleContainerItemID	Integer		Primary Key
Format	String	64
Is Hidden	Boolean
Is Required	Boolean	32
Is System	Boolean
Is U I Formatter	Boolean
Name	String	64
Pick List Name	String	64
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Type	String	32
Version	Integer
Web Link Name	String	32
Relationships
Type		Name	To Table
many-to-one		Container	SpLocaleContainer
many-to-one		Created By Agent	Agent
one-to-many		Descs	SpLocaleItemStr
many-to-one		Modified By Agent	Agent
one-to-many		Names	SpLocaleItemStr
one-to-many		Sp Export Schema Items	SpExportSchemaItem

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
SpLocaleItemStrID	Integer		Primary Key
Country	String	2
Language	String	2
Text	String	255
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Variant	String	2
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Container Desc	SpLocaleContainer
many-to-one		Container Name	SpLocaleContainer
many-to-one		Created By Agent	Agent
many-to-one		Item Desc	SpLocaleContainerItem
many-to-one		Item Name	SpLocaleContainerItem
many-to-one		Modified By Agent	Agent

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
LocalityID	Integer		Primary Key
Datum	String	50	GPS Datum.
Elevation Accuracy	Double		Plus or minus -- in meters.
Elevation Method	String	50	The method used to determine the elevation.
GML	Memo
GUID	String	128
Lat/Long Method	String	50	the method used to determine the Latitude, Longitude
Lat1text	String	50	User entry for Latitude1
Lat2text	String	50	User entry for Latitude2
Latitude/Longitude Accuracy	Double		radius -- in decimal degrees
Latitude/Longitude Type	String	50	The type of area described by the Latitude Longitude data (Point, Line, Rectangle)
Latitude1	BigDecimal		Latitude of first point
Latitude2	BigDecimal		Latitude of second point
Locality Name	String	255	The full name of the locality.
Long1text	String	50	User entry for Longitude1
Long2text	String	50	User entry for Longitude2
Longitude1	BigDecimal		Longitude of first point
Longitude2	BigDecimal		Longitude of second point
Max Elevation	Double		The maximum elevation in Meters
Min Elevation	Double		The minimum elevation in Meters
Named Place	String	255	The named place the locality is closest to
Original Elevation Unit	String	50	i.e. Meters, Feet, ...
Original Latitude Longitude Unit	Integer		i.e. Decimal, Deg/Min/Sec, ...
Relation To Named Place	String	120	Relation of the locality to the named place
Remarks	Memo	4096	Additional Comments
Short Name	String	32
Src Lat Long Unit	Byte
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Verbatim Elevation	String	50	The verbatim elevation including units as given in the field notes
Version	Integer
Visibility	Byte
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
zero-to-one		Geo Coord Details	GeoCoordDetail
many-to-one		Geography	Geography
one-to-many		Lat Lonpolygons	LatLonPolygon
one-to-many		Locality Attachments	LocalityAttachment
one-to-many		Locality Citations	LocalityCitation
zero-to-one		Locality Details	LocalityDetail
one-to-many		Locality Name Alias	LocalityNameAlias
many-to-one		Modified By Agent	Agent
many-to-one		Visibility Set By	SpecifyUser

Locality Attachment Refers to an attachment and provides order.
Field	Type	Length	Description
LocalityAttachmentID	Integer		Primary Key
Ordinal	Integer
Remarks	Memo	4096
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Created By Agent	Agent
many-to-one		Locality	Locality
many-to-one		Modified By Agent	Agent

Locality Citation A join table to link a Locality to a Citation.
Field	Type	Length	Description
LocalityCitationID	Integer		Primary Key
Remarks	Memo	4096	Additional Comments
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Locality	Locality
many-to-one		Modified By Agent	Agent
many-to-one		Reference Work	ReferenceWork

Locality Detail Describes additional Locality detail. For example, water body and island information. Includes UTM fields.
Field	Type	Length	Description
LocalityDetailID	Integer		Primary Key
Base Meridian	String	50
Drainage	String	64
Gml	Memo
HUC Code	String	16
Island	String	64
Island Group	String	64
National Park Name	String	64
Number1	Double
Number2	Double
Range	String	50
Range Direction	String	50
Section	String	50
Section Part	String	50
Text1	String	300
Text2	String	300
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Township	String	50
Township Direction	String	50
UTM Datum	String	32
UTM Easting	Float
UTM False Easting	Integer
UTM False Northing	Integer
UTM Northing	Float
UTM Orig Latitude	BigDecimal
UTM Orig Longitude	BigDecimal
UTM Scale	String	8
UTM Zone	Short
Version	Integer
Water Body	String	64
Yes No1	Boolean
Yes No2	Boolean
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Locality	Locality
many-to-one		Modified By Agent	Agent

Locality Name Alias Describes additional names for a given Locaity.
Field	Type	Length	Description
LocalityNameAliasID	Integer		Primary Key
Name	String	255	The alias for the locality name.
Source	String	64	The source of the alias.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Locality	Locality
many-to-one		Modified By Agent	Agent

Other Identifier Describes an identifier (Catalog Number) of a Collection Object from a different Institution.
Field	Type	Length	Description
OtherIdentifierID	Integer		Primary Key
Collection Member Id	Integer
Identifier	String	64
Institution	String	64
Remarks	Memo	4096	Additional Comments
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Collection Object	CollectionObject
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

Paleo Context Describes the paleontologic information for a Collection Object. This also references Chronostratigraphy and Bio Stratigray.
Field	Type	Length	Description
PaleoContextID	Integer		Primary Key
Bottom Distance	Float		The distance to the bottom of the position.
Collection Member Id	Integer
Direction	String	32	The direction of the measurement of the distance: up or down.
Distance Units	String	16	The units for the distances, feet or meters
Position State	String	32	How it was found: float or in-situ
Remarks	String	32
Text2	String	32
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Top Distance	Float		The distance to the top of the position.
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Relationships
Type		Name	To Table
many-to-one		Bio Strat	GeologicTimePeriod
many-to-one		Chrono Strat	GeologicTimePeriod
one-to-many		Collection Objects	CollectionObject
many-to-one		Created By Agent	Agent
many-to-one		Litho Strat	LithoStrat
many-to-one		Modified By Agent	Agent

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
PermitID	Integer		Primary Key
End Date	Calendar		Date permit expires
Issued Date	Calendar		Date permit was issued
Number1	Float	24	User definable
Number2	Float	24	User definable
Permit Number	String	50	Identifier for the permit
Remarks	Memo	4096	Additional Comments
Renewal Date	Calendar		Date of renewal
Start Date	Calendar		Date permit becomes effective
Text1	String	300	User definable
Text2	String	300	User definable
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Type	String	50	Permit category - `CITES`, `Migratory Bird Treaty Act`, ...
Version	Integer
Yes No1	Boolean		User definable
Yes No2	Boolean		User definable
Relationships
Type		Name	To Table
one-to-many		Accession Authorizations	AccessionAuthorization
many-to-one		Created By Agent	Agent
many-to-one		Issued By	Agent
many-to-one		Issued To	Agent
many-to-one		Modified By Agent	Agent
one-to-many		Permit Attachments	PermitAttachment

Permit Attachment Refers to an attachment and provides order.
Field	Type	Length	Description
PermitAttachmentID	Integer		Primary Key
Ordinal	Integer
Remarks	Memo	4096
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Permit	Permit

Pick List System Table: A list of items that can be choosen to produce a controlled vocabulary.
Field	Type	Length	Description
PickListID	Integer		Primary Key
Field Name	String	64
Filter Field Name	String	32
Filter Value	String	32
Formatter	String	64
Is System	Boolean		Where system form rely on this picklist, not user defined
Name	String	64
Read Only	Boolean
Size Limit	Integer	10
Sort Type	Byte
Table Name	String	64
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Type	Byte
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Collection	Collection
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
one-to-many		Pick List Items	PickListItem

Pick List Item
Field	Type	Length	Description
PickListItemID	Integer		Primary Key
Ordinal	Integer
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Title	String	64
Value	String	64
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Pick List	PickList

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
PreparationID	Integer		Primary Key
Collection Member Id	Integer
Count	Integer		Number of items
Description	String	255
Number1	Float
Number2	Float
Prepared Date	Calendar
Prepared Date Precision	Byte
Remarks	Memo	4096	Additional Comments
Sample Number	String	32
Status	String	32
Storage Location	String	50
Text1	String	300	User definable
Text2	String	300	User definable
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Yes No3	Boolean
Relationships
Type		Name	To Table
many-to-one		Collection Object	CollectionObject
many-to-one		Created By Agent	Agent
one-to-many		Deaccession Preparations	DeaccessionPreparation
one-to-many		Gift Preparations	GiftPreparation
one-to-many		Loan Preparations	LoanPreparation
many-to-one		Modified By Agent	Agent
many-to-one		Prep Type	PrepType
one-to-many		Preparation Attachments	PreparationAttachment
many-to-one		Preparation Attribute	PreparationAttribute
one-to-many		Preparation Attrs	PreparationAttr
many-to-one		Prepared By	Agent
many-to-one		Storage	Storage

Preparation Attachment Refers to an attachment and provides order.
Field	Type	Length	Description
PreparationAttachmentID	Integer		Primary Key
Collection Member Id	Integer
Ordinal	Integer
Remarks	Memo	4096
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Preparation	Preparation

Preparation Attribute Extensible attributes introduced for Specify 6.
Field	Type	Length	Description
AttrID	Integer		Primary Key
Collection Member Id	Integer
Double Value	Double
String Value	String	255
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Definition	AttributeDef
many-to-one		Modified By Agent	Agent
many-to-one		Preparation	Preparation

Preparation Attribute Preparation attributes that were also available in Specify 5.
Field	Type	Length	Description
PreparationAttributeID	Integer		Primary Key
Attr Date	Date	10
Collection Member Id	Integer
Number1	Float
Number2	Float
Number3	Float
Number4	Integer
Number5	Integer
Number6	Integer
Number7	Integer
Number8	Integer
Number9	Short
Remarks	Memo	4096
Text1	String	300
Text10	String	300
Text11	String	50
Text12	String	50
Text13	String	50
Text14	String	50
Text15	String	50
Text16	String	50
Text17	String	50
Text18	String	50
Text19	String	50
Text2	String	300
Text20	String	50
Text21	String	50
Text22	String	10
Text23	String	50
Text24	String	50
Text25	String	50
Text26	String	50
Text3	String	50
Text4	String	50
Text5	String	50
Text6	String	50
Text7	String	50
Text8	String	50
Text9	String	50
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Yes No3	Boolean
Yes No4	Boolean
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
one-to-many		Preparations	Preparation

Preparation Type Describe a Preparation Type. For example, Cleared and Stained, Mounted, etc.
Field	Type	Length	Description
PrepTypeID	Integer		Primary Key
Is Loanable	Boolean
Name	String	64
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Attribute Defs	AttributeDef
many-to-one		Collection	Collection
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

Project Describes a grouping of Collection Objects.
Field	Type	Length	Description
ProjectID	Integer		Primary Key
Collection Member Id	Integer
Description	String	255	Description of project
End Date	Calendar		Date project ended
Grant Agency	String	64
Grant Number	String	64
Number1	Float	24	User definable
Number2	Float	24	User definable
Project Name	String	50	Name of the project
Project Number	String	64
Remarks	Memo	4096	Additional Comments
Start Date	Calendar		Date project began
Text1	String	300	User definable
Text2	String	300	User definable
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
URL	String	1024	URL for project
Version	Integer
Yes No1	Boolean		User definable
Yes No2	Boolean		User definable
Relationships
Type		Name	To Table
many-to-one		Agent	Agent
many-to-many		Collection Objects	CollectionObject
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

Record Set Describes a set of records of any type that can be acted upon within the applicaiton.
Field	Type	Length	Description
RecordSetID	Integer		Primary Key
All Permission Level	Integer
Collection Member Id	Integer
Database Table Id	Integer
Group Permission Level	Integer
Name	String	64
Owner Permission Level	Integer
Remarks	Memo	4096	Additional Comments
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Type	Byte
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Group	SpPrincipal
many-to-one		Info Request	InfoRequest
many-to-one		Modified By Agent	Agent
one-to-many		Record Set Items	RecordSetItem
many-to-one		Specify User	SpecifyUser

Reference Work A literary reference work.
Field	Type	Length	Description
ReferenceWorkID	Integer		Primary Key
GUID	String	128
ISBN	String	16
Is Published	Boolean
Library Number	String	50
Number1	Float		User definable
Number2	Float		User definable
Pages	String	50	Number of pages or Page range for Journal articles
Place Of Publication	String	50
Publisher	String	50
Remarks	Memo	4096	Additional Comments
Text1	String	300	User definable
Text2	String	300	User definable
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Title	String	255	Title of reference
Type	Byte		Type of Reference (Book(0), Electronic Media(1), Paper(2), Technical Report(3), Thesis(4), Section in book(5))
Url	String	1024
Version	Integer
Volume	String	25	Volume/Issue for Journal articles
Work Date	String	25
Yes No1	Boolean		User definable
Yes No2	Boolean		User definable
Relationships
Type		Name	To Table
one-to-many		Authors	Author
one-to-many		Collection Object Citations	CollectionObjectCitation
many-to-one		Contained R F Parent	ReferenceWork
one-to-many		Contained Reference Works	ReferenceWork
many-to-one		Created By Agent	Agent
one-to-many		Determination Citations	DeterminationCitation
one-to-many		Exsiccatae	Exsiccata
many-to-one		Journal	Journal
one-to-many		Locality Citations	LocalityCitation
many-to-one		Modified By Agent	Agent
one-to-many		Taxon Citations	TaxonCitation

Repository Agreement An agreement for allowing an Accession to occur, but does not include ownership.
Field	Type	Length	Description
RepositoryAgreementID	Integer		Primary Key
Date Received	Calendar
End Date	Calendar
Number1	Float		User definable
Number2	Float		User definable
RA Number	String	60
Remarks	Memo	4096	Additional Comments
Start Date	Calendar
Status	String	32
Text1	String	255	User definable
Text2	String	255	User definable
Text3	String	255	User definable
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Yes No1	Boolean		User definable
Yes No2	Boolean		User definable
Relationships
Type		Name	To Table
one-to-many		Accessions	Accession
many-to-one		Address Of Record	AddressOfRecord
many-to-one		Created By Agent	Agent
many-to-one		Division	Division
many-to-one		Modified By Agent	Agent
many-to-one		Originator	Agent
one-to-many		Repository Agreement Agents	AccessionAgent
one-to-many		Repository Agreement Attachments	RepositoryAgreementAttachment
one-to-many		Repository Agreement Authorizations	AccessionAuthorization

Repository Agreement Attachment Refers to an attachment and provides order.
Field	Type	Length	Description
RepositoryAgreementAttachmentID	Integer		Primary Key
Ordinal	Integer
Remarks	Memo	4096
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Repository Agreement	RepositoryAgreement

Shipment Describes the shipment of a Loan or Exchange.
Field	Type	Length	Description
ShipmentID	Integer		Primary Key
Insured For Amount	String	50
Method	String	50	Description of shipment. E.g. `Hand-carried`, `Overnight`, `Air`, `Land`, `Sea`, ...
Num Of Packages	Short		Number of packages shipped
Number1	Float	24	User definable
Number2	Float	24	User definable
Remarks	Memo	4096	Additional Comments
Shipment Date	Calendar		Date of shipment
Shipment Number	String	50	Shipper`s tracking number
Text1	String	300	User definable
Text2	String	300	User definable
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Weight	String	50	The weight of the shipment
Yes No1	Boolean		User definable
Yes No2	Boolean		User definable
Relationships
Type		Name	To Table
many-to-one		Borrow	Borrow
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Exchange Out	ExchangeOut
many-to-one		Gift	Gift
many-to-one		Loan	Loan
many-to-one		Modified By Agent	Agent
many-to-one		Shipped By	Agent
many-to-one		Shipped To	Agent
many-to-one		Shipper	Agent

Sp Audit Log
Field	Type	Length	Description
SpAuditLogID	Integer		Primary Key
Action	Byte
Parent Record Id	Integer
Parent Table Num	Short
Record Id	Integer
Record Version	Integer
Table Num	Short
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
one-to-many		Fields	SpAuditLogField
many-to-one		Modified By Agent	Agent

Sp Audit Log Field
Field	Type	Length	Description
SpAuditLogFieldID	Integer		Primary Key
Field Name	String	32
New Value	String	64
Old Value	String	64
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Sp Audit Log	SpAuditLog

Sp Export Schema System Table:
Field	Type	Length	Description
SpExportSchemaID	Integer		Primary Key
Description	String	255
Schema Name	String	80
Schema Version	String	80
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Modified By Agent	Agent
one-to-many		Sp Export Schema Items	SpExportSchemaItem
many-to-many		Sp Export Schema Mappings	SpExportSchemaMapping

Sp Export Schema Item System Table:
Field	Type	Length	Description
SpExportSchemaItemID	Integer		Primary Key
Data Type	String	32
Description	String	255
Field Name	String	64
Formatter	String	32
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Sp Export Schema	SpExportSchema
many-to-one		Sp Locale Container Item	SpLocaleContainerItem

Sp Export Schema Item Mapping
Field	Type	Length	Description
SpExportSchemaItemMappingID	Integer		Primary Key
Remarks	String	255
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Export Schema Item	SpExportSchemaItem
many-to-one		Export Schema Mapping	SpExportSchemaMapping
many-to-one		Modified By Agent	Agent
many-to-one		Query Field	SpQueryField

Sp Export Schema Mapping
Field	Type	Length	Description
SpExportSchemaMappingID	Integer		Primary Key
Description	String	255
Mapping Name	String	50
Timestamp Created	Timestamp
Timestamp Exported	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
one-to-many		Mappings	SpExportSchemaItemMapping
many-to-one		Modified By Agent	Agent
many-to-many		Sp Export Schemas	SpExportSchema

Sp Field Value Default System Table: This represents a default field value for a form.
Field	Type	Length	Description
SpFieldValueDefaultID	Integer		Primary Key
Collection Member Id	Integer
Field Name	String	32
Id Value	Integer
Str Value	String	64
Table Name	String	32
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

Sp Permission System Table:
Field	Type	Length	Description
SpPermissionID	Integer		Primary Key
Actions	String	256
Name	String	64
Permission Class	String	256
Target Id	Integer
Relationships
Type		Name	To Table
many-to-many		Principals	SpPrincipal

Sp Principal System Table:
Field	Type	Length	Description
SpPrincipalID	Integer		Primary Key
Group Sub Class	String	255
Group Type	String	32
Name	String	64
Priority	Byte
Remarks	Memo
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-many		Permissions	SpPermission
many-to-one		Scope	UserGroupScope
many-to-many		Specify Users	SpecifyUser

Sp Query System Table: This represents a saved Query.
Field	Type	Length	Description
SpQueryID	Integer		Primary Key
Context Name	String	64
Context Table Id	Short
Count Only	Boolean
Is Favorite	Boolean
Name	String	64
Ordinal	Short
Remarks	Memo	4096
Search Synonymy	Boolean
Select Distinct	Boolean
Sql Str	String	64
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
one-to-many		Fields	SpQueryField
many-to-one		Modified By Agent	Agent
one-to-many		Reports	SpReport
many-to-one		Specify User	SpecifyUser

Sp Query Field System Table: This represents a single field in a saved Query.
Field	Type	Length	Description
SpQueryFieldID	Integer		Primary Key
Always Filter	Boolean
Column Alias	String	64
Context Table Ident	Integer
End Value	String	64
Field Name	String	32
Format Name	String	64
Is Display	Boolean
Is Not	Boolean
Is Prompt	Boolean
Is Rel Fld	Boolean
Oper End	Byte
Oper Start	Byte
Position	Short
Sort Type	Byte
Start Value	String	64
String Id	String	500
Table List	String	500
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
one-to-many		Mappings	SpExportSchemaItemMapping
many-to-one		Modified By Agent	Agent
many-to-one		Query	SpQuery

Sp Report System Table: This represents a saved Report.
Field	Type	Length	Description
SpReportId	Integer		Primary Key
Name	String	64
Remarks	Memo	4096
Repeat Count	Integer
Repeat Field	String	255
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		App Resource	SpAppResource
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Query	SpQuery
many-to-one		Specify User	SpecifyUser
one-to-one		Workbench Template	WorkbenchTemplate

Sp Task Semaphore System Table:
Field	Type	Length	Description
TaskSemaphoreID	Integer		Primary Key
Context	String	32
Is Locked	Boolean
Locked Time	Timestamp
Machine Name	String	64
Scope	Byte
Task Name	String	32
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Usage Count	Integer
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Collection	Collection
many-to-one		Created By Agent	Agent
many-to-one		Discipline	Discipline
many-to-one		Modified By Agent	Agent
many-to-one		Owner	SpecifyUser

Sp Version
Field	Type	Length	Description
SpVersionID	Integer		Primary Key
App Name	String	32
App Version	String	16
Schema Version	String	16
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent

Sp Visual Query
Field	Type	Length	Description
SpVisualQueryID	Integer		Primary Key
Description	Memo	4096
Name	String	64
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
one-to-many		Polygons	LatLonPolygon
many-to-one		Specify User	SpecifyUser

Specify User System Table: This represents Specify User within the application.
Field	Type	Length	Description
SpecifyUserID	Integer		Primary Key
Accumulated Minutes Logged In	Long
Email	String	64
Is Logged In	Boolean
Is Logged In Report	Boolean
Login Collection Name	String	64
Login Discipline Name	String	64
Login Out Time	Timestamp
Name	String	64
Password	String	255
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
User Group	String	32
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Agents	Agent
one-to-many		App Resources	SpAppResource
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
one-to-many		Record Sets	RecordSet
one-to-many		Sp App Resource Dirs	SpAppResourceDir
many-to-many		Sp Principals	SpPrincipal
one-to-many		Sp Querys	SpQuery
one-to-many		Task Semaphores	SpTaskSemaphore
one-to-many		Workbench Templates	WorkbenchTemplate
one-to-many		Workbenches	Workbench

Storage A tree data structure for describing where Collection Objects are physically stored.
Field	Type	Length	Description
StorageID	Integer		Primary Key
Abbreviation	String	16
Full Name	String	255
Highest Child Node Number	Integer
Is Preferred	Boolean
Name	String	64
Node Number	Integer
Number1	Integer		User definable
Number2	Integer		User definable
Rank Id	Integer
Remarks	Memo	4096	Additional Comments
Text1	String	32	User definable
Text2	String	32	User definable
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Timestamp Version	Date
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Children	Storage
one-to-many		Children	Storage
one-to-many		Containers	Container
many-to-one		Created By Agent	Agent
many-to-one		Definition	StorageTreeDef
many-to-one		Definition Item	StorageTreeDefItem
many-to-one		Modified By Agent	Agent
many-to-one		Parent	Storage
many-to-one		Preferred Storage	Storage
one-to-many		Preparations	Preparation

Storage Tree Definition Defines the levels of the tree.
Field	Type	Length	Description
StorageTreeDefID	Integer		Primary Key
Full Name Direction	Integer
Name	String	64
Remarks	Memo	4096	Additional Comments
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
one-to-many		Institutions	Institution
many-to-one		Modified By Agent	Agent
one-to-many		Tree Def Items	StorageTreeDefItem
one-to-many		Tree Entries	Storage

Storage Tree Definition Item Describes a level in the definition of the tree.
Field	Type	Length	Description
StorageTreeDefItemID	Integer		Primary Key
Full Name Separator	String	32
Is Enforced	Boolean
Is In Full Name	Boolean
Name	String	64
Rank Id	Integer
Remarks	Memo	4096	Additional Comments
Text After	String	64	User definable
Text Before	String	64	User definable
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Children	StorageTreeDefItem
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Parent	StorageTreeDefItem
many-to-one		Tree Def	StorageTreeDef
one-to-many		Tree Entries	Storage

Taxon Describes the taxonomy of a Determination.
Field	Type	Length	Description
TaxonID	Integer		Primary Key
Author	String	128
CITES Status	String	32
Col Status	String	32
Common Name	String	128
Cultivar Name	String	32
ESA Status	String	64
Environmental Protection Status	String	64
Full Name	String	255
GUID	String	128
Group Number	String	20	Taxonomic group number
Highest Child Node Number	Integer
ISIS Number	String	16
Is Hybrid	Boolean
Is Preferred	Boolean
Label Format	String	64
NCBI Taxon Number	String	8
Name	String	64
Node Number	Integer
Number 1	Integer
Number 2	Integer
Rank ID	Integer
Remarks	Memo	4096	Additional Comments
Source	String	64	If the record has been imported then this field holds information about the authority file it was obtained from, else it is user-editable.
Taxonomic Serial Number	String	50	If the record has been imported from an Authority File then this field stores a unique ID assigned by the provider, else it is null
Text 1	String	32
Text 2	String	32
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
USFWS Code	String	16
Unit Ind1	String	50
Unit Ind2	String	50
Unit Ind3	String	50
Unit Ind4	String	50
Unit Name1	String	50
Unit Name2	String	50
Unit Name3	String	50
Unit Name4	String	50
Version	Integer
Visibility	Byte
Relationships
Type		Name	To Table
one-to-many		Child Taxa	Taxon
one-to-many		Collecting Event Attributes	CollectingEventAttribute
one-to-many		Common Names	CommonNameTx
many-to-one		Created By Agent	Agent
many-to-one		Definition	TaxonTreeDef
one-to-many		Determinations	Determination
one-to-many		Hybrid Children1	Taxon
one-to-many		Hybrid Children2	Taxon
many-to-one		Hybrid Parent1	Taxon
many-to-one		Hybrid Parent2	Taxon
many-to-one		Modified By Agent	Agent
many-to-one		Parent	Taxon
many-to-one		Preferred Taxon	Taxon
one-to-many		Synonyms	Taxon
one-to-many		Taxon Attachments	TaxonAttachment
one-to-many		Taxon Citations	TaxonCitation
many-to-one		Taxonomic Rank	TaxonTreeDefItem
many-to-one		Visibility Set By	SpecifyUser

Taxon Attachment Refers to an attachment and provides order.
Field	Type	Length	Description
TaxonAttachmentID	Integer		Primary Key
Ordinal	Integer
Remarks	Memo	4096
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Attachment	Attachment
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Taxon	Taxon

Taxon Citation Linkage from the Taxonomic record to a published document.
Field	Type	Length	Description
TaxonCitationID	Integer		Primary Key
Number1	Float	24	User definable
Number2	Float	24	User definable
Remarks	Memo	4096	Additional Comments
Text1	String	300	User definable
Text2	String	300	User definable
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Yes No1	Boolean		User definable
Yes No2	Boolean		User definable
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Reference Work	ReferenceWork
many-to-one		Taxon	Taxon

Taxon Tree Definition Defines the levels of the tree.
Field	Type	Length	Description
TaxonTreeDefID	Integer		Primary Key
Full Name Direction	Integer
Name	String	64
Remarks	String	255	Additional Comments
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
one-to-one		Discipline	Discipline
many-to-one		Modified By Agent	Agent
one-to-many		Tree Def Items	TaxonTreeDefItem
one-to-many		Tree Entries	Taxon

Taxon Tree Definition Item Describes a level in the definition of the tree.
Field	Type	Length	Description
TaxonTreeDefItemID	Integer		Primary Key
Format Token	String	32
Full Name Separator	String	32
Is Enforced	Boolean
Is In Full Name	Boolean
Name	String	64
Rank Id	Integer
Remarks	Memo	4096	Additional Comments
Text After	String	64	User definable
Text Before	String	64	User definable
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
one-to-many		Children	TaxonTreeDefItem
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Parent	TaxonTreeDefItem
many-to-one		Tree Def	TaxonTreeDef
one-to-many		Tree Entries	Taxon

Treatment Event An action that occurrs to a Conservation Description.
Field	Type	Length	Description
TreatmentEventID	Integer		Primary Key
Date Boxed	Calendar
Date Cleaned	Calendar
Date Completed	Calendar
Date Received	Calendar
Date To Isolation	Calendar
End Date	Calendar
Field Number	String	50
Location	String	64
Remarks	Memo	2048
Start Date	Calendar
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Treat Number	String	32
Type	String	32
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Accession	Accession
many-to-one		Collection Object	CollectionObject
many-to-one		Created By Agent	Agent
many-to-one		Division	Division
many-to-one		Modified By Agent	Agent

View Set Object System Table: This represents a View Set used in the form system.
Field	Type	Length	Description
SpViewSetObjID	Integer		Primary Key
Description	String	255
File Name	String	255
Level	Short
Meta Data	String	255
Name	String	64
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
one-to-many		App Resource Datas	SpAppResourceData
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Sp App Resource Dir	SpAppResourceDir

WorkBench A WorkBench DataSet.
Field	Type	Length	Description
WorkbenchID	Integer		Primary Key
All Permission Level	Integer
Database Table Id	Integer
Export Institution Name	String	128
Form Id	Integer
Group Permission Level	Integer
Locked By User Name	String	64
Name	String	64
Owner Permission Level	Integer
Remarks	Memo	4096	Additional Comments
Source File Path	String	255
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Group	SpPrincipal
many-to-one		Modified By Agent	Agent
many-to-one		Specify User	SpecifyUser
one-to-many		Workbench Rows	WorkbenchRow
many-to-one		Workbench Template	WorkbenchTemplate

WorkBench Data Item A cell of data.
Field	Type	Length	Description
WorkbenchDataItemID	Integer		Primary Key
Cell Data	String	512
Row Number	Short
Validation Status	Short
Relationships
Type		Name	To Table
many-to-one		Workbench Row	WorkbenchRow
many-to-one		Workbench Template Mapping Item	WorkbenchTemplateMappingItem

WorkBench Template The mapping description of the WorkBench.
Field	Type	Length	Description
WorkbenchTemplateID	Integer		Primary Key
Name	String	64
Remarks	Memo	4096	Additional Comments
Source File Path	String	255
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
many-to-one		Specify User	SpecifyUser
one-to-many		Workbench Template Mapping Items	WorkbenchTemplateMappingItem
one-to-many		Workbenches	Workbench

WorkBench Template Mapping Item One column of the mapped description.
Field	Type	Length	Description
WorkbenchTemplateMappingItemID	Integer		Primary Key
Caption	String	64
Carry Forward	Boolean
Data Field Length	Short
Field Name	String	255
Field Type	Short
Imported Column Name	String	255
Is Exportable To Content	Boolean
Is Included In Title	Boolean
Is Required	Boolean
Meta Data	String	128
Original Import Column Index	Short
Source Table Id	Integer	64
Table Name	String	64
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
View Order	Short
X Coordinate	Short
Y Coordinate	Short
Relationships
Type		Name	To Table
many-to-one		Created By Agent	Agent
many-to-one		Modified By Agent	Agent
one-to-many		Workbench Data Items	WorkbenchDataItem
many-to-one		Workbench Template	WorkbenchTemplate

Workbench Row A row of data.
Field	Type	Length	Description
WorkbenchRowID	Integer		Primary Key
Bio Geomancer Results	Memo	8192	The XML returned from Bio Geomancer
Card Image Data	Memo	16000000	A single image attached to the row
Card Image Full Path	String	255	The full path of the image
Lat1 Text	String	50
Lat2 Text	String	50
Long1 Text	String	50
Long2 Text	String	50
Row Number	Short		The row number
Upload Status	Byte
Relationships
Type		Name	To Table
many-to-one		Workbench	Workbench
one-to-many		Workbench Data Items	WorkbenchDataItem
one-to-many		Workbench Row Images	WorkbenchRowImage

Workbench Row Image An image associated with a row.
Field	Type	Length	Description
WorkbenchRowImageID	Integer		Primary Key
Attach To Table Name	String	64
Card Image Data	Memo	16000000	The thumbnail data
Card Image Full Path	String	255	The full path to the image
Image Order	Integer		The position in the list of images
Relationships
Type		Name	To Table
many-to-one		Workbench Row	WorkbenchRow

Table Descriptions

Table	Description
Accession	Also called an acquisition. A consignment of specimens acquired either by field collecting of staff members, gifts, purchases, or exchange with another institution.
Accession Agent	The person(s) requesting the Accession. This references an Agent.
Accession Attachment	An attachment for the Accession. This may be one or more PDF files of paperwork or a photo of the Accession.
Accession Authorization	This represents the person authorizing the Accession. It references an existing Agent.
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.
Address Of Record	This is the address when the legal action took place.
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.
Agent Attachment	This table can be used for a picture of the agent or anything else used to further describe the agent.
Agent Geography	The geographical region that a particular collector was known for collecting in.
Agent Specialty	The Taxonomic specialty that a particular agent was known for.
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.
App Resource	System Table: This represents a resource, typically XML, that the application uses during run time.
App Resource Data	System Table: The data associated with an application resource.
App Resource Default	System Table: the default for application resources.
Appraisal	The monetary appraisal of an Acession or Collection Object
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.
Attachment Metadata	This holds meta data about the attachment. It is a set of named value pairs.
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.
Attribute Definition	The definition of an attribute.
Author	An Author is a reference to an Agent and provides the order for a list of authors of a Reference Work.
Auto Numbering Scheme	This is an internal table used to group together parts of a collection with the same numbering scheme.
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.
Borrow Agent	Refers to an Agent and describes their role in the borrowing process.
Borrow Material	Describes the material being borrowed.
Borrow Return Material	Describes the material that was returned.
Chronostratigraphy	Describes Chronostratigraphy.
Collecting Event	A collecting event is the 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.
Collecting Event Attachment	Refers to an attachment and provides an order.
Collecting Event Attribute	Extensible attributes introduced for Specify 6.
Collecting Event Attribute	Collecting Event Attributes that were also available in Specify 5.
Collecting Trip	Used to group Collecting Events together.
Collection	A collection holds Collection Objects that are of the same discipline type.
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.
Collection Object Attachment	An attachment for a collection object and provides order.
Collection Object Attribute	Extensible attributes introduced for Specify 6.
Collection Object Attribute	Collection Object attributes that were also available in Specify 5.
Collection Object Citation	Refers to a citation for a Collection Object.
Collection Relationship	Enables two collection objects to refer to each other, for example, voucher and tissue.
Collection Relationship Type	Describes the type of relationship between two collection objects.
Collector	In Specify, the person or persons who collected a specimen. Collector records are stored in the Agent table.
Common Name	Describes a common name and the localization of the name. This table is used to describe additional Common Names in other languages.
Common Name Tx Citation
Conservator Description	Describes an object that has participated in a Conservator action. There is only one of these for each Collection Object.
Conservator Description Attachment	Refers to an attachment and provides order.
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.
Conservator Event Attachment	Refers to an attachment and provides order.
Container	A container can optionally be cataloged as a collection object and it contains other collection objects. Describes a logical or physical container.
D N A Sequencing Run
D N A Sequencing Run Citation
DNA Sequence	Tracks DNA Sequencing information for a Collection Object.
DNA Sequence Attachment	Refers to an attachment and provides order.
Data Type	A data type represents a core type of collection data.
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.
Deaccession Agent	Refers to an agent and contains their role in the deaccession.
Deaccession Preparation	The preparation that was deaccessioned.
Determination	The determination of the collection object.
Determination Citation	Refers to a citation for the determination.
Discipline	May include one or more collections that share the Taxon, Geography, LithoStratigraphy, and Chronostratigraphy Trees, Localities, Agents and Determination Status.
Division	The division (or department) containing agents.
Exchange In	Describes an incoming Exchanged Specimen from a different institution.
Exchange Out	Describes an outgoing Exchanged Specimen to a different institution.
Exsiccata
Exsiccata Item
Field Notebook	Describes a physical Field NoteBook.
Field Notebook Attachment	Refers to an attachment and provides order.
Field Notebook Page	Describes a page from a Field Note Book.
Field Notebook Page Attachment	Refers to an attachment and provides order.
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 Notebook Page Set Attachment	Refers to an attachment and provides order.
Geo Coord Detail	Describes extra detail for a Locality for Manis data.
Geography	Represents a politcal boundary (Country, State, County, Township, etc.).
Geography Tree Definition	Defines the levels of the Geography tree.
Geography Tree Definition Item	Describes a level in the definition of the tree.
Geological Time Period Tree Definition	Defines the levels of the GTP tree.
Geological Time Period Tree Definition Item	Describes a level in the definition of the tree.
Gift	Describes a Gift.
Gift Agent	Describes the role the Agent played in the giving of a Gift.
Gift Preparation	Points a gift to a preparation.
Group Person	This is a join table for Agents that are Institutions and Organizations that contain other Agents. It also provides order.
Information Request	Describes a request for information of a collection and refers to a Bundle of Collection Objects.
Institution	The parent institution. An institution is made up of one or more divisions.
Journal	Refers to a published journal.
Lat Lon Polygon
Lat Lon Polygon Pnt
Lithostratigraphy	The Litho stratigraphy tree.
Lithostratigraphy Tree Definition	Defines the levels of the tree.
Lithostratigraphy Tree Definition Item	Describes a level in the definition of the tree.
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.
Loan Agent	An agent associated with a loan. Each agent includes the role played in the loan process.
Loan Attachment	Refers to an attachment and provides order.
Loan Preparation	A join table between the Loan and the Preparation. It contains comments and quantity fields.
Loan Return Preparation	This is used for tracking a returned Preparation for a loan.
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.
Locale Container Item	System Table: This is used for localizing the database schema it has a localized name and description.
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.
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.
Locality Attachment	Refers to an attachment and provides order.
Locality Citation	A join table to link a Locality to a Citation.
Locality Detail	Describes additional Locality detail. For example, water body and island information. Includes UTM fields.
Locality Name Alias	Describes additional names for a given Locaity.
Other Identifier	Describes an identifier (Catalog Number) of a Collection Object from a different Institution.
Paleo Context	Describes the paleontologic information for a Collection Object. This also references Chronostratigraphy and Bio Stratigray.
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.
Permit Attachment	Refers to an attachment and provides order.
Pick List	System Table: A list of items that can be choosen to produce a controlled vocabulary.
Pick List Item
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.
Preparation Attachment	Refers to an attachment and provides order.
Preparation Attribute	Extensible attributes introduced for Specify 6.
Preparation Attribute	Preparation attributes that were also available in Specify 5.
Preparation Type	Describe a Preparation Type. For example, Cleared and Stained, Mounted, etc.
Project	Describes a grouping of Collection Objects.
Record Set	Describes a set of records of any type that can be acted upon within the applicaiton.
Reference Work	A literary reference work.
Repository Agreement	An agreement for allowing an Accession to occur, but does not include ownership.
Repository Agreement Attachment	Refers to an attachment and provides order.
Shipment	Describes the shipment of a Loan or Exchange.
Sp Audit Log
Sp Audit Log Field
Sp Export Schema	System Table:
Sp Export Schema Item	System Table:
Sp Export Schema Item Mapping
Sp Export Schema Mapping
Sp Field Value Default	System Table: This represents a default field value for a form.
Sp Permission	System Table:
Sp Principal	System Table:
Sp Query	System Table: This represents a saved Query.
Sp Query Field	System Table: This represents a single field in a saved Query.
Sp Report	System Table: This represents a saved Report.
Sp Task Semaphore	System Table:
Sp Version
Sp Visual Query
Specify User	System Table: This represents Specify User within the application.
Storage	A tree data structure for describing where Collection Objects are physically stored.
Storage Tree Definition	Defines the levels of the tree.
Storage Tree Definition Item	Describes a level in the definition of the tree.
Taxon	Describes the taxonomy of a Determination.
Taxon Attachment	Refers to an attachment and provides order.
Taxon Citation	Linkage from the Taxonomic record to a published document.
Taxon Tree Definition	Defines the levels of the tree.
Taxon Tree Definition Item	Describes a level in the definition of the tree.
Treatment Event	An action that occurrs to a Conservation Description.
View Set Object	System Table: This represents a View Set used in the form system.
WorkBench	A WorkBench DataSet.
WorkBench Data Item	A cell of data.
WorkBench Template	The mapping description of the WorkBench.
WorkBench Template Mapping Item	One column of the mapped description.
Workbench Row	A row of data.
Workbench Row Image	An image associated with a row.

Table Indexes

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