person_id
by going into [Database]/personperson_id
by going into [Database]/personperson_id
of user with username=juliaLIKE 'FH-2206%'
: show the storage_id
of the storage location with name starting with FH-2206LIKE '%FH-2206%'
would mean find anything with storage name containing FH-2206LIKE 'FH-2206%'
would mean find anything with storage name ending with FH-2206GROUP BY storage_name
: is added so that duplicates are only shown oncechemical_storage_disabled IS NULL AND chemical_storage_barcode != ""
)test
is the name of the database in this examplechemical_storage_id
as well as autogenerated barcode)chemical_storage
chemical_storage_disabled is NULL
: to ignored disposed containers