Structure of tables and fields
To be able to run the stock management successfully, a specific structure of table and fields is required.
The following table and fields are needed:
-
Main table (Strains* or Specimen)Field typeNamePointing toRlinkStockStorage table
-
Storage tableField typeNamePointing toDRow position numberDColumn position numberDStored quantityRLinkAssociated specimenStrains* (= link back)RlinkAssociated storage deviceStorage devices
-
Storage devices
|
Field type
|
Name
|
Pointing to
|
|
E
|
Type of storage
|
|
|
E
|
Site name
|
|
|
E
|
Building
|
|
|
E
|
Room name
|
|
|
E
|
Storage device name
|
|
|
D
|
Shelf number
|
|
|
D
|
Rack number
|
|
|
D
|
Tray number
|
|
|
D
|
Box number
|
|
|
D
|
Row number
|
|
|
D
|
Column number
|
|
|
D
|
Max quantity
|
|
|
E
|
Description
|
|
|
Rlink
|
Stock
|
Storage table (= link back)
|
