borrowmaterial

Table info.

Title Borrow Material
Description Borrow Material

Fields

Name Type Required Index Hidden On form Title Pick list Description
BorrowMaterialID 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
CollectionMemberID int(11) MUL Collection Member Id collectionMemberId
Description varchar(50) MUL Description Description of the material
InComments text In comments Notes concerning the receipt of the material
MaterialNumber varchar(50) MUL Material Number e.g. `FMNH 223456`
OutComments text Out comments Notes concerning the return of the material
Quantity smallint(6) Quantity Number of specimens borrowed
QuantityResolved smallint(6) Quantity resolved Number of specimens resolved (returned, lost, discarded, destroyed etc.)
QuantityReturned smallint(6) Quantity returned Number of specimens returned
BorrowID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
Text1 text Text1 text1
Text2 text Text2 text2

Indexes

Name Fields Unique Nullable
BorMaterialColMemIDX CollectionMemberID
BorMaterialNumberIDX MaterialNumber
DescriptionIDX Description
FK86254A1C5327F942 ModifiedByAgentID
FK86254A1C7699B003 CreatedByAgentID
FK86254A1CF8BF6F28 BorrowID
PRIMARY BorrowMaterialID

One-to-many relationships

Name Field Related table Related field
FKA8170B8C83F392D6 BorrowMaterialID borrowreturnmaterial BorrowMaterialID

Many-to-one relationships

Name Field Related table Related field
FK86254A1C5327F942 ModifiedByAgentID agent AgentID
FK86254A1C7699B003 CreatedByAgentID agent AgentID
FK86254A1CF8BF6F28 BorrowID borrow BorrowID