Specify Database Schema

Version: 2.7 (Released with Specify 6.8.00, 7.4.00)

Published: 21 May 2020

List of tables

• Accession
• Accession Agent
• Accession Attachment
• Accession Authorization
• Accession Citation
• Address
• Address Of Record
• Agent
• Agent Attachment
• Agent Geography
• Agent Specialty
• Agent Variant
• Appraisal
• Attachment
• Attachment Image Attribute
• Attachment Metadata
• Attachment Tag
• Attribute Def
• Author
• Auto Numbering Scheme
• Borrow
• Borrow Agent
• Borrow Attachment
• Borrow Material
• Borrow Return Material
• Collecting Event
• Collecting Event Attachment
• Attr
• Collecting Event Attribute
• Collecting Event Authorization
• Collecting Trip
• Collecting Trip Attachment
• Collecting Trip Attribute
• Collecting Trip Authorization
• User Group Scope
• Collection Object
• Collection Object Attachment
• Attr
• Collection Object Attribute
• Collection Object Citation
• Collection Object Property
• Collection Rel Type
• Collection Relationship
• Collector
• Common Name Tx
• Common Name Tx Citation
• Conserv Description
• Conserv Description Attachment
• Conserv Event
• Conserv Event Attachment
• Container
• DNA Primer
• DNA Sequence
• DNA Sequence Attachment
• DNA Sequencing Run
• DNA Sequencing Run Attachment
• DNA Sequencing Run Citation
• Data Type
• Deaccession
• Deaccession Agent
• Deaccession Preparation
• Determination
• Determination Citation
• User Group Scope
• User Group Scope
• Exchange In
• Exchange In Prep
• Exchange Out
• Exchange Out Prep
• Exsiccata
• Exsiccata Item
• Extractor
• 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 Def
• Geography Tree Def Item
• Geologic Time Period
• Geologic Time Period Tree Def
• Geologic Time Period Tree Def Item
• Gift
• Gift Agent
• Gift Attachment
• Gift Preparation
• Group Person
• Info Request
• User Group Scope
• Institution Network
• Journal
• Lat Lon Polygon
• Lat Lon Polygon Pnt
• Litho Strat
• Litho Strat Tree Def
• Litho Strat Tree Def Item
• Loan
• Loan Agent
• Loan Attachment
• Loan Preparation
• Loan Return Preparation
• Locality
• Locality Attachment
• Locality Citation
• Locality Detail
• Locality Name Alias
• Material Sample
• Morph Bank View
• Other Identifier
• Paleo Context
• Pcr Person
• Permit
• Permit Attachment
• Pick List
• Pick List Item
• Prep Type
• Preparation
• Preparation Attachment
• Attr
• Preparation Attribute
• Preparation Property
• Project
• Record Set
• Record Set Item
• Reference Work
• Reference Work Attachment
• Repository Agreement
• Repository Agreement Attachment
• Shipment
• Sp App Resource
• Sp App Resource Data
• Sp App Resource Dir
• Sp Audit Log
• Sp Audit Log Field
• Sp Export Schema
• Sp Export Schema Item
• Sp Export Schema Item Mapping
• Sp Export Schema Mapping
• Sp Field Value Default
• Sp Locale Container
• Sp Locale Container Item
• Sp Locale Item Str
• Sp Permission
• Sp Principal
• Sp Query
• Sp Query Field
• Sp Report
• Sp Symbiota Instance
• Task Semaphore
• Sp Version
• Sp View Set Obj
• Sp Visual Query
• Specify User
• Storage
• Storage Attachment
• Storage Tree Def
• Storage Tree Def Item
• Taxon
• Taxon Attachment
• Taxon Attribute
• Taxon Citation
• Taxon Tree Def
• Taxon Tree Def Item
• Treatment Event
• Treatment Event Attachment
• Voucher Relationship
• Workbench
• Workbench Data Item
• Workbench Row
• Workbench Row Exported Relationship
• Workbench Row Image
• Workbench Template
• Workbench Template Mapping Item

Table Definitions

Back to top

Accession
Field	Type	Length	Description	Flags
AccessionCondition	String	255
AccessionNumber	String	60		Required Indexed
DateAccessioned	Calendar			Indexed
DateAcknowledged	Calendar
DateReceived	Calendar
Integer1	Integer
Integer2	Integer
Integer3	Integer
Number1	Float
Number2	Float
Remarks	Text	4096
Status	String	32
Text1	Text	65535
Text2	Text	65535
Text3	Text	65535
Text4	Text	65535
Text5	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
TotalValue	Bigdecimal
Type	String	32
VerbatimDate	String	50
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
one-to-many	Accession Agent		accessionAgents
one-to-many	Accession Attachment		accessionAttachments
one-to-many	Accession Authorization		accessionAuthorizations
one-to-many	Accession Citation		accessionCitations
many-to-one	Address Of Record		addressOfRecord
one-to-many	Appraisal		appraisals
one-to-many	Collection Object		collectionObjects
many-to-one	Agent		createdByAgent
one-to-many	Deaccession		deaccessions
many-to-one	User Group Scope		division
many-to-one	Agent		modifiedByAgent
many-to-one	Repository Agreement		repositoryAgreement
one-to-many	Treatment Event		treatmentEvents

Back to top

Accession Agent
Field	Type	Length	Description	Flags
Remarks	Text	4096
Role	String	50		Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Accession		accession
many-to-one	Agent		agent
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Repository Agreement		repositoryAgreement

Back to top

Accession Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Accession		accession
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Accession Authorization
Field	Type	Length	Description	Flags
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Accession		accession
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Permit		permit
many-to-one	Repository Agreement		repositoryAgreement

Back to top

Accession Citation
Field	Type	Length	Description	Flags
FigureNumber	String	50
IsFigured	Boolean
PageNumber	String	50
PlateNumber	String	50
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Accession		accession
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Reference Work		referenceWork

Back to top

Address
Field	Type	Length	Description	Flags
Address	String	255
Address2	String	255
Address3	String	64
Address4	String	64
Address5	String	64
City	String	64
Country	String	64
EndDate	Calendar
Fax	String	50
IsCurrent	Boolean
IsPrimary	Boolean
IsShipping	Boolean
Ordinal	Integer
Phone1	String	50
Phone2	String	50
PositionHeld	String	32
PostalCode	String	32
Remarks	Text	4096
RoomOrBuilding	String	50
StartDate	Calendar
State	String	64
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
TypeOfAddr	String	32
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Agent		createdByAgent
one-to-many	User Group Scope		divisions
one-to-many	User Group Scope		insitutions
many-to-one	Agent		modifiedByAgent

Back to top

Address Of Record
Field	Type	Length	Description	Flags
Address	String	255
Address2	String	255
City	String	64
Country	String	64
PostalCode	String	32
Remarks	Text	4096
State	String	64
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Accession		accessions
many-to-one	Agent		agent
many-to-one	Agent		createdByAgent
one-to-many	Exchange In		exchangeIns
one-to-many	Exchange Out		exchangeOuts
one-to-many	Loan		loans
many-to-one	Agent		modifiedByAgent
one-to-many	Repository Agreement		repositoryAgreements

Back to top

Agent
Field	Type	Length	Description	Flags
Abbreviation	String	50		Indexed
AgentType	Byte			Required Indexed
Date1	Calendar
Date1Precision	Byte
Date2	Calendar
Date2Precision	Byte
DateOfBirth	Calendar
DateOfBirthPrecision	Byte
DateOfDeath	Calendar
DateOfDeathPrecision	Byte
DateType	Byte
Email	String	50
FirstName	String	50		Indexed
GUID	String	128		Indexed
Initials	String	8
Integer1	Integer
Integer2	Integer
Interests	String	255
JobTitle	String	50
LastName	String	256		Indexed
MiddleInitial	String	50
Remarks	Text	4096
Suffix	String	50
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Title	String	50
URL	String	1024
VerbatimDate1	String	128
VerbatimDate2	String	128
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Address		addresses
one-to-many	Agent Attachment		agentAttachments
one-to-many	Agent Geography		agentGeographies
one-to-many	Agent Specialty		agentSpecialties
many-to-one	User Group Scope		collContentContact
many-to-one	User Group Scope		collTechContact
one-to-many	Collector		collectors
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		division
one-to-many	Group Person		groups
many-to-one	User Group Scope		instContentContact
many-to-one	User Group Scope		instTechContact
one-to-many	Group Person		members
many-to-one	Agent		modifiedByAgent
one-to-many	Agent		orgMembers
many-to-one	Agent		organization
many-to-one	Specify User		specifyUser
one-to-many	Agent Variant		variants

Back to top

Agent Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Agent Geography
Field	Type	Length	Description	Flags
Remarks	Text	4096
Role	String	64
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Agent		createdByAgent
many-to-one	Geography		geography
many-to-one	Agent		modifiedByAgent

Back to top

Agent Specialty
Field	Type	Length	Description	Flags
OrderNumber	Integer			Required
SpecialtyName	String	64		Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Agent Variant
Field	Type	Length	Description	Flags
Country	String	2
Language	String	2
Name	String	255
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
VarType	Byte			Required
Variant	String	2
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Appraisal
Field	Type	Length	Description	Flags
AppraisalDate	Calendar			Required Indexed
AppraisalNumber	String	64		Required Unique Indexed
AppraisalValue	Bigdecimal
MonetaryUnitType	String	8
Notes	Text	2048
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Accession		accession
many-to-one	Agent		agent
one-to-many	Collection Object		collectionObjects
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Attachment
Field	Type	Length	Description	Flags
AttachmentLocation	String	128
AttachmentStorageConfig	Text
CaptureDevice	String	128
CopyrightDate	String	64
CopyrightHolder	String	64
Credit	String	64
DateImaged	String	64		Indexed
FileCreatedDate	Calendar
GUID	String	128		Indexed
IsPublic	Boolean			Required
License	String	64
LicenseLogoUrl	String	256
MetadataText	String	256
MimeType	String	64
OrigFilename	String	20000		Required
Remarks	Text	4096
ScopeID	Integer			Indexed
ScopeType	Byte			Indexed
SubjectOrientation	String	64
Subtype	String	64
TableID	Short			Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Title	String	255		Indexed
Type	String	64
Version	Integer
Visibility	Byte
Relationships
Type	Target Table		Field name
one-to-many	Accession Attachment		accessionAttachments
one-to-many	Agent Attachment		agentAttachments
many-to-one	Attachment Image Attribute		attachmentImageAttribute
one-to-many	Borrow Attachment		borrowAttachments
one-to-many	Collecting Event Attachment		collectingEventAttachments
one-to-many	Collecting Trip Attachment		collectingTripAttachments
one-to-many	Collection Object Attachment		collectionObjectAttachments
one-to-many	Conserv Description Attachment		conservDescriptionAttachments
one-to-many	Conserv Event Attachment		conservEventAttachments
many-to-one	Agent		createdByAgent
many-to-one	Agent		creator
one-to-many	DNA Sequence Attachment		dnaSequenceAttachments
one-to-many	DNA Sequencing Run Attachment		dnaSequencingRunAttachments
one-to-many	Field Notebook Attachment		fieldNotebookAttachments
one-to-many	Field Notebook Page Attachment		fieldNotebookPageAttachments
one-to-many	Field Notebook Page Set Attachment		fieldNotebookPageSetAttachments
one-to-many	Gift Attachment		giftAttachments
one-to-many	Loan Attachment		loanAttachments
one-to-many	Locality Attachment		localityAttachments
one-to-many	Attachment Metadata		metadata
many-to-one	Agent		modifiedByAgent
one-to-many	Permit Attachment		permitAttachments
one-to-many	Preparation Attachment		preparationAttachments
one-to-many	Reference Work Attachment		referenceWorkAttachments
one-to-many	Repository Agreement Attachment		repositoryAgreementAttachments
one-to-many	Storage Attachment		storageAttachments
one-to-many	Attachment Tag		tags
one-to-many	Taxon Attachment		taxonAttachments
one-to-many	Treatment Event Attachment		treatmentEventAttachments
many-to-one	Specify User		visibilitySetBy

Back to top

Attachment Image Attribute
Field	Type	Length	Description	Flags
CreativeCommons	String	500
Height	Integer	24
ImageType	String	80
Magnification	Double	24
MBImageID	Integer	24
Number1	Double	24
Number2	Double	24
Remarks	Text	4096
Resolution	Double	24
Text1	String	200
Text2	String	200
TimestampCreated	Timestamp			Required
TimestampLastSend	Timestamp
TimestampLastUpdateCheck	Timestamp
TimestampModified	Timestamp
Version	Integer
ViewDescription	String	80
Width	Integer	24
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
one-to-many	Attachment		attachments
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Morph Bank View		morphBankView

Back to top

