agent

Table info.

Title Agent
Description Agent

Fields

Name Type Required Index Hidden On form Title Pick list Description
AgentID int(11) PRI
TimestampCreated datetime Created The timestamp the record was created
TimestampModified datetime Last edited The timestamp the record was last modified
Version int(11) Version version
Abbreviation varchar(50) MUL Abbreviation The abbreviation of an institution or organisation
AgentType tinyint(4) MUL Agent type Whether the agent is a person, group or organisation
DateOfBirth date Start The agent's date of birth, or the start of their collecting activity
DateOfBirthPrecision tinyint(4) Date Of Birth Precision dateOfBirthPrecision
DateOfDeath date End The agent's date of death, or the end of their collecting activity
DateOfDeathPrecision tinyint(4) Date Of Death Precision dateOfDeathPrecision
Email varchar(50) E-mail The agent's e-mail address
FirstName varchar(50) MUL Initials The agent's first and middle initials. If the agent's name contains a preposition that has not been anglicised, e.g. 'de', 'van', 'zu', enter it after the initials. If the preposition has been anglicised (and thus capitalised), include it in Last name.
GUID varchar(128) MUL GUID Global Unique Identifier.
Initials varchar(8) AgentID
Interests varchar(255) CITES no. The CITES number for an institution
JobTitle varchar(50) Job title The agent's job title at a specific organisation
LastName varchar(256) MUL Last name The agent's last name
MiddleInitial varchar(50) First name The agent's first name
Remarks text Comments Comments about the agent
Title varchar(50) Title AgentTitles
  • Mr
  • Ms
  • Rev. Dr
  • Miss
  • Mrs
  • Brother
  • Dr
  • Mme
  • Sergeant
  • Councillor
  • Superintendent
  • Father
  • Colonel
  • Rev. Mr
  • Police Inspector
  • Count
  • Master
  • Constable
  • Reverend
  • Judge
  • Herr
  • Prof.
  • Prof. Dr
  • Monsieur
  • Lieutenant
  • Frère
  • Sir
  • Captain
  • Hermano
  • Freiherr
Personal title of an agent
DateType tinyint(4) Date type Date type
  • Birth/Death
  • Collected
  • Received specimens
Indicates whether the start date and end date represent birth date and death date, or a period of collecting activity
URL text Web link A link to a website about the person or organisation
ModifiedByAgentID int(11) MUL
InstitutionTCID int(11) MUL
CollectionCCID int(11) MUL
ParentOrganizationID int(11) MUL
DivisionID int(11) MUL
SpecifyUserID int(11) MUL
InstitutionCCID int(11) MUL
CollectionTCID int(11) MUL
CreatedByAgentID int(11) MUL
Suffix varchar(50) Suffix suffix
Date1 date Date1 Date1
Date1Precision tinyint(4) Date1 Precision Date1 Precision
Date2 date Date1 Date1
Date2Precision tinyint(4) Date2 Precision Date2 Precision
Integer1 int(11) Integer1 Integer1
Integer2 int(11) Integer2 Integer2
Text1 text Text1 Text1
Text2 text Text2 Text2
VerbatimDate1 varchar(128) Verbatim Date1 Verbatim Date1
VerbatimDate2 varchar(128) Verbatim Date2 Verbatim Date2

Indexes

Name Fields Unique Nullable
AbbreviationIDX Abbreviation
AgentFirstNameIDX FirstName
AgentGuidIDX GUID
AgentLastNameIDX LastName
AgentTypeIDX AgentType
FK58743053D2DAD9A CollectionCCID
FK58743053D3567E9 CollectionTCID
FK58743054834EDBB InstitutionTCID
FK58743054BDD9E10 SpecifyUserID
FK58743055327F942 ModifiedByAgentID
FK58743057699B003 CreatedByAgentID
FK587430584B8A3FA ParentOrganizationID
FK587430587E99F68 InstitutionCCID
FK587430587F159B7 InstitutionTCID
FK587430597C961D8 DivisionID
PRIMARY AgentID

One-to-many relationships

