inventorylocation

105 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
inventorylocationitem.inventorylocation_id FK_19ED394026E88475R
location_id VARCHAR 36 √ null
warehousestoragelocation.id FK_6BD2CE4A64D218ER
inventory_id VARCHAR 36 √ null
inventory.id FK_6BD2CE4A9EEA759R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_6BD2CE4A64D218E Performance Asc location_id
IDX_6BD2CE4A9EEA759 Performance Asc inventory_id

Relationships

Close relationships within degrees of separation