giftpreparation

Table info.

Title Gift Preparation
Description Gift Preparation

Fields

Name Type Required Index Hidden On form Title Pick list Description
GiftPreparationID int(11) PRI
TimestampCreated datetime Created timestampCreated
TimestampModified datetime Last edited timestampModified
Version int(11) Version version
DescriptionOfMaterial varchar(255) Description A description of the preparation being sent as exchange, donation or shipping material (mainly used for shipping material)
InComments text In comments Comments about the incoming preparation
OutComments text Out comments Comments about the outgoing preparation
Quantity int(11) Quantity The number of preparations being sent as exchange, donation or shipping material
ReceivedComments text Received comments Comments about the receipt of outgoing preparations
PreparationID int(11) MUL
CreatedByAgentID int(11) MUL
GiftID int(11) MUL
DisciplineID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK18B1F6718627F06 PreparationID
FK18B1F674CE675DE DisciplineID
FK18B1F675327F942 ModifiedByAgentID
FK18B1F677699B003 CreatedByAgentID
FK18B1F679890879E GiftID
GiftPrepDspMemIDX DisciplineID
PRIMARY GiftPreparationID

Many-to-one relationships

Name Field Related table Related field
FK18B1F6718627F06 PreparationID preparation PreparationID
FK18B1F674CE675DE DisciplineID discipline UserGroupScopeId
FK18B1F675327F942 ModifiedByAgentID agent AgentID
FK18B1F677699B003 CreatedByAgentID agent AgentID
FK18B1F679890879E GiftID gift GiftID