Updated: 07-23-2012

Contents

Table of Contents

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

Table Definitions

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

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

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

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

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

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

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

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

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

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

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

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

Attachment
Field	Type	Length	Descriptions
AttachmentID	Integer		Primary Key
Attachment Location	String	128	Location of attachment repository.
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	32767	Additional comments.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Title	String	64	Title of attachment.
Version	Integer
Visibility	Byte
Relationships
Type		Name	To Table
OneToMany		accessionAttachments	Accession Attachment
OneToMany		agentAttachments	Agent Attachment
ManyToOne		attachmentImageAttribute	Attachment Image Attribute
OneToMany		borrowAttachments	Borrow Attachment
OneToMany		collectingEventAttachments	Collecting Event Attachment
OneToMany		collectionObjectAttachments	Collection Object Attachment
OneToMany		conservDescriptionAttachments	Conservator Description Attachment
OneToMany		conservEventAttachments	Conservator Event Attachment
ManyToOne		createdByAgent	Agent
OneToMany		dnaSequenceAttachments	DNA Sequence Attachment
OneToMany		dnaSequencingRunAttachments	dnasequencingrunattachment
OneToMany		fieldNotebookAttachments	Field Notebook Attachment
OneToMany		fieldNotebookPageAttachments	Field Notebook Page Attachment
OneToMany		fieldNotebookPageSetAttachments	Field Notebook Page Set Attachment
OneToMany		giftAttachments	Gift Attachment
OneToMany		loanAttachments	Loan Attachment
OneToMany		localityAttachments	Locality Attachment
OneToMany		metadata	Attachment Metadata
ManyToOne		modifiedByAgent	Agent
OneToMany		permitAttachments	Permit Attachment
OneToMany		preparationAttachments	Preparation Attachment
OneToMany		referenceWorkAttachments	Reference Work Attachment
OneToMany		repositoryAgreementAttachments	Repository Agreement Attachment
OneToMany		tags	Attachment Tag
OneToMany		taxonAttachments	Taxon Attachment
ManyToOne		visibilitySetBy	Specify User

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

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

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

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

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

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

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

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

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

Borrow Material
Field	Type	Length	Descriptions
BorrowMaterialID	Integer		Primary Key
Collection Member Id	Integer
Description	String	50	Description of the material. `e.g. Bufo bufo skull`.
In Comments	Memo	32767	Notes concerning the receipt of the material.
Material Number	String	50	e.g. `FMNH 223456`
Out Comments	Memo	32767	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
ManyToOne		borrow	Borrow
OneToMany		borrowReturnMaterials	Borrow Return Material
ManyToOne		createdByAgent	Agent
ManyToOne		modifiedByAgent	Agent

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

Collecting Event
Field	Type	Length	Descriptions
CollectingEventID	Integer		Primary Key
End Date	Calendar		The date collecting event ended.
End Date Precision	Byte
End Date Verbatim	String	50
End Time	Short		End time in military format.
Method	String	50	A method, such as net or trap, which is used to obtain the specimen.
Locality and\n Habitat Notes	Memo	32767	Field to record information on locality and habitat where specimen was collected.
Sgr Status	Byte
Start Date	Calendar		The date collecting event began.
Start Date Precision	Byte
Start Date Verbatim	String	50
Start Time	Short		Start time in military format.
Collector Number	String	50	Collector Number
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	32767	Original statement (literal quotation) of the location of the Collecting Event as given by the Collector.
Version	Integer
Visibility	Byte
Relationships
Type		Name	To Table
OneToMany		collectingEventAttachments	Collecting Event Attachment
ManyToOne		collectingEventAttribute	Collecting Event Attribute
OneToMany		collectingEventAttrs	Collecting Event Attribute
ManyToOne		collectingTrip	Collecting Trip
OneToMany		collectionObjects	Collection Object
OneToMany		collectors	Collector
ManyToOne		createdByAgent	Agent
ManyToOne		discipline	Discipline
ManyToOne		locality	Locality
ManyToOne		modifiedByAgent	Agent
ManyToOne		visibilitySetBy	Specify User

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

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

Collecting Event Attribute
Field	Type	Length	Descriptions
CollectingEventAttributeID	Integer		Primary Key
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	32767
Text1	String	32767
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	32767
Text3	String	32767
Text4	String	100
Text5	String	100
Text6	String	50
Text7	String	50
Text8	String	50
Text9	String	50
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Yes No3	Boolean
Yes No4	Boolean
Yes No5	Boolean
Relationships
Type		Name	To Table
OneToMany		collectingEvents	Collecting Event
ManyToOne		createdByAgent	Agent
ManyToOne		discipline	Discipline
ManyToOne		hostTaxon	Taxon
ManyToOne		modifiedByAgent	Agent

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

