| Title | Agent |
|---|---|
| Description | Agent |
| 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 | |||||
| varchar(50) | 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
|
Personal title of an agent | ||||
| DateType | tinyint(4) | Date type | Date type
|
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 |
| 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 |
| 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 |
| 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 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>
<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>