Attachment Metadata
Field	Type	Length	Description	Flags
Name	String	64		Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Value	String	128		Required
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Attachment Tag
Field	Type	Length	Description	Flags
Tag	String	64		Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Attribute Def
Field	Type	Length	Description	Flags
DataType	Short
FieldName	String	32
TableType	Short
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Attr		collectingEventAttrs
one-to-many	Attr		collectionObjectAttrs
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Agent		modifiedByAgent
many-to-one	Prep Type		prepType
one-to-many	Attr		preparationAttrs

Back to top

Author
Field	Type	Length	Description	Flags
OrderNumber	Short			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Reference Work		referenceWork

Back to top

Auto Numbering Scheme
Field	Type	Length	Description	Flags
FormatName	String	64
IsNumericOnly	Boolean			Required
SchemeClassName	String	64
SchemeName	String	64		Indexed
TableNumber	Integer			Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-many	User Group Scope		collections
many-to-one	Agent		createdByAgent
many-to-many	User Group Scope		disciplines
many-to-many	User Group Scope		divisions
many-to-one	Agent		modifiedByAgent

Back to top

Borrow
Field	Type	Length	Description	Flags
BorrowDate	Calendar
BorrowDatePrecision	Byte
CollectionMemberID	Integer			Required Indexed
CurrentDueDate	Calendar
DateClosed	Calendar	10
InvoiceNumber	String	50		Required Indexed
IsClosed	Boolean
IsFinancialResponsibility	Boolean
Number1	Float	24
Number2	Float	24
NumberOfItemsBorrowed	Integer	24
OriginalDueDate	Calendar
ReceivedDate	Calendar			Indexed
Remarks	Text	4096
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Address Of Record		addressOfRecord
one-to-many	Borrow Agent		borrowAgents
one-to-many	Borrow Attachment		borrowAttachments
one-to-many	Borrow Material		borrowMaterials
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
one-to-many	Shipment		shipments

Back to top

Borrow Agent
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Remarks	Text	4096
Role	String	32		Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Borrow		borrow
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Borrow Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Borrow		borrow
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Borrow Material
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Description	String	50		Indexed
InComments	Text	1024
MaterialNumber	String	50		Required Indexed
OutComments	Text	1024
Quantity	Short
QuantityResolved	Short
QuantityReturned	Short
Text1	Text	6667
Text2	Text	6667
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Borrow		borrow
one-to-many	Borrow Return Material		borrowReturnMaterials
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Borrow Return Material
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Quantity	Short
Remarks	Text	4096
ReturnedDate	Calendar			Indexed
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Borrow Material		borrowMaterial
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Collecting Event
Field	Type	Length	Description	Flags
EndDate	Calendar			Indexed
EndDatePrecision	Byte
EndDateVerbatim	String	50
EndTime	Short
GUID	String	128		Indexed
Integer1	Integer
Integer2	Integer
Method	String	50
Remarks	Text	4096
ReservedInteger3	Integer
ReservedInteger4	Integer
ReservedText1	String	128
ReservedText2	String	128
SGRStatus	Byte
StartDate	Calendar			Indexed
StartDatePrecision	Byte
StartDateVerbatim	String	50
StartTime	Short
StationFieldNumber	String	50		Indexed
StationFieldNumberModifier1	String	50
StationFieldNumberModifier2	String	50
StationFieldNumberModifier3	String	50
Text1	Text	65535
Text2	Text	65535
Text3	Text	65535
Text4	Text	65535
Text5	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
VerbatimDate	String	50
VerbatimLocality	Text	2048
Version	Integer
Visibility	Byte
Relationships
Type	Target Table		Field name
one-to-many	Collecting Event Attachment		collectingEventAttachments
many-to-one	Collecting Event Attribute		collectingEventAttribute
one-to-many	Attr		collectingEventAttrs
one-to-many	Collecting Event Authorization		collectingEventAuthorizations
many-to-one	Collecting Trip		collectingTrip
one-to-many	Collection Object		collectionObjects
one-to-many	Collector		collectors
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Locality		locality
many-to-one	Agent		modifiedByAgent
many-to-one	Paleo Context		paleoContext
many-to-one	Specify User		visibilitySetBy

Back to top

Collecting Event Attachment
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Collecting Event		collectingEvent
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Attr
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
DoubleValue	Double
StrValue	String	255
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Collecting Event		collectingEvent
many-to-one	Agent		createdByAgent
many-to-one	Attribute Def		definition
many-to-one	Agent		modifiedByAgent

Back to top

Collecting Event Attribute
Field	Type	Length	Description	Flags
Integer1	Integer
Integer10	Integer
Integer2	Integer
Integer3	Integer
Integer4	Integer
Integer5	Integer
Integer6	Integer
Integer7	Integer
Integer8	Integer
Integer9	Integer
Number1	Float
Number10	Float
Number11	Float
Number12	Float
Number13	Float
Number2	Float
Number3	Float
Number4	Float
Number5	Float
Number6	Float
Number7	Float
Number8	Float
Number9	Float
Remarks	Text	4096
Text1	Text	65535
Text10	String	50
Text11	String	50
Text12	String	50
Text13	String	50
Text14	String	50
Text15	String	50
Text16	String	50
Text17	String	50
Text2	Text	65535
Text3	Text	65535
Text4	String	100
Text5	String	100
Text6	String	50
Text7	String	50
Text8	String	50
Text9	String	50
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
YesNo3	Boolean
YesNo4	Boolean
YesNo5	Boolean
Relationships
Type	Target Table		Field name
one-to-many	Collecting Event		collectingEvents
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Taxon		hostTaxon
many-to-one	Agent		modifiedByAgent

Back to top

Collecting Event Authorization
Field	Type	Length	Description	Flags
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Collecting Event		collectingEvent
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Permit		permit

Back to top

Collecting Trip
Field	Type	Length	Description	Flags
CollectingTripName	String	250		Indexed
Cruise	String	250
Date1	Calendar
Date1Precision	Byte
Date2	Calendar
Date2Precision	Byte
EndDate	Calendar
EndDatePrecision	Byte
EndDateVerbatim	String	50
EndTime	Short
Expedition	String	250
Number1	Integer
Number2	Integer
Remarks	Text	4096
Sponsor	String	64
StartDate	Calendar			Indexed
StartDatePrecision	Byte
StartDateVerbatim	String	50
StartTime	Short
Text1	String	255
Text2	String	128
Text3	String	64
Text4	String	64
Text5	Text	65535
Text6	Text	65535
Text7	Text	65535
Text8	Text	65535
Text9	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Vessel	String	250
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent1
many-to-one	Agent		agent2
one-to-many	Collecting Event		collectingEvents
one-to-many	Collecting Trip Attachment		collectingTripAttachments
many-to-one	Collecting Trip Attribute		collectingTripAttribute
one-to-many	Collecting Trip Authorization		collectingTripAuthorizations
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
one-to-many	Funding Agent		fundingAgents
many-to-one	Agent		modifiedByAgent

Back to top

Collecting Trip Attachment
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Collecting Trip		collectingTrip
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Collecting Trip Attribute
Field	Type	Length	Description	Flags
Integer1	Integer
Integer10	Integer
Integer2	Integer
Integer3	Integer
Integer4	Integer
Integer5	Integer
Integer6	Integer
Integer7	Integer
Integer8	Integer
Integer9	Integer
Number1	Float
Number10	Float
Number11	Float
Number12	Float
Number13	Float
Number2	Float
Number3	Float
Number4	Float
Number5	Float
Number6	Float
Number7	Float
Number8	Float
Number9	Float
Remarks	Text	4096
Text1	Text	65535
Text10	String	50
Text11	String	50
Text12	String	50
Text13	String	50
Text14	String	50
Text15	String	50
Text16	String	50
Text17	String	50
Text2	Text	65535
Text3	Text	65535
Text4	String	100
Text5	String	100
Text6	String	50
Text7	String	50
Text8	String	50
Text9	String	50
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
YesNo3	Boolean
YesNo4	Boolean
YesNo5	Boolean
Relationships
Type	Target Table		Field name
one-to-many	Collecting Trip		collectingTrips
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Agent		modifiedByAgent

Back to top

Collecting Trip Authorization
Field	Type	Length	Description	Flags
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Collecting Trip		collectingTrip
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Permit		permit

Back to top

User Group Scope
Field	Type	Length	Description	Flags
CatalogFormatNumName	String	64		Required
Code	String	50
CollectionName	String	50		Indexed
CollectionType	String	32
DbContentVersion	String	32
Description	Text	2048
DevelopmentStatus	String	32
EstimatedSize	Integer
GUID	String	128		Indexed
InstitutionType	String	32
IsEmbeddedCollectingEvent	Boolean			Required
IsaNumber	String	24
KingdomCoverage	String	32
PreservationMethodType	String	32
PrimaryFocus	String	32
PrimaryPurpose	String	32
RegNumber	String	24
Remarks	Text	4096
Scope	Text	2048
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
WebPortalURI	String	255
WebSiteURI	String	255
Relationships
Type	Target Table		Field name
many-to-one	Agent		adminContact
one-to-many	Agent		contentContacts
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	User Group Scope		institutionNetwork
one-to-many	Collection Rel Type		leftSideRelTypes
many-to-one	Agent		modifiedByAgent
many-to-many	Auto Numbering Scheme		numberingSchemes
one-to-many	Pick List		pickLists
one-to-many	Prep Type		prepTypes
one-to-many	Collection Rel Type		rightSideRelTypes
one-to-many	Agent		technicalContacts
one-to-many	Sp Principal		userGroups

Back to top

Collection Object
Field	Type	Length	Description	Flags
AltCatalogNumber	String	64		Indexed
Availability	String	32
CatalogNumber	String	32		Indexed
CatalogedDate	Calendar			Indexed
CatalogedDatePrecision	Byte
CatalogedDateVerbatim	String	32
CollectionMemberID	Integer			Required
CountAmt	Integer
Date1	Calendar
Date1Precision	Byte
Deaccessioned	Boolean
Description	String	255
FieldNumber	String	50		Indexed
GUID	String	128		Indexed
Integer1	Integer
Integer2	Integer
InventoryDate	Calendar
InventoryDatePrecision	Byte
Modifier	String	50
Name	String	64
Notifications	String	32
Number1	Float	24
Number2	Float	24
NumberOfDuplicates	Integer
ObjectCondition	String	64
OCR	Text	4096
ProjectNumber	String	64
Remarks	Text	4096
ReservedInteger3	Integer
ReservedInteger4	Integer
ReservedText	String	128
ReservedText2	String	128
ReservedText3	String	128
Restrictions	String	32
SGRStatus	Byte
Text1	Text	65535
Text2	Text	65535
Text3	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
TotalValue	Bigdecimal
Version	Integer
Visibility	Byte	10
YesNo1	Boolean
YesNo2	Boolean
YesNo3	Boolean
YesNo4	Boolean
YesNo5	Boolean
YesNo6	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Accession		accession
many-to-one	Agent		agent1
many-to-one	Appraisal		appraisal
many-to-one	Agent		cataloger
many-to-one	Collecting Event		collectingEvent
many-to-one	User Group Scope		collection
one-to-many	Collection Object Attachment		collectionObjectAttachments
many-to-one	Collection Object Attribute		collectionObjectAttribute
one-to-many	Attr		collectionObjectAttrs
one-to-many	Collection Object Citation		collectionObjectCitations
one-to-many	Collection Object Property		collectionObjectProperties
one-to-many	Conserv Description		conservDescriptions
many-to-one	Container		container
many-to-one	Container		containerOwner
many-to-one	Agent		createdByAgent
one-to-many	Determination		determinations
one-to-many	DNA Sequence		dnaSequences
one-to-many	Exsiccata Item		exsiccataItems
many-to-one	Field Notebook Page		fieldNotebookPage
many-to-one	Agent		inventorizedBy
one-to-many	Collection Relationship		leftSideRels
many-to-one	Agent		modifiedByAgent
one-to-many	Other Identifier		otherIdentifiers
many-to-one	Paleo Context		paleoContext
one-to-many	Preparation		preparations
many-to-many	Project		projects
one-to-many	Collection Relationship		rightSideRels
one-to-many	Treatment Event		treatmentEvents
many-to-one	Specify User		visibilitySetBy
one-to-many	Voucher Relationship		voucherRelationships

Back to top

Collection Object Attachment
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Collection Object		collectionObject
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Attr
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
DoubleValue	Double
StrValue	String	255
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Collection Object		collectionObject
many-to-one	Agent		createdByAgent
many-to-one	Attribute Def		definition
many-to-one	Agent		modifiedByAgent

Back to top

