batch_sub_locations

-1 rows


Description

Which batches are stored in which sub-locations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
batch_id int8 19 null
batches.id batch_sub_locations_facility_id_batch_id_fkey R
sub_location_id int8 19 null
sub_locations.id batch_sub_locations_sub_location_id_fkey C
facility_id int8 19 null
batches.facility_id batch_sub_locations_facility_id_batch_id_fkey R
facilities.id batch_sub_locations_facility_id_fkey C
sub_locations.facility_id batch_sub_locations_facility_id_sub_location_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
batch_sub_locations_pkey Primary key Asc/Asc batch_id + sub_location_id
batch_sub_locations_sub_location_id_idx Performance Asc sub_location_id

Relationships

Close relationships within degrees of separation