Collection
Field	Type	Length	Descriptions
UserGroupScopeId	Integer		Primary Key
Catalog Num Format Name	String	64	Name of catalog number format the collection uses.
Code	String	50	Unique code for collection.
Collection Name	String	50	The name of the collection.
Collection Type	String	32	Textual description of collection. ABCD schema field.
Db Content Version	String	32	ABCD schema field.
Description	Memo	32767	Textual description of collection.
Development Status	String	32	ABCD schema field.
Estimated Size	Integer		ABCD schema field.
Institution Type	String	32	ABCD schema field.
Is Embedded Collecting Event	Boolean		Yes if collecting event is one-to-one relationship.
ISA Number	String	24	ISA number.
Kingdom Coverage	String	32	ABCD schema field.
Preservation\n Method Type	String	32	ABCD schema field.
Primary Focus	String	32	ABCD schema field.
Primary Purpose	String	32	ABCD schema field.
Reg Number	String	24
Remarks	Memo	32767	Additional comments.
Scope	Memo	32767	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
OneToMany		contentContacts	Agent
ManyToOne		createdByAgent	Agent
ManyToOne		discipline	Discipline
ManyToOne		institutionNetwork	Institution
OneToMany		leftSideRelTypes	Collection Relationship Type
ManyToOne		modifiedByAgent	Agent
ManyToMany		numberingSchemes	Auto Numbering Scheme
OneToMany		pickLists	Pick List
OneToMany		prepTypes	Preparation Type
OneToMany		rightSideRelTypes	Collection Relationship Type
OneToMany		technicalContacts	Agent
OneToMany		userGroups	Sp Principal

Collection Object
Field	Type	Length	Descriptions
CollectionObjectID	Integer		Primary Key
Alt Cat Number	String	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.
Specimen\nDescription	String	255	Image, Sound, Preparation, Container(Container Label?).
Field Number	String	50	A unique number a collector assigns to each specimen at the time of collection. For example, botanists often keep a running count of the individual specimens they have collected (LKK1023, LKK1024, etc.).
GUID	String	128	Global Unique Identifier
Inventory Date	Calendar
Modifier	String	50
Name	String	64
Notifications	String	32
Number1	Float	24	User definable.
Number2	Float	24	User definable.
Object Condition	String	64
Ocr	Memo	32767
Project Number	String	64
Remarks	Memo	32767	Additional Comments.
Restrictions	String	32
Sgr Status	Byte
Phenology	String	32767	User definable.
Text2	String	32767	User definable.
Timestamp Created	Timestamp		The timestamp the record was created.
Modified Date	Timestamp		The timestamp the record was last modified.
Total Value	BigDecimal
Version	Integer
Visibility	Byte	10
Yes No1	Boolean		User definable.
Yes No2	Boolean		User definable.
Yes No3	Boolean		User definable.
Yes No4	Boolean		User definable.
Yes No5	Boolean		User definable.
Yes No6	Boolean		User definable.
Relationships
Type		Name	To Table
ManyToOne		accession	Accession
ManyToOne		appraisal	Appraisal
ManyToOne		cataloger	Agent
ManyToOne		collectingEvent	Collecting Event
ManyToOne		collection	Collection
OneToMany		collectionObjectAttachments	Collection Object Attachment
ManyToOne		collectionObjectAttribute	Collection Object Attribute
OneToMany		collectionObjectAttrs	Collection Object Attribute
OneToMany		collectionObjectCitations	Collection Object Citation
OneToMany		conservDescriptions	Conservator Description
ManyToOne		container	Container
ManyToOne		containerOwner	Container
ManyToOne		createdByAgent	Agent
OneToMany		determinations	Determination
OneToMany		dnaSequences	DNA Sequence
OneToMany		exsiccataItems	Exsiccata Item
ManyToOne		fieldNotebookPage	Field Notebook Page
OneToMany		leftSideRels	Collection Relationship
ManyToOne		modifiedByAgent	Agent
OneToMany		otherIdentifiers	Other Identifier
ManyToOne		paleoContext	Paleo Context
OneToMany		preparations	Preparation
ManyToMany		projects	Project
OneToMany		rightSideRels	Collection Relationship
OneToMany		treatmentEvents	Treatment Event
ManyToOne		visibilitySetBy	Specify User

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

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

