loanreturnpreparation

Table info.

Title Loan Return Preparation
Description Loan Return Preparation

Fields

Name Type Required Index Hidden On form Title Pick list Description
LoanReturnPreparationID 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
QuantityResolved int(11) Quantity resolved Number of specimens returned, deaccessioned or otherwise accounted for
QuantityReturned int(11) Quantity returned Number of specimens returned
Remarks text Quarantine message Quarantine message
ReturnedDate date MUL Date returned The date the preparation was returned
ReceivedByID int(11) MUL
DisciplineID int(11) MUL
ModifiedByAgentID int(11) MUL
LoanPreparationID int(11) MUL
CreatedByAgentID int(11) MUL
DeaccessionPreparationID int(11) MUL

Indexes

Name Fields Unique Nullable
FK3632847749C90455 ReceivedByID
FK363284774CE675DE DisciplineID
FK363284775327F942 ModifiedByAgentID
FK363284777699B003 CreatedByAgentID
FK36328477CD552686 LoanPreparationID
FK36328477EF0E7D46 DeaccessionPreparationID
LoanRetPrepDspMemIDX DisciplineID
LoanReturnedDateIDX ReturnedDate
PRIMARY LoanReturnPreparationID

Many-to-one relationships

Name Field Related table Related field
FK3632847749C90455 ReceivedByID agent AgentID
FK363284774CE675DE DisciplineID discipline UserGroupScopeId
FK363284775327F942 ModifiedByAgentID agent AgentID
FK363284777699B003 CreatedByAgentID agent AgentID
FK36328477CD552686 LoanPreparationID loanpreparation LoanPreparationID
FK36328477EF0E7D46 DeaccessionPreparationID deaccessionpreparation DeaccessionPreparationID