Updated: 06-11-2008
Contents
Table of Contents
Table Descriptions
Table Indexes

Table of Contents

Table Definitions

Accession
Tracks accessions and be be part of a Repository Agreement.
Field Type Length Index Name Description
AccessionID Integer    AccessionID Primary Key
Accession Condition String 255    
Accession Number String 60 AccessionNumberIDX  
Date Accessioned Calendar    AccessionDateIDX Date of Accession
Date Acknowledged Calendar       
Date Received Calendar      Date material was received
Number1 Float      User definable
Number2 Float      User definable
Remarks Memo 4096   Additional Comments
Status String 32   Status of Accession, e.g. 'In process', 'Complete' ...
Text1 String 300   User definable
Text2 String 300   User definable
Text3 String 300   User definable
Timestamp Created Timestamp      The timestamp the record was created.
Timestamp Modified Timestamp      The timestamp the record was last modified.
Total Value BigDecimal       
Type String 32   Source of Accession, e.g. 'Collecting', 'Gift', 'Bequest' ...
Verbatim Date String 50   Accommodates historical accessions.
Version Integer       
Yes No1 Boolean      User definable
Yes No2 Boolean      User definable
Relationships
Type Name To Table
one-to-many Accession Agents AccessionAgent
one-to-many Accession Attachments AccessionAttachment
one-to-many Accession Authorizations AccessionAuthorization
many-to-one Address Of Record AddressOfRecord
one-to-many Appraisals Appraisal
one-to-many Collection Objects CollectionObject
many-to-one Created By Agent Agent
one-to-many Deaccessions Deaccession
many-to-one Division Division
many-to-one Modified By Agent Agent
many-to-one Repository Agreement RepositoryAgreement
one-to-many Treatment Events TreatmentEvent


Accession Agent
The person(s) requesting the Accession. This references an Agent.
Field Type Length Index Name Description
AccessionAgentID Integer    AccessionAgentID Primary Key
Remarks Memo 4096   Additional Comments
Role String 50   Role the agent played in the accession process
Timestamp Created Timestamp      The timestamp the record was created.
Timestamp Modified Timestamp      The timestamp the record was last modified.
Version Integer       
Relationships
Type Name To Table
many-to-one Accession Accession
many-to-one Agent Agent
many-to-one Created By Agent Agent
many-to-one Modified By Agent Agent
many-to-one Repository Agreement RepositoryAgreement


Accession Attachment
An attachment for the Accession. This may be one or more PDF files of paperwork or a photo of the Accession.
Field Type Length Index Name Description
AccessionAttachmentID Integer    AccessionAttachmentID Primary Key
Ordinal Integer       
Remarks Memo 4096    
Timestamp Created Timestamp       
Timestamp Modified Timestamp       
Version Integer       
Relationships
Type Name To Table
many-to-one Accession Accession
many-to-one Attachment Attachment
many-to-one Created By Agent Agent
many-to-one Modified By Agent Agent


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


Address
The address of a Agent. This also captures a start and end date for the address and the position held while at the address.
Field Type Length Index Name Description
AddressID Integer    AddressID Primary Key
Address String 255   Address as it should appear on mailing labels
Address2 String 255   Second line of address (optional)
City String 64   The City
Country String 64   The Country
End Date Calendar      The last date the agent was at the address
Fax String 50   The fax number
Is Current Boolean       
Is Primary Boolean      Indicates whether this is the primary address
Is Shipping Boolean       
Phone1 String 50   The primary phone number
Phone2 String 50   The secondary phone number
Position Held String 32   The position held by the agent while at this address
Postal Code String 32   Postal code (Zip Code)
Remarks Memo 4096   Additional Comments
Room Or Building String 50   The room or building of the agent
Start Date Calendar      The first date the the agent was at this address
State String 64   The state within the country
Timestamp Created Timestamp      The timestamp the record was created.
Timestamp Modified Timestamp      The timestamp the record was last modified.
Type Of Addr String 32    
Version Integer       
Relationships
Type Name To Table
many-to-one Agent Agent
many-to-one Created By Agent Agent
one-to-many Divisions Division
one-to-many Insitutions Institution
many-to-one Modified By Agent Agent


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