Collection Object Attribute
Field	Type	Length	Descriptions
CollectionObjectAttributeID	Integer		Primary Key
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	32767
Text1	String	32767
Text10	String	50
Text11	String	50
Text12	String	50
Text13	String	50
Text14	String	50
Text15	String	64
Text2	String	32767
Text3	String	32767
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
OneToMany		collectionObjects	Collection Object
ManyToOne		createdByAgent	Agent
ManyToOne		modifiedByAgent	Agent

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

D N A Sequencing Run
Field	Type	Length	Descriptions
DNASequencingRunID	Integer		Primary Key
Collection Member Id	Integer
Gene Sequence	Memo
Number1	Float
Number2	Float
Number3	Float
Ordinal	Integer
Pcr Cocktail Primer	Boolean
Pcr Forward Primer Code	String	32
Pcr Primer Name	String	32
Pcr Primer Seq5_3	String	64	Pcr Primer Sequence5_3
Pcr Rev Primer Code	String	32
Read Direction	String	16
Remarks	Memo	32767
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
OneToMany		attachments	dnasequencingrunattachment
OneToMany		citations	D N A Sequencing Run Citation
ManyToOne		createdByAgent	Agent
ManyToOne		dnaSequence	DNA Sequence
ManyToOne		modifiedByAgent	Agent
ManyToOne		preparedByAgent	Agent
ManyToOne		runByAgent	Agent

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

Exchange In
Field	Type	Length	Descriptions
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 Exch	Short		Number of items received.
Remarks	Memo	32767	Additional Comments.
Source Geography	String	32
Source Taxonomy	String	32
Text1	String	32767	User definable.
Text2	String	32767	User definable.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Yes No1	Boolean		User definable.
Yes No2	Boolean		User definable.
Relationships
Type		Name	To Table
ManyToOne		addressOfRecord	Address Of Record
ManyToOne		agentCatalogedBy	Agent
ManyToOne		agentReceivedFrom	Agent
ManyToOne		createdByAgent	Agent
ManyToOne		division	Division
OneToMany		exchangeInPreps	Exchange In Prep
ManyToOne		modifiedByAgent	Agent

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Gift
Field	Type	Length	Descriptions
GiftID	Integer		Primary Key
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	32767
Special Conditions	Memo	32767
Source Geography	String	32
Source Taxonomy	String	32
Text1	String	32767	User definable.
Text2	String	32767	User definable.
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Relationships
Type		Name	To Table
ManyToOne		addressOfRecord	Address Of Record
ManyToOne		createdByAgent	Agent
ManyToOne		discipline	Discipline
ManyToOne		division	Division
OneToMany		giftAgents	Gift Agent
OneToMany		giftAttachments	Gift Attachment
OneToMany		giftPreparations	Gift Preparation
ManyToOne		modifiedByAgent	Agent
OneToMany		shipments	Shipment

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

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

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

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

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

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

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

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

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

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

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

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

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

Loan
Field	Type	Length	Descriptions
LoanID	Integer		Primary Key
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
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	32767	Additional Comments
Special Conditions	Memo	32767
Source Geography	String	32
Source Taxonomy	String	32
Text1	String	32767	User definable.
Text2	String	32767	User definable.
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Extension Granted	Boolean		User definable.
Yes No2	Boolean		User definable.
Relationships
Type		Name	To Table
ManyToOne		addressOfRecord	Address Of Record
ManyToOne		createdByAgent	Agent
ManyToOne		discipline	Discipline
ManyToOne		division	Division
OneToMany		loanAgents	Loan Agent
OneToMany		loanAttachments	Loan Attachment
OneToMany		loanPreparations	Loan Preparation
ManyToOne		modifiedByAgent	Agent
OneToMany		shipments	Shipment

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

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

Loan Preparation
Field	Type	Length	Descriptions
LoanPreparationID	Integer		Primary Key
Description	String	255	Description of loaned material (intended to be used for non-cataloged items, i.e. when PreparationID is null)
In Comments	Memo	32767	Comments on item when returned.
Is Resolved	Boolean
Out Comments	Memo	32767	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	32767
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Version	Integer
Relationships
Type		Name	To Table
ManyToOne		createdByAgent	Agent
ManyToOne		discipline	Discipline
ManyToOne		loan	Loan
OneToMany		loanReturnPreparations	Loan Return Preparation
ManyToOne		modifiedByAgent	Agent
ManyToOne		preparation	Preparation

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

