sub_locations

0 rows


Description

The available locations where seeds can be stored at a seed bank facility or seedlings can be stored at a nursery facility.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
batch_details_history_sub_locations.sub_location_id batch_details_history_sub_locations_sub_location_id_fkeyN
batch_sub_locations.sub_location_id batch_sub_locations_sub_location_id_fkeyC
accessions.sub_location_id accession_storage_location_id_fkeyR
facility_id int8 19 null
batch_sub_locations.facility_id batch_sub_locations_facility_id_sub_location_id_fkeyR
facilities.id storage_locations_facility_id_fkeyC
name text 2147483647 null

E.g., Freezer 1, Freezer 2
created_time timestamptz 35,6 now()
modified_time timestamptz 35,6 now()
created_by int8 19 null
users.id storage_locations_created_by_fkeyR
modified_by int8 19 null
users.id storage_locations_modified_by_fkeyR

Indexes

Constraint Name Type Sort Column(s)
storage_location_pkey Primary key Asc id
storage_locations_facility_id_name_key Must be unique Asc/Asc facility_id + name
sub_locations_facility_id_id_key Must be unique Asc/Asc facility_id + id

Relationships

Close relationships within degrees of separation