Collection Object Attribute
Field	Type	Length	Description	Flags
BottomDistance	Float
CollectionMemberID	Integer			Required Indexed
Date1	Calendar
Date1Precision	Byte
Direction	String	32
DistanceUnits	String	16
Integer1	Integer
Integer10	Integer
Integer2	Integer
Integer3	Integer
Integer4	Integer
Integer5	Integer
Integer6	Integer
Integer7	Integer
Integer8	Integer
Integer9	Integer
Number1	Float
Number10	Float
Number11	Float
Number12	Float
Number13	Float
Number14	Float
Number15	Float
Number16	Float
Number17	Float
Number18	Float
Number19	Float
Number2	Float
Number20	Float
Number21	Float
Number22	Float
Number23	Float
Number24	Float
Number25	Float
Number26	Float
Number27	Float
Number28	Float
Number29	Float
Number3	Float
Number30	Integer
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	Integer
Number9	Float
PositionState	String	32
Remarks	Text	4096
Text1	Text	65535
Text10	String	50
Text11	String	50
Text12	String	50
Text13	String	50
Text14	String	50
Text15	String	64
Text16	Text	65535
Text17	Text	65535
Text18	Text	65535
Text19	Text	65535
Text2	Text	65535
Text20	Text	65535
Text21	Text	65535
Text22	Text	65535
Text23	Text	65535
Text24	Text	65535
Text25	Text	65535
Text26	Text	65535
Text27	Text	65535
Text28	Text	65535
Text29	Text	65535
Text3	Text	65535
Text30	Text	65535
Text4	String	50
Text5	String	50
Text6	String	100
Text7	String	100
Text8	String	50
Text9	String	50
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
TopDistance	Float
Version	Integer
YesNo1	Boolean
YesNo10	Boolean
YesNo11	Boolean
YesNo12	Boolean
YesNo13	Boolean
YesNo14	Boolean
YesNo15	Boolean
YesNo16	Boolean
YesNo17	Boolean
YesNo18	Boolean
YesNo19	Boolean
YesNo2	Boolean
YesNo20	Boolean
YesNo3	Boolean
YesNo4	Boolean
YesNo5	Boolean
YesNo6	Boolean
YesNo7	Boolean
YesNo8	Boolean
YesNo9	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent1
one-to-many	Collection Object		collectionObjects
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Collection Object Citation
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
FigureNumber	String	50
IsFigured	Boolean
PageNumber	String	50
PlateNumber	String	50
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Collection Object		collectionObject
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Reference Work		referenceWork

Back to top

Collection Object Property
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Date1	Calendar
Date10	Calendar
Date11	Calendar
Date12	Calendar
Date13	Calendar
Date14	Calendar
Date15	Calendar
Date16	Calendar
Date17	Calendar
Date18	Calendar
Date19	Calendar
Date2	Calendar
Date20	Calendar
Date3	Calendar
Date4	Calendar
Date5	Calendar
Date6	Calendar
Date7	Calendar
Date8	Calendar
Date9	Calendar
GUID	String	128
Integer1	Short
Integer10	Short
Integer11	Short
Integer12	Short
Integer13	Short
Integer14	Short
Integer15	Short
Integer16	Short
Integer17	Short
Integer18	Short
Integer19	Short
Integer2	Short
Integer20	Short
Integer21	Integer
Integer22	Integer
Integer23	Integer
Integer24	Integer
Integer25	Integer
Integer26	Integer
Integer27	Integer
Integer28	Integer
Integer29	Integer
Integer3	Short
Integer30	Integer
Integer4	Short
Integer5	Short
Integer6	Short
Integer7	Short
Integer8	Short
Integer9	Short
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	Double
Number22	Double
Number23	Double
Number24	Double
Number25	Double
Number26	Double
Number27	Double
Number28	Double
Number29	Double
Number3	Float
Number30	Double
Number4	Float
Number5	Float
Number6	Float
Number7	Float
Number8	Float
Number9	Float
Remarks	Text	4096
Text1	String	50
Text10	String	50
Text11	String	50
Text12	String	50
Text13	String	50
Text14	String	50
Text15	String	50
Text16	String	100
Text17	String	100
Text18	String	100
Text19	String	100
Text2	String	50
Text20	String	100
Text21	String	100
Text22	String	100
Text23	String	100
Text24	String	100
Text25	String	100
Text26	String	100
Text27	String	100
Text28	String	100
Text29	String	100
Text3	String	50
Text30	String	100
Text31	Text	65535
Text32	Text	65535
Text33	Text	65535
Text34	Text	65535
Text35	Text	65535
Text36	Text	65535
Text37	Text	65535
Text38	Text	65535
Text39	Text	65535
Text4	String	50
Text40	Text	65535
Text5	String	50
Text6	String	50
Text7	String	50
Text8	String	50
Text9	String	50
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo10	Boolean
YesNo11	Boolean
YesNo12	Boolean
YesNo13	Boolean
YesNo14	Boolean
YesNo15	Boolean
YesNo16	Boolean
YesNo17	Boolean
YesNo18	Boolean
YesNo19	Boolean
YesNo2	Boolean
YesNo20	Boolean
YesNo3	Boolean
YesNo4	Boolean
YesNo5	Boolean
YesNo6	Boolean
YesNo7	Boolean
YesNo8	Boolean
YesNo9	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent1
many-to-one	Agent		agent10
many-to-one	Agent		agent11
many-to-one	Agent		agent12
many-to-one	Agent		agent13
many-to-one	Agent		agent14
many-to-one	Agent		agent15
many-to-one	Agent		agent16
many-to-one	Agent		agent17
many-to-one	Agent		agent18
many-to-one	Agent		agent19
many-to-one	Agent		agent2
many-to-one	Agent		agent20
many-to-one	Agent		agent3
many-to-one	Agent		agent4
many-to-one	Agent		agent5
many-to-one	Agent		agent6
many-to-one	Agent		agent7
many-to-one	Agent		agent8
many-to-one	Agent		agent9
many-to-one	Collection Object		collectionObject
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Collection Rel Type
Field	Type	Length	Description	Flags
Name	String	32
Remarks	String	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		leftSideCollection
many-to-one	Agent		modifiedByAgent
many-to-one	User Group Scope		rightSideCollection

Back to top

Collection Relationship
Field	Type	Length	Description	Flags
Text1	String	32
Text2	String	32
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Collection Rel Type		collectionRelType
many-to-one	Agent		createdByAgent
many-to-one	Collection Object		leftSide
many-to-one	Agent		modifiedByAgent
many-to-one	Collection Object		rightSide

Back to top

Collector
Field	Type	Length	Description	Flags
IsPrimary	Boolean			Required
OrderNumber	Integer			Required
Remarks	Text	4096
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Collecting Event		collectingEvent
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		division
many-to-one	Agent		modifiedByAgent

Back to top

Common Name Tx
Field	Type	Length	Description	Flags
Author	String	128
Country	String	2		Indexed
Language	String	2
Name	String	255		Indexed
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Variant	String	2
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Common Name Tx Citation		citations
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Taxon		taxon

Back to top

Common Name Tx Citation
Field	Type	Length	Description	Flags
Number1	Float
Number2	Float
Remarks	Text	4096
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Common Name Tx		commonNameTx
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Reference Work		referenceWork

Back to top

Conserv Description
Field	Type	Length	Description	Flags
BackgroundInfo	Text	8192
Composition	Text	8192
Description	Text	8192
CatalogedDate	Calendar
DisplayRecommendations	Text	4096
Height	Float
LightRecommendations	Text	4096
ObjLength	Float
OtherRecommendations	Text	4096
Remarks	Text	8192
ShortDesc	String	128		Indexed
Source	Text	8192
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Units	String	16
Version	Integer
Width	Float
Relationships
Type	Target Table		Field name
many-to-one	Collection Object		collectionObject
one-to-many	Conserv Description Attachment		conservDescriptionAttachments
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		division
one-to-many	Conserv Event		events
many-to-one	Agent		modifiedByAgent
many-to-one	Preparation		preparation

Back to top

Conserv Description Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Conserv Description		conservDescription
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Conserv Event
Field	Type	Length	Description	Flags
AdvTestingExam	Text	8192
AdvTestingExamResults	Text	8192
CompletedComments	Text	4096
CompletedDate	Calendar
CompletedDatePrecision	Byte
ConditionReport	Text	8192
CuratorApprovalDate	Calendar	8192
CuratorApprovalDatePrecision	Byte
ExamDate	Calendar			Indexed
ExamDatePrecision	Byte
Number1	Integer
Number2	Integer
PhotoDocs	Text	8192
Remarks	Text	4096
Text1	String	64
Text2	String	64
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
TreatmentCompDate	Calendar
TreatmentCompDatePrecision	Byte
TreatmentReport	Text	8192
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Conserv Description		conservDescription
one-to-many	Conserv Event Attachment		conservEventAttachments
many-to-one	Agent		createdByAgent
many-to-one	Agent		curator
many-to-one	Agent		examinedByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Agent		treatedByAgent

Back to top

Conserv Event Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Conserv Event		conservEvent
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Container
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Description	String	255
Name	String	64		Indexed
Number	Integer
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Type	Short
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Container		children
one-to-many	Collection Object		collectionObjectKids
one-to-many	Collection Object		collectionObjects
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Container		parent
many-to-one	Storage		storage

Back to top

DNA Primer
Field	Type	Length	Description	Flags
Integer1	Integer
Integer2	Integer
Number1	Float
Number2	Float
PrimerDesignator	String	64		Indexed
PrimerNameForward	String	64
PrimerNameReverse	String	64
PrimerReferenceCitationForward	String	300
PrimerReferenceCitationReverse	String	300
PrimerReferenceLinkForward	String	300
PrimerReferenceLinkReverse	String	300
PrimerSequenceForward	String	128
PrimerSequenceReverse	String	128
purificationMethod	String	255
Remarks	Text	4096
ReservedInteger3	Integer
ReservedInteger4	Integer
ReservedNumber3	Float
ReservedNumber4	Float
ReservedText3	Text	4096
ReservedText4	Text	4096
Text1	Text	4096
Text2	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
one-to-many	DNA Sequencing Run		dnaSequencingRuns
many-to-one	Agent		modifiedByAgent

Back to top

DNA Sequence
Field	Type	Length	Description	Flags
AmbiguousResidues	Integer
BOLDBarcodeID	String	32		Indexed
BOLDLastUpdateDate	Calendar
BOLDSampleID	String	32		Indexed
BOLDTranslationMatrix	String	64
CollectionMemberID	Integer			Required
CompA	Integer
CompC	Integer
CompG	Integer
compT	Integer
ExtractionDate	Calendar
ExtractionDatePrecision	Byte
GenBankAccessionNumber	String	32		Indexed
GeneSequence	Text	2048
MoleculeType	String	32
Number1	Float
Number2	Float
Number3	Float
Remarks	Text	4096
SequenceDate	Calendar
SequenceDatePrecision	Byte
TargetMarker	String	32
Text1	String	32
Text2	String	32
Text3	String	64
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
TotalResidues	Integer
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
YesNo3	Boolean
Relationships
Type	Target Table		Field name
one-to-many	DNA Sequence Attachment		attachments
many-to-one	Collection Object		collectionObject
many-to-one	Agent		createdByAgent
one-to-many	DNA Sequencing Run		dnaSequencingRuns
many-to-one	Agent		extractor
one-to-many	Extractor		extractors
many-to-one	Material Sample		materialSample
many-to-one	Agent		modifiedByAgent
one-to-many	Pcr Person		pcrPersons
many-to-one	Agent		sequencer

Back to top

DNA Sequence Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	DNA Sequence		dnaSequence
many-to-one	Agent		modifiedByAgent

Back to top

DNA Sequencing Run
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required
DryadDOI	String	256
GeneSequence	Text
Number1	Float
Number2	Float
Number3	Float
Ordinal	Integer
PCRCocktailPrimer	Boolean
PCRForwardPrimerCode	String	32
PCRPrimerName	String	32
PCRPrimerSequence5_3	String	64
PCRReversePrimerCode	String	32
ReadDirection	String	16
Remarks	Text	4096
RunDate	Calendar
ScoreFileName	String	32
SequenceCocktailPrimer	Boolean
SequencePrimerCode	String	32
SequencePrimerName	String	32
SequencePrimerSequence5_3	String	64
SRAExperimentID	String	64
SRARunID	String	64
SRASubmissionID	String	64
Text1	String	32
Text2	String	32
Text3	String	64
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
TraceFileName	String	32
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
YesNo3	Boolean
Relationships
Type	Target Table		Field name
one-to-many	DNA Sequencing Run Attachment		attachments
one-to-many	DNA Sequencing Run Citation		citations
many-to-one	Agent		createdByAgent
many-to-one	DNA Primer		dnaPrimer
many-to-one	DNA Sequence		dnaSequence
many-to-one	Agent		modifiedByAgent
many-to-one	Agent		preparedByAgent
many-to-one	Agent		runByAgent

Back to top

DNA Sequencing Run Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	DNA Sequencing Run		dnaSequencingRun
many-to-one	Agent		modifiedByAgent

Back to top

DNA Sequencing Run Citation
Field	Type	Length	Description	Flags
Number1	Float
Number2	Float
Remarks	Text	4096
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Reference Work		referenceWork
many-to-one	DNA Sequencing Run		sequencingRun

Back to top