Locality
Field	Type	Length	Descriptions
LocalityID	Integer		Primary Key
Datum	String	50	GPS Datum.
Elevation Accuracy	Double		Plus or minus -- in meters.
Elevation Method	String	50	The method used to determine the elevation.
GML	Memo
GUID	String	128
Lat1text	String	50	User entry for Latitude1
Lat2text	String	50	User entry for Latitude2
Latitude/Longitude Accuracy	Double		radius -- in decimal degrees
Lat/Long Method	String	50	the method used to determine the Latitude, Longitude
Latitude/Longitude Type	String	50	The type of area described by the Latitude Longitude data (Point, Line, Rectangle)
Latitude1	BigDecimal		Latitude of first point
Latitude2	BigDecimal		Latitude of second point
Locality Name	String	255	The full name of the locality.
Long1text	String	50	User entry for Longitude1
Long2text	String	50	User entry for Longitude2
Longitude1	BigDecimal		Longitude of first point
Longitude2	BigDecimal		Longitude of second point
Max Elevation	Double		The maximum elevation in Meters
Min Elevation	Double		The minimum elevation in Meters
Named Place	String	255	The named place the locality is closest to
Original Elevation Unit	String	50	i.e. Meters, Feet, ...
Original Latitude Longitude Unit	Integer		i.e. Decimal, Deg/Min/Sec, ...
Relation To Named Place	String	120	Relation of the locality to the named place
Remarks	Memo	32767	Additional Comments
Sgr Status	Byte
Short Name	String	32
Src Lat Long Unit	Byte
Text1	String	32767
Text2	String	32767
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
ManyToOne		createdByAgent	Agent
ManyToOne		discipline	Discipline
ZeroOrOne		geoCoordDetails	Geo Coord Detail
ManyToOne		geography	Geography
OneToMany		latLonpolygons	Lat Lon Polygon
OneToMany		localityAttachments	Locality Attachment
OneToMany		localityCitations	Locality Citation
ZeroOrOne		localityDetails	Locality Detail
OneToMany		localityNameAliass	Locality Name Alias
ManyToOne		modifiedByAgent	Agent
ManyToOne		visibilitySetBy	Specify User

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

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

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

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

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

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

Paleo Context
Field	Type	Length	Descriptions
PaleoContextID	Integer		Primary Key
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	Memo	32767
Text1	String	64
Text2	String	64
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Top Distance	Float		The distance to the top of the position.
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Relationships
Type		Name	To Table
ManyToOne		bioStrat	Chronostratigraphy
ManyToOne		chronosStrat	Chronostratigraphy
ManyToOne		chronosStratEnd	Chronostratigraphy
OneToMany		collectionObjects	Collection Object
ManyToOne		createdByAgent	Agent
ManyToOne		lithoStrat	Lithostratigraphy
ManyToOne		modifiedByAgent	Agent

Permit
Field	Type	Length	Descriptions
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	32767	Additional Comments
Renewal Date	Calendar		Date of renewal
Start Date	Calendar		Date permit becomes effective
Text1	String	32767	User definable
Text2	String	32767	User definable
Timestamp Created	Timestamp		The timestamp the record was created.
Timestamp Modified	Timestamp		The timestamp the record was last modified.
Type	String	50	Permit category - `CITES`, `Migratory Bird Treaty Act`, ...
Version	Integer
Yes No1	Boolean		User definable
Yes No2	Boolean		User definable
Relationships
Type		Name	To Table
OneToMany		accessionAuthorizations	Accession Authorization
ManyToOne		createdByAgent	Agent
ManyToOne		issuedBy	Agent
ManyToOne		issuedTo	Agent
ManyToOne		modifiedByAgent	Agent
OneToMany		permitAttachments	Permit Attachment

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

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

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

Preparation
Field	Type	Length	Descriptions
PreparationID	Integer		Primary Key
Collection Member Id	Integer
Count	Integer		Number of items
Description	String	255
Number1	Float
Number2	Float
Prepared Date	Calendar
Prepared Date Precision	Byte
Remarks	Memo	32767	Additional Comments
Sample Number	String	32
Status	String	32
Storage Location	String	50
Text1	String	32767	User definable
Text2	String	32767	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
ManyToOne		collectionObject	Collection Object
ManyToOne		createdByAgent	Agent
OneToMany		deaccessionPreparations	Deaccession Preparation
OneToMany		exchangeInPreps	Exchange In Prep
OneToMany		exchangeOutPreps	Exchange Out Prep
OneToMany		giftPreparations	Gift Preparation
OneToMany		loanPreparations	Loan Preparation
ManyToOne		modifiedByAgent	Agent
ManyToOne		prepType	Preparation Type
OneToMany		preparationAttachments	Preparation Attachment
ManyToOne		preparationAttribute	Preparation Attribute
OneToMany		preparationAttrs	Preparation Attribute
ManyToOne		preparedByAgent	Agent
ManyToOne		storage	Storage

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

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