Name Field Related table Related field
FK81EF38245327F942 AgentID accession ModifiedByAgentID
FK81EF38247699B003 AgentID accession CreatedByAgentID
FK2DC98161384B3622 AgentID accessionagent AgentID
FK2DC981615327F942 AgentID accessionagent ModifiedByAgentID
FK2DC981617699B003 AgentID accessionagent CreatedByAgentID
FKA569B4475327F942 AgentID accessionattachment ModifiedByAgentID
FKA569B4477699B003 AgentID accessionattachment CreatedByAgentID
FK4F2602D55327F942 AgentID accessionauthorization ModifiedByAgentID
FK4F2602D57699B003 AgentID accessionauthorization CreatedByAgentID
FK9ED8DF0B5327F942 AgentID accessioncitation ModifiedByAgentID
FK9ED8DF0B7699B003 AgentID accessioncitation CreatedByAgentID
FKBB979BF4384B3622 AgentID address AgentID
FKBB979BF45327F942 AgentID address ModifiedByAgentID
FKBB979BF47699B003 AgentID address CreatedByAgentID
FKDBAAE4DC384B3622 AgentID addressofrecord AgentID
FKDBAAE4DC5327F942 AgentID addressofrecord ModifiedByAgentID
FKDBAAE4DC7699B003 AgentID addressofrecord CreatedByAgentID
FK58743055327F942 AgentID agent ModifiedByAgentID
FK58743057699B003 AgentID agent CreatedByAgentID
FK587430584B8A3FA AgentID agent ParentOrganizationID
FK56FE59E8384B3622 AgentID agentattachment AgentID
FK56FE59E85327F942 AgentID agentattachment ModifiedByAgentID
FK56FE59E87699B003 AgentID agentattachment CreatedByAgentID
FK89CDCA17384B3622 AgentID agentgeography AgentID
FK89CDCA175327F942 AgentID agentgeography ModifiedByAgentID
FK89CDCA177699B003 AgentID agentgeography CreatedByAgentID
FKDB5F5799384B3622 AgentID agentspecialty AgentID
FKDB5F57995327F942 AgentID agentspecialty ModifiedByAgentID
FKDB5F57997699B003 AgentID agentspecialty CreatedByAgentID
FK8DA4DE0384B3622 AgentID agentvariant AgentID
FK8DA4DE05327F942 AgentID agentvariant ModifiedByAgentID
FK8DA4DE07699B003 AgentID agentvariant CreatedByAgentID
FK8D3C72E5384B3622 AgentID appraisal AgentID
FK8D3C72E55327F942 AgentID appraisal ModifiedByAgentID
FK8D3C72E57699B003 AgentID appraisal CreatedByAgentID
FK8AF759235327F942 AgentID attachment ModifiedByAgentID
FK8AF759237699B003 AgentID attachment CreatedByAgentID
FK8AF759239B37C589 AgentID attachment CreatorID
FK857D77845327F942 AgentID attachmentimageattribute ModifiedByAgentID
FK857D77847699B003 AgentID attachmentimageattribute CreatedByAgentID
FK991701525327F942 AgentID attachmentmetadata ModifiedByAgentID
FK991701527699B003 AgentID attachmentmetadata CreatedByAgentID
FKA62FAF975327F942 AgentID attachmenttag ModifiedByAgentID
FKA62FAF977699B003 AgentID attachmenttag CreatedByAgentID
FKC36883E95327F942 AgentID attributedef ModifiedByAgentID
FKC36883E97699B003 AgentID attributedef CreatedByAgentID
FKAC2D218B384B3622 AgentID author AgentID
FKAC2D218B5327F942 AgentID author ModifiedByAgentID
FKAC2D218B7699B003 AgentID author CreatedByAgentID
FK8227D14F5327F942 AgentID autonumberingscheme ModifiedByAgentID
FK8227D14F7699B003 AgentID autonumberingscheme CreatedByAgentID
FKAD8CA9F55327F942 AgentID borrow ModifiedByAgentID
FKAD8CA9F57699B003 AgentID borrow CreatedByAgentID
FKF48F8A30384B3622 AgentID borrowagent AgentID
FKF48F8A305327F942 AgentID borrowagent ModifiedByAgentID
FKF48F8A307699B003 AgentID borrowagent CreatedByAgentID
FK86254A1C5327F942 AgentID borrowmaterial ModifiedByAgentID
FK86254A1C7699B003 AgentID borrowmaterial CreatedByAgentID
FKA8170B8C5327F942 AgentID borrowreturnmaterial ModifiedByAgentID
FKA8170B8C7699B003 AgentID borrowreturnmaterial CreatedByAgentID
FKA8170B8CC6A93143 AgentID borrowreturnmaterial ReturnedByID
FKFEB30F225327F942 AgentID collectingevent ModifiedByAgentID
FKFEB30F227699B003 AgentID collectingevent CreatedByAgentID
FK32C365C55327F942 AgentID collectingeventattachment ModifiedByAgentID
FK32C365C57699B003 AgentID collectingeventattachment CreatedByAgentID
FK42A088135327F942 AgentID collectingeventattr ModifiedByAgentID
FK42A088137699B003 AgentID collectingeventattr CreatedByAgentID
FK9AD681BA5327F942 AgentID collectingeventattribute ModifiedByAgentID
FK9AD681BA7699B003 AgentID collectingeventattribute CreatedByAgentID
FK67DBF8975327F942 AgentID collectingeventauthorization ModifiedByAgentID
FK67DBF8977699B003 AgentID collectingeventauthorization CreatedByAgentID
FK1080269D5327F942 AgentID collectingtrip ModifiedByAgentID
FK1080269D7699B003 AgentID collectingtrip CreatedByAgentID
FK1080269DCF197B29 AgentID collectingtrip Agent1ID
FK1080269DCF197EEA AgentID collectingtrip Agent2ID
FK3E419F805327F942 AgentID collectingtripattachment ModifiedByAgentID
FK3E419F807699B003 AgentID collectingtripattachment CreatedByAgentID
FK381CA49F5327F942 AgentID collectingtripattribute ModifiedByAgentID
FK381CA49F7699B003 AgentID collectingtripattribute CreatedByAgentID
FKDDDC20FC5327F942 AgentID collectingtripauthorization ModifiedByAgentID
FKDDDC20FC7699B003 AgentID collectingtripauthorization CreatedByAgentID
FK3D0021605327F9429835ae9e AgentID collection ModifiedByAgentID
FK3D0021607699B0039835ae9e AgentID collection CreatedByAgentID
FK9835AE9E6F3E820E AgentID collection AdminContactID
FKC1D4635D3B87E163 AgentID collectionobject CatalogerID
FKC1D4635D5327F942 AgentID collectionobject ModifiedByAgentID
FKC1D4635D7699B003 AgentID collectionobject CreatedByAgentID
FKC1D4635D9F4EE41 AgentID collectionobject InventorizedByID
FKC1D4635DCF197B29 AgentID collectionobject Agent1ID
FK9C00EC405327F942 AgentID collectionobjectattachment ModifiedByAgentID
FK9C00EC407699B003 AgentID collectionobjectattachment CreatedByAgentID
FK303746CE5327F942 AgentID collectionobjectattr ModifiedByAgentID
FK303746CE7699B003 AgentID collectionobjectattr CreatedByAgentID
FK32E0BFDF5327F942 AgentID collectionobjectattribute ModifiedByAgentID
FK32E0BFDF7699B003 AgentID collectionobjectattribute CreatedByAgentID
FK32E0BFDFCF197B29 AgentID collectionobjectattribute Agent1ID
FKAB9FC1445327F942 AgentID collectionobjectcitation ModifiedByAgentID
FKAB9FC1447699B003 AgentID collectionobjectcitation CreatedByAgentID
FKC66B94321213D341 AgentID collectionobjectproperty Agent10ID
FKC66B94321213D702 AgentID collectionobjectproperty Agent11ID
FKC66B94321213DAC3 AgentID collectionobjectproperty Agent12ID
FKC66B94321213DE84 AgentID collectionobjectproperty Agent13ID
FKC66B94321213E245 AgentID collectionobjectproperty Agent14ID
FKC66B94321213E606 AgentID collectionobjectproperty Agent15ID
FKC66B94321213E9C7 AgentID collectionobjectproperty Agent16ID
FKC66B94321213ED88 AgentID collectionobjectproperty Agent17ID
FKC66B94321213F149 AgentID collectionobjectproperty Agent18ID
FKC66B94321213F50A AgentID collectionobjectproperty Agent19ID
FKC66B9432121447A0 AgentID collectionobjectproperty Agent20ID
FKC66B9432384B3033 AgentID collectionobjectproperty Agent8D
FKC66B94325327F942 AgentID collectionobjectproperty ModifiedByAgentID
FKC66B94327699B003 AgentID collectionobjectproperty CreatedByAgentID
FKC66B9432CF197B29 AgentID collectionobjectproperty Agent1ID
FKC66B9432CF197EEA AgentID collectionobjectproperty Agent2ID
FKC66B9432CF1982AB AgentID collectionobjectproperty Agent3ID
FKC66B9432CF19866C AgentID collectionobjectproperty Agent4ID
FKC66B9432CF198A2D AgentID collectionobjectproperty Agent5ID
FKC66B9432CF198DEE AgentID collectionobjectproperty Agent6ID
FKC66B9432CF1991AF AgentID collectionobjectproperty Agent7ID
FKC66B9432CF199931 AgentID collectionobjectproperty Agent9ID
FK246327D65327F942 AgentID collectionrelationship ModifiedByAgentID
FK246327D67699B003 AgentID collectionrelationship CreatedByAgentID
FK1CAC96F55327F942 AgentID collectionreltype ModifiedByAgentID
FK1CAC96F57699B003 AgentID collectionreltype CreatedByAgentID
FK7043CC8D384B3622 AgentID collector AgentID
FK7043CC8D5327F942 AgentID collector ModifiedByAgentID
FK7043CC8D7699B003 AgentID collector CreatedByAgentID
FK3413DFFA5327F942 AgentID commonnametx ModifiedByAgentID
FK3413DFFA7699B003 AgentID commonnametx CreatedByAgentID
FK829B50E15327F942 AgentID commonnametxcitation ModifiedByAgentID
FK829B50E17699B003 AgentID commonnametxcitation CreatedByAgentID
FKC040F4645327F942 AgentID conservdescription ModifiedByAgentID
FKC040F4647699B003 AgentID conservdescription CreatedByAgentID
FK1EED20875327F942 AgentID conservdescriptionattachment ModifiedByAgentID
FK1EED20877699B003 AgentID conservdescriptionattachment CreatedByAgentID
FK74A8510227E00C28 AgentID conservevent ExaminedByAgentID
FK74A851025327F942 AgentID conservevent ModifiedByAgentID
FK74A8510271496BD2 AgentID conservevent TreatedByAgentID
FK74A851027699B003 AgentID conservevent CreatedByAgentID
FK74A85102828C4E73 AgentID conservevent CuratorID
FKD3F7CFA55327F942 AgentID conserveventattachment ModifiedByAgentID
FKD3F7CFA57699B003 AgentID conserveventattachment CreatedByAgentID
FKE7814C815327F942 AgentID container ModifiedByAgentID
FKE7814C817699B003 AgentID container CreatedByAgentID
FK6AB199E45327F942 AgentID datatype ModifiedByAgentID
FK6AB199E47699B003 AgentID datatype CreatedByAgentID
FKC3EACC35327F942 AgentID deaccession ModifiedByAgentID
FKC3EACC37699B003 AgentID deaccession CreatedByAgentID
FKBE551822384B3622 AgentID deaccessionagent AgentID
FKBE5518225327F942 AgentID deaccessionagent ModifiedByAgentID
FKBE5518227699B003 AgentID deaccessionagent CreatedByAgentID
FK6A06F1F45327F942 AgentID deaccessionpreparation ModifiedByAgentID
FK6A06F1F47699B003 AgentID deaccessionpreparation CreatedByAgentID
FKC1E98FE35327F942 AgentID determination ModifiedByAgentID
FKC1E98FE37699B003 AgentID determination CreatedByAgentID
FKC1E98FE3E9268B1C AgentID determination DeterminerID
FK259B07CA5327F942 AgentID determinationcitation ModifiedByAgentID
FK259B07CA7699B003 AgentID determinationcitation CreatedByAgentID
FK3D0021605327F942157b9b70 AgentID discipline ModifiedByAgentID
FK3D0021607699B003157b9b70 AgentID discipline CreatedByAgentID
FK3D0021605327F94215bd30ad AgentID division ModifiedByAgentID
FK3D0021607699B00315bd30ad AgentID division CreatedByAgentID
FK5E4FB5AA5327F942 AgentID dnaprimer ModifiedByAgentID
FK5E4FB5AA7699B003 AgentID dnaprimer CreatedByAgentID
FK9F42F5D8384B3622 AgentID dnasequence AgentID
FK9F42F5D85327F942 AgentID dnasequence ModifiedByAgentID
FK9F42F5D87699B003 AgentID dnasequence CreatedByAgentID
FK9F42F5D8E43B7581 AgentID dnasequence ExtractorID
FKFFC2E0FB5327F942 AgentID dnasequenceattachment ModifiedByAgentID
FKFFC2E0FB7699B003 AgentID dnasequenceattachment CreatedByAgentID
FKD0DAEB165327F942 AgentID dnasequencerunattachment ModifiedByAgentID
FKD0DAEB167699B003 AgentID dnasequencerunattachment CreatedByAgentID
FK2AF6F9D65327F942 AgentID dnasequencingrun ModifiedByAgentID
FK2AF6F9D67699B003 AgentID dnasequencingrun CreatedByAgentID
FK2AF6F9D6851BDBC0 AgentID dnasequencingrun RunByAgentID
FK2AF6F9D6D76CA4E AgentID dnasequencingrun PreparedByAgentID
FKDNASEQRUNPREPBYAGT AgentID dnasequencingrun PreparedByAgentID
FKDNASEQRUNRUNBYAGT AgentID dnasequencingrun RunByAgentID
FK24CEBD5327F942 AgentID dnasequencingruncitation ModifiedByAgentID
FK24CEBD7699B003 AgentID dnasequencingruncitation CreatedByAgentID
FK366E9E883824C16C AgentID exchangein CatalogedByID
FK366E9E885327F942 AgentID exchangein ModifiedByAgentID
FK366E9E887699B003 AgentID exchangein CreatedByAgentID
FK366E9E88F77B069B AgentID exchangein ReceivedFromOrganizationID
FK9A0BCB55327F942 AgentID exchangeinprep ModifiedByAgentID
FK9A0BCB57699B003 AgentID exchangeinprep CreatedByAgentID
FK97654A4B3824C16C AgentID exchangeout CatalogedByID
FK97654A4B5327F942 AgentID exchangeout ModifiedByAgentID
FK97654A4B7699B003 AgentID exchangeout CreatedByAgentID
FK97654A4BA21647A3 AgentID exchangeout SentToOrganizationID
FK7405CEF85327F942 AgentID exchangeoutprep ModifiedByAgentID
FK7405CEF87699B003 AgentID exchangeoutprep CreatedByAgentID
FKACC7DD855327F942 AgentID exsiccata ModifiedByAgentID
FKACC7DD857699B003 AgentID exsiccata CreatedByAgentID
FK23150E185327F942 AgentID exsiccataitem ModifiedByAgentID
FK23150E187699B003 AgentID exsiccataitem CreatedByAgentID
FKF0EDCE24384B3622 AgentID extractor AgentID
FKF0EDCE245327F942 AgentID extractor ModifiedByAgentID
FKF0EDCE247699B003 AgentID extractor CreatedByAgentID
FK4647A8D5384B3622 AgentID fieldnotebook AgentID
FK4647A8D55327F942 AgentID fieldnotebook ModifiedByAgentID
FK4647A8D57699B003 AgentID fieldnotebook CreatedByAgentID
FKDC15BBB85327F942 AgentID fieldnotebookattachment ModifiedByAgentID
FKDC15BBB87699B003 AgentID fieldnotebookattachment CreatedByAgentID
FK162198E45327F942 AgentID fieldnotebookpage ModifiedByAgentID
FK162198E47699B003 AgentID fieldnotebookpage CreatedByAgentID
FK91AA25075327F942 AgentID fieldnotebookpageattachment ModifiedByAgentID
FK91AA25077699B003 AgentID fieldnotebookpageattachment CreatedByAgentID
FK6FC0C8FE384B3622 AgentID fieldnotebookpageset AgentID
FK6FC0C8FE5327F942 AgentID fieldnotebookpageset ModifiedByAgentID
FK6FC0C8FE7699B003 AgentID fieldnotebookpageset CreatedByAgentID
FKB1477CA15327F942 AgentID fieldnotebookpagesetattachment ModifiedByAgentID
FKB1477CA17699B003 AgentID fieldnotebookpagesetattachment CreatedByAgentID
FKB688EB95384B3622 AgentID geocoorddetail AgentID
FKB688EB955327F942 AgentID geocoorddetail ModifiedByAgentID
FKB688EB957699B003 AgentID geocoorddetail CreatedByAgentID
FKB688EB9580202F05 AgentID geocoorddetail CompiledByID
FK496A777C5327F942 AgentID geography ModifiedByAgentID
FK496A777C7699B003 AgentID geography CreatedByAgentID
FKE8DD68AB5327F942 AgentID geographytreedef ModifiedByAgentID
FKE8DD68AB7699B003 AgentID geographytreedef CreatedByAgentID
FKF584963E5327F942 AgentID geographytreedefitem ModifiedByAgentID
FKF584963E7699B003 AgentID geographytreedefitem CreatedByAgentID
FKA2A8513B5327F942 AgentID geologictimeperiod ModifiedByAgentID
FKA2A8513B7699B003 AgentID geologictimeperiod CreatedByAgentID
FK8109EA0C5327F942 AgentID geologictimeperiodtreedef ModifiedByAgentID
FK8109EA0C7699B003 AgentID geologictimeperiodtreedef CreatedByAgentID
FKB6DF7F1F5327F942 AgentID geologictimeperiodtreedefitem ModifiedByAgentID
FKB6DF7F1F7699B003 AgentID geologictimeperiodtreedefitem CreatedByAgentID
FK3069305327F942 AgentID gift ModifiedByAgentID
FK3069307699B003 AgentID gift CreatedByAgentID
FK221917D5384B3622 AgentID giftagent AgentID
FK221917D55327F942 AgentID giftagent ModifiedByAgentID
FK221917D57699B003 AgentID giftagent CreatedByAgentID
FK18B1F675327F942 AgentID giftpreparation ModifiedByAgentID
FK18B1F677699B003 AgentID giftpreparation CreatedByAgentID
FK5DEB769450D2EC77 AgentID groupperson MemberID
FK5DEB76945327F942 AgentID groupperson ModifiedByAgentID
FK5DEB76947699B003 AgentID groupperson CreatedByAgentID
FK5DEB76948905F31C AgentID groupperson GroupID
FK68918E21384B3622 AgentID inforequest AgentID
FK68918E215327F942 AgentID inforequest ModifiedByAgentID
FK68918E217699B003 AgentID inforequest CreatedByAgentID
FK3D0021605327F9423529a5b8 AgentID institution ModifiedByAgentID
FK3D0021607699B0033529a5b8 AgentID institution CreatedByAgentID
FK945C55765327F942 AgentID institutionnetwork ModifiedByAgentID
FK945C55767699B003 AgentID institutionnetwork CreatedByAgentID
FKAB64AF375327F942 AgentID journal ModifiedByAgentID
FKAB64AF377699B003 AgentID journal CreatedByAgentID
FKE4EEDE6E5327F942 AgentID latlonpolygon ModifiedByAgentID
FKE4EEDE6E7699B003 AgentID latlonpolygon CreatedByAgentID
FK329297065327F942 AgentID lithostrat ModifiedByAgentID
FK329297067699B003 AgentID lithostrat CreatedByAgentID
FK268699E15327F942 AgentID lithostrattreedef ModifiedByAgentID
FK268699E17699B003 AgentID lithostrattreedef CreatedByAgentID
FKEC263C745327F942 AgentID lithostrattreedefitem ModifiedByAgentID
FKEC263C747699B003 AgentID lithostrattreedefitem CreatedByAgentID
FK32C4F05327F942 AgentID loan ModifiedByAgentID
FK32C4F07699B003 AgentID loan CreatedByAgentID
FK63FA1415384B3622 AgentID loanagent AgentID
FK63FA14155327F942 AgentID loanagent ModifiedByAgentID
FK63FA14157699B003 AgentID loanagent CreatedByAgentID
FK23ECB2135327F942 AgentID loanattachment ModifiedByAgentID
FK23ECB2137699B003 AgentID loanattachment CreatedByAgentID
FK374DEBA75327F942 AgentID loanpreparation ModifiedByAgentID
FK374DEBA77699B003 AgentID loanpreparation CreatedByAgentID
FK3632847749C90455 AgentID loanreturnpreparation ReceivedByID
FK363284775327F942 AgentID loanreturnpreparation ModifiedByAgentID
FK363284777699B003 AgentID loanreturnpreparation CreatedByAgentID
FK714BFD635327F942 AgentID locality ModifiedByAgentID
FK714BFD637699B003 AgentID locality CreatedByAgentID
FKB39C36C65327F942 AgentID localityattachment ModifiedByAgentID
FKB39C36C67699B003 AgentID localityattachment CreatedByAgentID
FK9877F54A5327F942 AgentID localitycitation ModifiedByAgentID
FK9877F54A7699B003 AgentID localitycitation CreatedByAgentID
FKBB0D3F745327F942 AgentID localitydetail ModifiedByAgentID
FKBB0D3F747699B003 AgentID localitydetail CreatedByAgentID
FK29EB5CA25327F942 AgentID localitynamealias ModifiedByAgentID
FK29EB5CA27699B003 AgentID localitynamealias CreatedByAgentID
FKD5CE21915327F942 AgentID materialsample ModifiedByAgentID
FKD5CE21917699B003 AgentID materialsample CreatedByAgentID
FKD5CE2191E43B7581 AgentID materialsample ExtractorID
FKDED66BE95327F942 AgentID morphbankview ModifiedByAgentID
FKDED66BE97699B003 AgentID morphbankview CreatedByAgentID
FK2A5397B95327F942 AgentID otheridentifier ModifiedByAgentID
FK2A5397B97699B003 AgentID otheridentifier CreatedByAgentID
FK99B5438A5327F942 AgentID paleocontext ModifiedByAgentID
FK99B5438A7699B003 AgentID paleocontext CreatedByAgentID
FK5D6EE8F4384B3622 AgentID pcrperson AgentID
FK5D6EE8F45327F942 AgentID pcrperson ModifiedByAgentID
FK5D6EE8F47699B003 AgentID pcrperson CreatedByAgentID
FKC4E3841B5327F942 AgentID permit ModifiedByAgentID
FKC4E3841B7699B003 AgentID permit CreatedByAgentID
FKC4E3841BCDCF181F AgentID permit IssuedByID
FKC4E3841BCDD72143 AgentID permit IssuedToID
FK7064B77E5327F942 AgentID permitattachment ModifiedByAgentID
FK7064B77E7699B003 AgentID permitattachment CreatedByAgentID
FKD3F8383F5327F942 AgentID picklist ModifiedByAgentID
FKD3F8383F7699B003 AgentID picklist CreatedByAgentID
FK30C57BD25327F942 AgentID picklistitem ModifiedByAgentID
FK30C57BD27699B003 AgentID picklistitem CreatedByAgentID
FKB19826975327F942 AgentID preparation ModifiedByAgentID
FKB19826977699B003 AgentID preparation CreatedByAgentID
FKB1982697FEE420B1 AgentID preparation PreparedByID
FKE3FD6EFA5327F942 AgentID preparationattachment ModifiedByAgentID
FKE3FD6EFA7699B003 AgentID preparationattachment CreatedByAgentID
FK4592DD085327F942 AgentID preparationattr ModifiedByAgentID
FK4592DD087699B003 AgentID preparationattr CreatedByAgentID
FK984BFDE55327F942 AgentID preparationattribute ModifiedByAgentID
FK984BFDE57699B003 AgentID preparationattribute CreatedByAgentID
FKFB3D7D6C1213D341 AgentID preparationproperty Agent10ID
FKFB3D7D6C1213D702 AgentID preparationproperty Agent11ID
FKFB3D7D6C1213DAC3 AgentID preparationproperty Agent12ID
FKFB3D7D6C1213DE84 AgentID preparationproperty Agent13ID
FKFB3D7D6C1213E245 AgentID preparationproperty Agent14ID
FKFB3D7D6C1213E606 AgentID preparationproperty Agent15ID
FKFB3D7D6C1213E9C7 AgentID preparationproperty Agent16ID
FKFB3D7D6C1213ED88 AgentID preparationproperty Agent17ID
FKFB3D7D6C1213F149 AgentID preparationproperty Agent18ID
FKFB3D7D6C1213F50A AgentID preparationproperty Agent19ID
FKFB3D7D6C121447A0 AgentID preparationproperty Agent20ID
FKFB3D7D6C384B3033 AgentID preparationproperty Agent8D
FKFB3D7D6C5327F942 AgentID preparationproperty ModifiedByAgentID
FKFB3D7D6C7699B003 AgentID preparationproperty CreatedByAgentID
FKFB3D7D6CCF197B29 AgentID preparationproperty Agent1ID
FKFB3D7D6CCF197EEA AgentID preparationproperty Agent2ID
FKFB3D7D6CCF1982AB AgentID preparationproperty Agent3ID
FKFB3D7D6CCF19866C AgentID preparationproperty Agent4ID
FKFB3D7D6CCF198A2D AgentID preparationproperty Agent5ID
FKFB3D7D6CCF198DEE AgentID preparationproperty Agent6ID
FKFB3D7D6CCF1991AF AgentID preparationproperty Agent7ID
FKFB3D7D6CCF199931 AgentID preparationproperty Agent9ID
FKB3C452E75327F942 AgentID preptype ModifiedByAgentID
FKB3C452E77699B003 AgentID preptype CreatedByAgentID
FKED904B195327F942 AgentID project ModifiedByAgentID
FKED904B195DDECE9 AgentID project ProjectAgentID
FKED904B197699B003 AgentID project CreatedByAgentID
FK3B38A2715327F942 AgentID recordset ModifiedByAgentID
FK3B38A2717699B003 AgentID recordset CreatedByAgentID
FK5F7C68DC5327F942 AgentID referencework ModifiedByAgentID
FK5F7C68DC7699B003 AgentID referencework CreatedByAgentID
FKA5A38A00384B3622 AgentID repositoryagreement AgentID
FKA5A38A005327F942 AgentID repositoryagreement ModifiedByAgentID
FKA5A38A007699B003 AgentID repositoryagreement CreatedByAgentID
FK93663235327F942 AgentID repositoryagreementattachment ModifiedByAgentID
FK93663237699B003 AgentID repositoryagreementattachment CreatedByAgentID
FKE139719A5327F942 AgentID shipment ModifiedByAgentID
FKE139719A7699B003 AgentID shipment CreatedByAgentID
FKE139719AB172EEC7 AgentID shipment ShippedByID
FKE139719AB17AF7EB AgentID shipment ShippedToID
FKE139719ABDA7A97E AgentID shipment ShipperID
FK96F9D2B25327F942 AgentID spappresource ModifiedByAgentID
FK96F9D2B27699B003 AgentID spappresource CreatedByAgentID
FKBBC195C5327F942 AgentID spappresourcedata ModifiedByAgentID
FKBBC195C7699B003 AgentID spappresourcedata CreatedByAgentID
FK3A2F5C9B5327F942 AgentID spappresourcedir ModifiedByAgentID
FK3A2F5C9B7699B003 AgentID spappresourcedir CreatedByAgentID
FKD51C16E65327F942 AgentID spauditlog ModifiedByAgentID
FKD51C16E67699B003 AgentID spauditlog CreatedByAgentID
FK154AE9D45327F942 AgentID spauditlogfield ModifiedByAgentID
FK154AE9D47699B003 AgentID spauditlogfield CreatedByAgentID
FKD54E94AC5327F942 AgentID specifyuser ModifiedByAgentID
FKD54E94AC7699B003 AgentID specifyuser CreatedByAgentID
FKD2861D325327F942 AgentID spexportschema ModifiedByAgentID
FKD2861D327699B003 AgentID spexportschema CreatedByAgentID
FKBB21AF455327F942 AgentID spexportschemaitem ModifiedByAgentID
FKBB21AF457699B003 AgentID spexportschemaitem CreatedByAgentID
FKCD08A1E95327F942 AgentID spexportschemaitemmapping ModifiedByAgentID
FKCD08A1E97699B003 AgentID spexportschemaitemmapping CreatedByAgentID
FK68B61F5C5327F942 AgentID spexportschemamapping ModifiedByAgentID
FK68B61F5C7699B003 AgentID spexportschemamapping CreatedByAgentID
FK14E6C4ED5327F942 AgentID spfieldvaluedefault ModifiedByAgentID
FK14E6C4ED7699B003 AgentID spfieldvaluedefault CreatedByAgentID
FK3CC8F6A5327F942 AgentID splocalecontainer ModifiedByAgentID
FK3CC8F6A7699B003 AgentID splocalecontainer CreatedByAgentID
FK22F4457D5327F942 AgentID splocalecontaineritem ModifiedByAgentID
FK22F4457D7699B003 AgentID splocalecontaineritem CreatedByAgentID
FK4F03EF675327F942 AgentID splocaleitemstr ModifiedByAgentID
FK4F03EF677699B003 AgentID splocaleitemstr CreatedByAgentID
FK56DC3A715327F942 AgentID spprincipal ModifiedByAgentID
FK56DC3A717699B003 AgentID spprincipal CreatedByAgentID
FK88FA7C8B5327F942 AgentID spquery ModifiedByAgentID
FK88FA7C8B7699B003 AgentID spquery CreatedByAgentID
FK8F33434F5327F942 AgentID spqueryfield ModifiedByAgentID
FK8F33434F7699B003 AgentID spqueryfield CreatedByAgentID
FK972D69D15327F942 AgentID spreport ModifiedByAgentID
FK972D69D17699B003 AgentID spreport CreatedByAgentID
FK95FF2A005327F942 AgentID spsymbiotainstance ModifiedByAgentID
FK95FF2A007699B003 AgentID spsymbiotainstance CreatedByAgentID
FKF2333F225327F942 AgentID sptasksemaphore ModifiedByAgentID
FKF2333F227699B003 AgentID sptasksemaphore CreatedByAgentID
FK22369BDB5327F942 AgentID spversion ModifiedByAgentID
FK22369BDB7699B003 AgentID spversion CreatedByAgentID
FK5FA666575327F942 AgentID spviewsetobj ModifiedByAgentID
FK5FA666577699B003 AgentID spviewsetobj CreatedByAgentID
FK34BC5F0B5327F942 AgentID spvisualquery ModifiedByAgentID
FK34BC5F0B7699B003 AgentID spvisualquery CreatedByAgentID
FK8FB0427B5327F942 AgentID storage ModifiedByAgentID
FK8FB0427B7699B003 AgentID storage CreatedByAgentID
FKBE9EFDDE5327F942 AgentID storageattachment ModifiedByAgentID
FKBE9EFDDE7699B003 AgentID storageattachment CreatedByAgentID
FK21AC10CC5327F942 AgentID storagetreedef ModifiedByAgentID
FK21AC10CC7699B003 AgentID storagetreedef CreatedByAgentID
FK589045DF5327F942 AgentID storagetreedefitem ModifiedByAgentID
FK589045DF7699B003 AgentID storagetreedefitem CreatedByAgentID
FK6908ECA5327F942 AgentID taxon ModifiedByAgentID
FK6908ECA7699B003 AgentID taxon CreatedByAgentID
FKF523736D5327F942 AgentID taxonattachment ModifiedByAgentID
FKF523736D7699B003 AgentID taxonattachment CreatedByAgentID
FKDAEA1F125327F942 AgentID taxonattribute ModifiedByAgentID
FKDAEA1F127699B003 AgentID taxonattribute CreatedByAgentID
FKDAEA1F12CF197B29 AgentID taxonattribute Agent1ID
FK14242FB15327F942 AgentID taxoncitation ModifiedByAgentID
FK14242FB17699B003 AgentID taxoncitation CreatedByAgentID
FK169B1D9D5327F942 AgentID taxontreedef ModifiedByAgentID
FK169B1D9D7699B003 AgentID taxontreedef CreatedByAgentID
FKF29A82305327F942 AgentID taxontreedefitem ModifiedByAgentID
FKF29A82307699B003 AgentID taxontreedefitem CreatedByAgentID
FK577D8522410EB2B4 AgentID treatmentevent PerformedByID
FK577D85225327F942 AgentID treatmentevent ModifiedByAgentID
FK577D85227699B003 AgentID treatmentevent CreatedByAgentID
FK577D85227D49A30F AgentID treatmentevent AuthorizedByID
FK1725BC55327F942 AgentID treatmenteventattachment ModifiedByAgentID
FK1725BC57699B003 AgentID treatmenteventattachment CreatedByAgentID
FKE5366FE65327F942 AgentID voucherrelationship ModifiedByAgentID
FKE5366FE67699B003 AgentID voucherrelationship CreatedByAgentID
FK41238DBF5327F942 AgentID workbench ModifiedByAgentID
FK41238DBF7699B003 AgentID workbench CreatedByAgentID
FK6829C9465327F942 AgentID workbenchrowexportedrelationship ModifiedByAgentID
FK6829C9467699B003 AgentID workbenchrowexportedrelationship CreatedByAgentID
FK6F902B395327F942 AgentID workbenchtemplate ModifiedByAgentID
FK6F902B397699B003 AgentID workbenchtemplate CreatedByAgentID
FK7D6D44085327F942 AgentID workbenchtemplatemappingitem ModifiedByAgentID
FK7D6D44087699B003 AgentID workbenchtemplatemappingitem CreatedByAgentID