Agent
This represents a Person, Organization, Group or Other. For example, an Agent can be a Cataloger, Determiner, Shipper, etc.
Field Type Length Index Name Description
AgentID Integer    AgentID Primary Key
Abbreviation String 50   of organization
Agent Type Byte      Discriminator between Organization(0), Person(1), Other(2), and Group(3)
Author Name String 64 AuthorNameIDX The named used when authoring publications
Collector Name String 64 CollectorNameIDX The name used as a collector
Email String 50   Email address
First Name String 50 AgentFirstNameIDX of Person
GUID String 128 AgentGuidIDX Global Unique Identifier
Initials String 8    
Interests String 255   of Person or Organization
Job Title String 50   Agent's (person) job title at specified address and organization
Label Name String 64   The name used on labels
Last Name String 50 AgentLastNameIDX of Person
Middle Initial String 50   of Person
Remarks Memo 4096   Additional Comments
Timestamp Created Timestamp      The timestamp the record was created.
Timestamp Modified Timestamp      The timestamp the record was last modified.
Title String 50   of Person
Url String 1024   An URL for their web site
Version Integer       
Visibility Integer       
Visibility Set By String 50    
Relationships
Type Name To Table
one-to-many Addresses Address
one-to-many Agent Attachments AgentAttachment
one-to-many Authors Author
one-to-many Borrow Return Materials BorrowReturnMaterial
one-to-many Catalogers CollectionObject
one-to-many Collectors Collector
one-to-many Determinations Determination
many-to-many Disciplines Discipline
many-to-one Division Division
one-to-many Exchange In Cataloged Bys ExchangeIn
one-to-many Exchange Out Cataloged Bys ExchangeOut
one-to-many Geo Coord Detail GeoCoordDetail
one-to-many Groups GroupPerson
many-to-one Inst Content Contact Institution
many-to-one Inst Tech Contact Institution
one-to-many Loan Return Physical Objects LoanReturnPreparation
one-to-many Members GroupPerson
one-to-many Preparations Preparation
one-to-many Projects Project
one-to-many Repository Agreements RepositoryAgreement
one-to-many Shipments Shipment
many-to-one Specify User SpecifyUser
one-to-many Variants AgentVariant


Agent Attachment
This is primarily used by Botanists for capturing Variant and Vernacular names. This table is searchable by does not have any specific business rules associated with it.
Field Type Length Index Name Description
AgentAttachmentID Integer    AgentAttachmentID Primary Key
Ordinal Integer       
Remarks Memo 4096    
Timestamp Created Timestamp       
Timestamp Modified Timestamp       
Version Integer       
Relationships
Type Name To Table
many-to-one Agent Agent
many-to-one Attachment Attachment
many-to-one Created By Agent Agent
many-to-one Modified By Agent Agent


Agent Variant
Internal to Specify, this represents a resource, typically XML, that the application uses during runtime.
Field Type Length Index Name Description
AgentVariantID Integer    AgentVariantID Primary Key
Name String 255   THe full name used as a variant or vernacular name
Timestamp Created Timestamp      The timestamp the record was created.
Timestamp Modified Timestamp      The timestamp the record was last modified.
Var Type Byte      Indicates whether the record is a variant (0) or a vernacular name (1)
Version Integer       
Relationships
Type Name To Table
many-to-one Agent Agent
many-to-one Created By Agent Agent
many-to-one Modified By Agent Agent


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


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