Data Type
Field	Type	Length	Description	Flags
Name	String	50
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Deaccession
Field	Type	Length	Description	Flags
DeaccessionDate	Calendar			Indexed
DeaccessionNumber	String	50		Indexed
Number1	Float	24
Number2	Float	24
Remarks	Text	4096
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Type	String	64
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Accession		accession
many-to-one	Agent		createdByAgent
one-to-many	Deaccession Agent		deaccessionAgents
one-to-many	Deaccession Preparation		deaccessionPreparations
many-to-one	Agent		modifiedByAgent

Back to top

Deaccession Agent
Field	Type	Length	Description	Flags
Remarks	Text	4096
Role	String	50		Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Agent		createdByAgent
many-to-one	Deaccession		deaccession
many-to-one	Agent		modifiedByAgent

Back to top

Deaccession Preparation
Field	Type	Length	Description	Flags
Quantity	Short
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Deaccession		deaccession
one-to-many	Loan Return Preparation		loanReturnPreparations
many-to-one	Agent		modifiedByAgent
many-to-one	Preparation		preparation

Back to top

Determination
Field	Type	Length	Description	Flags
Addendum	String	16
AlternateName	String	128		Indexed
CollectionMemberID	Integer			Required Indexed
Confidence	String	50
DeterminedDate	Calendar			Indexed
DeterminedDatePrecision	Byte
FeatureOrBasis	String	50
GUID	String	128		Indexed
IsCurrent	Boolean			Required
Method	String	50
NameUsage	String	64
Number1	Float	24
Number2	Float	24
Qualifier	String	16
Remarks	Text	4096
SubSpQualifier	String	16
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
TypeStatusName	String	50		Indexed
VarQualifier	String	16
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Collection Object		collectionObject
many-to-one	Agent		createdByAgent
one-to-many	Determination Citation		determinationCitations
many-to-one	Agent		determiner
many-to-one	Agent		modifiedByAgent
many-to-one	Taxon		preferredTaxon
many-to-one	Taxon		taxon

Back to top

Determination Citation
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Determination		determination
many-to-one	Agent		modifiedByAgent
many-to-one	Reference Work		referenceWork

Back to top

User Group Scope
Field	Type	Length	Description	Flags
IsPaleoContextEmbedded	Boolean			Required
Name	String	64		Indexed
PaleoContextChildTable	String	50
RegNumber	String	24
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Type	String	64
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Attribute Def		attributeDefs
one-to-many	User Group Scope		collections
many-to-one	Agent		createdByAgent
many-to-one	Data Type		dataType
many-to-one	User Group Scope		division
many-to-one	Geography Tree Def		geographyTreeDef
many-to-one	Geologic Time Period Tree Def		geologicTimePeriodTreeDef
many-to-one	Litho Strat Tree Def		lithoStratTreeDef
many-to-one	Agent		modifiedByAgent
many-to-many	Auto Numbering Scheme		numberingSchemes
one-to-many	Sp Export Schema		spExportSchemas
one-to-many	Sp Locale Container		spLocaleContainers
one-to-one	Taxon Tree Def		taxonTreeDef
one-to-many	Sp Principal		userGroups

Back to top

User Group Scope
Field	Type	Length	Description	Flags
Abbrev	String	64
AltName	String	128
Description	Text	8192
DisciplineType	String	64
IconURI	String	255
Name	String	255		Indexed
RegNumber	String	24
Remarks	Text	8192
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Uri	String	255
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Address		address
many-to-one	Agent		createdByAgent
one-to-many	User Group Scope		disciplines
many-to-one	User Group Scope		institution
one-to-many	Agent		members
many-to-one	Agent		modifiedByAgent
many-to-many	Auto Numbering Scheme		numberingSchemes
one-to-many	Sp Principal		userGroups

Back to top

Exchange In
Field	Type	Length	Description	Flags
Contents	Text	4096
DescriptionOfMaterial	String	120		Indexed
ExchangeDate	Calendar			Indexed
ExchangeInNumber	String	50
Number1	Float	24
Number2	Float	24
QuantityExchanged	Short
Remarks	Text	4096
SrcGeography	String	32
SrcTaxonomy	String	32
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Address Of Record		addressOfRecord
many-to-one	Agent		agentCatalogedBy
many-to-one	Agent		agentReceivedFrom
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		division
one-to-many	Exchange In Prep		exchangeInPreps
many-to-one	Agent		modifiedByAgent

Back to top

Exchange In Prep
Field	Type	Length	Description	Flags
Comments	Text
DescriptionOfMaterial	String	255
Number1	Integer
Quantity	Integer
Text1	Text
Text2	Text
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Exchange In		exchangeIn
many-to-one	Agent		modifiedByAgent
many-to-one	Preparation		preparation

Back to top

Exchange Out
Field	Type	Length	Description	Flags
Contents	Text	4096
DescriptionOfMaterial	String	120		Indexed
ExchangeDate	Calendar			Indexed
ExchangeOutNumber	String	50
Number1	Float	24
Number2	Float	24
QuantityExchanged	Short
Remarks	Text	4096
SrcGeography	String	32
SrcTaxonomy	String	32
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Address Of Record		addressOfRecord
many-to-one	Agent		agentCatalogedBy
many-to-one	Agent		agentSentTo
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		division
one-to-many	Exchange Out Prep		exchangeOutPreps
many-to-one	Agent		modifiedByAgent
one-to-many	Shipment		shipments

Back to top

Exchange Out Prep
Field	Type	Length	Description	Flags
Comments	Text
DescriptionOfMaterial	String	255
Number1	Integer
Quantity	Integer
Text1	Text
Text2	Text
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Exchange Out		exchangeOut
many-to-one	Agent		modifiedByAgent
many-to-one	Preparation		preparation

Back to top

Exsiccata
Field	Type	Length	Description	Flags
Remarks	Text	65535
Schedae	String	255
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Title	String	255		Required
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
one-to-many	Exsiccata Item		exsiccataItems
many-to-one	Agent		modifiedByAgent
many-to-one	Reference Work		referenceWork

Back to top

Exsiccata Item
Field	Type	Length	Description	Flags
Fascicle	String	16
Number	String	16
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Collection Object		collectionObject
many-to-one	Agent		createdByAgent
many-to-one	Exsiccata		exsiccata
many-to-one	Agent		modifiedByAgent

Back to top

Extractor
Field	Type	Length	Description	Flags
OrderNumber	Integer			Required
Remarks	Text	4096
Text1	Text	4096
Text2	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Agent		createdByAgent
many-to-one	DNA Sequence		dnaSequence
many-to-one	Agent		modifiedByAgent

Back to top

Field Notebook
Field	Type	Length	Description	Flags
Description	Text	2048
EndDate	Calendar			Indexed
Storage	String	64
Name	String	32		Indexed
StartDate	Calendar			Indexed
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Field Notebook Attachment		attachments
many-to-one	User Group Scope		collection
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Agent		modifiedByAgent
many-to-one	Agent		ownerAgent
one-to-many	Field Notebook Page Set		pageSets

Back to top

Field Notebook Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	8192
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Field Notebook		fieldNotebook
many-to-one	Agent		modifiedByAgent

Back to top

Field Notebook Page
Field	Type	Length	Description	Flags
Description	String	128
PageNumber	String	32		Required Indexed
ScanDate	Calendar			Indexed
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Field Notebook Page Attachment		attachments
one-to-many	Collection Object		collectionObjects
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Agent		modifiedByAgent
many-to-one	Field Notebook Page Set		pageSet

Back to top

Field Notebook Page Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	8192
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Field Notebook Page		fieldNotebookPage
many-to-one	Agent		modifiedByAgent

Back to top

Field Notebook Page Set
Field	Type	Length	Description	Flags
Description	String	128
EndDate	Calendar			Indexed
Method	String	64
OrderNumber	Short
StartDate	Calendar			Indexed
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Field Notebook Page Set Attachment		attachments
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Field Notebook		fieldNotebook
many-to-one	Agent		modifiedByAgent
one-to-many	Field Notebook Page		pages
many-to-one	Agent		sourceAgent

Back to top

Field Notebook Page Set Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	8192
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Field Notebook Page Set		fieldNotebookPageSet
many-to-one	Agent		modifiedByAgent

Back to top

Funding Agent
Field	Type	Length	Description	Flags
IsPrimary	Boolean			Required
OrderNumber	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Type	String	32
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Collecting Trip		collectingTrip
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		division
many-to-one	Agent		modifiedByAgent

Back to top

Geo Coord Detail
Field	Type	Length	Description	Flags
ErrorPolygon	Text
GeoRefAccuracy	Double
GeoRefAccuracyUnits	String	20
GeoRefCompiledDate	Calendar
GeoRefDetDate	Calendar
GeoRefDetRef	String	100
GeoRefRemarks	Text
GeoRefVerificationStatus	String	50
MaxUncertaintyEst	Bigdecimal
MaxUncertaintyEstUnit	String	8
NamedPlaceExtent	Bigdecimal
NoGeoRefBecause	String	100
OriginalCoordSystem	String	32
Protocol	String	64
Source	String	64
Text1	Text	65535
Text2	Text	65535
Text3	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
UncertaintyPolygon	Text
Validation	String	64
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		geoRefCompiledBy
many-to-one	Agent		geoRefDetBy
many-to-one	Locality		locality
many-to-one	Agent		modifiedByAgent

Back to top

Geography
Field	Type	Length	Description	Flags
Abbrev	String	16
CentroidLat	Bigdecimal
CentroidLon	Bigdecimal
CommonName	String	128
FullName	String	500		Indexed
GeographyCode	String	24
GML	Text	4096
GUID	String	128
HighestChildNodeNumber	Integer
IsAccepted	Boolean			Required
IsCurrent	Boolean
Name	String	128		Required Indexed
NodeNumber	Integer
Number1	Integer
Number2	Integer
RankID	Integer			Required
Remarks	Text	4096
Text1	String	32
Text2	String	32
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
TimestampVersion	Date
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Geography		acceptedChildren
many-to-one	Geography		acceptedGeography
one-to-many	Geography		children
many-to-one	Agent		createdByAgent
many-to-one	Geography Tree Def		definition
many-to-one	Geography Tree Def Item		definitionItem
one-to-many	Locality		localities
many-to-one	Agent		modifiedByAgent
many-to-one	Geography		parent

Back to top

Geography Tree Def
Field	Type	Length	Description	Flags
FullNameDirection	Integer
Name	String	64		Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
one-to-many	User Group Scope		disciplines
many-to-one	Agent		modifiedByAgent
one-to-many	Geography Tree Def Item		treeDefItems
one-to-many	Geography		treeEntries

Back to top

Geography Tree Def Item
Field	Type	Length	Description	Flags
FullNameSeparator	String	32
IsEnforced	Boolean
IsInFullName	Boolean
Name	String	64		Required
RankID	Integer			Required
Remarks	Text	4096
TextAfter	String	64
TextBefore	String	64
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Title	String	64
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Geography Tree Def Item		children
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Geography Tree Def Item		parent
many-to-one	Geography Tree Def		treeDef
one-to-many	Geography		treeEntries

Back to top

Geologic Time Period
Field	Type	Length	Description	Flags
EndPeriod	Float
EndUncertainty	Float
FullName	String	255		Indexed
GUID	String	128		Indexed
HighestChildNodeNumber	Integer
IsAccepted	Boolean			Required
IsBioStrat	Boolean
Name	String	64		Required Indexed
NodeNumber	Integer
RankID	Integer			Required
Remarks	Text	4096
Standard	String	64
StartPeriod	Float
StartUncertainty	Float
Text1	String	128
Text2	String	128
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Geologic Time Period		acceptedChildren
many-to-one	Geologic Time Period		acceptedGeologicTimePeriod
one-to-many	Paleo Context		bioStratsPaleoContext
one-to-many	Geologic Time Period		children
one-to-many	Paleo Context		chronosStratsPaleoContext
many-to-one	Agent		createdByAgent
many-to-one	Geologic Time Period Tree Def		definition
many-to-one	Geologic Time Period Tree Def Item		definitionItem
many-to-one	Agent		modifiedByAgent
many-to-one	Geologic Time Period		parent

Back to top

Geologic Time Period Tree Def
Field	Type	Length	Description	Flags
FullNameDirection	Integer
Name	String	64		Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
one-to-many	User Group Scope		disciplines
many-to-one	Agent		modifiedByAgent
one-to-many	Geologic Time Period Tree Def Item		treeDefItems
one-to-many	Geologic Time Period		treeEntries

Back to top

Geologic Time Period Tree Def Item
Field	Type	Length	Description	Flags
FullNameSeparator	String	32
IsEnforced	Boolean
IsInFullName	Boolean
Name	String	64		Required
RankID	Integer			Required
Remarks	Text	4096
TextAfter	String	64
TextBefore	String	64
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Title	String	64
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Geologic Time Period Tree Def Item		children
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Geologic Time Period Tree Def Item		parent
many-to-one	Geologic Time Period Tree Def		treeDef
one-to-many	Geologic Time Period		treeEntries

Back to top