Preparation Attribute
Field	Type	Length	Descriptions
PreparationAttributeID	Integer		Primary Key
Attr Date	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	32767
Text1	String	32767
Text10	String	32767
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	32767
Text20	String	50
Text21	String	50
Text22	String	50
Text23	String	50
Text24	String	50
Text25	String	50
Text26	String	50
Text3	String	50
Text4	String	50
Text5	String	50
Text6	String	50
Text7	String	50
Text8	String	50
Text9	String	50
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Yes No1	Boolean
Yes No2	Boolean
Yes No3	Boolean
Yes No4	Boolean
Relationships
Type		Name	To Table
ManyToOne		createdByAgent	Agent
ManyToOne		modifiedByAgent	Agent
OneToMany		preparations	Preparation

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Sp Query Field
Field	Type	Length	Descriptions
SpQueryFieldID	Integer		Primary Key
Allow Nulls	Boolean
Always Filter	Boolean
Column Alias	String	64
Context Table Ident	Integer
End Value	String	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	32767
Table List	String	32767
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Version	Integer
Relationships
Type		Name	To Table
ManyToOne		createdByAgent	Agent
OneToMany		mappings	Sp Export Schema Item Mapping
ManyToOne		modifiedByAgent	Agent
ManyToOne		query	Sp Query

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

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

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

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

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

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

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

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

Taxon
Field	Type	Length	Descriptions
TaxonID	Integer		Primary Key
Author	String	128
CITES Status	String	32
Col Status	String	32
Common Name	String	128
Cultivar Name	String	32
Environmental Protection Status	String	64
ESA Status	String	64
Full Name	String	255
Group Number	String	20	Taxonomic group number
GUID	String	128
Highest Child Node Number	Integer
Is Preferred	Boolean
Is Hybrid	Boolean
ISIS Number	String	16
Label Format	String	64
Name	String	64
NCBI Taxon Number	String	8
Node Number	Integer
Number 1	Integer
Number 2	Integer
Rank ID	Integer
Remarks	Memo	32767	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.
Unit Ind1	String	50
Unit Ind2	String	50
Unit Ind3	String	50
Unit Ind4	String	50
Unit Name1	String	50
Unit Name2	String	50
Unit Name3	String	50
Unit Name4	String	50
USFWS Code	String	16
Version	Integer
Visibility	Byte
Relationships
Type		Name	To Table
OneToMany		acceptedChildren	Taxon
ManyToOne		acceptedTaxon	Taxon
OneToMany		children	Taxon
OneToMany		collectingEventAttributes	Collecting Event Attribute
OneToMany		commonNames	Common Name
ManyToOne		createdByAgent	Agent
ManyToOne		definition	Taxon Tree Definition
ManyToOne		definitionItem	Taxon Tree Definition Item
OneToMany		determinations	Determination
OneToMany		hybridChildren1	Taxon
OneToMany		hybridChildren2	Taxon
ManyToOne		hybridParent1	Taxon
ManyToOne		hybridParent2	Taxon
ManyToOne		modifiedByAgent	Agent
ManyToOne		parent	Taxon
OneToMany		taxonAttachments	Taxon Attachment
OneToMany		taxonCitations	Taxon Citation
ManyToOne		visibilitySetBy	Specify User

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

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

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

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

Treatment Event
Field	Type	Length	Descriptions
TreatmentEventID	Integer		Primary Key
Date Boxed	Calendar
Date Cleaned	Calendar
Date Completed	Calendar
Date Received	Calendar
Date To Isolation	Calendar
End Date	Calendar
Start Date	Calendar
Field Number	String	50
Location	String	64
Remarks	Memo	32767
Timestamp Created	Timestamp
Timestamp Modified	Timestamp
Treat Number	String	32
Type	String	32
Version	Integer
Relationships
Type		Name	To Table
ManyToOne		accession	Accession
ManyToOne		collectionObject	Collection Object
ManyToOne		createdByAgent	Agent
ManyToOne		division	Division
ManyToOne		modifiedByAgent	Agent

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

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

Workbench Row
Field	Type	Length	Descriptions
WorkbenchRowID	Integer		Primary Key
Bio Geomancer Results	Memo	32767	The XML returned from Bio Geomancer
Card Image Data	Memo	32767	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
Record Id	Integer
Row Number	Short		The row number
Sgr Status	Byte
Upload Status	Byte
Relationships
Type		Name	To Table
ManyToOne		workbench	WorkBench
OneToMany		workbenchDataItems	WorkBench Data Item
OneToMany		workbenchRowExportedRelationships	Workbench Row Exported Relationship
OneToMany		workbenchRowImages	Workbench Row Image

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

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

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

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

Table Descriptions

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

Table Indexes

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