deaccessionagent

Table info.

Title Deaccession Agent
Description Deaccession Agent

Fields

Name Type Required Index Hidden On form Title Pick list Description
DeaccessionAgentID 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
Remarks text Remarks Additional Comments
Role varchar(50) MUL Role Role agent played in deaccession
AgentID int(11) MUL
DeaccessionID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKBE551822384B3622 AgentID
FKBE5518225327F942 ModifiedByAgentID
FKBE5518227699B003 CreatedByAgentID
FKBE551822BE26B05E DeaccessionID
PRIMARY DeaccessionAgentID
Role Role, AgentID, DeaccessionID

Many-to-one relationships

Name Field Related table Related field
FKBE551822384B3622 AgentID agent AgentID
FKBE5518225327F942 ModifiedByAgentID agent AgentID
FKBE5518227699B003 CreatedByAgentID agent AgentID
FKBE551822BE26B05E DeaccessionID deaccession DeaccessionID