Gift
Field	Type	Length	Description	Flags
Contents	Text	4096
DateReceived	Calendar
GiftDate	Calendar			Indexed
GiftNumber	String	50		Required Indexed
Integer1	Integer
Integer2	Integer
Integer3	Integer
IsFinancialResponsibility	Boolean
Number1	Float	24
Number2	Float	24
PurposeOfGift	String	64
ReceivedComments	String	255
Remarks	Text	4096
SpecialConditions	Text	2048
SrcGeography	String	500
SrcTaxonomy	String	500
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Address Of Record		addressOfRecord
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	User Group Scope		division
one-to-many	Gift Agent		giftAgents
one-to-many	Gift Attachment		giftAttachments
one-to-many	Gift Preparation		giftPreparations
many-to-one	Agent		modifiedByAgent
one-to-many	Shipment		shipments

Back to top

Gift Agent
Field	Type	Length	Description	Flags
Remarks	Text	4096
Role	String	50		Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Gift		gift
many-to-one	Agent		modifiedByAgent

Back to top

Gift Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Gift		gift
many-to-one	Agent		modifiedByAgent

Back to top

Gift Preparation
Field	Type	Length	Description	Flags
DescriptionOfMaterial	String	255
InComments	Text	1024
OutComments	Text	1024
Quantity	Integer
ReceivedComments	Text	1024
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Gift		gift
many-to-one	Agent		modifiedByAgent
many-to-one	Preparation		preparation

Back to top

Group Person
Field	Type	Length	Description	Flags
OrderNumber	Short			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		division
many-to-one	Agent		group
many-to-one	Agent		member
many-to-one	Agent		modifiedByAgent

Back to top

Info Request
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Email	String	50
Firstname	String	50
InfoReqNumber	String	32
Institution	String	127
Lastname	String	50
Remarks	Text	4096
ReplyDate	Calendar
RequestDate	Calendar
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
one-to-many	Record Set		recordSets

Back to top

User Group Scope
Field	Type	Length	Description	Flags
AltName	String	128
Code	String	64
Copyright	Text	8192
CurrentManagedRelVersion	String	8
CurrentManagedSchemaVersion	String	8
Description	Text	8192
Disclaimer	Text	8192
GUID	String	128		Indexed
HasBeenAsked	Boolean
IconURI	String	255
Ipr	Text	8192
IsAccessionsGlobal	Boolean			Required
IsAnonymous	Boolean
IsReleaseManagedGlobally	Boolean
IsSecurityOn	Boolean			Required
IsServerBased	Boolean			Required
IsSharingLocalities	Boolean			Required
IsSingleGeographyTree	Boolean			Required
License	Text	2048
LsidAuthority	String	64
MinimumPwdLength	Byte
Name	String	255		Indexed
RegNumber	String	24
Remarks	Text	8192
TermsOfUse	Text	8192
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Uri	String	255
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Address		address
one-to-many	Agent		contentContacts
many-to-one	Agent		createdByAgent
one-to-many	User Group Scope		divisions
many-to-one	Agent		modifiedByAgent
many-to-one	Storage Tree Def		storageTreeDef
one-to-many	Agent		technicalContacts
one-to-many	Sp Principal		userGroups

Back to top

Institution Network
Field	Type	Length	Description	Flags
AltName	String	128
Code	String	64
Copyright	Text	8192
Description	Text	8192
Disclaimer	Text	8192
IconURI	String	255
Ipr	Text	8192
License	Text	2048
Name	String	255		Indexed
Remarks	Text	8192
TermsOfUse	Text	8192
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Uri	String	255
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Address		address
one-to-many	User Group Scope		collections
one-to-many	Agent		contacts
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Journal
Field	Type	Length	Description	Flags
GUID	String	128		Indexed
ISSN	String	16
JournalAbbreviation	String	50
JournalName	String	255		Indexed
Remarks	Text	4096
Text1	String	32
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		institution
many-to-one	Agent		modifiedByAgent
one-to-many	Reference Work		referenceWorks

Back to top

Lat Lon Polygon
Field	Type	Length	Description	Flags
Description	Text	4096
IsPolyline	Boolean			Required
Name	String	64		Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Locality		locality
many-to-one	Agent		modifiedByAgent
one-to-many	Lat Lon Polygon Pnt		points
many-to-one	Sp Visual Query		visualQuery

Back to top

Lat Lon Polygon Pnt
Field	Type	Length	Description	Flags
Elevation	Integer
Latitude	Bigdecimal			Required
Longitude	Bigdecimal			Required
Ordinal	Integer			Required
Relationships
Type	Target Table		Field name
many-to-one	Lat Lon Polygon		latLonPolygon

Back to top

Litho Strat
Field	Type	Length	Description	Flags
FullName	String	255		Indexed
GUID	String	128		Indexed
HighestChildNodeNumber	Integer
IsAccepted	Boolean			Required
Name	String	64		Required Indexed
NodeNumber	Integer
Number1	Double
Number2	Double
RankID	Integer			Required
Remarks	Text	4096
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
one-to-many	Litho Strat		acceptedChildren
many-to-one	Litho Strat		acceptedLithoStrat
one-to-many	Litho Strat		children
many-to-one	Agent		createdByAgent
many-to-one	Litho Strat Tree Def		definition
many-to-one	Litho Strat Tree Def Item		definitionItem
many-to-one	Agent		modifiedByAgent
one-to-many	Paleo Context		paleoContexts
many-to-one	Litho Strat		parent

Back to top

Litho Strat Tree Def
Field	Type	Length	Description	Flags
FullNameDirection	Integer
Name	String	64		Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
one-to-many	User Group Scope		disciplines
many-to-one	Agent		modifiedByAgent
one-to-many	Litho Strat Tree Def Item		treeDefItems
one-to-many	Litho Strat		treeEntries

Back to top

Litho Strat Tree Def Item
Field	Type	Length	Description	Flags
FullNameSeparator	String	32
IsEnforced	Boolean
IsInFullName	Boolean
Name	String	64		Required
RankID	Integer			Required
Remarks	Text	4096
TextAfter	String	64
TextBefore	String	64
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Title	String	64
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Litho Strat Tree Def Item		children
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Litho Strat Tree Def Item		parent
many-to-one	Litho Strat Tree Def		treeDef
one-to-many	Litho Strat		treeEntries

Back to top

Loan
Field	Type	Length	Description	Flags
Contents	Text	4096
CurrentDueDate	Calendar			Indexed
DateClosed	Calendar
DateReceived	Calendar
Integer1	Integer
Integer2	Integer
Integer3	Integer
IsClosed	Boolean
IsFinancialResponsibility	Boolean
LoanDate	Calendar			Indexed
LoanNumber	String	50		Required Indexed
Number1	Float	24
Number2	Float	24
OriginalDueDate	Calendar
OverdueNotiSetDate	Calendar
PurposeOfLoan	String	64
ReceivedComments	String	255
Remarks	Text	4096
SpecialConditions	Text	2048
SrcGeography	String	500
SrcTaxonomy	String	500
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Address Of Record		addressOfRecord
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	User Group Scope		division
one-to-many	Loan Agent		loanAgents
one-to-many	Loan Attachment		loanAttachments
one-to-many	Loan Preparation		loanPreparations
many-to-one	Agent		modifiedByAgent
one-to-many	Shipment		shipments

Back to top

Loan Agent
Field	Type	Length	Description	Flags
Remarks	Text	4096
Role	String	50		Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Loan		loan
many-to-one	Agent		modifiedByAgent

Back to top

Loan Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Loan		loan
many-to-one	Agent		modifiedByAgent

Back to top

Loan Preparation
Field	Type	Length	Description	Flags
DescriptionOfMaterial	String	255
InComments	Text	1024
IsResolved	Boolean			Required
OutComments	Text	1024
Quantity	Integer
QuantityResolved	Integer
QuantityReturned	Integer
ReceivedComments	Text	1024
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Loan		loan
one-to-many	Loan Return Preparation		loanReturnPreparations
many-to-one	Agent		modifiedByAgent
many-to-one	Preparation		preparation

Back to top

Loan Return Preparation
Field	Type	Length	Description	Flags
QuantityResolved	Integer
QuantityReturned	Integer
Remarks	Text	4096
ReturnedDate	Calendar			Indexed
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Deaccession Preparation		deaccessionPreparation
many-to-one	User Group Scope		discipline
many-to-one	Loan Preparation		loanPreparation
many-to-one	Agent		modifiedByAgent
many-to-one	Agent		receivedBy

Back to top

Locality
Field	Type	Length	Description	Flags
Datum	String	50
ElevationAccuracy	Double
ElevationMethod	String	50
GML	Text
GUID	String	128
Lat1Text	String	50
Lat2Text	String	50
LatLongAccuracy	Double
LatLongMethod	String	50
LatLongType	String	50
Latitude1	Bigdecimal
Latitude2	Bigdecimal
LocalityName	String	255		Required Indexed
Long1Text	String	50
Long2Text	String	50
Longitude1	Bigdecimal
Longitude2	Bigdecimal
MaxElevation	Double
MinElevation	Double
NamedPlace	String	255		Indexed
OriginalElevationUnit	String	50
OriginalLatLongUnit	Integer
RelationToNamedPlace	String	120		Indexed
Remarks	Text	4096
SGRStatus	Byte
ShortName	String	32
SrcLatLongUnit	Byte			Required
Text1	Text	65535
Text2	Text	65535
Text3	Text	65535
Text4	Text	65535
Text5	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
VerbatimElevation	String	50
VerbatimLatitude	String	50
VerbatimLongitude	String	50
Version	Integer
Visibility	Byte
YesNo1	Boolean
YesNo2	Boolean
YesNo3	Boolean
YesNo4	Boolean
YesNo5	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
zero-to-one	Geo Coord Detail		geoCoordDetails
many-to-one	Geography		geography
one-to-many	Lat Lon Polygon		latLonpolygons
one-to-many	Locality Attachment		localityAttachments
one-to-many	Locality Citation		localityCitations
zero-to-one	Locality Detail		localityDetails
one-to-many	Locality Name Alias		localityNameAliass
many-to-one	Agent		modifiedByAgent
many-to-one	Paleo Context		paleoContext
many-to-one	Specify User		visibilitySetBy

Back to top

Locality Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Locality		locality
many-to-one	Agent		modifiedByAgent

Back to top

Locality Citation
Field	Type	Length	Description	Flags
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Locality		locality
many-to-one	Agent		modifiedByAgent
many-to-one	Reference Work		referenceWork

Back to top

Locality Detail
Field	Type	Length	Description	Flags
BaseMeridian	String	50
Drainage	String	64
EndDepth	Double
EndDepthUnit	String	23
EndDepthVerbatim	String	32
GML	Text
HucCode	String	16
Island	String	64
IslandGroup	String	64
MgrsZone	String	4
NationalParkName	String	64
Number1	Double
Number2	Double
Number3	Float
Number4	Float
Number5	Float
PaleoLat	String	32
PaleoLng	String	32
RangeDesc	String	50
RangeDirection	String	50
Section	String	50
SectionPart	String	50
StartDepth	Double
StartDepthUnit	String	23
StartDepthVerbatim	String	32
Text1	Text	65535
Text2	Text	65535
Text3	Text	65535
Text4	Text	65535
Text5	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Township	String	50
TownshipDirection	String	50
UtmDatum	String	32
UtmEasting	Bigdecimal
UtmFalseEasting	Integer
UtmFalseNorthing	Integer
UtmNorthing	Bigdecimal
UtmOrigLatitude	Bigdecimal
UtmOrigLongitude	Bigdecimal
UtmScale	Bigdecimal
UtmZone	Short
Version	Integer
WaterBody	String	64
YesNo1	Boolean
YesNo2	Boolean
YesNo3	Boolean
YesNo4	Boolean
YesNo5	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Locality		locality
many-to-one	Agent		modifiedByAgent

Back to top

Locality Name Alias
Field	Type	Length	Description	Flags
Name	String	255		Required Indexed
Source	String	64		Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Locality		locality
many-to-one	Agent		modifiedByAgent

Back to top

Material Sample
Field	Type	Length	Description	Flags
GGBNAbsorbanceRatio260_230	Float
GGBNAbsorbanceRatio260_280	Float
GGBNRAbsorbanceRatioMethod	String	64
GGBNConcentration	Float
GGBNConcentrationUnit	String	64
GGBNMaterialSampleType	String	64
GGBNMedium	String	64
GGBNPurificationMethod	String	64
GGBNQuality	String	64
GGBNQualityCheckDate	Calendar
GGBNQualityRemarks	Text	4096
GGBNSampleDesignation	String	128		Indexed
GGBNSampleSize	Float
GGBNVolume	Float
GGBNVolumeUnit	String	64
GGBNWeight	Float
GGBNWeightMethod	String	64
GGBNWeightUnit	String	64
CollectionMemberID	Integer			Required
ExtractionDate	Calendar
GUID	String	128
Integer1	Integer
Integer2	Integer
Number1	Float
Number2	Float
Remarks	Text	4096
ReservedInteger3	Integer
ReservedInteger4	Integer
ReservedNumber3	Float
ReservedNumber4	Float
ReservedText3	Text	4096
ReservedText4	Text	4096
SRABioProjectID	String	64
SRABioSampleID	String	64
SRAProjectID	String	64
SRASampleID	String	64
Text1	Text	4096
Text2	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
one-to-many	DNA Sequence		dnaSequences
many-to-one	Agent		extractor
many-to-one	Agent		modifiedByAgent
many-to-one	Preparation		preparation

