batch_sub_locations

0 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_fkeyR
sub_location_id int8 19 null
sub_locations.id batch_sub_locations_sub_location_id_fkeyC
facility_id int8 19 null
sub_locations.facility_id batch_sub_locations_facility_id_sub_location_id_fkeyR
facilities.id batch_sub_locations_facility_id_fkeyC
batches.facility_id batch_sub_locations_facility_id_batch_id_fkeyR

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