deaccessionpreparation

Table info.

Title Deaccession Preparation
Description Deaccession Preparation

Fields

Name Type Required Index Hidden On form Title Pick list Description
DeaccessionPreparationID 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
Quantity smallint(6) Quantity The number of items deaccessioned
Remarks text Remarks Additional Comments
DeaccessionID int(11) MUL
PreparationID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK6A06F1F418627F06 PreparationID
FK6A06F1F45327F942 ModifiedByAgentID
FK6A06F1F47699B003 CreatedByAgentID
FK6A06F1F4BE26B05E DeaccessionID
PRIMARY DeaccessionPreparationID

One-to-many relationships

Name Field Related table Related field
FK36328477EF0E7D46 DeaccessionPreparationID loanreturnpreparation DeaccessionPreparationID

Many-to-one relationships

Name Field Related table Related field
FK6A06F1F418627F06 PreparationID preparation PreparationID
FK6A06F1F45327F942 ModifiedByAgentID agent AgentID
FK6A06F1F47699B003 CreatedByAgentID agent AgentID
FK6A06F1F4BE26B05E DeaccessionID deaccession DeaccessionID