Back to top

Morph Bank View
Field	Type	Length	Description	Flags
DevelopmentState	String	128
Form	String	128
ImagingPreparationTechnique	String	128
ImagingTechnique	String	128
MorphBankExternalViewID	Integer
Sex	String	32
SpecimenPart	String	128
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
ViewAngle	String	128
ViewName	String	128
Relationships
Type	Target Table		Field name
one-to-many	Attachment Image Attribute		attachmentImageAttributes
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Other Identifier
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Identifier	String	64		Required
Institution	String	64
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Collection Object		collectionObject
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Paleo Context
Field	Type	Length	Description	Flags
Number1	Double
Number2	Double
Number3	Double
Number4	Double
Number5	Double
PaleoContextName	String	80		Indexed
Remarks	Text	4096
Text1	String	64
Text2	String	64
Text3	String	500
Text4	String	500
Text5	String	500
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
YesNo3	Boolean
YesNo4	Boolean
YesNo5	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Geologic Time Period		bioStrat
many-to-one	Geologic Time Period		chronosStrat
many-to-one	Geologic Time Period		chronosStratEnd
one-to-many	Collecting Event		collectingEvents
one-to-many	Collection Object		collectionObjects
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Litho Strat		lithoStrat
one-to-many	Locality		localities
many-to-one	Agent		modifiedByAgent

Back to top

Pcr Person
Field	Type	Length	Description	Flags
OrderNumber	Integer			Required
Remarks	Text	4096
Text1	Text	4096
Text2	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-one	Agent		createdByAgent
many-to-one	DNA Sequence		dnaSequence
many-to-one	Agent		modifiedByAgent

Back to top

Permit
Field	Type	Length	Description	Flags
Copyright	String	256
EndDate	Calendar
IsAvailable	Boolean
IsRequired	Boolean
IssuedDate	Calendar			Indexed
Number1	Float	24
Number2	Float	24
PermitNumber	String	50		Required Indexed
PermitText	Text	4096
Remarks	Text	4096
RenewalDate	Calendar
ReservedInteger1	Integer
ReservedInteger2	Integer
ReservedText3	String	128
ReservedText4	String	128
StartDate	Calendar
Status	String	64
StatusQualifier	String	128
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Type	String	50
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
one-to-many	Accession Authorization		accessionAuthorizations
one-to-many	Collecting Event Authorization		collectingEventAuthorizations
one-to-many	Collecting Trip Authorization		collectingTripAuthorizations
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		institution
many-to-one	Agent		issuedBy
many-to-one	Agent		issuedTo
many-to-one	Agent		modifiedByAgent
one-to-many	Permit Attachment		permitAttachments

Back to top

Permit Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Permit		permit

Back to top

Pick List
Field	Type	Length	Description	Flags
FieldName	String	64
FilterFieldName	String	32
FilterValue	String	32
Formatter	String	64
IsSystem	Boolean			Required
Name	String	64		Required Indexed
ReadOnly	Boolean			Required
SizeLimit	Integer	10
SortType	Byte
TableName	String	64
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Type	Byte			Required
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	User Group Scope		collection
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
one-to-many	Pick List Item		pickListItems

Back to top

Pick List Item
Field	Type	Length	Description	Flags
Ordinal	Integer
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Title	String	128		Required
Value	String	128
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Pick List		pickList

Back to top

Prep Type
Field	Type	Length	Description	Flags
IsLoanable	Boolean			Required
Name	String	64		Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Attribute Def		attributeDefs
many-to-one	User Group Scope		collection
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Preparation
Field	Type	Length	Description	Flags
BarCode	String	256		Indexed
CollectionMemberID	Integer			Required Indexed
CountAmt	Integer
Date1	Calendar
Date1Precision	Byte
Date2	Calendar
Date2Precision	Byte
Date3	Calendar
Date3Precision	Byte
Date4	Calendar
Date4Precision	Byte
Description	String	255
GUID	String	128		Indexed
Integer1	Integer
Integer2	Integer
Number1	Float
Number2	Float
PreparedDate	Calendar
PreparedDatePrecision	Byte
Remarks	Text	4096
ReservedInteger3	Integer
ReservedInteger4	Integer
SampleNumber	String	32		Indexed
Status	String	32
StorageLocation	String	50
Text1	Text	65535
Text2	Text	65535
Text3	Text	65535
Text4	Text	65535
Text5	Text	65535
Text6	Text	65535
Text7	Text	65535
Text8	Text	65535
Text9	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
YesNo3	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Storage		alternateStorage
many-to-one	Collection Object		collectionObject
one-to-many	Conserv Description		conservDescriptions
many-to-one	Agent		createdByAgent
one-to-many	Deaccession Preparation		deaccessionPreparations
one-to-many	Exchange In Prep		exchangeInPreps
one-to-many	Exchange Out Prep		exchangeOutPreps
one-to-many	Gift Preparation		giftPreparations
one-to-many	Loan Preparation		loanPreparations
one-to-many	Material Sample		materialSamples
many-to-one	Agent		modifiedByAgent
many-to-one	Prep Type		prepType
one-to-many	Preparation Attachment		preparationAttachments
many-to-one	Preparation Attribute		preparationAttribute
one-to-many	Attr		preparationAttrs
one-to-many	Preparation Property		preparationProperties
many-to-one	Agent		preparedByAgent
many-to-one	Storage		storage

Back to top

Preparation Attachment
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Preparation		preparation

Back to top

Attr
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
DoubleValue	Double
StrValue	String	255
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Attribute Def		definition
many-to-one	Agent		modifiedByAgent
many-to-one	Preparation		preparation

Back to top

Preparation Attribute
Field	Type	Length	Description	Flags
AttrDate	Calendar	10
CollectionMemberID	Integer			Required Indexed
Number1	Float
Number2	Float
Number3	Float
Number4	Integer
Number5	Integer
Number6	Integer
Number7	Integer
Number8	Integer
Number9	Short
Remarks	Text	4096
Text1	Text	65535
Text10	Text	65535
Text11	String	50
Text12	String	50
Text13	String	50
Text14	String	50
Text15	String	50
Text16	String	50
Text17	String	50
Text18	String	50
Text19	String	50
Text2	Text	65535
Text20	String	50
Text21	String	50
Text22	String	50
Text23	String	50
Text24	String	50
Text25	String	50
Text26	String	50
Text3	String	50
Text4	String	50
Text5	String	50
Text6	String	50
Text7	String	50
Text8	String	50
Text9	String	50
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
YesNo3	Boolean
YesNo4	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
one-to-many	Preparation		preparations

Back to top

Preparation Property
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Date1	Calendar
Date10	Calendar
Date11	Calendar
Date12	Calendar
Date13	Calendar
Date14	Calendar
Date15	Calendar
Date16	Calendar
Date17	Calendar
Date18	Calendar
Date19	Calendar
Date2	Calendar
Date20	Calendar
Date3	Calendar
Date4	Calendar
Date5	Calendar
Date6	Calendar
Date7	Calendar
Date8	Calendar
Date9	Calendar
GUID	String	128
Integer1	Short
Integer10	Short
Integer11	Short
Integer12	Short
Integer13	Short
Integer14	Short
Integer15	Short
Integer16	Short
Integer17	Short
Integer18	Short
Integer19	Short
Integer2	Short
Integer20	Short
Integer21	Integer
Integer22	Integer
Integer23	Integer
Integer24	Integer
Integer25	Integer
Integer26	Integer
Integer27	Integer
Integer28	Integer
Integer29	Integer
Integer3	Short
Integer30	Integer
Integer4	Short
Integer5	Short
Integer6	Short
Integer7	Short
Integer8	Short
Integer9	Short
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	Double
Number22	Double
Number23	Double
Number24	Double
Number25	Double
Number26	Double
Number27	Double
Number28	Double
Number29	Double
Number3	Float
Number30	Double
Number4	Float
Number5	Float
Number6	Float
Number7	Float
Number8	Float
Number9	Float
Remarks	Text	4096
Text1	String	50
Text10	String	50
Text11	String	50
Text12	String	50
Text13	String	50
Text14	String	50
Text15	String	50
Text16	String	100
Text17	String	100
Text18	String	100
Text19	String	100
Text2	String	50
Text20	String	100
Text21	String	100
Text22	String	100
Text23	String	100
Text24	String	100
Text25	String	100
Text26	String	100
Text27	String	100
Text28	String	100
Text29	String	100
Text3	String	50
Text30	String	100
Text31	Text	65535
Text32	Text	65535
Text33	Text	65535
Text34	Text	65535
Text35	Text	65535
Text36	Text	65535
Text37	Text	65535
Text38	Text	65535
Text39	Text	65535
Text4	String	50
Text40	Text	65535
Text5	String	50
Text6	String	50
Text7	String	50
Text8	String	50
Text9	String	50
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo10	Boolean
YesNo11	Boolean
YesNo12	Boolean
YesNo13	Boolean
YesNo14	Boolean
YesNo15	Boolean
YesNo16	Boolean
YesNo17	Boolean
YesNo18	Boolean
YesNo19	Boolean
YesNo2	Boolean
YesNo20	Boolean
YesNo3	Boolean
YesNo4	Boolean
YesNo5	Boolean
YesNo6	Boolean
YesNo7	Boolean
YesNo8	Boolean
YesNo9	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent1
many-to-one	Agent		agent10
many-to-one	Agent		agent11
many-to-one	Agent		agent12
many-to-one	Agent		agent13
many-to-one	Agent		agent14
many-to-one	Agent		agent15
many-to-one	Agent		agent16
many-to-one	Agent		agent17
many-to-one	Agent		agent18
many-to-one	Agent		agent19
many-to-one	Agent		agent2
many-to-one	Agent		agent20
many-to-one	Agent		agent3
many-to-one	Agent		agent4
many-to-one	Agent		agent5
many-to-one	Agent		agent6
many-to-one	Agent		agent7
many-to-one	Agent		agent8
many-to-one	Agent		agent9
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Preparation		preparation

Back to top

Project
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required
EndDate	Calendar
GrantAgency	String	64
GrantNumber	String	64
Number1	Float	24
Number2	Float	24
ProjectDescription	String	255
ProjectName	String	128		Required Indexed
ProjectNumber	String	64		Indexed
Remarks	Text	4096
StartDate	Calendar
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
URL	String	1024
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent
many-to-many	Collection Object		collectionObjects
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Record Set
Field	Type	Length	Description	Flags
AllPermissionLevel	Integer
CollectionMemberID	Integer			Required
TableID	Integer			Required
GroupPermissionLevel	Integer
Name	String	64		Required
OwnerPermissionLevel	Integer
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Type	Byte			Required
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Sp Principal		group
many-to-one	Info Request		infoRequest
many-to-one	Agent		modifiedByAgent
one-to-many	Record Set Item		recordSetItems
many-to-one	Specify User		specifyUser

Back to top

Record Set Item
Field	Type	Length	Description	Flags
OrderNumber	Integer
RecordId	Integer			Required
Relationships
Type	Target Table		Field name
many-to-one	Record Set		recordSet

Back to top

Reference Work
Field	Type	Length	Description	Flags
Doi	Text	65535
GUID	String	128		Indexed
IsPublished	Boolean
ISBN	String	16		Indexed
LibraryNumber	String	50
Number1	Float
Number2	Float
Pages	String	50
PlaceOfPublication	String	50
Publisher	String	250		Indexed
ReferenceWorkType	Byte			Required
Remarks	Text	4096
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Title	String	255		Required Indexed
Uri	Text	65535
URL	String	1024
Version	Integer
Volume	String	25
WorkDate	String	25
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
one-to-many	Author		authors
one-to-many	Collection Object Citation		collectionObjectCitations
many-to-one	Reference Work		containedRFParent
one-to-many	Reference Work		containedReferenceWorks
many-to-one	Agent		createdByAgent
one-to-many	Determination Citation		determinationCitations
one-to-many	Exsiccata		exsiccatae
many-to-one	User Group Scope		institution
many-to-one	Journal		journal
one-to-many	Locality Citation		localityCitations
many-to-one	Agent		modifiedByAgent
one-to-many	Reference Work Attachment		referenceWorkAttachments
one-to-many	Taxon Citation		taxonCitations

Back to top

Reference Work Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Reference Work		referenceWork

Back to top

