agentvariant

Table info.

Title Agent Variant
Description Agent Variant

Fields

Name Type Required Index Hidden On form Title Pick list Description
AgentVariantID int(11) PRI
TimestampCreated datetime Timestamp Created The timestamp the record was created.
TimestampModified datetime Timestamp Modified The timestamp the record was last modified.
Version int(11) Version version
Country varchar(2) Country Country of variant or vernacular name.
Language varchar(2) Language International character code for language as it pertains to the agent variant.
Name varchar(255) Name The variant agent name
VarType tinyint(4) Variant type AgentVariant
  • Maiden name
  • Author abbrev.
  • Previous name
  • Other
  • IPNI Author ID
  • Harvard Index of Botanists ID
  • Encyclopedia of Australian Science ID
  • Australian Dictionary of Biography ID
  • Wikidata ID
  • Preferred name
  • ORCID
  • Alternative name
  • Bionomia ID
 The variant type (author abbreviation, maiden name, previous name, other)
Variant varchar(2) Variant variant
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
AgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK8DA4DE0384B3622 AgentID
FK8DA4DE05327F942 ModifiedByAgentID
FK8DA4DE07699B003 CreatedByAgentID
PRIMARY AgentVariantID

Many-to-one relationships

Name Field Related table Related field
FK8DA4DE0384B3622 AgentID agent AgentID
FK8DA4DE05327F942 ModifiedByAgentID agent AgentID
FK8DA4DE07699B003 CreatedByAgentID agent AgentID