App Resource Default
This represents the actual attachment. The attachment itself is not sorted in the database. The information in this record identifies everything the application will need to load and display the attachment. The attachment location is an absolute path to
Field Type Length Index Name Description
SpAppResourceDirID Integer    SpAppResourceDirID Primary Key
Discipline Type String 64 SpAppResourceDirDispTypeIDX  
Is Personal Boolean       
Timestamp Created Timestamp      The timestamp the record was created.
Timestamp Modified Timestamp      The timestamp the record was last modified.
User Type String 64    
Version Integer       
Relationships
Type Name To Table
many-to-one Collection Collection
many-to-one Created By Agent Agent
many-to-one Discipline Discipline
many-to-one Modified By Agent Agent
one-to-many Sp Persisted App Resources SpAppResource
one-to-many Sp Persisted View Sets SpViewSetObj
many-to-one Specify User SpecifyUser


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


Attachment
This represents the actual attachment. The attachment itself is not sorted in the database. The information in this record identifies everything the application will need to load and display the attachment. The attachment location is an absolute path to t
Field Type Length Index Name Description
AttachmentID Integer    AttachmentID Primary Key
Attachment Location String 128    
Copyright Date String 64    
Copyright Holder String 64    
Credit String 64    
Date Imaged String 64 DateImagedIDX  
File Created Date Calendar       
License String 64    
Mime Type String 32    
Original Filename String 128    
Remarks Memo 4096    
Timestamp Created Timestamp       
Timestamp Modified Timestamp       
Title String 64 TitleIDX  
Version Integer       
Visibility Integer       
Visibility Set By String 50    
Relationships
Type Name To Table
one-to-many Accession Attachments AccessionAttachment
one-to-many Agent Attachments AgentAttachment
one-to-many Collecting Event Attachments CollectingEventAttachment
one-to-many Collection Object Attachments CollectionObjectAttachment
one-to-many Conserv Description Attachments ConservDescriptionAttachment
one-to-many Conserv Event Attachments ConservEventAttachment
many-to-one Created By Agent Agent
one-to-many Dna Sequence Attachments DNASequenceAttachment
one-to-many Field Notebook Attachments FieldNotebookAttachment
one-to-many Field Notebook Page Attachments FieldNotebookPageAttachment
one-to-many Field Notebook Page Set Attachments FieldNotebookPageSetAttachment
one-to-many Loan Attachments LoanAttachment
one-to-many Locality Attachments LocalityAttachment
one-to-many Metadata AttachmentMetadata
many-to-one Modified By Agent Agent
one-to-many Permit Attachments PermitAttachment
one-to-many Preparation Attachments PreparationAttachment
one-to-many Repository Agreement Attachments RepositoryAgreementAttachment
one-to-many Tags AttachmentTag
one-to-many Taxon Attachments TaxonAttachment


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


Attachment Tag
An attribute tag of an attachment. This consists of a single text field.
Field Type Length Index Name Description
AttachmentTagID Integer    AttachmentTagID Primary Key
Tag String 64    
Timestamp Created Timestamp       
Timestamp Modified Timestamp       
Version Integer       
Relationships
Type Name To Table
many-to-one Attachment Attachment
many-to-one Created By Agent Agent
many-to-one Modified By Agent Agent


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


Author
An Author is a reference to an Agent and provides the order for a list of authors of a Reference Work
Field Type Length Index Name Description
AuthorID Integer    AuthorID Primary Key
Order Number Short      Their position in a list of authors
Remarks Memo 4096   Additional Comments
Timestamp Created Timestamp      The timestamp the record was created.
Timestamp Modified Timestamp      The timestamp the record was last modified.
Version Integer       
Relationships
Type Name To Table
many-to-one Agent Agent
many-to-one Created By Agent Agent
many-to-one Modified By Agent Agent
many-to-one Reference Work ReferenceWork