Repository Agreement
Field	Type	Length	Description	Flags
DateReceived	Calendar
EndDate	Calendar
Number1	Float
Number2	Float
Remarks	Text	4096
RepositoryAgreementNumber	String	60		Required Indexed
StartDate	Calendar			Indexed
Status	String	32
Text1	String	255
Text2	String	255
Text3	String	255
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
one-to-many	Accession		accessions
many-to-one	Address Of Record		addressOfRecord
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		division
many-to-one	Agent		modifiedByAgent
many-to-one	Agent		originator
one-to-many	Accession Agent		repositoryAgreementAgents
one-to-many	Repository Agreement Attachment		repositoryAgreementAttachments
one-to-many	Accession Authorization		repositoryAgreementAuthorizations

Back to top

Repository Agreement Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Repository Agreement		repositoryAgreement

Back to top

Shipment
Field	Type	Length	Description	Flags
InsuredForAmount	String	50
Number1	Float	24
Number2	Float	24
NumberOfPackages	Short
Remarks	Text	4096
ShipmentDate	Calendar			Indexed
ShipmentMethod	String	50		Indexed
ShipmentNumber	String	50		Required Indexed
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Weight	String	50
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Borrow		borrow
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Exchange Out		exchangeOut
many-to-one	Gift		gift
many-to-one	Loan		loan
many-to-one	Agent		modifiedByAgent
many-to-one	Agent		shippedBy
many-to-one	Agent		shippedTo
many-to-one	Agent		shipper

Back to top

Sp App Resource
Field	Type	Length	Description	Flags
AllPermissionLevel	Integer
Description	String	255
GroupPermissionLevel	Integer
Level	Short			Required
MetaData	String	255
MimeType	String	255		Indexed
Name	String	64		Required Indexed
OwnerPermissionLevel	Integer
TimestampCreated	Timestamp			Required
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Sp Principal		group
many-to-one	Agent		modifiedByAgent
one-to-many	Sp App Resource Data		spAppResourceDatas
many-to-one	Sp App Resource Dir		spAppResourceDir
one-to-many	Sp Report		spReports
many-to-one	Specify User		specifyUser

Back to top

Sp App Resource Data
Field	Type	Length	Description	Flags
data	Text	16000000
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Sp App Resource		spAppResource
many-to-one	Sp View Set Obj		spViewSetObj

Back to top

Sp App Resource Dir
Field	Type	Length	Description	Flags
DisciplineType	String	64		Indexed
IsPersonal	Boolean			Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
UserType	String	64
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	User Group Scope		collection
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Agent		modifiedByAgent
one-to-many	Sp App Resource		spPersistedAppResources
one-to-many	Sp View Set Obj		spPersistedViewSets
many-to-one	Specify User		specifyUser

Back to top

Sp Audit Log
Field	Type	Length	Description	Flags
Action	Byte			Required
ParentRecordId	Integer
ParentTableNum	Short
RecordId	Integer
RecordVersion	Integer			Required
TableNum	Short			Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
one-to-many	Sp Audit Log Field		fields
many-to-one	Agent		modifiedByAgent

Back to top

Sp Audit Log Field
Field	Type	Length	Description	Flags
FieldName	String	128		Required
NewValue	Text	65535
OldValue	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Sp Audit Log		spAuditLog

Back to top

Sp Export Schema
Field	Type	Length	Description	Flags
Description	String	255
SchemaName	String	80
SchemaVersion	String	80
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Agent		modifiedByAgent
one-to-many	Sp Export Schema Item		spExportSchemaItems
many-to-many	Sp Export Schema Mapping		spExportSchemaMappings

Back to top

Sp Export Schema Item
Field	Type	Length	Description	Flags
DataType	String	32
Description	String	255
FieldName	String	64
Formatter	String	32
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Sp Export Schema		spExportSchema
many-to-one	Sp Locale Container Item		spLocaleContainerItem

Back to top

Sp Export Schema Item Mapping
Field	Type	Length	Description	Flags
ExportedFieldName	String	64
Remarks	String	255
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Sp Export Schema Item		exportSchemaItem
many-to-one	Sp Export Schema Mapping		exportSchemaMapping
many-to-one	Agent		modifiedByAgent
many-to-one	Sp Query Field		queryField

Back to top

Sp Export Schema Mapping
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Description	String	255
MappingName	String	50
TimestampCreated	Timestamp			Required
TimeStampExported	Timestamp
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
one-to-many	Sp Export Schema Item Mapping		mappings
many-to-one	Agent		modifiedByAgent
many-to-many	Sp Export Schema		spExportSchemas
one-to-many	Sp Symbiota Instance		symbiotaInstances

Back to top

Sp Field Value Default
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
FieldName	String	32
IdValue	Integer
StrValue	String	64
TableName	String	32
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Sp Locale Container
Field	Type	Length	Description	Flags
Aggregator	String	64
DefaultUI	String	64
Format	String	64
IsHidden	Boolean			Required
IsSystem	Boolean			Required
IsUIFormatter	Boolean
Name	String	64		Required Indexed
PickListName	String	64
SchemaType	Byte			Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Type	String	32
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
one-to-many	Sp Locale Item Str		descs
many-to-one	User Group Scope		discipline
one-to-many	Sp Locale Container Item		items
many-to-one	Agent		modifiedByAgent
one-to-many	Sp Locale Item Str		names

Back to top

Sp Locale Container Item
Field	Type	Length	Description	Flags
Format	String	64
IsHidden	Boolean			Required
IsRequired	Boolean	32
IsSystem	Boolean			Required
IsUIFormatter	Boolean
Name	String	64		Required Indexed
PickListName	String	64
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Type	String	32
Version	Integer
WebLinkName	String	32
Relationships
Type	Target Table		Field name
many-to-one	Sp Locale Container		container
many-to-one	Agent		createdByAgent
one-to-many	Sp Locale Item Str		descs
many-to-one	Agent		modifiedByAgent
one-to-many	Sp Locale Item Str		names
one-to-many	Sp Export Schema Item		spExportSchemaItems

Back to top

Sp Locale Item Str
Field	Type	Length	Description	Flags
Country	String	2		Indexed
Language	String	2		Required Indexed
Text	String	255		Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Variant	String	2
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Sp Locale Container		containerDesc
many-to-one	Sp Locale Container		containerName
many-to-one	Agent		createdByAgent
many-to-one	Sp Locale Container Item		itemDesc
many-to-one	Sp Locale Container Item		itemName
many-to-one	Agent		modifiedByAgent

Back to top

Sp Permission
Field	Type	Length	Description	Flags
Actions	String	256
Name	String	64
PermissionClass	String	256		Required
TargetId	Integer
Relationships
Type	Target Table		Field name
many-to-many	Sp Principal		principals

Back to top

Sp Principal
Field	Type	Length	Description	Flags
GroupSubClass	String	255		Required
groupType	String	32
Name	String	64		Required
Priority	Byte			Required
Remarks	Text
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-many	Sp Permission		permissions
many-to-one	undefined		scope
many-to-many	Specify User		specifyUsers

Back to top

Sp Query
Field	Type	Length	Description	Flags
ContextName	String	64		Required
ContextTableId	Short			Required
CountOnly	Boolean
FormatAuditRecIds	Boolean
IsFavorite	Boolean
Name	String	64		Required Indexed
Ordinal	Short
Remarks	Text	4096
SearchSynonymy	Boolean
SelectDistinct	Boolean
Smushed	Boolean
SqlStr	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
one-to-many	Sp Query Field		fields
many-to-one	Agent		modifiedByAgent
one-to-many	Sp Report		reports
many-to-one	Specify User		specifyUser

Back to top

Sp Query Field
Field	Type	Length	Description	Flags
AllowNulls	Boolean
AlwaysFilter	Boolean
ColumnAlias	String	64
ContextTableIdent	Integer
EndValue	String	1000
FieldName	String	32		Required
FormatName	String	64
IsDisplay	Boolean			Required
IsNot	Boolean			Required
IsPrompt	Boolean
IsRelFld	Boolean
OperEnd	Byte
OperStart	Byte			Required
Position	Short			Required
SortType	Byte			Required
StartValue	String	1000		Required
StringId	String	500		Required
TableList	String	500		Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
one-to-many	Sp Export Schema Item Mapping		mappings
many-to-one	Agent		modifiedByAgent
many-to-one	Sp Query		query

Back to top

Sp Report
Field	Type	Length	Description	Flags
Name	String	64		Required Indexed
Remarks	Text	4096
RepeatCount	Integer
RepeatField	String	255
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Sp App Resource		appResource
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Sp Query		query
many-to-one	Specify User		specifyUser
one-to-one	Workbench Template		workbenchTemplate

Back to top

Sp Symbiota Instance
Field	Type	Length	Description	Flags
CollectionMemberID	Integer			Required Indexed
Description	String	256
InstanceName	String	256
LastCacheBuild	Calendar
LastPull	Calendar
LastPush	Calendar
Remarks	Text
SymbiotaKey	String	128
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Sp Export Schema Mapping		schemaMapping

Back to top

Task Semaphore
Field	Type	Length	Description	Flags
Context	String	32
IsLocked	Boolean
LockedTime	Timestamp
MachineName	String	64
Scope	Byte
TaskName	String	32
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
UsageCount	Integer
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	User Group Scope		collection
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		discipline
many-to-one	Agent		modifiedByAgent
many-to-one	Specify User		owner

Back to top

Sp Version
Field	Type	Length	Description	Flags
AppName	String	32
AppVersion	String	16
DbClosedBy	String	32
IsDBClosed	Boolean
SchemaVersion	String	16
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
WorkbenchSchemaVersion	String	16
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Sp View Set Obj
Field	Type	Length	Description	Flags
Description	String	255
FileName	String	255
Level	Short			Required
MetaData	String	255
Name	String	64		Required Indexed
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
one-to-many	Sp App Resource Data		spAppResourceDatas
many-to-one	Sp App Resource Dir		spAppResourceDir

Back to top

Sp Visual Query
Field	Type	Length	Description	Flags
Description	Text	4096
Name	String	64		Required Indexed
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
one-to-many	Lat Lon Polygon		polygons
many-to-one	Specify User		specifyUser

Back to top

Specify User
Field	Type	Length	Description	Flags
AccumMinLoggedIn	Long
EMail	String	64
IsLoggedIn	Boolean			Required
IsLoggedInReport	Boolean			Required
LoginCollectionName	String	64
LoginDisciplineName	String	64
LoginOutTime	Timestamp
Name	String	64		Required Unique
Password	String	255		Required
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
UserType	String	32
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Agent		agents
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
one-to-many	Sp App Resource Dir		spAppResourceDirs
one-to-many	Sp App Resource		spAppResources
many-to-many	Sp Principal		spPrincipals
one-to-many	Sp Query		spQuerys
one-to-many	Task Semaphore		taskSemaphores
one-to-many	Workbench Template		workbenchTemplates
one-to-many	Workbench		workbenches

Back to top

Storage
Field	Type	Length	Description	Flags
Abbrev	String	16
FullName	String	255		Indexed
HighestChildNodeNumber	Integer
IsAccepted	Boolean			Required
Name	String	64		Required Indexed
NodeNumber	Integer
Number1	Integer
Number2	Integer
RankID	Integer			Required
Remarks	Text	4096
Text1	String	32
Text2	String	32
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
TimestampVersion	Date
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Storage		acceptedChildren
many-to-one	Storage		acceptedStorage
one-to-many	Preparation		alternateStoragePreparations
one-to-many	Storage		children
one-to-many	Container		containers
many-to-one	Agent		createdByAgent
many-to-one	Storage Tree Def		definition
many-to-one	Storage Tree Def Item		definitionItem
many-to-one	Agent		modifiedByAgent
many-to-one	Storage		parent
one-to-many	Preparation		preparations
one-to-many	Storage Attachment		storageAttachments

Back to top

Storage Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Storage		storage

Back to top

Storage Tree Def
Field	Type	Length	Description	Flags
FullNameDirection	Integer
Name	String	64		Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
one-to-many	User Group Scope		institutions
many-to-one	Agent		modifiedByAgent
one-to-many	Storage Tree Def Item		treeDefItems
one-to-many	Storage		treeEntries

Back to top

Storage Tree Def Item
Field	Type	Length	Description	Flags
FullNameSeparator	String	32
IsEnforced	Boolean
IsInFullName	Boolean
Name	String	64		Required
RankID	Integer			Required
Remarks	Text	4096
TextAfter	String	64
TextBefore	String	64
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Title	String	64
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Storage Tree Def Item		children
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Storage Tree Def Item		parent
many-to-one	Storage Tree Def		treeDef
one-to-many	Storage		treeEntries

Back to top

