agentspecialty

Table info.

Title Agent Specialty
Description Agent Specialty

Fields

Name Type Required Index Hidden On form Title Pick list Description
AgentSpecialtyID int(11) PRI
TimestampCreated datetime Created timestampCreated
TimestampModified datetime Modified timestampModified
Version int(11) Version version
OrderNumber int(11) Order Number The priority of specialization, for agents with primary and secondary areas of specialization.
SpecialtyName varchar(64) Specialty The field of taxonomic specialisation
AgentID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
AgentID AgentID, OrderNumber
FKDB5F5799384B3622 AgentID
FKDB5F57995327F942 ModifiedByAgentID
FKDB5F57997699B003 CreatedByAgentID
PRIMARY AgentSpecialtyID

Many-to-one relationships

Name Field Related table Related field
FKDB5F5799384B3622 AgentID agent AgentID
FKDB5F57995327F942 ModifiedByAgentID agent AgentID
FKDB5F57997699B003 CreatedByAgentID agent AgentID