preptype

Table info.

Title Preparation Type
Description Preparation Type

Fields

Name Type Required Index Hidden On form Title Pick list Description
PrepTypeID 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
IsLoanable bit(1) Is loanable isLoanable
Name varchar(64) Preparation type Preparation type
CollectionID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKB3C452E75327F942 ModifiedByAgentID
FKB3C452E77699B003 CreatedByAgentID
FKB3C452E78C2288BA CollectionID
PRIMARY PrepTypeID

One-to-many relationships

Name Field Related table Related field
FKC36883E96E8973EC PrepTypeID attributedef PrepTypeID
FKB19826976E8973EC PrepTypeID preparation PrepTypeID

Many-to-one relationships

Name Field Related table Related field
FKB3C452E75327F942 ModifiedByAgentID agent AgentID
FKB3C452E77699B003 CreatedByAgentID agent AgentID
FKB3C452E78C2288BA CollectionID collection UserGroupScopeId