Taxon
Field	Type	Length	Description	Flags
Author	String	128
CitesStatus	String	32
COLStatus	String	32
CommonName	String	128		Indexed
CultivarName	String	32
EnvironmentalProtectionStatus	String	64		Indexed
EsaStatus	String	64
FullName	String	255		Indexed
GroupNumber	String	20
GUID	String	128		Indexed
HighestChildNodeNumber	Integer
Integer1	Long
Integer2	Long
Integer3	Long
Integer4	Integer
Integer5	Integer
IsAccepted	Boolean			Required
IsHybrid	Boolean			Required
IsisNumber	String	16
LabelFormat	String	64
LSID	Text
Name	String	64		Required Indexed
NcbiTaxonNumber	String	8
NodeNumber	Integer
Number1	Integer
Number2	Integer
Number3	Float
Number4	Float
Number5	Float
RankID	Integer			Required
Remarks	Text	4096
Source	String	64
TaxonomicSerialNumber	String	50		Indexed
Text1	String	32
Text10	String	128
Text11	String	128
Text12	String	128
Text13	String	128
Text14	String	256
Text15	String	256
Text16	String	256
Text17	String	256
Text18	String	256
Text19	String	256
Text2	String	32
Text20	String	256
Text3	Text	65535
Text4	Text	65535
Text5	Text	65535
Text6	Text	65535
Text7	Text	65535
Text8	Text	65535
Text9	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
UnitInd1	String	50
UnitInd2	String	50
UnitInd3	String	50
UnitInd4	String	50
UnitName1	String	50
UnitName2	String	50
UnitName3	String	50
UnitName4	String	50
UsfwsCode	String	16
Version	Integer
Visibility	Byte
YesNo1	Boolean
YesNo10	Boolean
YesNo11	Boolean
YesNo12	Boolean
YesNo13	Boolean
YesNo14	Boolean
YesNo15	Boolean
YesNo16	Boolean
YesNo17	Boolean
YesNo18	Boolean
YesNo19	Boolean
YesNo2	Boolean
YesNo3	Boolean
YesNo4	Boolean
YesNo5	Boolean
YesNo6	Boolean
YesNo7	Boolean
YesNo8	Boolean
YesNo9	Boolean
Relationships
Type	Target Table		Field name
one-to-many	Taxon		acceptedChildren
many-to-one	Taxon		acceptedTaxon
one-to-many	Taxon		children
one-to-many	Collecting Event Attribute		collectingEventAttributes
one-to-many	Common Name Tx		commonNames
many-to-one	Agent		createdByAgent
many-to-one	Taxon Tree Def		definition
many-to-one	Taxon Tree Def Item		definitionItem
one-to-many	Determination		determinations
one-to-many	Taxon		hybridChildren1
one-to-many	Taxon		hybridChildren2
many-to-one	Taxon		hybridParent1
many-to-one	Taxon		hybridParent2
many-to-one	Agent		modifiedByAgent
many-to-one	Taxon		parent
one-to-many	Taxon Attachment		taxonAttachments
many-to-one	Taxon Attribute		taxonAttribute
one-to-many	Taxon Citation		taxonCitations
many-to-one	Specify User		visibilitySetBy

Back to top

Taxon Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Taxon		taxon

Back to top

Taxon Attribute
Field	Type	Length	Description	Flags
Date1	Calendar
Date1Precision	Byte
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
Number3	Float
Number4	Float
Number5	Float
Number6	Float
Number7	Float
Number8	Float
Number9	Float
Remarks	Text	65535
Text1	String	128
Text10	String	128
Text11	String	128
Text12	String	128
Text13	String	128
Text14	String	128
Text15	String	128
Text16	String	128
Text17	String	128
Text18	String	128
Text19	String	128
Text2	String	128
Text20	String	128
Text21	String	128
Text22	String	128
Text23	String	128
Text24	String	128
Text25	String	128
Text26	String	128
Text27	String	256
Text28	String	256
Text29	String	256
Text3	String	128
Text30	String	256
Text31	String	256
Text32	String	256
Text33	String	256
Text34	String	256
Text35	String	256
Text36	String	256
Text37	String	256
Text38	String	256
Text39	String	256
Text4	String	128
Text40	String	256
Text41	String	256
Text42	String	256
Text43	String	256
Text44	String	256
Text45	String	256
Text46	String	256
Text47	String	256
Text48	String	256
Text49	Text	65535
Text5	String	128
Text50	Text	65535
Text51	Text	65535
Text52	Text	65535
Text53	Text	65535
Text54	Text	65535
Text55	Text	65535
Text56	Text	65535
Text57	Text	65535
Text58	Text	65535
Text6	String	128
Text7	String	128
Text8	String	128
Text9	String	128
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo10	Boolean
YesNo11	Boolean
YesNo12	Boolean
YesNo13	Boolean
YesNo14	Boolean
YesNo15	Boolean
YesNo16	Boolean
YesNo17	Boolean
YesNo18	Boolean
YesNo19	Boolean
YesNo2	Boolean
YesNo20	Boolean
YesNo21	Boolean
YesNo22	Boolean
YesNo23	Boolean
YesNo24	Boolean
YesNo25	Boolean
YesNo26	Boolean
YesNo27	Boolean
YesNo28	Boolean
YesNo29	Boolean
YesNo3	Boolean
YesNo30	Boolean
YesNo31	Boolean
YesNo32	Boolean
YesNo33	Boolean
YesNo34	Boolean
YesNo35	Boolean
YesNo36	Boolean
YesNo37	Boolean
YesNo38	Boolean
YesNo39	Boolean
YesNo4	Boolean
YesNo40	Boolean
YesNo41	Boolean
YesNo42	Boolean
YesNo43	Boolean
YesNo44	Boolean
YesNo45	Boolean
YesNo46	Boolean
YesNo47	Boolean
YesNo48	Boolean
YesNo49	Boolean
YesNo5	Boolean
YesNo50	Boolean
YesNo51	Boolean
YesNo52	Boolean
YesNo53	Boolean
YesNo54	Boolean
YesNo55	Boolean
YesNo56	Boolean
YesNo57	Boolean
YesNo58	Boolean
YesNo59	Boolean
YesNo6	Boolean
YesNo60	Boolean
YesNo61	Boolean
YesNo62	Boolean
YesNo63	Boolean
YesNo64	Boolean
YesNo65	Boolean
YesNo66	Boolean
YesNo67	Boolean
YesNo68	Boolean
YesNo69	Boolean
YesNo7	Boolean
YesNo70	Boolean
YesNo71	Boolean
YesNo72	Boolean
YesNo73	Boolean
YesNo74	Boolean
YesNo75	Boolean
YesNo76	Boolean
YesNo77	Boolean
YesNo78	Boolean
YesNo79	Boolean
YesNo8	Boolean
YesNo80	Boolean
YesNo81	Boolean
YesNo82	Boolean
YesNo9	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		agent1
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
one-to-many	Taxon		taxons

Back to top

Taxon Citation
Field	Type	Length	Description	Flags
Number1	Float	24
Number2	Float	24
Remarks	Text	4096
Text1	Text	65535
Text2	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Reference Work		referenceWork
many-to-one	Taxon		taxon

Back to top

Taxon Tree Def
Field	Type	Length	Description	Flags
FullNameDirection	Integer
Name	String	64		Required
Remarks	String	255
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
one-to-one	User Group Scope		discipline
many-to-one	Agent		modifiedByAgent
one-to-many	Taxon Tree Def Item		treeDefItems
one-to-many	Taxon		treeEntries

Back to top

Taxon Tree Def Item
Field	Type	Length	Description	Flags
FormatToken	String	32
FullNameSeparator	String	32
IsEnforced	Boolean
IsInFullName	Boolean
Name	String	64		Required
RankID	Integer			Required
Remarks	Text	4096
TextAfter	String	64
TextBefore	String	64
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Title	String	64
Version	Integer
Relationships
Type	Target Table		Field name
one-to-many	Taxon Tree Def Item		children
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Taxon Tree Def Item		parent
many-to-one	Taxon Tree Def		treeDef
one-to-many	Taxon		treeEntries

Back to top

Treatment Event
Field	Type	Length	Description	Flags
DateBoxed	Calendar
DateCleaned	Calendar
DateCompleted	Calendar
DateReceived	Calendar			Indexed
DateToIsolation	Calendar
DateTreatmentEnded	Calendar
DateTreatmentStarted	Calendar			Indexed
FieldNumber	String	50		Indexed
Storage	String	64
Number1	Integer
Number2	Integer
Number3	Float
Number4	Float
Number5	Float
Remarks	Text	2048
Text1	Text	65535
Text2	Text	65535
Text3	Text	65535
Text4	Text	65535
Text5	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
TreatmentNumber	String	32		Indexed
Type	String	128
Version	Integer
YesNo1	Boolean
YesNo2	Boolean
YesNo3	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Accession		accession
many-to-one	Agent		authorizedBy
many-to-one	Collection Object		collectionObject
many-to-one	Agent		createdByAgent
many-to-one	User Group Scope		division
many-to-one	Agent		modifiedByAgent
many-to-one	Agent		performedBy
one-to-many	Treatment Event Attachment		treatmentEventAttachments

Back to top

Treatment Event Attachment
Field	Type	Length	Description	Flags
Ordinal	Integer			Required
Remarks	Text	4096
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Attachment		attachment
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Treatment Event		treatmentEvent

Back to top

Voucher Relationship
Field	Type	Length	Description	Flags
CollectionCode	String	64
CollectionMemberID	Integer			Required Indexed
InstitutionCode	String	64
Integer1	Integer
Integer2	Integer
Integer3	Integer
Number1	Float
Number2	Float
Number3	Float
Remarks	Text	65535
Text1	Text	65535
Text2	Text	65535
Text3	Text	65535
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
UrlLink	String	1024
Version	Integer
VoucherNumber	String	256
YesNo1	Boolean
YesNo2	Boolean
YesNo3	Boolean
Relationships
Type	Target Table		Field name
many-to-one	Collection Object		collectionObject
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent

Back to top

Workbench
Field	Type	Length	Description	Flags
AllPermissionLevel	Integer
TableID	Integer
ExportInstitutionName	String	128
ExportedFromTableName	String	128
FormId	Integer
GroupPermissionLevel	Integer
LockedByUserName	String	64
Name	String	64
OwnerPermissionLevel	Integer
Remarks	Text	4096
SrcFilePath	String	255
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Sp Principal		group
many-to-one	Agent		modifiedByAgent
many-to-one	Specify User		specifyUser
one-to-many	Workbench Row		workbenchRows
many-to-one	Workbench Template		workbenchTemplate

Back to top

Workbench Data Item
Field	Type	Length	Description	Flags
CellData	Text
RowNumber	Short
ValidationStatus	Short
Relationships
Type	Target Table		Field name
many-to-one	Workbench Row		workbenchRow
many-to-one	Workbench Template Mapping Item		workbenchTemplateMappingItem

Back to top

Workbench Row
Field	Type	Length	Description	Flags
BioGeomancerResults	Text	8192
CardImageData	Text	16000000
CardImageFullPath	String	255
ErrorEstimate	Bigdecimal
ErrorPolygon	Text	65535
Lat1Text	String	50
Lat2Text	String	50
Long1Text	String	50
Long2Text	String	50
RecordID	Integer
RowNumber	Short			Indexed
SGRStatus	Byte
UploadStatus	Byte
Relationships
Type	Target Table		Field name
many-to-one	Workbench		workbench
one-to-many	Workbench Data Item		workbenchDataItems
one-to-many	Workbench Row Exported Relationship		workbenchRowExportedRelationships
one-to-many	Workbench Row Image		workbenchRowImages

Back to top

Workbench Row Exported Relationship
Field	Type	Length	Description	Flags
RecordID	Integer
RelationshipName	String	120
Sequence	Integer
TableName	String	120
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Workbench Row		workbenchRow

Back to top

Workbench Row Image
Field	Type	Length	Description	Flags
AttachToTableName	String	64
CardImageData	Text	16000000
CardImageFullPath	String	255
ImageOrder	Integer
Relationships
Type	Target Table		Field name
many-to-one	Workbench Row		workbenchRow

Back to top

Workbench Template
Field	Type	Length	Description	Flags
Name	String	64
Remarks	Text	4096
SrcFilePath	String	255
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
many-to-one	Specify User		specifyUser
one-to-many	Workbench Template Mapping Item		workbenchTemplateMappingItems
one-to-many	Workbench		workbenches

Back to top

Workbench Template Mapping Item
Field	Type	Length	Description	Flags
Caption	String	64
CarryForward	Boolean
DataFieldLength	Short
FieldName	String	255
FieldType	Short
ImportedColName	String	255
IsEditable	Boolean
IsExportableToContent	Boolean
IsIncludedInTitle	Boolean
IsRequired	Boolean
MetaData	String	128
DataColumnIndex	Short
TableId	Integer	64
TableName	String	64
TimestampCreated	Timestamp			Required
TimestampModified	Timestamp
Version	Integer
ViewOrder	Short
XCoord	Short
YCoord	Short
Relationships
Type	Target Table		Field name
many-to-one	Agent		createdByAgent
many-to-one	Agent		modifiedByAgent
one-to-many	Workbench Data Item		workbenchDataItems
many-to-one	Workbench Template		workbenchTemplate