Borrow
A Borrow represents a Loan from another Collection to yours.
Field Type Length Index Name Description
BorrowID Integer    BorrowID Primary Key
Collection Member Id Integer    BorColMemIDX  
Current Due Date Calendar      Date loan is currently due. (Same as Original Due Date unless loan period has been extended)
Date Closed Calendar 10   Date loan was closed
Invoice Number String 50 BorInvoiceNumberIDX Lender's loan number
Is Closed Boolean      Indicates whether the borrow was closed (returned)
Is Financial Responsibility Boolean       
Number1 Float 24   User definable
Number2 Float 24   User definable
Original Due Date Calendar      Original Due date for loan
Received Date Calendar    BorReceivedDateIDX Date material was received
Remarks Memo 4096   Additional Comments
Text1 String 300   User definable
Text2 String 300   User definable
Timestamp Created Timestamp      The timestamp the record was created.
Timestamp Modified Timestamp      The timestamp the record was last modified.
Version Integer       
Yes No1 Boolean      User definable
Yes No2 Boolean      User definable
Relationships
Type Name To Table
many-to-one Address Of Record AddressOfRecord
one-to-many Borrow Agents BorrowAgent
one-to-many Borrow Materials BorrowMaterial
many-to-one Created By Agent Agent
many-to-one Modified By Agent Agent
one-to-many Shipments Shipment


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


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


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


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


Catalog Numbering Scheme
Internal Specify table for describing numbering schemes. It enables multiple collections to share a numbering scheme.
Field Type Length Index Name Description
CatalogNumberingSchemeID Integer    CatalogNumberingSchemeID Primary Key
Is Numeric Only Boolean      Indicates it is a completely numeric catalog number scheme
Scheme Class Name String 32   The Java Class that implements the scheme
Scheme Name String 32 SchemeNameIDX The name of the scheme
Timestamp Created Timestamp      The timestamp the record was created.
Timestamp Modified Timestamp      The timestamp the record was last modified.
Version Integer       
Relationships
Type Name To Table
one-to-many Collections Collection
many-to-one Created By Agent Agent
many-to-one Modified By Agent Agent


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


Collecting Event
Describes a Collecting Event. For some disciplines, like Botany this hidden and only the start state may be used.
Field Type Length Index Name Description
CollectingEventID Integer    CollectingEventID Primary Key
End Date Calendar    CEEndDateIDX The date collecting event ended
End Date Precision Short       
End Date Verbatim String 50    
End Time Short      End time in military format
Group Permitted To View Integer      The name of the group that this record is visible to.
Method String 50   The method used to obtain the biological object
Remarks Memo 4096   Additional Comments
Start Date Calendar    CEStartDateIDX The date collecting event began
Start Date Precision Short       
Start Date Verbatim String 50    
Start Time Short      Start time in military format
Station Field Number String 50 CEStationFieldNumberIDX Station number or field number of the site where collecting event took place, A number or code recorded in field notes and/or written on field tags that identifies ALL material collected in a Collecting Event.
Timestamp Created Timestamp      The timestamp the record was created.
Timestamp Modified Timestamp      The timestamp the record was last modified.
Verbatim Date String 50   Date which collector recorded in field book, exactly as reported by the collector. Should indicate whether reported as range, season, month, etc.
Verbatim Locality Memo 2048   Original statement (literal quotation) of the location of the Collecting Event as given by the Collector.
Version Integer       
Visibility Integer       
Visibility Set By String 50    
Relationships
Type Name To Table
one-to-many Collecting Event Attachments CollectingEventAttachment
many-to-one Collecting Event Attribute CollectingEventAttribute
one-to-many Collecting Event Attrs CollectingEventAttr
many-to-one Collecting Trip CollectingTrip
one-to-many Collection Objects CollectionObject
one-to-many Collectors Collector
many-to-one Created By Agent Agent
many-to-one Discipline Discipline
many-to-one Locality Locality
many-to-one Modified By Agent Agent


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


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


Collecting Event Attribute
Field Type Length Index Name Description
CollectingEventAttributeID Integer    CollectingEventAttributeID Primary Key
Collection Member Id Integer    COLEVATSColMemIDX  
Number1 Float