Many-to-one relationships

Name Field Related table Related field
FK58743053D2DAD9A CollectionCCID collection UserGroupScopeId
FK58743053D3567E9 CollectionTCID collection UserGroupScopeId
FK58743054834EDBB InstitutionTCID institutionnetwork InstitutionNetworkID
FK58743054BDD9E10 SpecifyUserID specifyuser SpecifyUserID
FK58743055327F942 ModifiedByAgentID agent AgentID
FK58743057699B003 CreatedByAgentID agent AgentID
FK587430584B8A3FA ParentOrganizationID agent AgentID
FK587430587E99F68 InstitutionCCID institution UserGroupScopeId
FK587430587F159B7 InstitutionTCID institution UserGroupScopeId
FK587430597C961D8 DivisionID division UserGroupScopeId

View: Agent (Discipline)

<view name="Agent"
      class="edu.ku.brc.specify.datamodel.Agent"
      busrules="edu.ku.brc.specify.datamodel.busrules.AgentBusRules"
      isinternal="false"
      resourcelabels="false">
    <desc><![CDATA[Agent subform within the AccessionAgent form.]]></desc>
    <altviews defaultmode="view">
        <altview name="Agent View" title="Agent" viewdef="Agent" mode="view" validated="false"/>
        <altview name="Agent Edit" title="Agent" viewdef="Agent" mode="edit" validated="true" default="true"/>
    </altviews>
</view>

View def.: Agent

<viewdef name="Agent"
      type="form"
      class="edu.ku.brc.specify.datamodel.Agent"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Agent form]]></desc>
    <!--columnDef>100px,2px,190px,5px,100px,2px,190px,5px,105px,2px,89px,2px,35px,15px,p:g</columnDef-->
    <columnDef>120px,2px,140px,5px,120px,2px,120px,2px,47px,5px,40px,2px,168px,2px,2px,28px,2px,35px,p:g</columnDef>
    <!--columnDef os="lnx">115px,2px,200px,5px,115px,2px,200px,5px,119px,2px,115px,2px,35px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,230px,5px,120px,2px,230px,5px,139px,2px,125px,2px,38px,15px,p:g</columnDef>
    <columnDef os="exp">p,2px,max(p;190px),5px:g,p,2px,max(p;190px),5px:g,p,2px,89px,2px,p,p,p:g</columnDef-->
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <!--row>
            <cell type="label" labelfor="300"/>
            <cell type="field" id="300" name="initials" uitype="text" readonly="true"/>
        </row-->
        <row>
            <cell type="label" labelfor="0"/>
            <cell type="field" id="0" name="agentType" uitype="combobox" ignore="true"/>
            <cell type="label" label="Institution/Last name:" initialize="align=right" colspan="1"/>
            <cell type="field" id="3" name="lastName" uitype="text" cols="20" colspan="7"/>
        </row>
        <!--row>
            <cell type="label"labelfor="99"/>
            <cell type="field" id="99" name="parentOrganizationID" uitype="querycbx" initialize="name=Agent"/>
        </row-->
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="title" uitype="combobox" picklist="AgentTitles"/>
            <cell type="label" labelfor="21" colspan="1"/>
            <cell type="field" id="21" name="middleInitial" uitype="text" colspan="3"/>
            <!--cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="initials" uitype="text" colspan="2"/-->
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="firstName" uitype="text" cols="20" colspan="1"/>
        </row>
        <row>
            <cell type="label" labelfor="8"/>
            <cell type="field" id="8" name="abbreviation" uitype="text" cols="20"/>
            <cell type="label" labelfor="7" colspan="1"/>
            <cell type="field" id="7" name="email" uitype="text" colspan="5" cols="32"/>
            <cell type="field" id="mailto" name="this" uitype="plugin" initialize="name=WebLinkButton;weblink=MailTo;icon=EMail;watch=7"/>
        </row>
        <row>
            <cell type="label" labelfor="14"/>
            <cell type="field" id="14" name="jobTitle" uitype="text" cols="20" colspan="3"/>
            <cell type="label" labelfor="13"/>
            <cell type="field" id="13" name="interests" uitype="text" colspan="5"/>
        </row>
        <row>
            <cell type="label" labelfor="26"/>
            <cell type="field" id="26" name="dateType" uitype="combobox" colspan="1"/>
            <cell type="label" labelfor="19" colspan="1"/>
            <cell type="field" id="19" uitype="plugin" name="this" initialize="name=PartialDateUI;df=dateOfBirth;tp=dateOfBirthPrecision" uifieldformatter="Date" colspan="3"/>
            <cell type="label" labelfor="20" colspan="1"/>
            <cell type="field" id="20" uitype="plugin" name="this" initialize="name=PartialDateUI;df=dateOfDeath;tp=dateOfDeathPrecision" uifieldformatter="Date" colspan="1"/>
        </row>
        <row>
            <cell type="label" labelfor="16"/>
            <cell type="field" id="16" name="remarks" uitype="textareabrief" rows="2" colspan="11"/>
        </row>
        <row>
            <cell type="label" labelfor="17"/>
            <cell type="field" id="17" name="url" uitype="plugin" initialize="name=WebLinkButton;" colspan="15"/>
        </row>
        <row>
            <cell type="subview" viewname="Address" id="9" name="addresses" colspan="15"/>
        </row>
        <row>
            <cell type="subview" viewname="GroupPersons" id="31" name="groups" defaulttype="table" colspan="15"/>
        </row>
        <!--row>
            <cell type="subview" viewname="AgentVariant" id="10" name="variants" colspan="20"/>
        </row-->
        <row>
            <cell type="subview" viewname="AgentGeographies" id="agentgeographies" name="agentGeographies" colspan="15"/>
        </row>
        <row>
            <cell type="separator" label="Attachments" colspan="15"/>
        </row>
        <row>
            <cell type="subview" id="agentAttachments" viewname="AgentAttachmentMEL" name="agentAttachments" colspan="15" initialize="btn=true;icon=AgentAttachment"/>
        </row>
        <!--row>
            <cell type="subview" viewname="AccessionAuthorization" id="9" desc="Authorization" name="accessionAuthorizations" colspan="19"/>
        </row-->
 
        <!-- Unadded relationships from specify_datamodel.xml
 
        agentAttachments, authors, borrowReturnMaterials, catalogers, collectors, 
        determinations, disciplines, division, exchangeInCatalogedBys, exchangeOutCatalogedBys, 
        geoCoordDetail, groups, instContentContact, instTechContact, loanReturnPreparations, 
        members, preparations, projects, repositoryAgreements, shipments, specifyUser
 
         -->
        <row>
            <cell type="label" label=""/>
        </row>	
        <row>
            <cell type="separator" label="" colspan="15"/>
        </row>
        <row>
            <cell type="label" labelfor="160"/>
            <cell type="field" id="160" name="createdByAgent" uitype="label" readonly="true" uifieldformatter="Agent"/>
            <cell type="label" labelfor="170"/>
            <cell type="field" id="170" name="timestampCreated" uitype="label" readonly="true" cols="20"/>
        </row>
        <row>
            <cell type="label" labelfor="180"/>
            <cell type="field" id="180" name="modifiedByAgent" uitype="label" readonly="true" uifieldformatter="Agent"/>
            <cell type="label" labelfor="190"/>
            <cell type="field" id="190" name="timestampModified" uitype="label" readonly="true" cols="20"/>
        </row>
    </rows>
</viewdef>